- a) Submit a copy of your dataset along with a file thatcontains your answers to all of the following questions.
b) What the mean and StandardDeviation (SD) of the Close column in your data set?
c) If a person bought 1 share ofGoogle stock within the last year, what is the probability that thestock on that day closed at less than the mean for that year? Hint:You do not want to calculate the mean to answer this one. Theprobability would be the same for any normal distribution.(5 points)
- If a person bought 1 share of Google stock within the lastyear, what is the probability that the stock on that day closed atmore than $950? (5 points)
- If a person bought 1 share of Google stock within the lastyear, what is the probability that the stock on that day closedwithin $50 of the mean for that year? (between 50 below and 50above the mean) (5 points)
- If a person bought 1 share of Google stock within the lastyear, what is the probability that the stock on that day closed atless than $800 per share. Would this be considered unusal? Use thedefinition of unusual from the course textbook that is measured asa number of standard deviations (5 points)
- At what prices would Google have to close in order for it to beconsidered statistically unusual? You will have a low and highvalue. Use the definition of unusual from the course textbook thatis measured as a number of standard deviations. (5points)
- What are Quartile 1, Quartile 2, and Quartile 3 in this dataset? Use Excel to find these values. This is the only question thatyou must answer without using anything about the normaldistribution. (5 points)
- Is the normality assumption that was made at the beginningvalid? Why or why not? Hint: Does this distribution have theproperties of a normal distribution as described in the coursetextbook? Real data sets are never perfect, however, it should beclose. One option would be to construct a histogram like you did inProject 1 to see if it has the right shape. Something in the rangeof 10 to 12 classes is a good number. (5points)
DATA SET- Closed stock prices
| 1044.689941 |
| 1077.150024 |
| 1080.969971 |
| 1089.900024 |
| 1098.26001 |
| 1070.52002 |
| 1075.569946 |
| 1073.900024 |
| 1090.98999 |
| 1070.079956 |
| 1060.619995 |
| 1089.060059 |
| 1116.369995 |
| 1110.75 |
| 1132.800049 |
| 1145.98999 |
| 1115.22998 |
| 1098.709961 |
| 1095.060059 |
| 1095.01001 |
| 1121.369995 |
| 1120.160034 |
| 1121.670044 |
| 1113.650024 |
|
