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 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
Get step-by-step solutions from verified subject matter experts
