# How To Analyze The Regression Analysis Output From Excel

Essay by 24 • November 27, 2010 • 988 Words (4 Pages) • 1,846 Views

**Page 1 of 4**

How to Analyze the Regression Analysis Output from Excel

In a simple regression model, we are trying to determine if a variable Y is linearly dependent on variable X. That is, whenever X changes, Y also changes linearly. A linear relationship is a straight line relationship. In the form of an equation, this relationship can be expressed as

Y = Ðž± + ÐžÐ†X + e

In this equation, Y is the dependent variable, and X is the independent variable. Ðž± is the intercept of the regression line, and ÐžÐ† is the slope of the regression line. e is the random disturbance term.

The way to interpret the above equation is as follows:

Y = Ðž± + ÐžÐ†X (ignoring the disturbance term Ð²Ð‚ÑšeÐ²Ð‚Ñœ)

gives the average relationship between the values of Y and X.

For example, let Y be the cost of goods sold and X be the sales. If Ðž± = 2 and ÐžÐ† = 0.75, and if the sales are 100, i.e., X = 100, the cost of goods sold would be, on average,

2 + 0.75(100) = 77. However, in any particular year when sales X = 100, the actual cost of goods sold can deviate randomly around 77. This deviation from the average is called the Ð²Ð‚ÑšdisturbanceÐ²Ð‚Ñœ or the Ð²Ð‚ÑšerrorÐ²Ð‚Ñœ and is represented by Ð²Ð‚ÑšeÐ²Ð‚Ñœ.

Also, in the equation

Y = 2 + 0.75X + e

i.e.,

Cost of goods sold = 2 + 0.75 (sales) + e

the interpretation is that the cost of goods sold increase by 0.75 times the increase in sales. For example, if the sales increase by 20, the cost of goods sold increase, on average, by 0.75 (20) = 15. In general, we are much more interested in the value of the slope of the regression line, ÐžÐ†, than in the value of the intercept, Ðž±.

Now, suppose we are trying to determine if there is a relationship between two variables which have apparently no relationship, say the sales of a firm, and the average height of employees of the firm. We would set up an equation like the following:

Y = Ðž± + ÐžÐ†X + e

where

Y = sales of firm, X = average height of employees, Ðž± = intercept of the regression line,

ÐžÐ† = slope of the regression line, and e = disturbance term

Then, we would collect a sample of data from a number of firms regarding sales and average height of employees. The relationship between the two variables is estimated by a technique called the Ð²Ð‚Ñšordinary least squaresÐ²Ð‚Ñœ. If indeed there is no relationship between the two variables, what do you expect the value of ÐžÐ†, the slope of the regression line to be? We would expect this value to be zero, or some number close to it.

Though there may not be any real relationship between the two variables, the estimated value of ÐžÐ† may not be exactly (and most probably will not be) equal to zero. But, if we were to repeat this exercise of estimating the value of ÐžÐ† using many more samples, we would expect the value of ÐžÐ† to be zero on average. However, we have only one sample of a certain number of firms (say, 30 firms) and we have to make an inference from this one sample whether X influences Y (i.e. ÐžÐ† Ð²‰

...

...

(2010, 11). How To Analyze The Regression Analysis Output From Excel. *Essays24.com*. Retrieved 11, 2010, from https://www.essays24.com/essay/How-To-Analyze-The-Regression-Analysis-Output-From/14571.html

"How To Analyze The Regression Analysis Output From Excel" __Essays24.com__. 11 2010. 2010. 11 2010 <https://www.essays24.com/essay/How-To-Analyze-The-Regression-Analysis-Output-From/14571.html>.

"How To Analyze The Regression Analysis Output From Excel." *Essays24.com*. Essays24.com, 11 2010. Web. 11 2010. <https://www.essays24.com/essay/How-To-Analyze-The-Regression-Analysis-Output-From/14571.html>.

"How To Analyze The Regression Analysis Output From Excel." Essays24.com. 11, 2010. Accessed 11, 2010. https://www.essays24.com/essay/How-To-Analyze-The-Regression-Analysis-Output-From/14571.html.