Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

need help on doing these in excel with explanations please You are trying to find a relationship between the productivity of your sales staff and

image text in transcribed

need help on doing these in excel with explanations please

image text in transcribedimage text in transcribed
You are trying to find a relationship between the productivity of your sales staff and some other factors such as the number of training hours, age, and the current annual salary. You have collected the data of 37 employees. The Output is the percent of actual sales given the sales leads. You want to study the impact of other variables on this Output. For example, does age matter? And if it does, are the younger employees better performers than the older employees? Output Data Employee | Output (O) raining hours(T Age (A) Income (1) 1 58.8 24 60 22. 2 58.7 25 59 24.6 w 58.2 25 59 25.1 57 25 53 28 UT D 56.5 25 52 28. 6 55.2 27 50 29.7 54.7 30 50 32 . 8 54.5 30 19 32.6 52.8 30 49 33.7 10 51.1 31 49 44.1 11 44.8 32 48 42.9 12 44 33 47 40.7 1 3 59.4 39 47 40.2 14 59.8 41 45 40 15 61.7 43 45 39.9 16 62.5 44 43 39.6 17 62.6 45 43 38.5 18 64.6 60 41 38.4 19 64.9 57 40 38 20 65.3 56 40 37.4 21 65.7 56 40 34.5 22 66.1 49 40 34.4 23 58.2 48 44.4 24 71. 48 35 44. 25 71.7 46 35 8'tt 26 71.3 46 35 448 27 70.1 60 36 15.6 28 69.9 63 37 46.5 29 69.8 53 38 47.5 30 69.6 63 39 4930 69.6 63 39 49 31 68.8 64 39 51.4 32 68.5 68 39 52.6 33 72.6 72 34 52.9 34 73.9 75 34 54.8 35 75.3 76 33 55.1 36 81.6 77 31 55.2 37 83.7 79 30 55.6 a) What portion of the variation in the Output is explained by the 3 independent variables? b) What output would you expect for a 40-year old employee who has 50 hours of training and is making $55,450? c) Based on this model, productivity d) Based on this model, productivity e) Comment on the quality of your regression result. That is, how strong or weak it is? Regression Output

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Discrete Mathematics With Applications

Authors: Susanna S Epp, Robert Gatewood,

4th Edition

1133168663, 9781133168669

More Books

Students also viewed these Mathematics questions

Question

What kinds of molecules often trigger our sense of smell?

Answered: 1 week ago

Question

Make eye contact when talking and listening

Answered: 1 week ago

Question

Do not go, wait until I come

Answered: 1 week ago

Question

Pay him, do not wait until I sign

Answered: 1 week ago