copy,,,thE...data into.a new tab in the worksheet...you were using for Mod.. 7. Give this nEw tab a descriptive name. For this new data, use Excel's COUNTIF function to find the number of days with a PM2.5 AQI value over 50. Use this to find the proportion of days for which the air quality was not good in your sample. You.will need to know the number of successes, the sample size, and the proportion of successes for to continue. Create.a.new tab in your workshee t and labe.L it ..Mod 8. Perform.a four-step hypothesisTest (hypothesize, prepare, compute to compare, and interpret) to..Test whether the proportion of days which do not have "Good" air quality has changed. Insert/any work done using StatCrunch into your Mod.8 tab . Includ clear.verbal explanation for each of the..steps. JUst.give.nswer ill..copy data myself in excel HERE IS THE DATA https://www.epa.gov/outdoor-air-quality-data/download-daily-data PollutantSelect ...PM2.5 YearSelect ... 2005 Geographic Area Select a State ... NEW YORk Select a County ... Albany county NY Monitor SiteAll 360010005 THere is not enough room on here for data go to link and follow instuctions i provided please!!
Put the data as shown ,usw the formulas to test the hypothesis.
Please note this is only done to show you the formulas to calculate the value. You need to put the previous proportion and calculate the values.
Hope this helps.
Copy,,,thE...data into.a new tab in the worksheet...you were using for Mod.. 7. Give this nEw tab...