Step-by-step, easy-to-follow instructions on how to do the Chi-square goodness-of-fit test in Excel, which is a robust normality test.
Regression done in Microsoft Excel produces a complicated output. There are many parts to it, but only 4 are the most important. This article will show you how to quickly pick out and understand the 4 most important parts of regression done in Excel.
In the ideal world, all of your data samples are normally distributed. In this case you can usually apply the well-known parametric statistical tests such as ANOVA, the t Test, and regression to the sampled data. What can you do if your data does...