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.


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

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

  • Process Improvement and KPOVs

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

  • 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.

  • Histogram in Excel

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

  • Learn Data Analysis Techniques

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

  • Regression

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

  • 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!

  • Continuous Data

    Continuous data is part of six sigma tools and statistical process control

  • 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. $59.00. Satisfaction guaranteed.

  • Chi Square

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

  • Process Capability Studies

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

  • Anova

    Anova : One-Way Analysis of Variance (ANOVA) is used to compare the means of two or more sample


> >



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

Unique QA Products

All Products

Software, Videos, Manuals, On-Line Certifications

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

On-Line Accredited Certifications

Six Sigma, Risk Management, SCRUM

All Products

Software, Videos, Manuals, Training Material


Please Recommend Us!

submit to reddit