Statistics homework ith excel | Mathematics homework help

this is homeproduction achieve page attached 


For the activities of Module 7 fascinate production in the Mod 7 tab you bear created. 

Use Excel’s COUNTIF office to encounter the compute of days after a while a PM2.5 AQI esteem balance 50.  On such days, the air attribute provisions are considered not to be “Good” per the EPA’s Air Attribute Index. Use this to encounter the uniformity of days for which the air attribute was not cheerful in your exemplification (phat). A prosperity get be a day in which the PM2.5 AQI is overhead 50.

We highest must obstruct that the provisions of the Central Limit Theorem exercise for estimating uniformitys in a population.

  1. The Random and Independent proviso is met by the EPA’s assembly agencies. 
  2. The Large Exemplification proviso must be obstructed. If phat is the uniformity of days after a while AQI overhead 50, then we want to bear twain n*phat and n*(1-phat) superior than or similar to 10. 
  3. The Big Population proviso is met for our grounds. 

When these three provisions are met, we can use the Normal distribution to encounter probabilities touching the exemplification uniformity.  If your grounds set does not encounter the Large Exemplification proviso, accomplish a new grounds set for a irrelative city our county neighboring wnear you feed and then obstruct these provisions anew.

Clearly write cells after a while the names and esteems for the following:  compute of prosperityes in exemplification, exemplification bulk, exemplification uniformity of prosperityes, z esteem multiplier for 95% faith gap, the estimated gauge fault and the faith gap.  By laborer investigate the estimated gauge fault and the faith gap (using a calculator to do the math) using formulas 7.1 from our quotation.  Confirm your results using StatCrunch, inserting your StatCrunch results into your productionsheet.

We are 95% sure that the developed uniformity of days after a while AQI that is not “Good” is after a whilein the faith gap we endow near.

Now encounter the 90% faith gap using any process (by laborer or after a while StatCrunch).  How is the 90% faith gap irrelative than the 95% faith gap?  Why is this so?