Income(in Exp(in
Lacs INR) thousands)
0.928
X Y r 6
1 9
2 8
3 10
4 12
5 11
6 13
7 14
Assume
linear
relation
Y=A + BX
SUMMARY
OUTPUT
Regression
Statistics
0.9285714
Multiple R 29 r
Coefficient of
0.8622448 Determination(C
R Square 98 OD)
Adjusted R 0.8346938
Square 78
Standard 0.8783100
Error 66
Observatio
ns 7
ANOVA
df SS MS F Significance F
24.14
Regression 1 24.1429 3 31.3 0.0025
0.771
Residual 5 3.85714 4
Total 6 28
Low Upp
P- er er
Coefficien valu Uppe 95.0 95.0
ts Standard Error t Stat e Lower 95% r 95% % %
2E- 9.193
Intercept 7.29 0.74231 9.815 04 5.38 9 5.38 9.19
X Variable 5.594 0.00 1.355
1 0.93 0.16599 3 3 0.5 2 0.5 1.36
A=7.29
B=0.93
Y=7.29+0.9
3X
Questions
Pls refer to Excel output of the Regression Analysis between Income and Expenditure
[Link] a linear regression equation between X and Y
2. What is Coefficient of Correlation between Income and Expenditure? Comment on its value
[Link] do you mean by Coefficient of determination(COD)? What is COD value in above case?
[Link] is Y intercept and Slope of the Regression line?
[Link] will be Expenditure when Income becomes INR 20 Lacs?
[Link] the Significance of Regression Analysis in Business?