math guru

Get perfect grades by consistently using Place your order and get a quality paper today. Take advantage of our current 20% discount by using the coupon code GET20

Order a Similar Paper Order a Different Paper

the excel page is attached you are going to use data from the first tab sheet and put results from information below on tab 3 which is labled module 9. please let me know if this makes sense



National Ambient Air Quality Standards (NAAQS) can be found at the EPA’s website. Link opens in a new window  Over the past 50 years the standard annual mean for fine particulate matter PM2.5 has been significantly tightened, starting out at 75 µg/m3 of air in 1971 and now only 12 µg/m3 of air (as of 2012 standards).

For this discussion you will be using your 2013 data from Module 7.  Create a new tab in your worksheet and name it “Mod 9”.  Note the two conditions for a valid confidence interval are met. Use StatCrunch to find a 90% confidence interval for the column Daily Mean PM2.5 Concentration. 

Is the 12 Âµg/m3 of air standard limit contained in your confidence interval?   With standards getting stricter over time, it is possible that even if it the current standard is not contained in the confidence interval a future stricter standard might be.  What concerns might you have if this were contained in your confidence interval?  What can you interpret from this? 

The textbook noted that confidence intervals may be reported in two different ways.  Please give your results in both formats.  Which format do you find to be more useful or clearer?

Now, utilize Excel’s COUNTIF function to find how many days in your data set had a Daily Mean PM2.5 Concentration over 12 µg/m3.  Did your area have any days over the standard annual mean for fine particulate matter, and if so how many?   Note that the 12 µg/m3 is an annual mean so that over the course of the year the AVERAGE for any given area should be under that value.  As an average, one would expect some days to be higher and some days to be lower concentrations, but the overall average for the year should be below this value to meet the EPA’s standards. 

"Is this question part of your assignment? We can help"


Need help with an assignment? We work for the best interests of our clients. We maintain professionalism and offer brilliant writing services in most of the fields ranging from nursing, philosophy, psychology, biology, finance, accounting, criminal justice, mathematics, computer science, among others. We offer CONFIDENTIAL, ORIGINAL (Turnitin & SafeAssign checks), and PRIVATE services using the latest (within 5 years) peer-reviewed articles. Kindly click on ORDER NOW to receive an A++ paper from our masters- and doctorate-prepared writers. Thank you in advance!

Get a 15% discount on your order using the following coupon code SAVE15

Order a Similar Paper Order a Different Paper