UH Bauer College of Business
Management of Marketing Information MARK7362
Professor Sam K. Hui
Notes on Regression (Introduction)
1. EXCEL instructions for “Simple Regression Mathematics” tutorial
(a) Installing the data analysis toolpak in EXCEL 2010
→Files → Options → Add-ins
→ Near the bottom of the Add-ins screen, find “Manage Excel Add–ins”, and click “Go”
→ Check “Analysis Toolpak”, and click OK.
(b) plotting the data in EXCEL
→ Open the dataset “copier.xls”
→ Highlight the “X” and “Y” columns (hold “Ctrl” key to select multiple columns)
→ select “Insert” → “Scatter” → “Scatter with Only Markers”
(c) Computing correlation coefficient
→ In an empty cell, type CORREL(
→ then select the column X as the first argument, Y as the second argument
