BUS 308 Statistics for Managers – Ashford – Week 4 Discussions

Simple Regression Analysis.

Save Time On Research and Writing
Hire a Pro to Write You a 100% Plagiarism-Free Paper.
Get My Paper

Use the data in the chart to answer the questions below. The data indicates the number of “sick days” appliance installers take during a three month period, and the number of complaints filed by customers during the same interval. Use the Analysis Toolpak in Excel to perform this simple regression and answer the questions.

a. Is the correlation between number of sick days and number of customer complaints statistically significant?

b. What is the best prediction for the number of complaints that will be registered for an installer who takes five sick days during the period?

Use Excel to help you answer the questions in the forum but do not attach your Excel document to the discussion post.

Save Time On Research and Writing
Hire a Pro to Write You a 100% Plagiarism-Free Paper.
Get My Paper

 

Multiple Regression Analysis.

Develop a multiple linear regression equation that describes the relationship between tenure and the other variables in the chart above. Use the Analysis Toolpak located in Excel to perform this multiple regression.

Do these two variables explain a reasonable amount of the variation in the dependent variable?

Estimate the tenure of someone that could have $5.8($k) and 15 years of job satisfaction. Make sure to state your multiple regression equation in your example. What are some of things that you can estimate from the model? How effective is evaluating the R-squared of the model? What is the relationship between the independent and dependent variables?

Use Excel to help you answer the questions in the forum but do not attach your Excel document to the discussion post.

 

Guided Response: Review several of your classmates’ postings. Respond to at least two classmates by commenting on how this information might be used to make business decisions.

Order your essay today and save 25% with the discount code: GREEN

Order a unique copy of this paper

600 words
We'll send you the first draft for approval by September 11, 2018 at 10:52 AM
Total price:
$26
Top Academic Writers Ready to Help
with Your Research Proposal

Order your essay today and save 25% with the discount code GREEN