 The Resource Excel 2010 for social science statistics : a guide to solving practical statistics problems, by Thomas J. Quirk

# Excel 2010 for social science statistics : a guide to solving practical statistics problems, by Thomas J. Quirk Resource Information The item Excel 2010 for social science statistics : a guide to solving practical statistics problems, by Thomas J. Quirk represents a specific, individual, material embodiment of a distinct intellectual or artistic creation found in Massey University Library, University of New Zealand.This item is available to borrow from 1 library branch.

Label
Excel 2010 for social science statistics : a guide to solving practical statistics problems
Title
Excel 2010 for social science statistics
Title remainder
a guide to solving practical statistics problems
Statement of responsibility
by Thomas J. Quirk
Creator
Subject
Language
eng
UKMGB
Quirk, Thomas Joseph
Illustrations
illustrations
Index
no index present
Literary form
non fiction
• Social sciences
Label
Excel 2010 for social science statistics : a guide to solving practical statistics problems, by Thomas J. Quirk
Instantiates
Publication
Contents
• Standard Error of the Mean
• 4.1.5 STEP 5
• Find the Critical Value of t in the t-Table in Appendix E
• 4.1.6 STEP 6
• State the Result of Your Statistical Test
• 4.1.7 STEP 7
• State the Conclusion of Your Statistical Test in Plain English!
• 4.2.
• One-Group t-Test for the Mean
• 4.3.
• Can You Use Either the 95% Confidence Interval About the Mean or the One-Group t-Test When Testing Hypotheses?
• 1.4.
• 4.4.
• End-of-Chapter Practice Problems
• References
• 5.
• Two-Group t-Test of the Difference of the Means for Independent Groups
• 5.1.
• The 9 STEPS for Hypothesis-testing Using the Two-Group t-Test
• 5.1.1.
• Step 1: Name One Group, Group 1, and the Other Group, Group 2
• 5.1.2.
• Sample Size, Mean, Standard Deviation, and Standard Error of the Mean
• Step 2: Create a Table That Summarizes the Sample Size, Mean Score, and Standard Deviation of Each Group
• 5.1.3.
• Step 3: State the Null Hypothesis and the Research Hypothesis for the Two-Group t-Test
• 5.1.4.
• Step 4: Select the Appropriate Statistical Test
• 5.1.5.
• Step 5: Decide on a Decision Rule for the Two-Group t-Test
• 5.1.6.
• Step 6: Calculate the Formula for the Two-Group t-Test
• 5.1.7.
• 1.4.1.
• Step 7: Find the Critical Value of t in the t-Table in Appendix E
• 5.1.8.
• Step 8: State the Result of Your Statistical Test
• 5.1.9.
• Step 9: State the Conclusion of Your Statistical Test in Plain English!
• 5.2.
• Formula #1: Both Groups Have More Than 30 People in Them
• 5.2.1.
• An Example of Formula #1 for the Two-Group t-Test
• 5.3.
• Using the Fill/Series/Columns Commands
• Formula #2: One or Both Groups Have Less Than 30 People in Them
• 5.4.
• End-of-Chapter Practice Problems
• References
• 6.
• Correlation and Simple Linear Regression
• 6.1.
• What Is a "Correlation?"
• 6.1.1.
• Understanding the Formula for Computing a Correlation
• 1.4.2.
• 6.1.2.
• Understanding the Nine Steps for Computing a Correlation, r
• 6.2.
• Using Excel to Compute a Correlation Between Two Variables
• 6.3.
• Creating a Chart and Drawing the Regression Line onto the Chart
• 6.3.1.
• Using Excel to Create a Chart and the Regression Line Through the Data Points
• 6.4.
• Printing a Spreadsheet so That the Table and Chart Fit onto One Page
• Changing the Width of a Column
• 6.5.
• Finding the Regression Equation
• 6.5.1.
• Installing the Data Analysis ToolPak into Excel
• 6.5.2.
• Using Excel to Find the SUMMARY OUTPUT of Regression
• 6.5.3.
• Finding the Equation for the Regression Line
• 6.5.4.
• Using the Regression Line to Predict the y-Value for a Given x-Value
• 1.4.3.
• 6.6.
• Adding the Regression Equation to the Chart
• 6.7.
• How to Recognize Negative Correlations in the SUMMARY OUTPUT Table
• 6.8.
• Printing Only Part of a Spreadsheet Instead of the Entire Spreadsheet
• 6.8.1.
• Printing Only the Table and the Chart on a Separate Page
• 6.8.2.
• Printing Only the Chart on a Separate Page
• Centering Information in a Range of Cells
• 6.8.3.
• Printing Only the SUMMARY OUTPUT of the Regression Analysis on a Separate Page
• 6.9.
• End-of-Chapter Practice Problems
• References
• 7.
• Multiple Correlation and Multiple Regression
• 7.1.
• Multiple Regression Equation
• 7.2.
• 1.4.4.
• Finding the Multiple Correlation and the Multiple Regression Equation
• 7.3.
• Using the Regression Equation to Predict FROSH GPA
• 7.4.
• Using Excel to Create a Correlation Matrix in Multiple Regression
• 7.5.
• End-of-Chapter Practice Problems
• References
• 8.
• One-Way Analysis of Variance (ANOVA)
• Machine generated contents note:
• Naming a Range of Cells
• 8.1.
• Using Excel to Perform a One-Way Analysis of Variance (ANOVA)
• 8.2.
• How to Interpret the ANOVA Table Correctly
• 8.3.
• Using the Decision Rule for the ANOVA F-Test
• 8.4.
• Testing the Difference Between Two Groups Using the ANOVA t-Test
• 8.4.1.
• Comparing Republicans vs. Democrats in Their Attitude Toward U.S. Military Spending Using the ANOVA t-Test
• 1.4.5.
• 8.5.
• End-of-Chapter Practice Problems
• References
• Appendices
• Appendix A
• Answers to End-of-Chapter Practice Problems
• Appendix B
• Practice Test
• Appendix C
• Answers to Practice Test
• Finding the Sample Size Using the =COUNT Function
• Appendix D
• Statistical Formulas
• Appendix E
• t-Table
• 1.4.6.
• Finding the Mean Score Using the =AVERAGE Function
• 1.4.7.
• Finding the Standard Deviation Using the =STDEV Function
• 1.4.8.
• Finding the Standard Error of the Mean
• 1.5.
• 1.
• 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
• References
• Sample Size, Mean, Standard Deviation, and Standard Error of the Mean
• 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 Page
• 1.1.
• 2.5.
• End-of-Chapter Practice Problems
• References
• 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.
• Mean
• Estimating the Lower Limit and the Upper Limit of the 95% Confidence Interval About the Mean
• 3.1.3.
• Estimating the Confidence Interval 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's TINV Function to Find the Confidence Interval About the Mean
• 3.1.7.
• 1.2.
• Using Excel to Find the 95% Confidence Interval for a Car's 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.3.
• The 7 Steps for Hypothesis-Testing Using the Confidence Interval About the Mean
• 3.3.
• Standard Deviation
• Alternative Ways to Summarize the Result of a Hypothesis Test
• 3.3.1.
• Different Ways to Accept the Null Hypothesis
• 3.3.2.
• Different Ways to Reject the Null Hypothesis
• 3.4.
• End-of-Chapter Practice Problems
• References
• 4.
• One-Group t-Test for the Mean
• 1.3.
• 4.1.
• The 7 STEPS for Hypothesis-Testing Using the One-Group t-Test
• 4.1.1 STEP 1
• State the Null Hypothesis and the Research Hypothesis
• 4.1.2 STEP 2
• Select the Appropriate Statistical Test
• 4.1.3 STEP 3
• Decide on a Decision Rule for the One-Group t-Test
• 4.1.4 STEP 4
• Calculate the Formula for the One-Group t-Test
Control code
ocn779864574
Dimensions
24 cm
Extent
xv, 254 p.
Isbn
9781461436362
Isbn Type
(pbk.)
Other physical details
col. ill.
System control number
(OCoLC)779864574
Label
Excel 2010 for social science statistics : a guide to solving practical statistics problems, by Thomas J. Quirk
Publication
Contents
• Standard Error of the Mean
• 4.1.5 STEP 5
• Find the Critical Value of t in the t-Table in Appendix E
• 4.1.6 STEP 6
• State the Result of Your Statistical Test
• 4.1.7 STEP 7
• State the Conclusion of Your Statistical Test in Plain English!
• 4.2.
• One-Group t-Test for the Mean
• 4.3.
• Can You Use Either the 95% Confidence Interval About the Mean or the One-Group t-Test When Testing Hypotheses?
• 1.4.
• 4.4.
• End-of-Chapter Practice Problems
• References
• 5.
• Two-Group t-Test of the Difference of the Means for Independent Groups
• 5.1.
• The 9 STEPS for Hypothesis-testing Using the Two-Group t-Test
• 5.1.1.
• Step 1: Name One Group, Group 1, and the Other Group, Group 2
• 5.1.2.
• Sample Size, Mean, Standard Deviation, and Standard Error of the Mean
• Step 2: Create a Table That Summarizes the Sample Size, Mean Score, and Standard Deviation of Each Group
• 5.1.3.
• Step 3: State the Null Hypothesis and the Research Hypothesis for the Two-Group t-Test
• 5.1.4.
• Step 4: Select the Appropriate Statistical Test
• 5.1.5.
• Step 5: Decide on a Decision Rule for the Two-Group t-Test
• 5.1.6.
• Step 6: Calculate the Formula for the Two-Group t-Test
• 5.1.7.
• 1.4.1.
• Step 7: Find the Critical Value of t in the t-Table in Appendix E
• 5.1.8.
• Step 8: State the Result of Your Statistical Test
• 5.1.9.
• Step 9: State the Conclusion of Your Statistical Test in Plain English!
• 5.2.
• Formula #1: Both Groups Have More Than 30 People in Them
• 5.2.1.
• An Example of Formula #1 for the Two-Group t-Test
• 5.3.
• Using the Fill/Series/Columns Commands
• Formula #2: One or Both Groups Have Less Than 30 People in Them
• 5.4.
• End-of-Chapter Practice Problems
• References
• 6.
• Correlation and Simple Linear Regression
• 6.1.
• What Is a "Correlation?"
• 6.1.1.
• Understanding the Formula for Computing a Correlation
• 1.4.2.
• 6.1.2.
• Understanding the Nine Steps for Computing a Correlation, r
• 6.2.
• Using Excel to Compute a Correlation Between Two Variables
• 6.3.
• Creating a Chart and Drawing the Regression Line onto the Chart
• 6.3.1.
• Using Excel to Create a Chart and the Regression Line Through the Data Points
• 6.4.
• Printing a Spreadsheet so That the Table and Chart Fit onto One Page
• Changing the Width of a Column
• 6.5.
• Finding the Regression Equation
• 6.5.1.
• Installing the Data Analysis ToolPak into Excel
• 6.5.2.
• Using Excel to Find the SUMMARY OUTPUT of Regression
• 6.5.3.
• Finding the Equation for the Regression Line
• 6.5.4.
• Using the Regression Line to Predict the y-Value for a Given x-Value
• 1.4.3.
• 6.6.
• Adding the Regression Equation to the Chart
• 6.7.
• How to Recognize Negative Correlations in the SUMMARY OUTPUT Table
• 6.8.
• Printing Only Part of a Spreadsheet Instead of the Entire Spreadsheet
• 6.8.1.
• Printing Only the Table and the Chart on a Separate Page
• 6.8.2.
• Printing Only the Chart on a Separate Page
• Centering Information in a Range of Cells
• 6.8.3.
• Printing Only the SUMMARY OUTPUT of the Regression Analysis on a Separate Page
• 6.9.
• End-of-Chapter Practice Problems
• References
• 7.
• Multiple Correlation and Multiple Regression
• 7.1.
• Multiple Regression Equation
• 7.2.
• 1.4.4.
• Finding the Multiple Correlation and the Multiple Regression Equation
• 7.3.
• Using the Regression Equation to Predict FROSH GPA
• 7.4.
• Using Excel to Create a Correlation Matrix in Multiple Regression
• 7.5.
• End-of-Chapter Practice Problems
• References
• 8.
• One-Way Analysis of Variance (ANOVA)
• Machine generated contents note:
• Naming a Range of Cells
• 8.1.
• Using Excel to Perform a One-Way Analysis of Variance (ANOVA)
• 8.2.
• How to Interpret the ANOVA Table Correctly
• 8.3.
• Using the Decision Rule for the ANOVA F-Test
• 8.4.
• Testing the Difference Between Two Groups Using the ANOVA t-Test
• 8.4.1.
• Comparing Republicans vs. Democrats in Their Attitude Toward U.S. Military Spending Using the ANOVA t-Test
• 1.4.5.
• 8.5.
• End-of-Chapter Practice Problems
• References
• Appendices
• Appendix A
• Answers to End-of-Chapter Practice Problems
• Appendix B
• Practice Test
• Appendix C
• Answers to Practice Test
• Finding the Sample Size Using the =COUNT Function
• Appendix D
• Statistical Formulas
• Appendix E
• t-Table
• 1.4.6.
• Finding the Mean Score Using the =AVERAGE Function
• 1.4.7.
• Finding the Standard Deviation Using the =STDEV Function
• 1.4.8.
• Finding the Standard Error of the Mean
• 1.5.
• 1.
• 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
• References
• Sample Size, Mean, Standard Deviation, and Standard Error of the Mean
• 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 Page
• 1.1.
• 2.5.
• End-of-Chapter Practice Problems
• References
• 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.
• Mean
• Estimating the Lower Limit and the Upper Limit of the 95% Confidence Interval About the Mean
• 3.1.3.
• Estimating the Confidence Interval 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's TINV Function to Find the Confidence Interval About the Mean
• 3.1.7.
• 1.2.
• Using Excel to Find the 95% Confidence Interval for a Car's 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.3.
• The 7 Steps for Hypothesis-Testing Using the Confidence Interval About the Mean
• 3.3.
• Standard Deviation
• Alternative Ways to Summarize the Result of a Hypothesis Test
• 3.3.1.
• Different Ways to Accept the Null Hypothesis
• 3.3.2.
• Different Ways to Reject the Null Hypothesis
• 3.4.
• End-of-Chapter Practice Problems
• References
• 4.
• One-Group t-Test for the Mean
• 1.3.
• 4.1.
• The 7 STEPS for Hypothesis-Testing Using the One-Group t-Test
• 4.1.1 STEP 1
• State the Null Hypothesis and the Research Hypothesis
• 4.1.2 STEP 2
• Select the Appropriate Statistical Test
• 4.1.3 STEP 3
• Decide on a Decision Rule for the One-Group t-Test
• 4.1.4 STEP 4
• Calculate the Formula for the One-Group t-Test
Control code
ocn779864574
Dimensions
24 cm
Extent
xv, 254 p.
Isbn
9781461436362
Isbn Type
(pbk.)
Other physical details
col. ill.
System control number
(OCoLC)779864574

#### Library Locations

• Manawatū Library
Tennent Drive, Palmerston North, Palmerston North, 4472, NZ
-40.385340 175.617349