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 2: Frequency Distributions
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
Chapter 5: Cumulative Distribution Functions and Probability
Chapter 6: Student’s t-Test for Numerical Measurements
Chapter 7: ANOVA / F-Tests
Chapter 8: Chi-Square and Nominal Data
Chapter 9 Regression Analysis, Multivariate Regression, and the Price – Demand Relationship
Chapter 10: Hypothesis Tests
Video 10.1 Hypothesis Testing