Data Analysis with Microsoft Excel: Updated for Office 2007

248 Fundamentals of Statistics The p value changes from 0.024 to 0.249. A p value of 0.249 is not small enough to reject the nul ...

Chapter 6 Statistical Inference 249 The observed difference values don’t appear to follow the normal curve particularly well. Le ...

250 Fundamentals of Statistics From the two plots, there is enough graphical evidence to make us worry that the data do not foll ...

Chapter 6 Statistical Inference 251 Table 6-4 Signed Ranks Variable Values Signed Ranks 18 7.0 4 2.0 15 6.0 25 2 3.5 22 2 1.0 10 ...

252 Fundamentals of Statistics The bottom line is that if there is some question about whether to use a parametric or a nonparam ...

Chapter 6 Statistical Inference 253 percentage points (4 cities were unchanged). This information strengthens our earlier conclu ...

254 Fundamentals of Statistics 5 Click the OK button to generate the output from the Sign test. See Figure 6-17. median differen ...

Chapter 6 Statistical Inference 255 conclude that there has been an increase in the percentage of women par- ticipating in the w ...

256 Fundamentals of Statistics Comparing the Pooled and Unpooled Test Statistics There are important differences between the two ...

Chapter 6 Statistical Inference 257 where m 1 is the assumed mean of the fi rst distribution and m 2 is the mean of the second d ...

258 Fundamentals of Statistics Testing for Equality of Variance Part of the challenge in performing a two-sample t test is deter ...

Chapter 6 Statistical Inference 259 BARTLETT2(values, category) Returns the p value of the Bartlett test statistic for values in ...

260 Fundamentals of Statistics You’ve been asked to examine the data and determine whether there was a difference in revenue gen ...

Chapter 6 Statistical Inference 261 3 Click the Data Values button and select Revenue from the list of range names. 4 Click the ...

262 Fundamentals of Statistics According to the output, the average revenue for nonrural homes is $16,821, whereas for rural hom ...

Chapter 6 Statistical Inference 263 Under the pooled test the p value changes to 0.048, leading us to reject the null hypothesis ...

264 Fundamentals of Statistics Figure 6-22 indicates that there is a moderate outlier for revenues gener- ated by rural nursing ...

Chapter 6 Statistical Inference 265 Applying a Nonparametric Test to Two-Sample Data The two-sample nonparametric test is the Ma ...

266 Fundamentals of Statistics The Mann-Whitney test relies on ranks; this lessens the effect of outliers. The downside is that ...

Chapter 6 Statistical Inference 267 From the output in Figure 6-23, we note that the median revenue from nonrural nursing homes ...