BUSA 3110: First Regression Lab Session
Collect Data
Minutes Miles
Student 1
Student 2
Student 3
Student 4
Student 5
Student 6
Develop a Theory
Start the process of assessing the theory
Defining variables
Model statement
Scatter Diagram
Finding the equation for a line
Obtaining Regression output
Excel Topics to Cover:
Accessing Excel
Entering data
Creating new variables using a formula (x2, y2, xy)
Absolute and Relative References
Using function wizard and built-in functions (x, y, x2, y2, xy)
Using Chart Wizard
Creating a Scatter Diagram (plotting, resizing, modifying, labeling axes, removing chartjunk)
Accessing Data Analysis
Obtaining Regression Output
Custom headers
Page Layout
Print Preview
Saving/Printing
