Home

Products Products
Videos
Customers

Consulting Contact Us
E-zine
The QA Blog

Tools CI Tools
8D Reports
Sampling
SWOT
Data Analysis
SPC
Flowcharts
5S
Histograms
CpK
Kaizen
Brainstorming
Web Tools

Management ISO 9001
The Basics
QA vs. QC
TQM
QMS Review
QA Manual
Metrics
Control Plan
QC
QA Jobs

Systems Corrective Action
Calibration
Document Control
QA Audit
Traceability
Material Control
Preventive Action
Risk Management
Training Software

[?] Subscribe To This Site

XML RSS
Add to Google
Add to My Yahoo!
Add to My MSN
Subscribe with Bloglines
 

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.

Introduction to Data Analysis

Training Video (Created by Quality Assurance Solutions)



Price $49.95

Buy Now

Data Analysis is key to making business decisions about your process or product. To improve the process or product you have to measure it. Once you have the measurements, you need to quickly interpret the data.

This hour long video will show you how to present the data to management and others. Normally, management is not interested in the raw data. Business decisions are based on the summarized data or graphs of the data.

This course provides the basic tools for understanding, summarizing, creating graphs, and making future yield predictions with your collected data.

You will learn about

  • the types of data
  • basic statistics such as averages and variation
  • creating and interpreting histograms
  • normal distribution
  • process capability
  • predicting yields
  • the relationship between process improvement and data
  • pareto charts
  • data analysis in excel

In addition you will learn how to use Microsoft Excel to conduct the data analysis. A final spreadsheet is provided for your review.

Your Satisfaction is Guaranteed.

Within 30 days, if you are not satisfied with this training video, I will refund your money.

Price $49.95

Buy Now

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


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


© Copyright Quality-Assurance-Solutions.com