discussion Please see attachment. work need to be excel sheet. and show work! You are told that a random sample of 150 people from Manchester New Hampshire

Click here to Order a Custom answer to this Question from our writers. It’s fast and plagiarism-free.

discussion Please see attachment. work need to be excel sheet. and show work! You are told that a random sample of 150 people from Manchester New Hampshire have been given cholesterol tests, and 60 of these people had levels over the “safe” count of 200.
Using Excel, construct a 95% confidence interval for the population proportion of people in New Hampshire with cholesterol levels over 200.
Note: Note that this question requires confidence interval for a proportion, the interval that is likely to capture the proportion of all population members’ that satisfy a specified property. Do you remember the formula? If not, here it is:
p estimate + – z-critical value X sqrt (p estimate (1-p estimate)/n)
Also note that, for population proportion, we use z-multiple not the t-multiple. So you can ask, where is the population standard deviation? You don’t need it. Look at the formula.

Place your order now for a similar assignment and have exceptional work written by one of our experts, guaranteeing you an A result.

Need an Essay Written?

This sample is available to anyone. If you want a unique paper order it from one of our professional writers.

Get help with your academic paper right away

Quality & Timely Delivery

Free Editing & Plagiarism Check

Security, Privacy & Confidentiality