Excel Master Series Blog Directory

Statistical Topics and Articles In Each Topic

• Histograms in Excel
  • Creating a Histogram With the Histogram Data Analysis Tool in Excel
  • Creating an Automatically Updating Histogram in 7 Steps in Excel With Formulas and a Bar Chart
• Bar Chart in Excel
  • Creating a Bar Chart in 7 Steps in Excel 2010 and Excel 2013
• Box Plots in Excel
  • Creating a Box Plot in 8 Steps in Excel 2010 and Excel 2013
• Probability in Excel
  • Probability in Excel
• Combinations & Permutations in Excel
  • Combinations in Excel 2010 and Excel 2013
  • Permutations in Excel 2010 and Excel 2013
• Sorting and Ranking in Excel
  • Automated Data Column Sorting in Excel
  • Simplifying Excel Ranking Functions: RANK(), RANK.AVG(), RANK.EQ(), PERCENTILE(), PERCENTILE.INC(), PERCENTILE.EXC(), QUARTILE(), QUARTILE.INC(), QUARTILE.EXC()
• Normal Distribution in Excel
  • Overview of the Normal Distribution
  • Normal Distribution’s PDF (Probability Density Function) in Excel 2010 and Excel 2013
  • Normal Distribution’s CDF (Cumulative Distribution Function) in Excel 2010 and Excel 2013
  • Solving Normal Distribution Problems in Excel 2010 and Excel 2013
  • Overview of the Standard Normal Distribution in Excel 2010 and Excel 2013
  • An Important Difference Between the t and Normal Distribution Graphs
  • The Empirical Rule and Chebyshev’s Theorem in Excel – Calculating How Much Data Is a Certain Distance From the Mean
  • Demonstrating the Central Limit Theorem In Excel 2010 and Excel 2013 In An Easy-To-Understand Way
• t-Distribution in Excel
  • Overview of the t- Distribution
• Binomial Distribution in Excel
  • Overview of the Binomial Distribution in Excel 2010 and Excel 2013
  • Solving Problems With the Binomial Distribution in Excel 2010 and Excel 2013
  • Normal Approximation of the Binomial Distribution in Excel 2010 and Excel 2013
  • Distributions Related to the Binomial Distribution
• z-Tests in Excel
  • Overview of Hypothesis Tests Using the Normal Distribution in Excel 2010 and Excel 2013
  • One-Sample z-Test in 4 Steps in Excel 2010 and Excel 2013
  • 2-Sample Unpooled z-Test in 4 Steps in Excel 2010 and Excel 2013
  • Overview of the Paired (Two-Dependent-Sample) z-Test in 4 Steps in Excel 2010 and Excel 2013
• t-Tests in Excel
  • Overview of t-Tests: Hypothesis Tests that Use the t-Distribution
  • 1-Sample t-Tests in Excel
    • 1-Sample t-Test in 4 Steps in Excel 2010 and Excel 2013
    • Excel Normality Testing For the 1-Sample t-Test in Excel 2010 and Excel 2013
    • 1-Sample t-Test – Effect Size in Excel 2010 and Excel 2013
    • 1-Sample t-Test Power With G*Power Utility
    • Wilcoxon Signed-Rank Test in 8 Steps As a 1-Sample t-Test Alternative in Excel 2010 and Excel 2013
    • Sign Test As a 1-Sample t-Test Alternative in Excel 2010 and Excel 2013
  • 2-Independent-Sample Pooled t-Tests in Excel
    • 2-Independent-Sample Pooled t-Test in 4 Steps in Excel 2010 and Excel 2013
    • Excel Variance Tests: Levene’s, Brown-Forsythe, and F Test For 2-Sample Pooled t-Test in Excel 2010 and Excel 2013
    • Excel Normality Tests Kolmogorov-Smirnov, Anderson-Darling, and Shapiro Wilk Tests For Two-Sample Pooled t-Test
    • Two-Independent-Sample Pooled t-Test - All Excel Calculations
    • 2- Sample Pooled t-Test – Effect Size in Excel 2010 and Excel 2013
    • 2-Sample Pooled t-Test Power With G*Power Utility
    • Mann-Whitney U Test in 12 Steps in Excel as 2-Sample Pooled t-Test Nonparametric Alternative in Excel 2010 and Excel 2013
    • 2- Sample Pooled t-Test = Single-Factor ANOVA With 2 Sample Groups
  • 2-Independent-Sample Unpooled t-Tests in Excel
    • 2-Independent-Sample Unpooled t-Test in 4 Steps in Excel 2010 and Excel 2013
    • Variance Tests: Levene’s Test, Brown-Forsythe Test, and F-Test in Excel For 2-Sample Unpooled t-Test
    • Excel Normality Tests Kolmogorov-Smirnov, Anderson-Darling, and Shapiro-Wilk For 2-Sample Unpooled t-Test
    • 2-Sample Unpooled t-Test Excel Calculations, Formulas, and Tools
    • Effect Size for a 2-Independent-Sample Unpooled t-Test in Excel 2010 and Excel 2013
    • Test Power of a 2-Independent Sample Unpooled t-Test With G-Power Utility
  • Paired (2-Sample Dependent) t-Tests in Excel
    • Paired t-Test in 4 Steps in Excel 2010 and Excel 2013
    • Excel Normality Testing of Paired t-Test Data
    • Paired t-Test Excel Calculations, Formulas, and Tools
    • Paired t-Test – Effect Size in Excel 2010, and Excel 2013
    • Paired t-Test – Test Power With G-Power Utility
    • Wilcoxon Signed-Rank Test in 8 Steps As a Paired t-Test Alternative
    • Sign Test in Excel As A Paired t-Test Alternative
