Project 3 | Mathematics homework help


 

Project 3 instructions

 

Based on Larson & Farber: sections 5.1–5.3

 

 

 

Go to http://www.google.com/finance/historical?cid=694653&startdate=Nov+20%2C+2011&enddate=Nov+18%2C+2012&num=30&ei=JaipUPDLIIK10QH57wE

 

Click the with on the straight that says Download to Spreadsheet.  Set the duration class to end on 11/19/13 (the source of Module/Week 5) and going tail accurately 1 year (11/20/12).  Then, click the with on the straight that says, “Download to Spreadsheet.” Assume that the bankruptcy expenses of the store arrange a regularly exclusive axioms set. (Now obtain be a good-natured-natured notion to revisal the limitation and properties of a regular disposal on p. 236

 

Do not manually number appreciates in the axioms set, but use the notions set-up in sections 5.2–5 .3. (You may insufficiency to revisal how to ascertain medium and gauge solution abandoned a axioms set. It obtain too aid to revisal how to use Excel to ascertain those quantities. Please connect to the Excel finish I posted on DB>>Useful finishs) Complete this assignment among a one Excel finish. Show your employment where feasible.

 

Answer the following:

 

 

 

  1. If a idiosyncratic bought 1 portion-out of Google store among the terminal year, what is the appearance that the store on that day shut at plug than the medium for that year?  Hint: Use the Empirical Rule, do not weigh the medium. The reply is unconstrained.

 

Hint: use wealth #2 on p. 236- the regular incurvation is bell-shaped and is symmetric about the medium.

 

2. If a idiosyncratic bought 1 portion-out of Google store among the terminal year, what is the appearance that the store on that day shut at over than $500?  Hint: Use Excel to ascertain the medium and gauge solution. Then ascertain the z reckoning.

 

Hint: To ascertain that, you obtain deficiency to ascertain: a) the medium, b) ascertain z reckoning (let’s seduce it z1) that harmonizes to x = 500, c) ascertain P(z< z1), and reseduce that P(z > z1) = 1 – P(z<z1)

 

3. If a idiosyncratic bought 1 portion-out of Google store among the terminal year, what is the appearance that the store on that day shut among $45 of the medium for that year? Hint: Ascertain two z reckonings and use the Gauge Regular Table. 

 

Hint: Ascertain the z-scores that harmonize to adding and withdrawing $45 from the medium.   Find the harmonizeing probabilities and then withdraw.

 

4. Suppose a idiosyncratic among the terminal year claimed to enjoy bought Google store at bankruptcy at $700 per portion-out. Would such a expense be considered uncommon?  Explain by using the Empirical Rule, do not ascertain the max or min appreciates of the daily bankruptcy expenses

 

Hint: ascertain the z reckoning. What z reckoning do we say that the harmonizeing axioms top x is uncommon?

 

5. At what expense would Google enjoy to plug at in enjoin for it to be considered statistically uncommon? You should enjoy a low and exalted appreciate. Use the Empirical Rule.

 

Hint: You obtain enjoy an conspicuous skip and a inferior skip. You obtain deficiency to ascertain the gauge solution of the axioms set precedently you profits.

 

6. What are Q1, Q2, and Q3 in this axioms set? Use Excel to ascertain these appreciates.

 

Hint: use = quartile(array, 1) to ascertain Q1, =quartile(array, 2) to ascertain Q2, and =quartile(array, 3) to ascertain Q3. The arrange is your axioms set. 

 

7. Is the boldness that was made at the source substantial? Why or why not?  Hint: Construct a histogram.

 

Hint: Does the axioms set enjoy the properties of a regular disposal? Is the medium and median almost the identical? Is the separation among Q1 and Q2 and the separation among Q2 and Q3 closely the identical?