Normal distribution (Gaussian bell curve)

[janz]

Trying to analyse different sets of data in a normal distribution way.
Want to show the result in an Excel sheet. (more sets per excel sheet)

However I want to deliver the data + the set Bell curve for that data to excel so that I can draw an XY scatter chart showing the "set value" Bell curve and the measured "value data". (works fine in Excel when I set the mean and st.dev by hand for each curve).

My idea.
In Msaccess
1) calculate the data to fit the curve
2) calculate the bell curve (with every time an other set mean and st.dev)
3) Export to excel in a set sheet creating the XY scatter.

Two questions
1) Would you agree that is the way to go
2) How do I calculate the bell curve if I know the mean and the st.dev.
Without creating the normdist() excel function in Access?

I certainly can use some help!

 

[janz]

Did some digging (couldn't wait) and came up with the following function call


Sub xlMedian()
Dim objExcel As Object
Set objExcel = CreateObject("Excel.Application")
MsgBox objExcel.Application.NORMDIST(70, 102, 9, False)
objExcel.Quit
Set objExcel = Nothing
End Sub

This uses the normdist function from excel in Access so with some programming around it I should be able to do what I want.
Still all good ideas are welcome!