buss 302
kmac805
green-guard-student-coaching-slides.ppt*
Question 3:
Regression Analysis
Evaluate the time trends in visits per week and cost per visit.
Use regression.
- Instructions are in the Materials section of the BUS 302 web site for both Excel 2003 and Excel 2007.
- Be sure to correctly indentify the X and Y variables.
*
13
*
Question 3:
Regression Analysis
- Coefficient of Determination – (R2)
- The percent of variation in the dependent variable (Y) accounted for by variation in the independent variable (X). The closer to 1 the better.
- Regression Coefficients
- Coefficient on x-variable measures the slope of the trend Line. (Positive Sign - Positive Relationship, Negative Sign – Negative Relationship)
- t-statistic and p-value are used to indicate the observed level of significance.
