Unit 6: Correlation and Regression
If two data points move in the same direction, does that mean that one causes the other? How are we to analyze their correlation?
Regression is an analysis of the relationship of one variable to another. A regression might identify, for example, the relationship between car speed and the number of fatal accidents. In this example, speed and number of accidents are the two variables; the number of accidents is said to be the dependent variable, because the number of accidents depends on the speed. Speed is considered the independent variable. While regressions can be calculated manually, a statistically significant data set could take a long time to regress.
Regressions not only allow us to determine whether a relationship exists but also to identify how strong that relationship is. The measure of this relationship is known as the regression coefficient. If the regression coefficient is relatively low, then speed may not be the major factor in fatal accidents. Perhaps the major factor is the time of day, whether it rained or not, or if alcohol was involved. With multiple regression, a number of independent variables can be tested against the dependent variable at the same time. The regression coefficient would determine which variables have the strongest relationship with the dependent variable. In business, you will frequently use regression to predict future events. Though not an exact science, regression can be used to make reliable predictions if enough variables are identified. For example, first responders could use regression outputs to predict the number of fatal accidents in a given shift based on average travel speed, time of day, weather, and any other factors deemed significant. This unit will also stress the importance of determining the factors that most likely contribute to a dependent variable.
Regression is often used in finance. Investors often want to know the relationship between a stock's performance and the overall performance of the market. By regressing the period returns of a stock with the returns of the market, investors can see the regression coefficient. This coefficient is known as a stock's beta and is covered extensively in BUS202: Principles of Finance.
Completing this unit should take you approximately 5 hours.
6.1 Working with More Than One Variable
6.2: Correlation and Association
6.4: Spreadsheet Activity for Unit 6
Unit 6 Problem Set and Assessment