HOME > 상세정보

상세정보

Excel 2016 for advertising statistics [electronic resource] : a guide to solving practical problems

Excel 2016 for advertising statistics [electronic resource] : a guide to solving practical problems

자료유형
E-Book(소장)
개인저자
Quirk, Thomas J. Rhiney, Eric.
서명 / 저자사항
Excel 2016 for advertising statistics [electronic resource] : a guide to solving practical problems / Thomas J. Quirk, Eric Rhiney.
발행사항
Cham :   Springer,   c2017.  
형태사항
1 online resource (xv, 249 p.) : ill. (some col.).
총서사항
Excel for statistics,2570-4605
ISBN
9783319721033 9783319721040 (eBook)
요약
This text is a step-by-step guide for students taking a first course in statistics for advertising and for advertising managers and practitioners who want to learn how to use Excel to solve practical statistics problems in in the workplace, whether or not they have taken a course in statistics. Excel 2016 for Advertising Statistics explains statistical formulas and offers practical examples for how students can solve real-world advertising statistics problems. This book leaves detailed explanations of statistical theory to other statistics textbooks and focuses entirely on practical, real-world problem solving. Each chapter briefly explains a topic and then demonstrates how to use Excel commands and formulas to solve specific advertising statistics problems.  This book gives practice in using Excel in two different ways:  (1) writing formulas (e.g., confidence interval about the mean, one-group t-test, two-group t-test, correlation) and (2) using Excel’s drop-down formula menus (e.g., simple linear regression, multiple correlation and multiple regression, and one-way ANOVA).  Three practice problems are provided at the end of each chapter, along with their solutions in an Appendix.  An additional Practice Test allows readers to test their understanding of each chapter by attempting to solve a specific practical advertising statistics problem using Excel; the solution to each of these problems is also given in an Appendix. Includes 167 illustrations in color Suitable for undergraduates or graduate students Thomas J. Quirk is Professor of Marketing in the George Herbert Walker School of Business & Technology at Webster University based in St. Louis, Missouri (USA) where he teaches Marketing Statistics, Marketing Research, and Pricing Strategies. He has published over 20 articles in professional journals, and presented more than 20 papers at professional conferences. Eric Rhiney is Associate Professor of Marketing at the George Herbert Walker School of Business & Technology at Webster University in St. Louis, Missouri (USA) where he teaches Research Design, Marketing Research and Marketing Strategies.  He is involved in several quantitative research studies focused on in-group out-group orientation on consumer attitudes, digital marketing behavior, and cross-cultural marketing, and has presented is work at numerous professional conferences.
일반주기
Title from e-Book title page.  
내용주기
Preface -- Acknowledgements --  Ch 1. Sample Size, Mean, Standard Deviation, and Standard Error of the Mean -- Ch 2. Random Number Generator --  Ch 3. Confidence Interval About the Mean Using the TINV Function and Hypothesis Testing -- Ch 4. One-Group t-Test for the Mean -- Ch 5. Two-Group t-Test of the Difference of the Means for Independent Groups -- Ch 6. Correlation and Simple Linear Regression -- Ch 7. Multiple Correlation and Multiple Regression -- Ch 8. One-Way Analysis of Variance (ANOVA).- Appendix A:  Answers to End-of-Chapter Practice Problems.- Appendix B:  Practice Test.- Appendix C:  Answers to Practice Test.- Appendix D:  Statistical Formulas.- Appendix E:  t-table.- Index.
서지주기
Includes bibliographical references and index.
이용가능한 다른형태자료
Issued also as a book.  
일반주제명
Advertising --Statistical methods. Statistics. Marketing.
바로가기
URL
000 00000cam u2200205 a 4500
001 000045988868
005 20190705112557
006 m d
007 cr
008 190703s2017 sz a ob 001 0 eng d
020 ▼a 9783319721033
020 ▼a 9783319721040 (eBook)
040 ▼a 211009 ▼c 211009 ▼d 211009
050 4 ▼a HF5823
082 0 4 ▼a 659.10727 ▼2 23
084 ▼a 659.10727 ▼2 DDCK
090 ▼a 659.10727
100 1 ▼a Quirk, Thomas J.
245 1 0 ▼a Excel 2016 for advertising statistics ▼h [electronic resource] : ▼b a guide to solving practical problems / ▼c Thomas J. Quirk, Eric Rhiney.
260 ▼a Cham : ▼b Springer, ▼c c2017.
300 ▼a 1 online resource (xv, 249 p.) : ▼b ill. (some col.).
490 1 ▼a Excel for statistics, ▼x 2570-4605
500 ▼a Title from e-Book title page.
504 ▼a Includes bibliographical references and index.
505 0 ▼a Preface -- Acknowledgements --  Ch 1. Sample Size, Mean, Standard Deviation, and Standard Error of the Mean -- Ch 2. Random Number Generator --  Ch 3. Confidence Interval About the Mean Using the TINV Function and Hypothesis Testing -- Ch 4. One-Group t-Test for the Mean -- Ch 5. Two-Group t-Test of the Difference of the Means for Independent Groups -- Ch 6. Correlation and Simple Linear Regression -- Ch 7. Multiple Correlation and Multiple Regression -- Ch 8. One-Way Analysis of Variance (ANOVA).- Appendix A:  Answers to End-of-Chapter Practice Problems.- Appendix B:  Practice Test.- Appendix C:  Answers to Practice Test.- Appendix D:  Statistical Formulas.- Appendix E:  t-table.- Index.
520 ▼a This text is a step-by-step guide for students taking a first course in statistics for advertising and for advertising managers and practitioners who want to learn how to use Excel to solve practical statistics problems in in the workplace, whether or not they have taken a course in statistics. Excel 2016 for Advertising Statistics explains statistical formulas and offers practical examples for how students can solve real-world advertising statistics problems. This book leaves detailed explanations of statistical theory to other statistics textbooks and focuses entirely on practical, real-world problem solving. Each chapter briefly explains a topic and then demonstrates how to use Excel commands and formulas to solve specific advertising statistics problems.  This book gives practice in using Excel in two different ways:  (1) writing formulas (e.g., confidence interval about the mean, one-group t-test, two-group t-test, correlation) and (2) using Excel’s drop-down formula menus (e.g., simple linear regression, multiple correlation and multiple regression, and one-way ANOVA).  Three practice problems are provided at the end of each chapter, along with their solutions in an Appendix.  An additional Practice Test allows readers to test their understanding of each chapter by attempting to solve a specific practical advertising statistics problem using Excel; the solution to each of these problems is also given in an Appendix. Includes 167 illustrations in color Suitable for undergraduates or graduate students Thomas J. Quirk is Professor of Marketing in the George Herbert Walker School of Business & Technology at Webster University based in St. Louis, Missouri (USA) where he teaches Marketing Statistics, Marketing Research, and Pricing Strategies. He has published over 20 articles in professional journals, and presented more than 20 papers at professional conferences. Eric Rhiney is Associate Professor of Marketing at the George Herbert Walker School of Business & Technology at Webster University in St. Louis, Missouri (USA) where he teaches Research Design, Marketing Research and Marketing Strategies.  He is involved in several quantitative research studies focused on in-group out-group orientation on consumer attitudes, digital marketing behavior, and cross-cultural marketing, and has presented is work at numerous professional conferences.
530 ▼a Issued also as a book.
538 ▼a Mode of access: World Wide Web.
650 0 ▼a Advertising ▼x Statistical methods.
650 0 ▼a Statistics.
650 0 ▼a Marketing.
700 1 ▼a Rhiney, Eric.
830 0 ▼a Excel for statistics.
856 4 0 ▼u https://oca.korea.ac.kr/link.n2s?url=https://doi.org/10.1007/978-3-319-72104-0
945 ▼a KLPA
991 ▼a E-Book(소장)

소장정보

No. 소장처 청구기호 등록번호 도서상태 반납예정일 예약 서비스
No. 1 소장처 중앙도서관/e-Book 컬렉션/ 청구기호 CR 659.10727 등록번호 E14014620 도서상태 대출불가(열람가능) 반납예정일 예약 서비스 M

컨텐츠정보

목차

Intro -- 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 Function -- 1.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 -- References -- 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 Page -- 2.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´s TINV Function to Find the Confidence Interval About the Mean -- 3.1.7 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.2.1 Determining the Null Hypothesis and the Research Hypothesis When Rating Scales Are Used -- 3.2.3 The Seven 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 Test -- 3.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 H.

관련분야 신착자료