How Do You Use Excel To Calculate P-Values Under Normal Distribution?
I use MS Office a lot. Although I never really studied its software formally, I gradually gained some real life experience. They might be of help to you at work or study when you run into the same problem. Well, if you are pretty savvy about excel or any other similar software, you probably can skip this one. Suppose you understand what I mean by talking about “mean”, “standard deviation”, “sigma” and “z-score”. So far so good?! If you feel challenged already, google these concepts in statistic context. Suppose you have a series of data points that you need to work on, to get the relative p-value for each data point in this data set. If your data set is not too big to use excel, you should keep on reading. OK, first using the command “average” to calculate the “mean” of the data set, and using “stdev” to compute the “standard deviation” of the data set. For each data point, using this formula to compute the z-score: z-score = (value_this_data_point – mean) / stdev you basically just co
