Question
The following regression results relate to a study of the salaries of public school teachers in a midwestern city (the sample size was 450 teachers):
-
The following regression results relate to a study of the salaries of public school teachers in a midwestern city (the sample size was 450 teachers):
Variable Coefficient Standard Error t-ratio Constant 20,720 6,820 3.04 EXP 805 258 R-squared = 0.684; n = 105. Standard error of the estimate = 2,000. EXP is the experience of teachers in years of full-time teaching.
-
What is the t-ratio for EXP? Does it indicate that experience is a statistically significant determinant of salary if a 95 percent confidence level is desired?
-
What percentage of the variation in salary is explained by this model?
-
Determine the point estimate of a salary for a teacher with 20 years of experience.
-
What is the approximate 95 percent confidence interval for your point estimate from part (c)?
-
Please post steps using excel or Forecast x to solve so I can figure out what I am doing wrong
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started