Kamini, a student of the 1-Year post graduate program at theInternational School of Business and Design is trying to establishthe relationship between compensation (in Rs. Lakh) and years ofwork experience. She collected data from 9 students who have beenplaced and fitted a regression equation with Compensation (in Rs.Lakh) as the dependent variable and Years of experience as theindependent variable. The Excel output is given below (with somemissing values):

SUMMARY OUTPUT
Regression Statistics
Multiple R
R Square
Adjusted R Square	0.67224
Standard Error	1.262251
Observations	9
ANOVA
	df	SS	MS	F	Significance F
Regression	1			17.40811	0.004177
Residual	7	11.15294	1.593277
Total	8	38.88889
	Coefficients	Standard Error	t Stat	P-value	Lower 95%	Upper 95%
Intercept	11.91765	1.542901		0.000114	8.269266	15.56603
years of experience		0.290431		0.004177	0.525005	1.898524

Answer the following questions based on the above.

1. What is the value of Regression Sum of Squares?

2. What is the 95% confidence interval for the slope?

3. What is the estimated compensation for a person with 8 yearsof experience?

4. What is the coefficient of correlation between Compensationand Years of experience?

5. What is the R2 for the above regression equation?

6. What is the t-value corresponding to the intercept?

7. Interpret the value 0.004177 under the column “P-Value”

8. What is the expected compensation for a person with no workexperience?

9. The above output provides 95% confidence interval for theintercept. What is the lower limit for the 90% confidence intervalfor the intercept?

10. The above output provides 95% confidence interval for theintercept. What is the upper limit for the 90% confidence intervalfor the intercept?