• Hypothesis Tests of Proportion in Excel
  • Hypothesis Tests of Proportion Overview (Hypothesis Testing On Binomial Data)
  • 1-Sample Hypothesis Test of Proportion in 4 Steps in Excel 2010 and Excel 2013
  • 2-Sample Pooled Hypothesis Test of Proportion in 4 Steps in Excel 2010 and Excel 2013
  • How To Build a Much More Useful Split-Tester in Excel Than Google's Website Optimizer
• Chi-Square Independence Tests in Excel
  • Chi-Square Independence Test in 7 Steps in Excel 2010 and Excel 2013
• Chi-Square Goodness-Of-Fit Tests in Excel
  • Overview of the Chi-Square Goodness-of-Fit Test
  • Chi-Square Goodness- of-Fit Test With Pre-Determined Bins Sizes in 7 Steps in Excel 2010 and Excel 2013
  • Chi-Square Goodness-Of-Fit-Normality Test in 9 Steps in Excel 2010 and Excel 2013
• F Tests in Excel
  • F-Test in 6 Steps in Excel 2010 and Excel 2013
  • Normality Testing For F Test In Excel 2010 and Excel 2013
  • Levene’s and Brown- Forsythe Tests: F-Test Alternatives in Excel
• Correlation in Excel
  • Overview of Correlation In Excel 2010 and Excel 2013
• Pearson Correlation in Excel
  • Pearson Correlation in 3 Steps in Excel 2010 and Excel 2013
  • Pearson Correlation – Calculating r Critical and p Value of r in Excel
• Spearman Correlation in Excel
  • Spearman Correlation in 6 Steps in Excel 2010 and Excel 2013
• Confidence Intervals in Excel
  • z-Based Confidence Intervals of a Population Mean in 2 Steps in Excel 2010 and Excel 2013
  • t-Based Confidence Intervals of a Population Mean in 2 Steps in Excel 2010 and Excel 2013
  • Minimum Sample Size to Limit the Size of a Confidence interval of a Population Mean
  • Confidence Interval of Population Proportion in 2 Steps in Excel 2010 and Excel 2013
  • Min Sample Size of Confidence Interval of Proportion in Excel 2010 and Excel 2013
• Simple Linear Regression in Excel
  • Overview of Simple Linear Regression in Excel 2010 and Excel 2013
  • Complete Simple Linear Regression Example in 7 Steps in Excel 2010 and Excel 2013
  • Residual Evaluation For Simple Regression in 8 Steps in Excel 2010 and Excel 2013
  • Residual Normality Tests in Excel – Kolmogorov-Smirnov Test, Anderson-Darling Test, and Shapiro-Wilk Test For Simple Linear Regression
  • Evaluation of Simple Regression Output For Excel 2010 and Excel 2013
  • All Calculations Performed By the Simple Regression Data Analysis Tool in Excel 2010 and Excel 2013
  • Prediction Interval of Simple Regression in Excel 2010 and Excel 2013
• Multiple Linear Regression in Excel
  • Basics of Multiple Regression in Excel 2010 and Excel 2013
  • Complete Multiple Linear Regression Example in 6 Steps in Excel 2010 and Excel 2013
  • Multiple Linear Regression’s Required Residual Assumptions
  • Normality Testing of Residuals in Excel 2010 and Excel 2013
  • Evaluating the Excel Output of Multiple Regression
  • Estimating the Prediction Interval of Multiple Regression in Excel
  • Regression - How To Do Conjoint Analysis Using Dummy Variable Regression in Excel
