Data Analysis with Microsoft Excel: Updated for Office 2007

128 Chapter 4 DESCRIBING YOUR DATA Objectives In this chapter you will learn: About different types of variables How to create t ...

Chapter 4 Describing Your Data 129 C hapter 4 introduces the different tools that statisticians use to describe and summarize th ...

130 Fundamentals of Statistics Continuous variables, on the other hand, have values from a wide range of possible values. An ind ...

Chapter 4 Describing Your Data 131 Table 4-2 Summary of variable properties Quantitative Variables whose values come in meaningf ...

132 Fundamentals of Statistics To view the Housing workbook: 1 Start Excel. 2 Open the Housing workbook from the Chapter04 folde ...

Chapter 4 Describing Your Data 133 but you can use the one supplied with the StatPlus add-in. Use StatPlus now to create a frequ ...

134 Fundamentals of Statistics The table contains fi ve columns. The fi rst column, Price, lists in ascend- ing order each home ...

Chapter 4 Describing Your Data 135 To interpret a frequency table that involves bins correctly, you need to know which of these ...

136 Fundamentals of Statistics Figure 4-4 Frequency table with equally spaced bins This frequency table gives us a little cleare ...

Chapter 4 Describing Your Data 137 3 Select the range G2:G3, drag the fi ll handle down to cell G20, and release the mouse butto ...

138 Fundamentals of Statistics This table is a lot easier to interpret than that of Figure 4-4. Looking at the table, it’s easy ...

Chapter 4 Describing Your Data 139 3 Click the Chart Options dialog tab. 4 Click the Values button and then click the Use Range ...

140 Fundamentals of Statistics Figure 4-7 Completed histogram dialog box you can create four different types of histograms 10 Cl ...

Chapter 4 Describing Your Data 141 The histogram gives us the strong visual picture that most of the home prices in this 1993 sa ...

142 Fundamentals of Statistics Figure 4-9 Distribution shapes ...

Chapter 4 Describing Your Data 143 Another important component of a distribution’s shape is the distribu- tion’s tails—the value ...

144 Fundamentals of Statistics 9 Click the Output button and type Price Histogram by NE Sector in the Chart Sheet name box. Clic ...

Chapter 4 Describing Your Data 145 3 Click the Change Chart Type button on the Type group on the Design tab. 4 Excel opens the C ...

146 Fundamentals of Statistics This chart shows us that the distribution of home prices is positively skewed (as we would expect ...

Chapter 4 Describing Your Data 147 Match each leaf to its stem, placing the leaf values in ascending order horizontally to the ...