Excel 2013 for Marketing MOOC

Home / 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

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

Chapter 2: Frequency Distributions

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

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

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

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

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

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

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

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

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

Chapter 10: Hypothesis Tests

Video 10.1 Hypothesis Testing