• Logistic Regression in Excel
  • Logistic Regression Overview
  • Logistic Regression in 6 Steps in Excel 2010 and Excel 2013
  • R Square For Logistic Regression Overview
  • Excel R Square Tests: Nagelkerke, Cox and Snell, and Log-Linear Ratio in Excel 2010 and Excel 2013
  • Likelihood Ratio Is Better Than Wald Statistic To Determine if the Variable Coefficients Are Significant For Excel 2010 and Excel 2013
  • Excel Classification Table: Logistic Regression’s Percentage Correct of Predicted Results in Excel 2010 and Excel 2013
  • Hosmer- Lemeshow Test in Excel – Logistic Regression Goodness-of-Fit Test in Excel 2010 and Excel 2013
• Single-Factor ANOVA in Excel
  • Overview of Single-Factor ANOVA
  • Single-Factor ANOVA in 5 Steps in Excel 2010 and Excel 2013
  • Shapiro-Wilk Normality Test in Excel For Each Single-Factor ANOVA Sample Group
  • Kruskal-Wallis Test Alternative For Single Factor ANOVA in 7 Steps in Excel 2010 and Excel 2013
  • Levene’s and Brown-Forsythe Tests in Excel For Single-Factor ANOVA Sample Group Variance Comparison
  • Single-Factor ANOVA - All Excel Calculations
  • Overview of Post-Hoc Testing For Single-Factor ANOVA
  • Tukey-Kramer Post-Hoc Test in Excel For Single-Factor ANOVA
  • Games-Howell Post-Hoc Test in Excel For Single-Factor ANOVA
  • Overview of Effect Size For Single-Factor ANOVA
  • ANOVA Effect Size Calculation Eta Squared in Excel 2010 and Excel 2013
  • ANOVA Effect Size Calculation Psi – RMSSE – in Excel 2010 and Excel 2013
  • ANOVA Effect Size Calculation Omega Squared in Excel 2010 and Excel 2013
  • Power of Single-Factor ANOVA Test Using Free Utility G*Power
  • Welch’s ANOVA Test in 8 Steps in Excel Substitute For Single-Factor ANOVA When Sample Variances Are Not Similar
  • Brown-Forsythe F-Test in 4 Steps in Excel Substitute For Single-Factor ANOVA When Sample Variances Are Not Similar
• Two-Factor ANOVA With Replication in Excel
  • Two-Factor ANOVA With Replication in 5 Steps in Excel 2010 and Excel 2013
  • Variance Tests: Levene’s and Brown-Forsythe For 2-Factor ANOVA in Excel 2010 and Excel 2013
  • Shapiro-Wilk Normality Test in Excel For 2-Factor ANOVA With Replication
  • 2-Factor ANOVA With Replication Effect Size in Excel 2010 and Excel 2013
  • Excel Post Hoc Tukey’s HSD Test For 2-Factor ANOVA With Replication
  • 2-Factor ANOVA With Replication – Test Power With G-Power Utility
  • Scheirer-Ray-Hare Test Alternative For 2-Factor ANOVA With Replication
• Two-Factor ANOVA Without Replication in Excel
  • Two-Factor ANOVA Without Replication in Excel 2010 and Excel 2013
• Randomized Block Design ANOVA in Excel
  • Randomized Block Design ANOVA in Excel 2010 and Excel 2013
• Repeated-Measures ANOVA in Excel
  • Single-Factor Repeated-Measures ANOVA in 4 Steps in Excel 2010 and Excel 2013
  • Sphericity Testing in 9 Steps For Repeated Measures ANOVA in Excel 2010 and Excel 2013
  • Effect Size For Repeated-Measures ANOVA in Excel 2010 and Excel 2013
  • Friedman Test in 3 Steps For Repeated-Measures ANOVA in Excel 2010 and Excel 2013
• ANCOVA in Excel
  • Single-Factor ANCOVA in 8 Steps in Excel 2010 and Excel 2013
• Normality Testing in Excel
  • Creating a Box Plot in 8 Steps in Excel
  • Creating a Normal Probability Plot With Adjustable Confidence Interval Bands in 9 Steps in Excel With Formulas and a Bar Chart
  • Chi-Square Goodness-of-Fit Test For Normality in 9 Steps in Excel
  • How To Create a Completely Automated Shapiro-Wilk Normality Test in Excel in 8 Steps
  • Kolmogorov-Smirnov, Anderson-Darling, and Shapiro-Wilk Normality Tests in Excel
