Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Given the accompanying sample data, use Excel's formula options to find the 90% confidence interval for the population mean. Assume that the population is normally

Given the accompanying sample data, use Excel's formula options to find the 90% confidence interval for the population mean. Assume that the population is normally distributed and that the population standard deviation equals 5.

A1:A20 is -10, -9, -7, -7, -6, -6, -4, -4, -3, -2, -1, 1, 4, 4, 5, 6, 8, 8, 8, 10 The average of those # is -0.25

Confidence Coefficient = 0.9

Population Standard Deviation = 5 (E10)

Sample Size n = 20 (E11)

a/2 = 0.05 (E12)

I need to find out

Lower Limit of Confidence Interval compute the lower limit of confidence interval using A1:A20. E10,E11, and E12

Upper Limit Confidence Interval

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Statistics The Art And Science Of Learning From Data

Authors: Alan Agresti, Christine A. Franklin

3rd Edition

9780321849281, 321755944, 321849280, 978-0321755940

Students also viewed these Mathematics questions