Excel 2019 Bible

Part II: Working with Formulas and Functions FIGURE 16.3 A partial listing of golf scores FIGURE 16.4 A graph of raw golf scores ...

Chapter 16: Using Formulas for Statistical Analysis 16 The OFFSET function is used to return a particular range that’s offset fr ...

Part II: Working with Formulas and Functions FIGURE 16.5 The moving average is charted over the raw scores. FIGURE 16.6 The dema ...

Chapter 16: Using Formulas for Statistical Analysis 16 The alpha value, shown in cell H2 on Figure 16.6, is the weight given to ...

Part II: Working with Formulas and Functions Getting the largest or smallest value Figure 16.8 shows the average low temperature ...

Chapter 16: Using Formulas for Statistical Analysis 16 in the list. INDEX uses that 7 to return the seventh row of the lists of ...

Part II: Working with Formulas and Functions If two values in the list have the same value, LARGE and SMALL return the same valu ...

Chapter 16: Using Formulas for Statistical Analysis 16 To determine the rank of Gianna Ruiz, we pass into RANK the time in C3, t ...

Part II: Working with Formulas and Functions even number of grades, there is not an exact middle value. In that case, MEDIAN ret ...

Chapter 16: Using Formulas for Statistical Analysis 16 FIGURE 16.12 The grades listing sorted by grade Bucketing Data into Perce ...

Part II: Working with Formulas and Functions FIGURE 16.13 Identifying quartiles for product defects The QUARTILE function provid ...

Chapter 16: Using Formulas for Statistical Analysis 16 The quart argument in our QUARTILE function uses the expression 5-ROW(A1) ...

Part II: Working with Formulas and Functions FIGURE 16.14 Sorted data and demarcation lines To identify outliers, we’ll use a me ...

Chapter 16: Using Formulas for Statistical Analysis 16 Fence Factor: 1.5 Upper Fence: =G4+(G6*G8) Lower Fence: =G5-(G6*G8) Outli ...

Part II: Working with Formulas and Functions FIGURE 16.16 Leveraged interquartile ranges expand the fences outward. To determine ...

Chapter 16: Using Formulas for Statistical Analysis 16 Creating a Frequency Distribution Quartiles are a popular way to group da ...

Part II: Working with Formulas and Functions column F. Column E does not affect the formula; it’s just there to show the lower b ...

385 C H A P T E R 17 Using Formulas with Tables and Conditional Formatting IN THIS CHAPTER Highlighting cells that meet certain ...

Part II: Working with Formulas and Functions FIGURE 17.1 The cells in this table are conditionally formatted to show a red backg ...

Chapter 17: Using Formulas with Tables and Conditional Formatting 17 In the list box at the top of the dialog box, click the op ...