Read the wikpedia webpage below
'Normal distribution - Wikipedia, the free encyclopedia'
(
http://en.wikipedia.org/wiki/Normal_distribution)
Read sections
1) Standardizing normal random variables
2) Moments
3) And at the top of the webpage : (variance: σ2 )
The p value is based on sigma square as shown in the table i the
Moments Section above. depending on the momentum you want (p value) it
is simply a function of sigma. You need to calculate sigma. Again,
sigma square is the "variance" which you can calculate with functions in
excel.
=VAR(A2:A11)
--
joel
------------------------------------------------------------------------
joel's Profile: 229
View this thread:
http://www.thecodecage.com/forumz/sh...d.php?t=180334
Microsoft Office Help