How to make a normal curve from a spreadsheet; I had some help but this is how to do it in Libre Office. I can’t find the pages that helped me now, but others have written about this.
- Create a scale in a column, in the example, it runs from -4 to +4. It has an average of 0.
- Place the average of the scale and a standard deviation in named cells. In the example below, these are N_AVE (μ) and N_STDEV (σ). The standard deviation should be between the average and the scale limits.
- From the range value, calculate the range scaled by the mean () * stddev ()
- From the scaled range, use the normal distribution function to calculate the normal distribution value which can be charted.
This example shows one row in the table.
| Range | Scale (Calc) | n() |
| value |
. row[RANGE] * σ + μ |
=NORM.DIST(
row[Scale (Calc)],
μ,σ,false())
|
An example spreadsheet showing a Normal Distribution