Question: Can you please explain/write/show how to complete these using Excel formulas? If I have a population of an unknown mean, what is the 95% confidence

Can you please explain/write/show how to complete these using Excel formulas?

If I have a population of an unknown mean, what is the 95% confidence interval estimate of the population mean if

a.A random sample of size 36 gives a mean of 50 and a standard deviation of 12.

b.A random sample of size 49 gives a mean of 50 and a standard deviation of 12.

c.Interpret the confidence intervals obtained in parts a and b. In other words, explain in an English sentence on what that those confidence intervals mean.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Mathematics Questions!

I need to know how to to question 8 in excel AutoSave Ofi He statisticsQuickstove-VO-Seunathana_Perry_H... - Search Seunathana Hole SH X File Home Insert Draw Page Layout Formulas Data Review G21 fx...

Studies conducted by the manufacturer of Boston and Vermont asphalt shingles have shown product weight to be a major factor in the customers perception of quality. Moreover, product weight represents...

Pleas help with an explanation of possible. Using program statcrunch 1 A clinical trial was conducted to test the effectiveness of a drug for treating insomnia in older subjects. Before treatment, 23...

Business Statistics | Stat 2000 CTRA[31452] Log In | Co. Debora Pierre 12/13/22 1:02 PM o Homewe Homework: Stat 2000 HW_CH08 Question 10, 8.3.32-T HW Score: 30.16%, 3.92 of 13 11/10/2022 Part 1 of 3...

I just need help on the below problem Score: 0 of 1 pt 16 of 25 (24 complete) HW Score: 85.33%, 21.33 of 25 pt X 7.3.11-T Question Help A clinical trial was conducted to test the effectiveness of a...

Hi , I need help with this question please A clinical trial was conducted to test the effectiveness of a drug used for treating insomnia in older subjects. After treatment with the drug, 17 subjects...

1.A researcher conducted a survey of graduating college students. 350 college students were randomly selected to answer the survey. One of the survey questions asked, "What are your plans after...

A stationary store wants to estimate the mean retail value of greeting cards that it has in its inventory. A random sample of 100 greeting cards indicates a mean value of $ 2.55 and a standard...

Group Graded Assignment 6 Instructions Question 1 The production manager of Nagel Beverage Company is responsible for monitoring the filling operation of soft drink cans. His company has recently...

how do i answer these If X =75, o = 10, and n = 65, construct a 95% confidence interval estimate of the population mean, J. SUS (Round to two decimal places as needed.)A bottled water distributor...

Prepare presentation highlighting the crime reduction and prevention proposal.

Establish the convergence of the following integrals: (a) (b) (c) (d) dx, e-x dx, 2x dr

Gertup has maintained the same inventory levels throughout 2 0 0 5 . If end of year inventory turnover was increased to 1 2 through more efficient relationships with suppliers, how much cash would be...

Hart began construction of a new building last year on July 1, 2017. On the day construction was started, the land was appraised at $350,000. It had been purchased 2 years earlier for $200,000. By...