Excel Statistical Analysis Stats Naïve Forecast Weighted Moving (Rolling) Average Exponential Moving (Rolling) Average Cumulative/ Moving (Rolling) Average Calculate Cumulative Percentage Weighted Standard Deviation Relative Frequency Distribution Cumulative Frequency Distribution How to Calculate Root Mean Squared Error (RMSE) VAR.P vs VAR.S (Population vs Sample Variance) Q-Q Plot How to Calculate Mean Squared Error (MSE) Shapiro-Wilk Test Shapiro-Wilk Royston Test Wilcoxon Signed-Rank Test Wilcoxon Rank Sum Test (Mann Whitney U Test) Test for Normality (Normal Dist.) STDEV.P vs STDEV.S (Population vs Sample Standard Deviations) Chi-Square Critical Value Confidence Intervals Chi-Square-Test-of-Independence Chi-Square P-Value Chi-Square Goodness of Fit (GoF) Test Find Midrange Calculate Quintiles Calculate Interquartile Range (IQR) Percent Frequency Distribution Binomial Distribution
