A Normal Distribution

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. 

  1. Create a scale in a column, in the example, it runs from -4 to +4. It has an average of 0.
  2. 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.
  3. From the range value, calculate the range scaled by the mean () * stddev ()
  4. 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

Related Posts

  • System V init scripts I really like Ubuntu's system V initialisation scripts and features. This is now based […]
  • VLOOKUP vs INDEX ( MATCH) How awesome is this! Excel =INDEX, is a matrix retrieve i.e. =INDEX(array, row, col) […]
  • Code is Law Lessig's article, "Code is Law" for Harvard Magazine is here. I have made a .pdf here […]
  • zbench and photo headers I finally got round to experimenting with a photo banner for the site. This is a […]
  • Chartered Engineer I have been a member of the BCS for a while.   They now have got back, or maybe not, […]

Leave a Reply

Your email address will not be published. Required fields are marked *