Showing Page:
1/4
2. In determining the best companies to work for, a number
of variables are considered, including size, average annual
pay, and turnover rate, etc. Moreover, employee surveys are
conducted in order to assess aspects of the organizations
culture, such as trust and openness to change. In an attempt
to determine what affects turnover rate, a sample of 33
companies was randomly selected and data collected on the
average annual bonus and turnover rate (%). In addition, a
questionnaire was administered to the employees of each
company to arrive at a trust index (measured on a scale of 0
100). Below are the multiple regression results.
a. Write out the estimated regression equation.
b. Is the regression equation significant overall? Explain.
c. How much of the variability in Turnover Rate is explained
by the regression
equation?
d. State the hypotheses for testing the regression coefficient
of Trust Index. Based on
the results, what do you conclude?
e. State the hypotheses for testing the regression coef ficient
of Average Annual Bonus.
Based on the results, what do you conclude?
f. Predict the turnover rate for a company with a trust index
score of 70 and an average
annual bonus of $6500.
g. Comment on whether the conditions for multiple
regression are satisfied based on the
plots shown below.
Solution
Showing Page:
2/4
2. In determining the best companies to work for, a number
of variables are considered, including size, average annual
pay, and turnover rate, etc. Moreover, employee surveys are
conducted in order to assess aspects of the organizations
culture, such as trust and openness to change. In an attempt
to determine what affects turnover rate, a sample of 33
companies was randomly selected and data collected on the
average annual bonus and turnover rate (%). In addition, a
questionnaire was administered to the employees of each
company to arrive at a trust index (measured on a scale of 0
100). Below are the multiple regression results.
a. Write out the estimated regression equation.
The estimated regression equation is given as below:
Turnover rate = 12.1005 0.0715*Trust index
0.0007*average bonus
b. Is the regression equation significant overall? Explain.
The regression equation is significant because we get the p -
value less than the given level of significance or alpha value
0.05 or 5% so we reject the null hypothesis that the given
regression model is not significant.
c. How much of the variability in Turnover Rate is explained
by the regression equation?
The value for the multiple correlation or the coefficient of
determination R-square is not given so we can find the
Showing Page:
3/4
explained variation in the turnover rate due to the
independent variables.
d. State the hypotheses for testing the regression coefficient
of Trust Index. Based on the results, what do you conclude?
The null and alternative hypothesis for testing the
regression coefficient of trust index is given as below:
Null hypothesis: H0: The slope of the trust index is not
significant.
Alternative hypothesis: Ha: The slope of the trust index is
significant.
The p-value for this test is given as 0.001 so we reject the
null hypothesis that the slope of the trust index is not
significant.
e. State the hypotheses for testing the regression coefficient
of Average Annual Bonus.
The null and alternative hypothesis for testing the
regression coefficient of average annual bonus is given as
below:
Null hypothesis: H0: The slope of the average annual bonus
is not significant.
Alternative hypothesis: Ha: The slope of the average annual
bonus is significant.
Based on the results, what do you conclude?
The p-value for this test is given as 0.0001481 which is less
than the given level of significance so we reject the null
Showing Page:
4/4
hypothesis that the slope of the average annual bonus is not
significant.
f. Predict the turnover rate for a company with a trust index
score of 70 and an average annual bonus of $6500.
The regression equation is given as below:
Turnover rate = 12.1005 0.0715*Trust index
0.0007*average bonus
Turnover rate = 12.1005 0.0715*70 0.0007*6500
Turnover rate = 2.5455

Unformatted Attachment Preview

2. In determining the best companies to work for, a number of variables are considered, including size, average annual pay, and turnover rate, etc. Moreover, employee surveys are conducted in order to assess aspects of the organization’s culture, such as trust and openness to change. In an attempt to determine what affects turnover rate, a sample of 33 companies was randomly selected and data collected on the average annual bonus and turnover rate (%). In addition, a questionnaire was administered to the employees of each company to arrive at a trust index (measured on a scale of 0 – 100). Below are the multiple regression results. a. Write out the estimated regression equation. b. Is the regression equation significant overall? Explain. c. How much of the variability in Turnover Rate is explained by the regression equation? d. State the hypotheses for testing the regression coefficient of Trust Index. Based on the results, what do you conclude? e. State the hypotheses for testing the regression coef ficient of Average Annual Bonus. Based on the results, what do you conclude? f. Predict the turnover rate for a company with a trust index score of 70 and an average annual bonus of $6500. g. Comment on whether the conditions for multiple regression are satisfied based on the plots shown below. Solution 2. In determining the best companies to work for, a number of variables are considered, including size, average annual pay, and turnover rate, etc. Moreover, employee surveys are conducted in order to assess aspects of the organization’s culture, such as trust and openness to change. In an attempt to determine what affects turnover rate, a sample of 33 companies was randomly selected and data collected on the average annual bonus and turnover rate (%). I n addition, a questionnaire was administered to the employees of each company to arrive at a trust index (measured on a scale of 0 – 100). Below are the multiple regression results. a. Write out the estimated regression equation. The estimated regression equation is given as below: Turnover rate = 12.1005 – 0.0715*Trust index – 0.0007*average bonus b. Is the regression equation significant overall? Explain. The regression equation is significant because we get the p value less than the given level of signif icance or alpha value 0.05 or 5% so we reject the null hypothesis that the given regression model is not significant. c. How much of the variability in Turnover Rate is explained by the regression equation? The value for the multiple correlation or the coe fficient of determination R-square is not given so we can find the explained variation in the turnover rate due to the independent variables. d. State the hypotheses for testing the regression coefficient of Trust Index. Based on the results, what do you c onclude? The null and alternative hypothesis for testing the regression coefficient of trust index is given as below: Null hypothesis: H0: The slope of the trust index is not significant. Alternative hypothesis: Ha: The slope of the trust index is significant. The p-value for this test is given as 0.001 so we reject the null hypothesis that the slope of the trust index is not significant. e. State the hypotheses for testing the regression coefficient of Average Annual Bonus. The null and alternative hypothesis for testing the regression coefficient of average annual bonus is given as below: Null hypothesis: H0: The slope of the average annual bonus is not significant. Alternative hypothesis: Ha: The slope of the average annual bonus is significant. Based on the results, what do you conclude? The p-value for this test is given as 0.0001481 which is less than the given level of significance so we reject the null hypothesis that the slope of the average annual bonus is not significant. f. Predict the turnover rate for a company with a trust index score of 70 and an average annual bonus of $6500. The regression equation is given as below: Turnover rate = 12.1005 – 0.0715*Trust index – 0.0007*average bonus Turnover rate = 12.1005 – 0.0715*70 – 0.0007*6500 Turnover rate = 2.5455 Name: Description: ...
User generated content is uploaded by users for the purposes of learning and should be used following Studypool's honor code & terms of service.
Studypool
4.7
Trustpilot
4.5
Sitejabber
4.4