Question

In: Math

Kamini, a student of the 1-Year post graduate program at the International School of Business and...

Kamini, a student of the 1-Year post graduate program at the International School of Business and Design is trying to establish the relationship between compensation (in Rs. Lakh) and years of work experience. She collected data from 9 students who have been placed and fitted a regression equation with Compensation (in Rs. Lakh) as the dependent variable and Years of experience as the independent variable. The Excel output is given below (with some missing 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 years of experience?

4. What is the coefficient of correlation between Compensation and 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 work experience?

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

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

Solutions

Expert Solution

Solution:

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

Answer:

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

Answer:

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

Answer:

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

Answer:

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

Answer:

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

Answer:

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

Answer: The p-value = 0.004177 is less than 0.05 significance level, we, therefore, reject the null hypothesis and conclude that there is a significant relationship between the two variables.

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

Answer:

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

Answer:

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

Answer:


Related Solutions

Jessica is a graduate of a University’s business school entrepreneurship program.  As part of her final year...
Jessica is a graduate of a University’s business school entrepreneurship program.  As part of her final year of studies, she developed a business plan for a business that develops websites for individuals and commercial businesses.  She put her business plan into action with the help of start-up funding from family and friends, and has been operating for two and a half years. Jessica has decided to apply the concepts in a balanced scorecard to evaluate and improve her business.  Her vision for this...
Jessica is a recent graduate of Brenau University’s business school entrepreneurship program. The business plan that...
Jessica is a recent graduate of Brenau University’s business school entrepreneurship program. The business plan that she created before she graduated was for a business developing websites for individuals and commercial businesses. Friends and family provided funding for the start-up, and she has been in business for the last two and a half years. Jessica had learned about the balanced scorecard in her accounting classes and has been applying some of the techniques. Her vision for this business is to...
1. The dean of a school of business is forecasting total student enrollment for this year...
1. The dean of a school of business is forecasting total student enrollment for this year (2019)'s summer session classes based on the following historical data: YEAR TOTAL ENROLLMENT   y 2015 2,000 2016 2,200 2017 2,800 2018 3,000   a) What is this year's forecast using a three-year simple moving average? b) What is this year's forecast using a three-year weighted moving average with weights of 0.5, 0.3, and 0.22 c) What is this year's forecast using exponential smoothing...
A graduate student in the School of Education is interested in whether families of students in...
A graduate student in the School of Education is interested in whether families of students in the Chicago Public Schools are for or against the new legislation proposing school uniform requirements. She surveys 600 students and finds that 480 are against the new legislation. Compute a 90 and 98 percent confidence interval for the true proportion who are for the new legislation.
Question 1 A student organization wants develop a program for students who are going to graduate...
Question 1 A student organization wants develop a program for students who are going to graduate in the next 18 months.   To get a sense of how many students might be interested in the program, they want an estimate of the proportion of students who are going to graduate in the next 18 months. They take a simple random sample of 89 students. The data they collected can be found in the column labeled “Graduate in the next 18 month”.  ...
Chapter 1 underscores the value of studying international business as a student or a domestic business....
Chapter 1 underscores the value of studying international business as a student or a domestic business. However, every student or business manager doesn't see the international business the same. We found that proclaiming or documenting your international experience may help international firms find valuable human capital capable of helping achieve objectives in a foreign country. Recognizing there are motivational differences in both of these types of interest groups. You have to at least create a self-reference criterion. This criterion is...
1. You are an accounting student at Berkeley College and will not graduate for another year....
1. You are an accounting student at Berkeley College and will not graduate for another year. But because of your excellent grades so far, you have been able to land a job in the purchasing department of a retailer. One of the purchasing agents in your company is negotiating for the receipt of a very large order of uninsured goods from a supplier. The purchasing agent is able to get a better deal on the goods if they are shipped...
Scenario you are a 30 year old college student going to school for business and will...
Scenario you are a 30 year old college student going to school for business and will graduate in a year. Instructions: Find a company online where you would like to apply for a job. Research the company and write a description using the guidelines below. Answer the question: Why do you want to work for this company? Do Your Homework When I say, “homework” I am referring to research and preparation in three key areas: Know yourself Know the company...
As Stamford International University continues to grow and grow, expanding into post graduate, and doctorate courses,...
As Stamford International University continues to grow and grow, expanding into post graduate, and doctorate courses, many have asked for higher education to be free. Describe the advantages and disadvantages to the economy, if education was free in Thailand.
As ABAC International University continues to grow and grow, expanding into post graduate, and doctorate courses,...
As ABAC International University continues to grow and grow, expanding into post graduate, and doctorate courses, many have asked for higher education to be free. Describe the advantages and disadvantages to the economy, if education was free in Thailand.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT