Data Analysis with Microsoft Excel: Updated for Office 2007

268 Fundamentals of Statistics Exercises True or false (and why): A 95% confi dence interval that covers the range ( 2 5, 5) te ...

Chapter 6 Statistical Inference 269 d. Create a boxplot of the Beds variable for the different locations. Do the plot and the de ...

270 Fundamentals of Statistics The Junior College workbook contains salary information for faculty at a col- lege. The female f ...

Chapter 6 Statistical Inference 271 e. Redo your analysis using the Wil- coxon Signed Rank test. How do your results compare to ...

272 Fundamentals of Statistics b. State your null and alternative hypotheses. c. Perform a two-sample t test compar- ing the val ...

Chapter 6 Statistical Inference 273 the difference between the 1980 and 1984 voting patterns. a. Open the Voting workbook from t ...

274 Fundamentals of Statistics Have you accepted the null hypoth- esis, or is there evidence that reaction times do change from ...

275 Chapter 7 TABLES Objectives In this chapter you will learn to: Create PivotTables of a single categorical variable Create Pi ...

I n this chapter you’ll learn how to work with categorical data in the form of tables and ordinal variables. You’ll learn how to ...

Chapter 7 Tables 277 To open the Survey workbook: 1 Start Excel if necessary and maximize the Excel window. 2 Open the Survey wo ...

To insert a PivotTable: 1 Click the Insert tab from the Excel ribbon and then click the Pivot- Table button from the Tables grou ...

Chapter 7 Tables 279 Now you control the layout of the PivotTable. A PivotTable has four areas. The Row Labels determine the cat ...

280 Fundamentals of Statistics 2 Drag Dept from the PivotTable Field List box and drop it in the Values box. As shown in Figure ...

Chapter 7 Tables 281 To remove a category from the PivotTable: 1 Click the Row Labels drop-down box on the PivotTable. 2 Deselec ...

282 Fundamentals of Statistics The PivotTable now shows a grand total of 345 respondents with the blank department category remo ...

Chapter 7 Tables 283 To view the counts of the responses again: 1 Right-click any of the percentages in the PivotTable and then ...

284 Fundamentals of Statistics The PivotChart works the same as the PivotTable. For example, if you click the Axis Fields button ...

Chapter 7 Tables 285 2 Click Center from the list of Data Label options. Excel updates the chart, which now shows the counts for ...

286 Fundamentals of Statistics From the pie chart we can easily see a graphical comparison of the size of each department group ...

Chapter 7 Tables 287 The pie chart is an effective tool for displaying categorical data, though it tends to be used more often i ...