Topic Index > Excel for Statistics In order to follow this article, you should know how to create a regular distribution table/histogram in Excel. Don’t know how? Check out this video/article first: How to Make a Frequency Distribution Table in…

# How to Find Pearson’s Coefficient of Skewness in Excel

Topic Index > Microsoft Excel for Statistics Pearson’s coefficient of skewness is a method developed by Karl Pearson to find skewness in a sample using descriptive statistics like the mean and mode. Skewness is one measure of the shape of…

# How to Make a Scatter Plot in Excel

Topic Index > Excel for Statistics > How to make a scatter plot in Excel In this article, I’ll cover how to make a scatter plot in Excel plus some advanced options like formatting your chart, adding labels, and adding…

# Excel Regression Analysis Output Explained

Topic Index > Excel for statistics > Excel Regression Analysis Output Explained Previous article: Excel 2013 Regression Analysis How To Watch the video or read the steps below: Excel Regression Analysis Output Explained In the previous article, I explained how…

# Which Standard Deviation to use in Excel: STDEV to STDEV.P

Main Index > Excel for statistics > Which Standard Deviation to use in Excel? Watch the video or read the article below: Which Standard Deviation to use in Excel? Excel 2013 has SIX functions to find the standard deviation: STDEV,…

# Two Sample z Test Excel 2013: Easy Steps

Main Index > Excel for Statistics > Two Sample z Test Excel 2013 Watch the video or read the steps below: Two Sample z Test Excel 2013: Overview A two sample z test in Excel compares the means of two…

# How to make a bar graph in Excel 2013

Main Index > Excel for Statistics > How to make a bar graph in Excel 2013 Watch the video or read the steps below to learn How to make a bar graph in Excel 2013. Plus, learn some basic formatting…

# Column Chart Excel 2013: Make one in Easy Steps

Main Index: Column Chart Excel 2013 Watch the video or read the steps below: Column Chart Excel 2013: Overview Column charts compare categories of data and display them graphically. Excel has a myriad of options for column charts, but you…

# Excel Pivot Table (Excel 2013): Easy Steps — Video

Statistics Videos > Excel pivot table Excel Pivot Tables A pivot table is way to summarize data. It’s called a “pivot” table because you can pivot the table; In other words, you can switch rows and columns. These charts are…

# Excel Sampling: How to find a Sample in Excel

Statistics Videos > How to use Excel Sampling to find a Sample Watch the video or read the steps below: How to use Excel Sampling to find a Sample If you have a set of data and you know your…