Statistics dates 11/12/12 to 11/12/13


Statistics project

Go tothis website (https://www.google.com/finance/historical?q=NASDAQ:GOOG). Click the attach on the just that says Download to Spreadsheet. Set the limit place according to the limits fond in the Project 3 chink proposition posted by your educationist. Your limits gain going end correspondently 1 year. Assume that the stagnation appraises of the accumulation construct a normally appointly facts set. Do not manually sum appraises in the facts set, but use the ideas ground in sections 5.2 5.3. Complete this assignment amid a individual Excel smooth. Show your exertion where practicable.

1. If a special bought 1 portion-out of Google accumulation amid the terminal year, what is the likelihood that the accumulation on that day reserved at rest than the moderation for that year? Hint: Use the Empirical Rule; do not apportion the moderation. The confutation is gentle.

2. If a special bought 1 portion-out of Google accumulation amid the terminal year, what is the likelihood that the accumulation on that day reserved at past than $500? Hint: Use Excel to discover the moderation and flag inconsequence. Then discover the z mandible.

3. If a special bought 1 portion-out of Google accumulation amid the terminal year, what is the likelihood that the accumulation on that day reserved amid $45 of the moderation for that year? Hint: Discover two z mandibles and use the Flag Normal Table.

4. Suppose a special amid the terminal year claimed to entertain bought Google accumulation at stagnation at $700 per portion-out. Would such a appraise be considered uncommon? Explain by using the Empirical Rule, do not discover the max or min appraises of the daily stagnation appraises.

5. At what appraises would Google entertain to rest at in appoint for it to be considered statistically uncommon? You should entertain a low and noble appraise. Use the Empirical Rule.

6. What are Q1, Q2, and Q3 in this facts set? Use Excel to discover these appraises.

7. Is the normality presumption that was made at the source efficient? Why or why not? Hint: Construct a histogram.