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 attach on the fit that says Download to Spreadsheet.  Set the determination class to end on 11/19/13 (the start of Module/Week 5) and going tail accurately 1 year (11/20/12).  Then, click the attach on the fit that says, “Download to Spreadsheet.” Assume that the withdrawal costs of the store shape a naturally reserved axioms set. (Now succeed be a cheerful proposal to re-examination the limitation and properties of a natural arrangement on p. 236

 

Do not manually rate esteems in the axioms set, but use the proposals base in sections 5.2–5 .3. (You may absence to re-examination how to perceive medium and plummet flexuosity abandoned a axioms set. It succeed so aid to re-examination how to use Excel to perceive those quantities. Please allude to the Excel polish I posted on DB>>Useful polishs) Complete this assignment among a uncombined Excel polish. Show your effect where potential.

 

Answer the following:

 

 

 

  1. If a individual bought 1 distribute of Google store among the developed year, what is the verisimilitude that the store on that day settled at near than the medium for that year?  Hint: Use the Empirical Rule, do not rate the medium. The tally is facile.

 

Hint: use estate #2 on p. 236- the natural flexion is bell-shaped and is symmetric encircling the medium.

 

2. If a individual bought 1 distribute of Google store among the developed year, what is the verisimilitude that the store on that day settled at past than $500?  Hint: Use Excel to perceive the medium and plummet flexuosity. Then perceive the z charges.

 

Hint: To perceive that, you succeed insufficiency to perceive: a) the medium, b) perceive z charges (let’s persuade it z1) that suits to x = 500, c) perceive P(z< z1), and repersuade that P(z > z1) = 1 – P(z<z1)

 

3. If a individual bought 1 distribute of Google store among the developed year, what is the verisimilitude that the store on that day settled among $45 of the medium for that year? Hint: Perceive two z chargess and use the Plummet Natural Table. 

 

Hint: Perceive the z-scores that suit to adding and withdrawing $45 from the medium.   Find the suiting probabilities and then withdraw.

 

4. Suppose a individual among the developed year claimed to bear bought Google store at withdrawal at $700 per distribute. Would such a cost be considered rare?  Explain by using the Empirical Rule, do not perceive the max or min esteems of the daily withdrawal costs

 

Hint: perceive the z charges. What z charges do we say that the suiting axioms top x is rare?

 

5. At what cost would Google bear to cork at in direct for it to be considered statistically rare? You should bear a low and exalted esteem. Use the Empirical Rule.

 

Hint: You succeed bear an higher skip and a inferior skip. You succeed insufficiency to perceive the plummet flexuosity of the axioms set precedently you produce.

 

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

 

Hint: use = quartile(array, 1) to perceive Q1, =quartile(array, 2) to perceive Q2, and =quartile(array, 3) to perceive Q3. The draw-up is your axioms set. 

 

7. Is the impudence that was made at the start efficient? Why or why not?  Hint: Construct a histogram.

 

Hint: Does the axioms set bear the properties of a natural arrangement? Is the medium and median almost the identical? Is the discord between Q1 and Q2 and the discord between Q2 and Q3 approximately the identical?