Regression Analysis

From WikiEducator
Jump to: navigation, search
FIN.png
Final andc logo white.jpg
Top.jpg


MICROECONOMICS

SLMtitle.png Forecasting

Regression Analysis


.



SLMobj.png Learning Objectives
After reading this chapter, you are expected to learn about:


Objectives:

  • Understand regression
  • Estimate the regression equation
  • Understand the relation of correlation and regression
  • Use regression analysis
  • Understand the application of regression analysis in business
  • Appreciate the regression analysis.






SLMinto.png Introduction


In business many a times we want to predict what may happen if some action is taken. Like if price is increased how will demand be affected. We may be interested in knowing if the demand of a commodity has been in the past then what will be the future demand may be two years later if the same trend continues. Such kind of analysis is required if the data we have is dependent on each other or have some type of causal relationship.

We know that such relationships are measured using coefficient of correlation. Coefficient of correlation gives the magnitude of the association of two variables. If the relationship is established and is significant then next step is to obtain the expression of relationship of the variables.

We derive the equation that defines the relationship, which is linear, as we have defined linear correlation in the previous sections. The functional relation between the variables is called as regression equation. The meaning of regression is a tendency of returning to the mean. For example, in the correlation of heights of fathers and sons, a tendency of human race to return to or regress to the average height is observed.




SLMsections.png
Straight Line Equation


We know that equation of a straight line.

The equation of the straight line is given by

Y = a + bx

Where a and b are constants,

a is the y intercept i.e. the point where the line y = a + bx cuts the y axis, 

b is the slope of the line. It gives the rate of change of y with respect to X.

.=



SLMact.gif Activity
Where will the following lines touch the Y axis?

How much Y value will get incremented if X is increased by 1.


Y= -3+2/3X Y intercept.......................... Slope ….........

Y=2+1.75 X Y Intercept........................... slope...........



Yes you got it right

The line -3+2/3X touches Y axis at -3 and the slope of the line is 2/3, means for one unit increase in X the value of Y increases by 0.67

The line 2+1.75X touches Y axis at2 and the slope of the line is 1.75, means for one unit increase in X the value of Y increases by 1.75



SLMsections.png
Get the constants for the regression line



Now we see how to calculate the constants a: y intercept, where the regression line will meet Y axis and slope i.r. gradient of the straight line We can find the values of a and b using the following normal equations.

From y = a + bx ........(1)

Taking sum of both sides, we get

[math]\sum[/math] y = na + b[math]\sum[/math]X .......(2) as a is constant hence  [math]\sum[/math]a = na.

Multiply equation (1) by X and take sum of both sides we get

[math]\sum[/math]XY = a[math]\sum[/math]X + b[math]\sum[/math]X2 ........(3)

Solving equations (2) and (3) we get



b=[math]\frac{\sum XY-n\bar X \bar Y}{\sum X^2-n\bar X^2}[/math]


a=[math]\bar Y -n \bar X[/math]





After obtaining the values of a & b we get an estimating equation.

[math]\hat Y[/math]=a+bX

where [math]\hat Y[/math]  is estimated value of y when value of X is given.



Subsection.png
{{{Subsection}}}


Obtain the regression equation for the following data.

10
9
7
8
11
6
3
4
2
5


We find out values of a and b using the above data


X
Y
XY
X2
10
6
60
100
9
3
27
81
7
4
28
49
8
2
16
64
11
5
55
12




  TOTAL 45 20 188 415

[math]\bar X = \frac{45}{5}[/math]= 9

[math]\bar Y = \frac{20}{5}[/math]= 4

b = [math]\frac{\sum XY-n\bar X \bar Y}{\sum X^2-n\bar X^2}[/math]= 0.8
a = 4 – 9 x 0.8 = - 3.2


[math] \hat Y [/math]= -3.2 +0.8X is an estimating equation





SLMact.gif Activity
Obtain an estimating equation for the data given below



X 5 3 7 4 8 2 10 6 8 7 9 11
Y 8 6 8 5 9 6 8 5 11 7 8 10


SLMsections.png
Two Lines Of Regression Equations


For a bivariate data (Xi, Yi), the relationship may be Y depends on X or X depends on Y.

If Y depends on X then the regression line is Y on X. Y is dependent variable and X is independent variable.

If X depends on Y, then regression line is X on Y and X is dependent variable and Y is independent variable. The regression equation Y on X is Y = a + bx, is used to estimate value of Y when X is known. The regression equation X on Y is X = c + dy is used to estimate value of X when Y is given and a, b, c and d are constant.

|
Kavita.png

Y = a + bx can also be interpreted as ‘a’ is the average value of Y when X is zero.

X = c + dy, value c is the average value of X, when Y is zero.

The slopes of the equation Y on X and X on Y are denoted as byx and bxy respectively.

The values of byx and bxy are

byx = [math]\frac{Cov(X Y)}{Variance X}[/math]


bxy = [math]\frac{Cov(X Y)}{Variance Y}[/math]


Simplifying we get,

byx = [math]\frac{\sum XY-n\bar X \bar Y}{\sum X^2-n\bar X^2}[/math]


bxy = [math]\frac{\sum XY-n\bar X \bar Y}{\sum Y^2-n\bar Y^2}[/math]


byx and bxy are the coefficient of regression.

After we obtain values of byx and bxy we obtain the regression equations by substituting in the following equation.

Y on X is [math] Y-\bar Y= byx (X-\bar X)[/math]

and


X on Y Y on X is [math] X-\bar X= bxy (Y-\bar Y)[/math]

The value of b in the previous section is same as byx.



SLMsections.png
Properties of Regression Lines



The regression equations Y on X and X on Y has following properties

a)The lines of regression meet in a point whose co-ordinates are . The averages of both X and Y will lie on both the lines of regression.


