
How do you make a bell curve using excel?
Answer
449.1k+ views
Hint: To solve this question first we need to recall the definition of bell curve also known as normal distribution curve. Then we will discuss the steps involved in making a bell curve using excel.
Complete step by step solution:
We know that a bell curve is a way to plot and analyze the data that looks like a bell curve.
We have to follow some steps to create a bell curve in excel. The steps are as follows:
First we need to enter the data in the A1 column. We calculate the mean and standard deviation.
Now, in the cell adjacent to the first data we need to enter the formula : NORM.DIST (A1, mean, standard deviation, FALSE).
Now, by using the autofill option we have to copy paste the same formula to all the cells.
Now, select the dataset and go to the insert tab.
Insert the scatter with a smooth lines chart.
It gives the bell curve in excel.
The bell curve generally looks like
Note:
The point to be noted is that when we have a low standard deviation we get a packed slim bell curve and when we have a high standard deviation we get a wide bell curve and it covers more area on the chart. We can calculate the mean using AVERAGE function in excel and standard deviation using STDEV.P function.
Complete step by step solution:
We know that a bell curve is a way to plot and analyze the data that looks like a bell curve.
We have to follow some steps to create a bell curve in excel. The steps are as follows:
First we need to enter the data in the A1 column. We calculate the mean and standard deviation.
Now, in the cell adjacent to the first data we need to enter the formula : NORM.DIST (A1, mean, standard deviation, FALSE).
Now, by using the autofill option we have to copy paste the same formula to all the cells.
Now, select the dataset and go to the insert tab.
Insert the scatter with a smooth lines chart.
It gives the bell curve in excel.
The bell curve generally looks like

Note:
The point to be noted is that when we have a low standard deviation we get a packed slim bell curve and when we have a high standard deviation we get a wide bell curve and it covers more area on the chart. We can calculate the mean using AVERAGE function in excel and standard deviation using STDEV.P function.
Recently Updated Pages
How do you factor x2 + x 20 0 class 9 maths CBSE

How do you solve y6x and 2x+3y20 using substitutio class 9 maths CBSE

Chipko movement originated in Gopeshwar in A 1953 B class 9 biology CBSE

The adjacent sides in the parallelogram are supplementary class 9 maths CBSE

The compound used in plastic industry is A Vinyl acetate class 9 chemistry CBSE

How do you solve for y in 2left y dfrac12 right 4left class 9 maths CBSE

Trending doubts
Write the difference between soap and detergent class 10 chemistry CBSE

When was Shivaji born A 1632 B 1627 C 1678 D 1634 class 10 social science CBSE

a Why did Mendel choose pea plants for his experiments class 10 biology CBSE

State and explain Ohms law class 10 physics CBSE

The Equation xxx + 2 is Satisfied when x is Equal to Class 10 Maths

Differentiate between Food chain and Food web class 10 biology CBSE
