Excel Statistical Analysis

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 P-Value
Chi-Square Goodness of Fit (GoF) Test
Find Midrange
Calculate Quintiles
Calculate Interquartile Range (IQR)
Percent Frequency Distribution
Binomial Distribution