Excel 2013 for Marketing MOOC

Free online tutorials on using Excel to solve quantitative challenges in marketing. Videos + Excel Workbooks.

Great for marketing students. Learn how to analyze marketing research data, evaluate business propositions, and identify the ROI on Marketing (ROMI). Just follow the video and the associated Excel spreadsheet, and you will be on your way.

The Excel Workbooks should be saved to your desktop, then opened with Excel.

Chapter 1: Data Types & Measurement Scales

Chapter-1Download Excel Workbook 1

Video 1.1 Data Type and Measurement Scales
Video 1.2 Category Incidence Frequency

Chapter 2: Frequency Distributions

Chapter-2Download Excel Workbook 2

Video 2.1 Frequency Bar Chart
Video 2.2 Frequency Distribution in Groups
Video 2.3 Histograms (Simple)
Video 2.4 Frequency Distribution Shapes and Statistics
Video 2.5 Histograms and Standard Deviations

Chapter 3: Cross Tabs and Sampling

Chapter-3Download Excel Workbook 3

Video 3.1 Cross Tabs with Single Sample and 2 Categories
Video 3.2 Cross Tabs with Single Sample and Multiple Categories
Video 3.3 Cross Tabs with Multiple Samples and Multiple Categories
Video 3.4 Marketing Metrics of Margins and Markups

Chapter 4:  Normal Distributions, Z-Scores, and Confidence Intervals

Chapter-4Download Excel Workbook 4

Video 4.1 Normal Distribution
Video 4.2 Population Metrics
Video 4.3 Standard Scores
Video 4.4 Marketing Metrics: Profit/Loss and Breakeven Analysis

Chapter 5: Cumulative Distribution Functions and Probability

Chapter-5Download Excel Workbook 5

Video 5.1 Cumulative Distribution Function
Video 5.2 Probability and Cumulative Distributions
Video 5.3 Market Metrics: CDI & BDI

Chapter 6: Student’s t-Test for Numerical Measurements

Chapter-6Download Excel Workbook 6

Video 6.1 Student T-test
Video 6.2 Venn Diagram and Segmentation
Video 6.3 Market Metrics: Demand Estimation from Market Buildup Ratios

Chapter 7: ANOVA / F-Tests

Chapter-7Download Excel Workbook 7

Video 7.1 F-test and ANOVA
Video 7.2 ANOVA – Single Factor and Two Factors Analysis
Video 7.3 Marketing Metrics: Return on Investment

Chapter 8: Chi-Square and Nominal Data

Chapter-8Download Excel Workbook 8

Video 8.1 Chi-Square
Video 8.2 Marketing Metrics: Discounting Factors

Chapter 9 Regression Analysis, Multivariate Regression, and the Price – Demand Relationship

Chapter-9Download Excel Workbook 9

Video 9.1 Regression Analysis
Video 9.2 Marketing Metrics: Demand and Price Analysis

Chapter 10: Hypothesis Tests

Video 10.1 Hypothesis Testing