View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
joel[_681_] joel[_681_] is offline
external usenet poster
 
Posts: 1
Default P value in excel


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