Data Analysis in Excel

This article discusses basic data analysis in excel.

In order to improve your Quality Assurance you must be able to measure and then interpret that data. MS Excel can help you interpret that data.

Overall, Excel is not the best software for working with statistics. Nor is it the best for quickly generating histograms. However it can be done. With some effort, this article shows you how to do basic data analysis in Excel.

In the discussions below, we use MS Excel 2007 version. Earlier versions can also be used.

Before you do data analysis in excel, read “what is data analysis”. All of the statistics found on this page are explain there.

Calculating Mean or Average of the data set

Click the cell where you want the average to go.
Type = in the desired cell
Click the formulas tab
Click More Functions
Click Statistical
Click Average

Highlight all the numbers that need to be averaged
Click Ok

Calculating Mode of the data set

Click the cell where you want the mode to go.
Type = in the desired cell
Click the formulas tab
Click More Functions
Click Statistical
Click mode
Highlight all the numbers that need to find the mode
Click Ok

Calculating Median of the data set

Click the cell where you want the median to go.
Type = in the desired cell
Click the formulas tab
Click More Functions
Click Statistical
Click mode
Highlight all the numbers that need to find the median
Click Ok

Calculating the Standard Deviation of the data set

Click the cell where you want the standard deviation to go.
Type = in the desired cell
Click the formulas tab
Click More Functions
Click Statistical
Click STDev
Highlight all the numbers that are needed for standard deviation
Click Ok

Calculating the Minimum of the data set

Type = in the desired cell
Click the formulas tab
Click More Functions
Click Statistical
Click Min
Highlight all the numbers that are needed to find the minimum
Click Ok

Calculating the Maximum of the data set

Type = in the desired cell
Click the formulas tab
Click More Functions
Click Statistical
Click Max
Highlight all the numbers that are needed to find the maximum
Click Ok

Calculating the Range of the data set

Type = in the desired cell
Click the Max cell
Type –
Click the Min Cell
Type the Enter Key

Creating Histograms in Excel
Instructions for creating Excel Histograms

Applications That Drive Improvement
Robert Broughton
(805) 200-7979
USA
email