Excel 2016 for marketing statistics [electronic resource] : a guide to solving practical problems / Thomas J. Quirk, Eric Rhiney.
This is the first book to show the capabilities of Microsoft Excel in teaching marketing statistics effectively. It is a step-by-step exercise-driven guide for students and practitioners who need to master Excel to solve practical marketing problems. If understanding statistics isn your strongest su...
Saved in:
| Online Access: |
Full Text (via Springer) |
|---|---|
| Main Author: | |
| Other Authors: | |
| Format: | Electronic eBook |
| Language: | English |
| Published: |
Cham :
Springer,
©2016.
|
| Series: | Excel for statistics.
|
| Subjects: |
Table of Contents:
- 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.