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
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
Chapter 5 Cumulative Distribution Functions, Probabilities, and Indexing
Chapter 6 t-Test, Venn Diagrams and Demand Estimation
Chapter 7 ANOVA / F-Test, and Return on Investment (ROI)
Chapter 8 Chi-Squared, Discount Factors, and Net Present Value (NPV)
Chapter 9 Regression Analysis, Multivariate Regression, and the Price – Demand Relationship
Chapter 10 Hypothesis Testing
Video 10.1 Hypothesis Testing