1)-I need step by step instruction how to do this problem in excel please. An in

Question

1)-I need step by step instruction how to do this problem in excel please.
An investigator wants to estimate caffeine consumption in high school students. How many students would be required to ensure that a 95% confidence interval estimate for the mean caffeine intake (measured in mg) is within 15 units of the true mean?. Assume that the standard deviation in caffeine intake is 68mg.

2)- I need step by step instruction how to do this problem in excel please.
Consider the study proposed in problem 1. How many students would be required to estimate the proportion of students who consume coffee? Suppose we want the estimate to be within 5% of the true proportion with 95% confidence.

Explanation / Answer

Please post 1 question at time.

i uploaded the solution here:-

http://www.mediafire.com/?kb8gbib22odde48

or try this link

http://www.mediafire.com/file/kb8gbib22odde48/excellfiles.xlsx

Related Questions

Navigate

• Browse (All)
• Browse 1
• Subjects

---

---

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