Excel 2010 for Marketers MOOC

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

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

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

The videos require a Flash Player. Install Adobe Flash.

Introduction Start Here

Chapter 1 Data Types, Measurement Scales, and Category Incidence Frequency

Excel Workbook 1
Video 1.1 Data Type and Measurement Scales
Video 1.2 Category Incidence Frequency

Chapter 2 Frequency Distributions, Central Tendencies, Standard Deviations, and the Profit Equation of the Firm

Excel Workbook 2
Video 2.1 Frequency Bar Chart
Video 2.2 Frequency Distribution in Group
Video 2.3 Histogram (Example 1)
Video 2.4 Shapes and Statistics of Frequency Distribution
Video 2.5 Histogram (Example 2: Standard Deviation)
Video 2.6 Profit Calculation

Chapter 3 Cross Tabs, Margins, and Markups

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: Margins and Markups

Chapter 4 Normal Distributions, Z-Scores, Confidence Intervals, and Breakeven Analysis

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

Chapter 5 Cumulative Distribution Functions, Probabilities, and Indexing

Excel Workbook 5
Video 5.1 Cumulative Distribution Function
Video 5.2 Continuous Distribution and Discrete Distribution
Video 5.3 Market Metrics: CDI & BDI

Chapter 6 t-Test, Venn Diagrams and Demand Estimation

Excel Workbook 6
Video 6.1 Student T-test
Video 6.2 Venn Diagram
Video 6.3 Market Metrics: Demand Estimation

Chapter 7 ANOVA / F-Test, and Return on Investment (ROI)

Excel Workbook 7
Video 7.1 F-test
Video 7.2 ANOVA-single factor and two factors analysis
Video 7.3 Marketing Metrics: Return on Investment

Chapter 8 Chi-Squared, Discount Factors, and Net Present Value (NPV)

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

Excel Workbook 9
Video 9.1 Regression Analysis
Video 9.2 Marketing Metrics: Demand and Price Analysis

Chapter 10 Hypothesis Testing 

Video 10.1 Hypothesis Testing