Excel Chapter 8

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

Conditional statistical functions

Statistical functions, such as SUM, AVERAGE, and COUNT, perform calculations on the range specified in the arguments [1]. Conditional statistical functions, such as SUMIF, AVERAGEIF, and COUNTIF, perform calculations based on a condition [1]. 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.

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.