# Excel Chapter 8

## Chapter Demonstrable Skills

After completing the Excel Chapter 8 portion of the Excel & Data Analysis unit, students will be able to:

Demonstrable Skill Learning Activities
& Informal Assessments
Formal Assessments
(excluding Exams)
Import data from Access databases.
• Excel: Excel Basics Participation Project
• MyLab Lesson A
• Homework #6
• MyLab Lesson A
Use conditional math and statistical functions such as SUMIF, AVERAGEIF, and COUNTIF.
• Excel: Formulas & Functions III Participation Project
• MyLab Lesson B
• MyLab Lesson B
Use ranking functions like RANK.EQ and RANK.AVG.
• Excel: Formulas & Functions I Participation Project
• MyLab Lesson A
• Homework #1
• MyLab Lesson A
Perform correlation analysis.
• Excel: What-If Analysis Participation Project
• MyLab Lesson B
• MyLab Lesson B
Calculate frequency distributions.
• MyLab Lesson B
• MyLab Lesson B
• MyLab Lesson B
• MyLab Lesson B
Create and format a forecast sheet.
• MyLab Lesson B
• MyLab Lesson B

## Chapter Notes

### Conditional statistical functions

Statistical functions, such as SUM, AVERAGE, and COUNT, perform calculations on the range specified in the arguments . Conditional statistical functions, such as SUMIF, AVERAGEIF, and COUNTIF, perform calculations based on a condition . We've already looked at basic statistical functions in Excel Chapter 2. This chapter add a conditional if onto the the original function.Adding an IF to each of these functions allows you to determine if a value will be included in the calculation or not.  For example, you might want to use the COUNTIF function to count all of the As in a class.

## References

1. A. Poatsy, K. Mulberry, C. Krebs, L. Hogan, A. Rutledge, and E. Cameron, Exploring Microsoft Office 2013, 1st ed., vol. 2. Upper Saddle River, NJ: Pearson Education, 2013.