Periodically, a town water department tests the drinking water of homeowners for

Question

Periodically, a town water department tests the drinking water of homeowners for contaminants such as lead The lead levels in water specimens collected for a Lead (mg/L) sample of 10 residents of the town are shown. 1.33 1.32 13,2 4.09 0.975 4.49 0.624 1) Use the Powerpoint presentation instructions on Moodle to determine whether you have access to the Microsoft Excel Data Analysis Toolpak on your computer. ifnot, you will need to complete this assignment in one of the university's computer labs. open ar download the link Locating the MS Excel Data Analysis Toolpak 2) Use the "Descriptive Statistics tool in the Microsoft Excel Data Analysis Toolpak to generate the informaton you will need to complete the following questions The Powerpoint presentation Using the Descripove Statistics Toor on Moodle will show you an example for using this tool 3) Complete parts a through di a. Fill in the following table based on the descriptive statistics generated by MS Excel ound each answer to four decimal places as needed) Sample mean Sample standard deviation Sample variance

Explanation / Answer

1. The statisticaal software output for summary stats is:

Summary statistics:

Hence,

Sample mean = 2.9029

Sample standard deviation = 3.9541

Sample variance = 15.6346

b) The statistical software output for this problem is:

One sample T confidence interval:
: Mean of variable

99% confidence interval results:

Hence,

Critical value = 3.250

Confidence interval: (-1.161, 6.966)

Column Mean Std. dev. Variance var15 2.9029 3.9540586 15.63458

Related Questions

Navigate

• Browse (All)
• Browse P
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.