Confidence Interval WS

Confidence Intervals

[WLO: 2] [CLOs: 1, 3]

Prior to beginning work on this assignment, read Chapter 8: Confidence Interval Estimations.

You may find it helpful to review

Don't use plagiarized sources. Get Your Custom Essay on
Confidence Interval WS
Just from $13/Page
Order Essay

Excel Tutorial – Calculating Confidence Intervals (Links to an external site.)

and

How to Calculate Confidence Intervals in Excel (Links to an external site.)

.

In this week’s reading, the text discussed different types of samples and their distributions, and sampling errors, probabilities, and confidence intervals. Using Excel, complete the problem below. This is similar to Problem 33 in Chapter 8.

Problem: You have been assigned to determine whether more people prefer Coke or Pepsi. Assume that roughly half the population prefers Coke and half prefers Pepsi. How large a sample do you need to take to ensure that you can estimate, with 90% confidence, the proportion of people preferring Coke to within 5% of the actual value? Show all of your work.

In your Excel spreadsheet,

  • Identify the sample size.
  • Utilize the support tool of Excel.
  • Present any equations utilized.

Calculate your order
Pages (275 words)
Standard price: $0.00
Client Reviews
4.9
Sitejabber
4.6
Trustpilot
4.8
Our Guarantees
100% Confidentiality
Information about customers is confidential and never disclosed to third parties.
Original Writing
We complete all papers from scratch. You can get a plagiarism report.
Timely Delivery
No missed deadlines – 97% of assignments are completed in time.
Money Back
If you're confident that a writer didn't follow your order details, ask for a refund.

Calculate the price of your order

You will get a personal manager and a discount.
We'll send you the first draft for approval by at
Total price:
$0.00
Power up Your Academic Success with the
Team of Professionals. We’ve Got Your Back.
Power up Your Study Success with Experts We’ve Got Your Back.
error: Content is protected !!
Live Chat+1(978) 822-0999EmailWhatsApp

Order your essay today and save 20% with the discount code ORIGINAL