Question: 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

 need help on doing these in excel with explanations please You

need help on doing these in excel with explanations please

are trying to find a relationship between the productivity of your salesstaff and some other factors such as the number of training hours,

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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Mathematics Questions!