For creating a bell curve using data in excel, say I have A2 to A101 data in ord

Question

For creating a bell curve using data in excel, say I have A2 to A101 data in order and in B2 to B101 the number of times each of those data occurs. How would I use this information to create a Gaussian distribution (bell curve) using excel? Along with standard deviation, as well as a measure of the goodness of fit of the Gaussian distribution, typically the chi-squared value. For creating a bell curve using data in excel, say I have A2 to A101 data in order and in B2 to B101 the number of times each of those data occurs. How would I use this information to create a Gaussian distribution (bell curve) using excel? Along with standard deviation, as well as a measure of the goodness of fit of the Gaussian distribution, typically the chi-squared value.

Explanation / Answer

To create a sample bell curve, follow these steps:

You now have a chart that compares a given data set to a bell curve.

Related Questions

Navigate

• Browse (All)
• Browse F
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.