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. Data analysis in excel can help you interpret that data.

This Data Analysis Video teaches you the basic tools for understanding, summarizing, and making future predictions with your collected data. Includes MS Excel templates.

Data Analysis Video

In the discussions below, we use Office 365 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

  1. Click the cell where you want the average to go.
  2. Type = in the desired cell
  3. Click the formulas tab
  4. Click More Functions
  5. Click Statistical
  6. Click Average
  7. Highlight all the numbers that need to be averaged
  8. Click Ok

Calculating Mode of the Data Set

  1. Click the cell where you want the mode to go.
  2. Type = in the desired cell
  3. Click the formulas tab
  4. Click More Functions
  5. Click Statistical
  6. Click mode.sngl
  7. Highlight all the numbers that need to find the mode
  8. Click Ok

This Data Analysis Video teaches you the basic tools for understanding, summarizing, and making future predictions with your collected data. Includes MS Excel templates.

Data Analysis Video

Calculating Median of the Data Set

  1. Click the cell where you want the median to go.
  2. Type = in the desired cell
  3. Click the formulas tab
  4. Click More Functions
  5. Click Statistical
  6. Click mode
  7. Highlight all the numbers that need to find the median
  8. Click Ok

Calculating the Standard Deviation of the Data Set

  1. Click the cell where you want the standard deviation to go.
  2. Type = in the desired cell
  3. Click the formulas tab
  4. Click More Functions
  5. Click Statistical
  6. Click STDev.S (sample population) 
  7. Highlight all the numbers that are needed for standard deviation
  8. Click Ok

This Data Analysis Video teaches you the basic tools for understanding, summarizing, and making future predictions with your collected data. Includes MS Excel templates.

Data Analysis Video

Calculating the Minimum of the Data Set

  1. Type = in the desired cell
  2. Click the formulas tab
  3. Click More Functions
  4. Click Statistical
  5. Click Min
  6. Highlight all the numbers that are needed to find the minimum
  7. Click Ok

Calculating the Maximum of the Data Set

  1. Type = in the desired cell
  2. Click the formulas tab
  3. Click More Functions
  4. Click Statistical
  5. Click Max
  6. Highlight all the numbers that are needed to find the maximum
  7. Click Ok

Calculating the Range of the Data Set

  1. Type = in the desired cell
  2. Click the Max cell
  3. Type –
  4. Click the Min Cell
  5. Type the Enter Key




Quality Assurance Solutions
Robert Broughton
(805) 419-3344
USA
email

Unique QA Products

All Products

Software, Videos, Manuals, Training Material

8D Manager

Corrective Action Software

Snap Sampling Plans!

AQL Inspection Software

TrainingKeeper Software

Plan and Track Training

StreamLiner Software

Lean and Continuous Improvement



Statistical Process Control

Training Video

ISO 9001:2015 QA Manual

Editable Template

ISO 9001 Calibration Manual

Editable Template

ISO 9001:2015 QMS Kit

Templates, Guides, QA Manual, Audit Checklists

QA Training Guides

ISO 9001, Kaizen, Benchmarking, 5S and more

All Products

Software, Videos, Manuals, Training Material


Please Recommend Us!

submit to reddit