Data Analysis in Excel

data analysis in excel slide

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.


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
Comment Box is loading comments...

More Info

  • Data and Information, are often used interchangeably, they don’t mean the same thing

    Data and Information

    Data and Information, are often used interchangeably, they don’t mean the same thing

  • Lean Sigma is different to many traditional Process Improvement initiatives in its reliance on data to make decisions

    Process Improvement and KPOVs

    Lean Sigma is different to many traditional Process Improvement initiatives in its reliance on data to make decisions

  • Follow these steps to create a Histogram in Excel. This includes turning on data analysis, creating bins, and sorting data.

    Histogram in Excel

    Follow these steps to create a Histogram in Excel. This includes turning on data analysis, creating bins, and sorting data.

  • See our histogram examples. We discuss normal distribution and how it applies to quality assurance. Histograms are a key process improvement tool.

    Histogram Examples: A Picture of Your Data

    See our histogram examples. We discuss normal distribution and how it applies to quality assurance. Histograms are a key process improvement tool.

  • When you understand data analysis techniques, you take a big step towards making product and process improvements.

    Learn Data Analysis Techniques

    When you understand data analysis techniques, you take a big step towards making product and process improvements.

  • Download Today. Don’t take chances without understanding your data. Data drives business decisions. But how does this work? This introduction to Data Analysis Video shows you how to gather, summarize, and present data to management and your team. $69.00. Satisfaction guaranteed.

    Data Analysis Video

    Download Today. Don’t take chances without understanding your data. Data drives business decisions. But how does this work? This introduction to Data Analysis Video shows you how to gather, summarize, and present data to management and your team. $69.00. Satisfaction guaranteed.

  • A Run Chart displays the process performance over time. It is a line graph of data points plotted in chronological order. Learn more!

    Run Chart

    A Run Chart displays the process performance over time. It is a line graph of data points plotted in chronological order. Learn more!

  • See our article on regression, includes details, collecting the data, examples, roadmap and possible problems

    Regression

    See our article on regression, includes details, collecting the data, examples, roadmap and possible problems

  • Learn how to evaluate your continuous data and assure satisfactory inspection. Without conducting an MSA on your data set, you put your inspection data at risk.

    Continuous Data

    Learn how to evaluate your continuous data and assure satisfactory inspection. Without conducting an MSA on your data set, you put your inspection data at risk.

  • Process capability studies demonstrate the fit of your data to your specifications.  Machine process capability determines current and future defects.

    Process Capability Studies

    Process capability studies demonstrate the fit of your data to your specifications. Machine process capability determines current and future defects.

  • Learn how to apply Chi Square in practice, when to use it , how to insure results

    Chi Square

    Learn how to apply Chi Square in practice, when to use it , how to insure results


Quality Assurance Solutions
Robert Broughton
(805) 419-3344
USA
email
Enjoy this page? Please pay it forward. Here's how...

Would you prefer to share this page with others by linking to it?

  1. Click on the HTML link code below.
  2. Copy and paste it, adding a note of your own, into your blog, a Web page, forums, a blog comment, your Facebook account, or anywhere that someone would find this page valuable.

All Products

Software, Videos, Manuals, On-Line Certifications

PDCA Complete

An Organizational Task Management System. Projects, Meetings, Audits & more

8D Manager

Corrective Action Software

TrainingKeeper Software

Plan and Track Training

Snap Sampling Plans!

AQL Inspection Software

QAS Business Slide Deck

450+ Editable Slides with support links

TRIZ Kit

Learn and Train TRIZ

ISO 9001:2015 QA Manual

Editable Template

ISO 9001:2015 QMS Kit

Templates, Guides, QA Manual, Audit Checklists

ISO 14001:2015 EMS Kit

EMS Manual, Procedures, Forms, Examples, Audits, Videos

On-Line Accredited Certifications

Six Sigma, Risk Management, SCRUM

All Products

Software, Videos, Manuals, On-Line Certifications