Excel 2016 for marketing statistics : a guide to solving practical problems /: a guide to solving practical problems. (©2016)

• Record Type: Book
• Further Information: Note: Thomas J. Quirk, Eric Rhiney.
• Other Names: Quirk, Thomas J; Rhiney, Eric
• 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.
• Publisher Details: Cham : Springer
• Publication Date: 2016
• Copyright Date: 2016
• Extent: 1 online resource (257 pages)
• Subjects: 658.80072/7; 519.5; Statistics; Marketing -- Statistical methods; Mathematical statistics; Marketing; Social sciences -- Data processing; BUSINESS & ECONOMICS -- Industrial Management; BUSINESS & ECONOMICS -- Management; BUSINESS & ECONOMICS -- Management Science; BUSINESS & ECONOMICS -- Organizational Behavior; Marketing -- Statistical methods; Business & Economics -- Marketing -- General; Computers -- Data Processing; Sales & marketing; Society & social sciences; Mathematics -- Probability & Statistics -- General; Probability & statistics; Electronic books
• Languages: English
• ISBNs: 9783319433769; 3319433768
• Related ISBNs: 9783319433752; 331943375X
• Notes: Note: Includes bibliographical references and index.; Note: Print version record.
• Access Rights: Legal Deposit; Only available on premises controlled by the deposit library and to one user at any one time; The Legal Deposit Libraries (Non-Print Works) Regulations (UK).
• Access Usage: Restricted: Printing from this resource is governed by The Legal Deposit Libraries (Non-Print Works) Regulations (UK) and UK copyright law currently in force.