Probability and Statistics > Microsoft Excel for Statistics
Microsoft Excel for Statistics
This collection of articles will guide you through the most common functions in Microsoft Excel for statistics. For nearly all Excel stats operations, you’ll have to load the Data Analysis ToolPak first. One advantage of using Microsoft Excel for statistics is that you can enter your data and manipulate it. For example, you can sort from A to Z or high values to low. You can also create several graphs next to your data.
Microsoft Excel for Statistics Topics (2007-2010)
- How to find a 5 Number Summary in Excel.
- how to make a Box and Whiskers Chart in Excel.
- How to Make a Column Chart in Excel
- How to find a Z-Score in Excel.
- The Mode in Microsoft Excel.
- An Interquartile Range Excel 2007.
- The Standard Deviation in Excel.
- The Mean in Excel 2007 & 2010.
- How to run a Hypothesis Test in Excel.
- How to find a Confidence Interval for the Mean: Excel.
- How to find a chi-square p-value in Excel
- The Median in Excel.
- How to find a Normal Distribution Probability in Excel.
- Excel Descriptive Statistics.
- Excel Data Analysis Toolpak.
- How to Create a Histogram in Excel 2007.
- The Normal Distribution Excel 2007.
- An Excel beta distribution.
- The Correlation Coefficient Excel 2007.
- How to make a Scatter Plot in Excel 2007.
- A Linear Regression Equation in Microsoft Excel.
- Chebyschev’s Theorem in Excel.
- A Frequency Distribution in Excel.
- A Pie Chart in Excel.
- The Random Number Generator in Excel.
- How to find Pearson’s Coefficient of Skewness in Excel.
- Excel Multiple Regression (Polynomial Regression).
- T Test in Excel.
Microsoft Excel for Statistics: Excel 2013
- Make a Scatter Plot in Excel 2013.
- How to Make a Bar Graph in Excel 2013.
- A Histogram in Excel 2013.
- An ANOVA Excel 2013.
- A Two Way ANOVA in Excel with replication & without replication.
- Find Covariance in Excel 2013.
- Find Correlation in Excel.
- Find Sample Variance Excel.
- Kurtosis Excel in 2013.
- Find Skewness in Excel 2013.
- How to Sum in Excel 2013.
- Find Standard Deviation in Excel.
- The Mode in Excel 2013.
- The Median in Excel 2013.
- The Standard Error in Excel 2013.
- The Mean in Excel 2013.
- Load the Excel Data analysis Toolpak.
- Skewness in Excel 2013.
- The Range in Excel 2013.
- Sample Variance in Excel 2013.
- Exponential Smoothing in Excel 2013.
- F test two sample for Variance.
- Fourier Analysis in Excel 2013.
- Moving Average in Excel 2013.
- Make an Excel Pivot Table.
- Excel Sampling: Find a Sample.
- Run the Excel 2013 Regression analysis.
- Excel Regression Analysis Output Explained.
- Use the Excel PERCENTRANK function and Excel PERCENTILE function.
- Use the Excel RANK function (Excel 2013).
- T-Test in Excel 2013.
- Two Sample z test in Excel 2013.
Subscribe to our YouTube channel for more Microsoft Excel for Statistics help and tips!
Excel for Statistics: Problems, Tips and Warnings
If you’re using Microsoft Excel in your stat class, you may be surprised to learn that Excel is actually a very poor choice. Excel is a great spreadsheet package, but it was never intended to be used for statistical analysis. The Data Analysis package is an optional add-in. That should give you a clue that data analysis isn’t Excel’s strong point. You can easily make simple graphs and calculations. But you’ll run into some serious issues with more complex tasks: Including missing data.
Specific Issues with Excel for Statistics
According to the University of Massachusetts, Excel has several issues with statistical calculations. These include:
- Excel can only perform certain tests on one column at a time. In the “real world,” it’s unlikely that you’ll have a single column of variables; You’re much more likely to have a mix over several columns. This can cause issues with running t-tests and even simple frequency counts
- Excel doesn’t log what you are doing. So if you forget what you’ve done, or simply want to repeat a task, that may not be possible without starting from scratch
- If you want to perform a series of statistical tests on your data, you’re likely going to be doing a lot of copying, pasting, sorting, and rearranging. That’s because each test in Excel requires the data to be arranged in a certain way. For example, the One-Way ANOVA requires that data be arranged in separate and adjacent columns or rows for each group. The two-factor ANOVA with replicates requires a rectangular region with columns representing one factor and rows representing the other. With a statistical package such as SPSS, you won’t have to rearrange anything.
These are just a few of the pitfalls with Excel for statistics. Of course, statistical packages like SPSS are likely out of your budget; They cost thousands of dollars which is why the casual user chooses Excel. However, if your school or work offers a statistical package, you may want to learn it. In the long run your computations will be easier, less time-consuming and more accurate.