Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

1. In cell A1, enter 20400. This value can be calculated using Mean - 3Standard Deviation [30000 - 3(3200)]. 2. In the cell below it,

1. In cell A1, enter 20400. This value can be calculated using Mean - 3Standard Deviation [30000 - 3(3200)].

2. In the cell below it, enter 20401 and create a series from 20400 to 39600 (where 39600 is Mean + 3Standard Deviation). You can do this quickly by using the autofill option, or use the fill handle and drag it down to fill the cells.

3. In the cell adjacent to 20400, enter the formula:=NORM.DIST(A1,20400,3200,FALSE)

4. Note that here I have hardcoded the value of mean and standard deviation. You can also have these in cells and use the cell references in the formula.

5. Again use the fill handle to quickly copy and paste the formula for all the cells.

6. Select the data set and go to Insert tab.

7. This will give you a bell curve in Excel. This will give you a bell curve in Excel.

can you please draw the bell curve charts in excel for me following the data above and indicate the Zs around the mean

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored 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

Trigonometry, Enhanced

Authors: Cynthia Y Young

4th Edition

1119321131, 9781119321132

More Books

Students also viewed these Mathematics questions

Question

politeness and modesty, as well as indirectness;

Answered: 1 week ago