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.

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

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

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

1. QAS Home
>
2. CI Tools
>
3. Data Analysis in Excel

---

---

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