Marketing Research for Managerial Decision Making: Data Analytics Using Microsoft Excel examines the role of marketing research in helping marketing managers make marketing decisions. In addition to describing important marketing research concepts, terms, techniques, and procedures, this book contains a number of MiniCases and Discussion Questions at the end of each chapter which provide the reader with an increased understanding of, and experience with, various aspects of a research project. This book also explains and illustrates how to use Microsoft® Excel to perform data analytics; including Pivot Tables, descriptive statistics, cross-tabs and chi-square, correlations, regression, t-tests, and ANOVA. Included are 34 individual analytics exercises for analyzing marketing research data. A separate Excel dataset accompanies each of these data analytics exercises. In addition to these exercises, 10 larger cases from a variety of industries and businesses allow the reader to apply multiple analytical techniques to larger and more complex marketing related situations. As with the smaller analytical exercises, a separate dataset accompanies each of these cases.
Chapter 1 What is Marketing Research?
Chapter 2 Marketing Research as a Profession
Chapter 3 Marketing Research and the Decision-Making Process
Chapter 4 Social Media and Emerging Technologies: Opportunities and Challenges
Chapter 5 Classes of Marketing Research
Chapter 6 The Marketing Research Process
Chapter 7 Identifying Marketing Problems: Exploratory Research Techniques
Chapter 8 Focus Groups
Chapter 9 Moderating a Focus Group Session
Chapter 10 Survey Data Collection Methodologies
Chapter 11 Sources of Error in Survey Research
Chapter 12 Measurement and Scaling
Chapter 13 Qualities of Good Measurement Scales: Reliability, Sensitivity and Validity
Chapter 14 Scales Used in Marketing Research Surveys
Chapter 15 Identifying Survey Research Objectives
Chapter 16 Writing Survey Questions and Organizing Surveys
Chapter 17 Sampling Procedures
Chapter 18 Casual Research and Experimental Design
Chapter 19 Entering and Preparing Data for Analysis
Chapter 20 Analyzing Quantitative Data
Chapter 21 Data Analytics: Descriptive Statistics, Pivot Tables, and Pivot Charts
Chapter 22 Data Analytics: Contingency Tables and Chi-Square Analysis
Chapter 23 Data Analytics: Correlation and Regression Analysis
Chapter 24 Data Analytics: Differences in Means
Chapter 25 Presenting Research Results to Decision Makers
Case 1 The Red Hills Mall
Case 2 Grandview Public Library
Case 3 OnStage Theater
Case 4 Fenton Springs B-Sharp Jazz Fest
Case 5 Rockville Medical Center
Case 6 Superspeedway Fan Survey
Case 7 Pinellas University Marketing Study
Case 8 State Tax Proposal Survey
Case 9 Thomas Buehl Historic Home and Museum
Case 10 Mutter Bäckerei Baked Goods Taste Test