Bonanome | MAT 1372/OL57 | Fall 2021

Category: Assignment Instructions (Page 1 of 2)

OpenLab Assignment 4

Go to the NY Lottery website and pick one game you would like to analyze. For games which have a current Jackpot amount posted – refer to that Jackpot amount as you do this assignment. (Games such as scratch-offs have fixed prizes which do not change.)

Refer to the odds and prizes posted for your game as you calculate the expected winnings. Probabilities are posted as odds – so an odds of 1 in 10 is the same as a probability 0.10. Keep in mind “winnings” are equal to prize money minus the cost of a ticket.

Please show all work. Make sure you create a table to keep track of the values of your random variable (possible winnings) along with their associated probabilities. This will help you to compute the expected value of the winnings for your game.

For an example, refer to the WINFALL lottery calculation we did together in class. No need to calculate the probabilities for your game, however, as they are given to you on the lottery website.

Please submit your assignment as an Excel file via Blackboard. I have created an assignment called “OpenLab Assignment 4” which is available under “Content.”

In order to receive credit, you must submit this assignment by uploading your Excel file to Blackboard. Please do NOT submit this assignment via email as you will not receive credit for it. If you have questions as to how to submit this assignment, please plan ahead and contact me in advance for help. Do not wait until the last moment as the assignment will close.

This assignment is due 10/29/2020 at 5 pm.

OpenLab Assignment #3

Refer to your OpenLab Assignment #2 and answer the following questions:

  1. What company did you create your predictive model for?
  2. What was the 10/12/2021 stock price you predicted for your company using your model?
  3. What was the actual stock price of your company on 10/12/2021.
  4. Was there a difference between your prediction and the actual price? If so, what was it?

Please respond by writing a comment on this post – once it is “approved” you will receive credit. Please make sure you are a member of this site in order to view your grade in the course gradebook (the gradebook can be found as a widget in the right hand column menu at the bottom).

OpenLab Assignment 2

Use the Yahoo finance site to download a .csv file of historical data for your favorite public company. As an example, here are Tesla’s stock prices, however you may choose to investigate any company which catches your interest. Once you have your data, use Excel to:

1) calculate: the covariance of the two variables
2) determine: the coefficient of correlation r
3) answer: What do  these statistics tell you about the relationship between
time and your company’s stock price?

4) graph: Find the scatter plot for your data sets. Be sure to include a detailed title and labels for horizontal and vertical axes.

5) determine: What is the linear equation which models your data?

6) predict: According to your linear equation, what will the stock price for your company be on 10/12/2021?

Please submit your assignment as an Excel file via Blackboard. I have created an assignment called “OpenLab Assignment 2” which is available under “Content.”

In order to receive credit, you must submit this assignment by uploading your Excel file to Blackboard. Please do NOT submit this assignment via email as you will not receive credit for it. If you have questions as to how to submit this assignment, please plan ahead and contact me in advance for help. Do not wait until the last moment as the assignment will close.

This assignment is due 9/21/2021 at 5 pm.

« Older posts