confidence interval of population in Excel

Q85. I have test scores for my student population. In Excel, how can I determine confidence interval for my Population Mean?

As shown in Table below, I have test results for my entire class captured. I have calculated Population Mean and Standard Deviation. I want to determine confidence interval for the calculated

Population Mean with a 95% confidence level.

excel confidence interval of population

To do it in Excel, here is the answer:

a) Enter the formula =CONFIDENCE.NORM(1-E25,E24,B22) as shown below to get the confidence value

The first argument is a which is "1-Confidence Level". Second argument is Standard Deviation and third argument is population size.

The ".NORM" in formula indicates interval is calculated using a Normal distribution.

excel excel confidence interval of population

b) Subtract and add confidence value to mean to get the lower and upper limit of Confidence Interval as shown below.

excel excel excel confidence interval of population

 

You can find similar Excel Questions and Answer hereunder

1) How can I see where page breaks occur before actually printing?

2) How can I add interval to dates?

3) I have data arranged in rows of information. Is there any way I can enter new data through a form instead of entering it directly in SpreadSheet?

4) Can I add a Text histogram to Table data to make it visually appealing and easy to interpret?

5) How do I get the 2nd highest number in a range of numbers?

6) How can I hide a sheet completely from users (the sheet should not even appear in Unhide dialog box)?

7) How can I delete all shapes in a WorkSheet?

8) How do I find the median salary of employees with the same skillset in my Organization?

9) How can I calculate depreciation of assets using Excel?

10) How can I edit data in multiple WorkSheets together?

11) I have a table where inputs have to come from various users. In Excel, how can I highlight a row automatically that does not have input so that I can follow up with the concerned?

12) I have to retrieve data from a specific column in a Table. In Excel, how can I do that?

13) I am a construction Engineer. Considering a room with dimension, 14ft x 12ft can I find the side of the largest square tile which can tile the room?

14) Subtotal and sumif combination help in Excel

15) How can I fill a range of cells with incremental times?