Data Analysis with Microsoft Excel: Updated for Office 2007
148 Fundamentals of Statistics This stem and leaf plot is at a disadvantage compared to the histogram in that the size of each b ...
Chapter 4 Describing Your Data 149 To create a stem and leaf plot: 1 Return to the data set by clicking the Housing Data workshe ...
150 Fundamentals of Statistics 8 Click the OK button. Excel generates the stem and leaf plot shown in Figure 4-14. Figure 4-14 S ...
Chapter 4 Describing Your Data 151 Distribution Statistics You should always create a chart of the distribution when analyzing a ...
152 Fundamentals of Statistics QUARTILE(array, quart) Returns the quartile of an array of values or range reference, where quart ...
Chapter 4 Describing Your Data 153 7 Click the OK button to create the table of percentiles. Figure 4-16 shows the completed tab ...
154 Fundamentals of Statistics It’s particularly striking to note that the 90th percentile for home prices out- side the northea ...
Chapter 4 Describing Your Data 155 The total number of observations in the sample is represented by the symbol n, and each indiv ...
156 Fundamentals of Statistics lower values. Both approaches have their limitations, and the best approach is to examine the dat ...
Chapter 4 Describing Your Data 157 Table 4-5 Excel functions to calculate the distribution’s center Function Description AVERAGE ...
158 Fundamentals of Statistics 7 Click the OK button to create the table of values (see Figure 4-19). Figure 4-18 Selecting summ ...
Chapter 4 Describing Your Data 159 Measures of Variability The mean and median do not tell the whole story about a distribution. ...
160 Fundamentals of Statistics The most common measure of variability depends on the deviation of each data value from the sampl ...
Chapter 4 Describing Your Data 161 other out. In fact, the sum of the deviations between each sample value and the sample mean e ...
162 Fundamentals of Statistics Measures of Shape: Skewness and Kurtosis You’ve seen that different distributions can be characte ...
Chapter 4 Describing Your Data 163 7 Click the OK button to create the table. Figure 4-23 shows the vari- ability statistics gen ...
164 Fundamentals of Statistics STATPLUS TIPS You can select all summary, variability, or distribution statistics by clicking the ...
Chapter 4 Describing Your Data 165 differences involved. In any case, you should not remove an observation without good cause an ...
166 Fundamentals of Statistics Concept Tutorials: Boxplots The fi les available with this book contain several instructional wor ...
Chapter 4 Describing Your Data 167 3 Click The interquartile from the list of subject titles. The box part of the boxplot displa ...
«
4
5
6
7
8
9
10
11
12
13
»
Free download pdf