• Nonparametric Testing in Excel
  • Mann-Whitney U Test in 12 Steps in Excel
  • Wilcoxon Signed-Rank Test in 8 Steps in Excel
  • Sign Test in Excel
  • Friedman Test in 3 Steps in Excel
  • Scheirer-Ray-Hope Test in Excel
  • Welch's ANOVA Test in 8 Steps Test in Excel
  • Brown-Forsythe F Test in 4 Steps Test in Excel
  • Levene's Test and Brown-Forsythe Variance Tests in Excel
  • Chi-Square Independence Test in 7 Steps in Excel
  • Chi-Square Goodness-of-Fit Tests in Excel
  • Chi-Square Population Variance Test in Excel
• Post Hoc Testing in Excel
  • Tukey's HSD Post Hoc Test in Excel
  • Tukey-Kramer Post Hoc Test in Excel
  • Games-Howell Post Hoc Test in Excel
• Creating Interactive Graphs of Statistical Distributions in Excel
  • Interactive Statistical Distribution Graph in Excel 2010 and Excel 2013
  • Interactive Graph of the Normal Distribution in Excel 2010 and Excel 2013
  • Interactive Graph of the Chi-Square Distribution in Excel 2010 and Excel 2013
  • Interactive Graph of the t-Distribution in Excel 2010 and Excel 2013
  • Interactive Graph of the t-Distribution’s PDF in Excel 2010 and Excel 2013
  • Interactive Graph of the t-Distribution’s CDF in Excel 2010 and Excel 2013
  • Interactive Graph of the Binomial Distribution in Excel 2010 and Excel 2013
  • Interactive Graph of the Exponential Distribution in Excel 2010 and Excel 2013
  • Interactive Graph of the Beta Distribution in Excel 2010 and Excel 2013
  • Interactive Graph of the Gamma Distribution in Excel 2010 and Excel 2013
  • Interactive Graph of the Poisson Distribution in Excel 2010 and Excel 2013
• Solving Problems With Other Distributions in Excel
  • Solving Uniform Distribution Problems in Excel 2010 and Excel 2013
  • Solving Multinomial Distribution Problems in Excel 2010 and Excel 2013
  • Solving Exponential Distribution Problems in Excel 2010 and Excel 2013
  • Solving Beta Distribution Problems in Excel 2010 and Excel 2013
  • Solving Gamma Distribution Problems in Excel 2010 and Excel 2013
  • Solving Poisson Distribution Problems in Excel 2010 and Excel 2013
• Optimization With Excel Solver
  • Maximizing Lead Generation With Excel Solver
  • Minimizing Cutting Stock Waste With Excel Solver
  • Optimal Investment Selection With Excel Solver
  • Minimizing the Total Cost of Shipping From Multiple Points To Multiple Points With Excel Solver
  • Knapsack Loading Problem in Excel Solver – Optimizing the Loading of a Limited Compartment
  • Optimizing a Bond Portfolio With Excel Solver
  • Travelling Salesman Problem in Excel Solver – Finding the Shortest Path To Reach All Customers
• Chi-Square Population Variance Test in Excel
  • Overview of the Chi-Square Population Variance Test in Excel 2010 and Excel 2013
• Analyzing Data With Pivot Tables and Pivot Charts
  • Simplifying Excel Pivot Table and Pivot Chart Setup
• SEO Functions in Excel
  • Top 10 Excel SEO Functions - You'll Like These
• Time Series Analysis in Excel
  • Forecasting With Exponential Smoothing in Excel
  • Forecasting With the Weighted Moving Average in Excel
  • Forecasting With the Simple Moving Average in Excel
• VLOOKUP
  • Simplifying Excel Lookup Functions: VLOOKUP, HLOOKUP, INDEX, MATCH, CHOOSE, and OFFSET
  • VLOOKUP - Just Like Looking Up a Number in a Telephone Book
  • VLOOKUP To Look Up a Discount in a Distant Database
• Measures of Central Tendency and Variation in Excel
  • Measures of Central Tendency in Excel
  • Measures of Variation in Excel
• Simplifying Useful Excel Functions and Tools
  • Simplifying Excel Functions: SUMIF, SUMIFS, COUNTIF, COUNTIFS, AVERAGEIF, and AVERAGEIFS
  • Simplifying Excel Form Controls: Check Box, Option Button, Spin Button, and Scroll Bar
  • Simplifying Excel Lookup Functions: VLOOKUP, HLOOKUP, INDEX, MATCH, CHOOSE, and OFFSET
  • Scenario Analysis in Excel With Option Buttons and the What-If Scenario Manager
  • Simplifying Goal Seek in Excel