Answer
384.3k+ 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
![seo images](https://www.vedantu.com/question-sets/25c6f57b-6bc4-4647-9407-f643e2d94af45205331352587243797.png)
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 many sigma and pi bonds are present in HCequiv class 11 chemistry CBSE
![arrow-right](/cdn/images/seo-templates/arrow-right.png)
Why Are Noble Gases NonReactive class 11 chemistry CBSE
![arrow-right](/cdn/images/seo-templates/arrow-right.png)
Let X and Y be the sets of all positive divisors of class 11 maths CBSE
![arrow-right](/cdn/images/seo-templates/arrow-right.png)
Let x and y be 2 real numbers which satisfy the equations class 11 maths CBSE
![arrow-right](/cdn/images/seo-templates/arrow-right.png)
Let x 4log 2sqrt 9k 1 + 7 and y dfrac132log 2sqrt5 class 11 maths CBSE
![arrow-right](/cdn/images/seo-templates/arrow-right.png)
Let x22ax+b20 and x22bx+a20 be two equations Then the class 11 maths CBSE
![arrow-right](/cdn/images/seo-templates/arrow-right.png)
Trending doubts
Fill the blanks with the suitable prepositions 1 The class 9 english CBSE
![arrow-right](/cdn/images/seo-templates/arrow-right.png)
At which age domestication of animals started A Neolithic class 11 social science CBSE
![arrow-right](/cdn/images/seo-templates/arrow-right.png)
Which are the Top 10 Largest Countries of the World?
![arrow-right](/cdn/images/seo-templates/arrow-right.png)
Give 10 examples for herbs , shrubs , climbers , creepers
![arrow-right](/cdn/images/seo-templates/arrow-right.png)
Difference between Prokaryotic cell and Eukaryotic class 11 biology CBSE
![arrow-right](/cdn/images/seo-templates/arrow-right.png)
Difference Between Plant Cell and Animal Cell
![arrow-right](/cdn/images/seo-templates/arrow-right.png)
Write a letter to the principal requesting him to grant class 10 english CBSE
![arrow-right](/cdn/images/seo-templates/arrow-right.png)
Change the following sentences into negative and interrogative class 10 english CBSE
![arrow-right](/cdn/images/seo-templates/arrow-right.png)
Fill in the blanks A 1 lakh ten thousand B 1 million class 9 maths CBSE
![arrow-right](/cdn/images/seo-templates/arrow-right.png)