b)The regression coefficients byx, bxy and correlation coefficient ‘r’ will have the same sign. The relationship will remain the same in any of the coefficients.


c)There is an angle formed between the two lines of regression. Let the angle be denoted by [math]\theta[/math]. The correlation is perfect then the angle [math]\theta[/math]. is 0. The lines exactly coincide. As the correlation becomes weaker and weaker the [math]\theta[/math]. increases. An if [math]\theta[/math]. is 900 then variables may not be linearly correlated.

|
Kavita.png


d)The correlation coefficient ‘r’ is geometric mean of the regression coefficients. The sign + or – given to ‘r’, that exists for byx and bxy.


byx = [math]\frac{\sum XY-n\bar X \bar Y}{\sum X^2-n\bar X^2}[/math]


bxy = [math]\frac{\sum XY-n\bar X \bar Y}{\sum Y^2-n\bar Y^2}[/math]




r = ± [math]\sqrt{byx*bxy}[/math]


e) byx = r [math] \frac{\sigma y}{\sigma x}[/math]

and

bxy = r [math] \frac{\sigma x}{\sigma y}[/math]





Icon casestudy.gif
Case Study
Enter your text here




SLMact.gif Activity
Write your activity here



Example:

{{{Example}}}

SLMexample.png












SLMsaq.gif Self-Assessment Questions (SAQs) {{{n}}}
{{{SAQ}}}



SLMsum.png Results


Regression analysis is used for defining the relationship of two variables. The linear relationships are expressed using mathematical formula. For a given value of independent variable we can predict value of independent variable.For example, given value of advertising expenditure what will be projection of revenue? we use regression analysis for such kind of forecasting.



MU KEY.jpg Key Terms




Regression: A general process of predicting one variable from another by statistical means using previous data

Regression line: A line fitted to set of data points to estimate the relationship between the variables.

Dependent variable: The variable we are trying to predict

Independent variable: The known variable in regression analysis.




Icon activity.jpg

Extension exercise

{{{1}}}




1. A computer while calculating correlation coefficient between two variables X and Y from 25 pairs of observations obtained the following

N = 25


Find the correlation coefficient of X and Y. Mean values of, X and Y. Regression equations of Y on X and X on Y.


2. A furniture retailer in a locality is interested in studying whether some relationship exists between the number of building permits issued in that locality in the past years and the volume of sales in those years. He has accordingly collected the data for the sales (y) and the number of building permits issued(X) in the past 10 years. The results are as follows ∑ X=200 ∑Y= 2200 ∑XY= 45800 ∑X2= 4600 and ∑Y2 =-490400. Using the appropriate regression equations, find i)The level of sales expected next year when 2000 building permits are to be issued. ii)The level of sales expected next year when 2000 building permits are to be issued.

3. To the Internal Revenue Service, the reasonableness of total itemized deduction depends on taxpayer’s adjusted gross income. Large deductions, which include charity and m A furniture retailer in a locality is interested in studying whether some relationship exists between the number of building permits issued in that locality in the past years and the volume of sales in those years. He has accordingly collected the data for the sales (y) and the number of building permits issued (X) in the past 10 years. The results are as follows ∑ X=200 ∑Y= 2200 ∑XY= 45800 ∑X2= 4600 and ∑Y2 =-490400.

Using the appropriate regression equations, find iii)The level of sales expected next year when 2000 building permits are to be issued. iv)The level of sales expected next year when 2000 building permits are to be issued.

4. To the Internal Revenue Service, the reasonableness of total itemized deduction depends on taxpayer’s adjusted gross income. Large deductions, which include charity and medical deductions, are more reasonable for taxpayers with large adjusted gross incomes. If a taxpayer claims larger than average itemized deductions for a given level of income, the chances if a IRS audit are increased. Data (in $1000) on adjusted gross income and the average or reasonable amount of itemized deductions follow. Adjusted gross income ($1000s) 22 27 32 48 65 85 120 Total itemized deductions ($1000s) 9.6 9.6 10.1 11.1 13.5 17.7 25.5 Use the least square method to develop the estimated regression equation. Estimate a reasonable level of total itemized deductions for a tax payer with an adjusted gross income of $52000. If this taxpayer has claimed total itemized deductions of $20,00, would the IRS agent’s request for a n audit appear justified? Explain.

5. In a laboratory experiment on correlation research study, the equation to the to regression lines were to be 2X-Y+1=0 and 3X-2Y+7=0. Find the means of X and Y. Also work out the values of the regression coefficients and the coefficient of correlation between the two variables X and Y. Given variance of X=9 find the standard deviation of Y.

6. In a laboratory experiment on correlation research study, the equation to the to regression lines were to be 2X-Y+1=0 and 3X-2Y+7=0. Find the means of X and Y. Also work out the values of the regression coefficients and the coefficient of correlation between the two variables X and Y. Given variance of X=9 find the standard deviation of Y.


7. The two lines of regression based on 100 observations were 20X-9Y-106=0 and 4X-5Y+30=0. Determine the coefficient of correlation, and calculate the variance of Y if the variance of X is 9.


SLMref.png References and Bibliography



Anderson et al, Statistics for business and economics, eighth edition,2002, Thomson Asia Pvt. Ltd. Singapore 

R. Levin and D. Rubin, Statistics for management, seventh edition,1997,Prntice Hall of India, New Delhi.

Frank and Althoen, Statistics concept and applications,1994, Cambridge university press, Cambridge

A.D.Aczel and J. Sounderpandian, Complete Business Statistics, 2002, Tata McGraw Hill , New Delhi,India

W.J.Stevenson, Business Statistics concept and applications, 1978, Harper and Row publishers, New York, USA.


SLMref.png Further Readings