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()
row[RANGE] * σ + μ

    row[Scale (Calc)],

An example spreadsheet showing a Normal Distribution

Related Posts

  • VLOOKUP vs INDEX ( MATCH) How awesome is this! Excel =INDEX, is a matrix retrieve i.e. =INDEX(array, row, col) […]
  • zbench and photo headers I finally got round to experimenting with a photo banner for the site. This is a […]
  • Microsoft Office Templates With Office 2010, the location of the "My Templates" folder for Excel is managed using […]
  • Analysing the 2015 General Election I am fed up hearing about the PLP's 9m votes mandate. A large number of these 9m votes […]
  • DaaS I was thinking about DaaS and how to use RDP to access a modern desktop from my Tablet […]

Leave a Reply

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

This site uses Akismet to reduce spam. Learn how your comment data is processed.