Create bell curves easily in Numbers on macOS

How to derive a normal distribution of a given range of values on your mac using Numbers, with a bit of help from AppleScript.
Update (April 2022) - sincere apologies... I know this has been broken for a while, but I have only managed to find time yesterday to look at it. This has been updated/fixed.
Mainly:
1. selection range is now behaving more like a class than an element
2. valuePoints can now be reliably changed for users who prefer (more or less) resolution in the final bell curve; note that this is NOT a limit on how much data you select in Numbers
The updated script can be downloaded from the following link: bitbucket.org/pigbirdegg/norm...

[@daluvedkube2160]

Thanks a lot, this was really helpful and i mean it, your earned a new sub.

[@boyinyang2672]

Thank you! It is really simple and nice!

[@annaonderkova5663]

Thanks! Worked really well.

[@RoganHamby]

Really useful, thank you!

[@stevensukar141]

works like a treat... thanks

[@Timekeeper102]

Wonderful. Thank you so much!

[@ShaheenGhiassy]

Uh wow; thanks!! Super helpful

[@inesbalasch4182]

Hi Junior, thank you for posting this video! I am trying to run the syntax but Numbers says the formula contains syntax errors. Perhaps this is because I'm running it on a new version of the programme? Do you know how I could fix it? I'd appreciate your help!

[@ellatariman6313]

I downloaded it. Did higlighted the data in numbers and pressed run in applescript..it did not work...

[@SaschaHeineLAB]

This doesn't work on my Mac. It either does nothing when clicking on the play symbol or with the version called "Fill_Start_End.scpt" of the script it says "Numbers got an error".

[@jrtan]

Sascha Hein you need to select your data set in numbers before running the script.

[@ansarisg]

Hi, I was trying to run the script in the Ventura version, but get the following error:
error "Can’t make missing value into type number." number -1700 from missing value to number
Can you help?

[@startrooper2770]

Junior Tan. Thanks for this link it works amazing. Got a question. The maximum data points that can be analysed from your programme is 21-21. Is there anyway
this can be changed to 40. We have bigger classes in North of Scotland?.

[@jrtan]

hi star trooper can you drop me a PM or email?

[@jrtan]

Hi star trooper. I have rechecked, the valuepoints in the script are just to build the table to create the chart. there is no limit on the data points as far as I can tell. standard deviation, etc are calculated based on the data you highlight, however many you select.

[@startrooper2770]

@@jrtan thanks for this. I feel like a fool. I realised my error after I took time to examine it. Great work. Please keep it up.

[@seanfrost2509]

numbers said the formula contains a syntax error.

[@theresaseem7702]

I select column of salaries in numbers file, then click 'run' in script editor file, but keep getting following error:

[@jrtan]

Hi! apologies - I have only just found time to fix this - do download the new script, test it out and lemme know :-)

[@samuelpnewton]

I tried using the script and I get the following error: error "Can’t make name of {} into type Unicode text." number -1700 from name of {} to Unicode text. I'd love to get it working!

[@jrtan]

Hi Sam I have just updated the script. Should be fixed now :-)

[@dmsveshnikov6547]

Second column demonstrate exclamations - syntax error

[@wyattb3138]

I have numbers on iPad for school. 🥺

[@xtpsxreportsx]

I was expecting the script to be a text file, but it was binary. This post is not trustworthy enough to run some random linked binary

[@jrtan]

Hi if you are using a mac, the script should open in script editor for your full assessment You need to click on the run button for the script to run. It does not autorun.