Preface; Acknowledgments; Contents; Chapter 1: Sample Size, Mean, Standard Deviation, and Standard Error of the Mean; 1.1 Mean; 1.2 Standard Deviation; 1.3 Standard Error of the Mean; 1.4 Sample Size, Mean, Standard Deviation, and Standard Error of the Mean; 1.4.1 Using the Fill/Series/Columns Commands; 1.4.2 Changing the Width of a Column; 1.4.3 Centering Information in a Range of Cells; 1.4.4 Naming a Range of Cells; 1.4.5 Finding the Sample Size Using the =COUNT Function; 1.4.6 Finding the Mean Score Using the =AVERAGE Function

1.4.7 Finding the Standard Deviation Using the =STDEV Function1.4.8 Finding the Standard Error of the Mean; 1.4.8.1 Formatting Numbers in Number Format (Two decimal places); 1.5 Saving a Spreadsheet; 1.6 Printing a Spreadsheet; 1.7 Formatting Numbers in Currency Format (Two decimal places); 1.8 Formatting Numbers in Number Format (Three decimal places); 1.9 End-of-Chapter Practice Problems; Reference; Chapter 2: Random Number Generator; 2.1 Creating Frame Numbers for Generating Random Numbers; 2.2 Creating Random Numbers in an Excel Worksheet; 2.3 Sorting Frame Numbers into a Random Sequence

2.4 Printing an Excel File So That All of the Information Fits onto One Page2.5 End-of-Chapter Practice Problems; Reference; Chapter 3: Confidence Interval About the Mean Using the TINV Function and Hypothesis Testing; 3.1 Confidence Interval About the Mean; 3.1.1 How to Estimate the Population Mean; 3.1.2 Estimating the Lower Limit and the Upper Limit of the 95% Confidence Interval About the Mean; 3.1.3 Estimating the Confidence Interval for the Chevy Impala in Miles Per Gallon; 3.1.4 Where Did the Number ``1.96 ́́Come From?; 3.1.5 Finding the Value for t in the Confidence Interval Formula

3.1.6 Using Excelś TINV Function to Find the Confidence Interval About the Mean3.1.7 Using Excel to Find the 95% Confidence Interval for a Carś mpg Claim; 3.2 Hypothesis Testing; 3.2.1 Hypotheses Always Refer to the Population of People or Events That You Are Studying; 3.2.2 The Null Hypothesis and the Research (Alternative) Hypothesis; 3.2.2.1 Determining the Null Hypothesis and the Research Hypothesis When Rating Scales Are Used; 3.2.3 The 7 Steps for Hypothesis-Testing Using the Confidence Interval About the Mean; 3.2.3.1 STEP 1: State the Null Hypothesis and the Research Hypothesis

3.2.3.2 STEP 2: Select the Appropriate Statistical Test3.2.3.3 STEP 3: Calculate the Formula for the Statistical Test; 3.2.3.4 STEP 4: Draw a Picture of the Confidence Interval About the Mean, Including the Mean, the Lower Limit of the Interval,...; 3.2.3.5 STEP 5: Decide on a Decision Rule; 3.2.3.6 STEP 6: State the Result of Your Statistical Test; 3.2.3.7 STEP 7: State the Conclusion of Your Statistical Test in Plain English!; 3.3 Alternative Ways to Summarize the Result of a Hypothesis Test; 3.3.1 Different Ways to Accept the Null Hypothesis