Random sample Description Instructions This is an excel assignment. 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 a 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.

Random sample

Description

Instructions

This is an excel assignment.

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 a 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.

GET HELP WITH YOUR HOMEWORK PAPERS @ 25% OFF

For faster services, inquiry about  new assignments submission or  follow ups on your assignments please text us/call us on +1 (251) 265-5102

Write My Paper Button

WeCreativez WhatsApp Support
We are here to answer your questions. Ask us anything!
👋 Hi, how can I help?
Scroll to Top