Question

Salesperson Years of Experience Annual Sales ($1000s) 1 1 85 2 4 100 3 4 91...

 
Salesperson Years of Experience Annual Sales ($1000s)
1 1 85
2 4 100
3 4 91
4 4 97
5 6 107
6 9 109
7 10 118
8 11 126
9 10 113
10 14 132
  • Compute b1 and b0 (to 1 decimal).

    b1 =

    b0 =

    Complete the estimated regression equation (to 1 decimal).

    y = ... + x

  • According to this model, what is the change in annual sales ($1000s) for every year of experience (to 1 decimal)?

  • Compute the coefficient of determination (to 3 decimals). Note: report r2 between 0 and 1.

    r2 =

    What percentage of the variation in annual sales ($1000s) can be explained by the years of experience of the salesperson (to 1 decimal)?

    ... %

  • A new salesperson joins the team with 6 years of experience. What is the estimated annual sales ($1000s) for the new salesperson (to the nearest whole number)?

    $ ...

Homework Answers

Answer #1
X Y X * Y
1 85 85 1 7225
4 100 400 16 10000
4 91 364 16 8281
4 97 388 16 9409
6 107 642 36 11449
9 109 981 81 11881
10 118 1180 100 13924
11 126 1386 121 15876
10 113 1130 100 12769
14 132 1848 196 17424
Total 73 1078 8404 683 118238


Equation of regression line is


b = 3.6



a =( 1078 - ( 3.5616 * 73 ) ) / 10
a = 81.8


Equation of regression line becomes

b0 = a = 81.8

b1 = b = 3.6



r = 0.969

Coefficient of Determination

Explained variation = 0.938* 100 = 93.8%
Unexplained variation = 1 - 0.938* 100 = 6.2%

When X = 6
= 81.8 + 3.562 X
= 81.8 + 3.562 * 6
= 103

Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
A sales manager collected data on annual sales for new customer accounts and the number of...
A sales manager collected data on annual sales for new customer accounts and the number of years of experience for a sample of 10 salespersons. In the Microsoft Excel Online file below you will find a sample of data on years of experience of the salesperson and annual sales. Conduct a regression analysis to explore the relationship between these two variables and then answer the following questions. Salesperson Years of Experience Annual Sales ($1000s) 1 1 84 2 4 93...
A sales manager collected data on annual sales for new customer accounts and the number of...
A sales manager collected data on annual sales for new customer accounts and the number of years of experience for a sample of 10 salespersons. In the Microsoft Excel Online file below you will find a sample of data on years of experience of the salesperson and annual sales. Conduct a regression analysis to explore the relationship between these two variables and then answer the following questions. Open spreadsheet Compute b1 and b0 (to 1 decimal). b1 = b0 =...
3. A sales manager collected the following data on annual sales and years of experience. Salesperson...
3. A sales manager collected the following data on annual sales and years of experience. Salesperson Years of Experience Annual Sales ($000s) 1 1 132 2 3 160 3 4 145 4 5 168 5 6 168 6 8 180 7 10 188 8 11 218 9 11 193 10 13 229 a. Develop a scatter diagram for these data with years of experience as the independent variable. b. Develop an estimated regression equation that can be used to predict...
A sales manager collected the following data on x = years of experience and y =...
A sales manager collected the following data on x = years of experience and y = annual sales ($1,000s). The estimated regression equation for these data is ŷ = 80 + 4x. Salesperson Years of Experience Annual Sales ($1,000s) 1 1 80 2 3 97 3 4 92 4 4 107 5 6 103 6 8 101 7 10 119 8 10 118 9 11 127 10 13 136 A. Compute SST, SSR, and SSE. B. Compute the coefficient of...
A statistical program is recommended. A sales manager collected the following data on x = years...
A statistical program is recommended. A sales manager collected the following data on x = years of experience and y = annual sales ($1,000s). The estimated regression equation for these data is ŷ = 82 + 4x. Salesperson Years of Experience Annual Sales ($1,000s) 1 1 80 2 3 97 3 4 102 4 4 107 5 6 103 6 8 101 7 10 119 8 10 128 9 11 127 10 13 136 (a) Compute the residuals. Years of...
A sales manager collected the following data on x = years of experience and y =...
A sales manager collected the following data on x = years of experience and y = annual sales ($1,000s). The estimated regression equation for these data is ŷ = 82 + 4x. Salesperson Years of Experience Annual Sales ($1,000s) 1 1 80 2 3 97 3 4 102 4 4 107 5 6 103 6 8 101 7 10 119 8 10 128 9 11 127 10 13 136 (a) Compute SST, SSR, and SSE. SST = SSR = SSE...
1. A sales manager collected the following data on annual sales for new customer accounts and...
1. A sales manager collected the following data on annual sales for new customer accounts and the number of years of experience for a sample of 10 salespersons. Salesperson Years of Experience Annual Sales ($1000) 1 1 84 2 1 81 3 2 87 4 4 101 5 5 104 6 7 118 7 8 119 8 9 120 9 10 127 10 11 134 a. Compute the residuals and choose a residual plot for this problem. 2. The following...
A statistical program is recommended. A sales manager collected the following data on x = years...
A statistical program is recommended. A sales manager collected the following data on x = years of experience and y = annual sales ($1,000s). The estimated regression equation for these data is ŷ = 80 + 4x. Salesperson Years of Experience Annual Sales ($1,000s) 1 1 80 2 3 97 3 4 92 4 4 102 5 6 103 6 8 111 7 10 119 8 10 123 9 11 117 10 13 136 A) Compute the residuals. Years of...
Week Sales (1000s of gallons) 1     16    2     22    3     19    4    ...
Week Sales (1000s of gallons) 1     16    2     22    3     19    4     24    5     18    6     15    7     19    8     19    9     23    10     20    11     16    12     23    a. Using a weight of 1/2 for the most recent observation, 1/3 for the second most recent observation, and 1/6 third the most recent observation, compute a three-week weighted moving average for the time series (to 2 decimals). Enter...
Taxpayer Form 1 Form 2 Form 3 Form 4 1 109 115 126 120 2 98...
Taxpayer Form 1 Form 2 Form 3 Form 4 1 109 115 126 120 2 98 103 107 108 3 29 27 53 38 4 93 95 103 109 5 62 65 67 64 6 103 107 111 128 7 83 82 101 116 8 122 119 141 143 9 92 101 105 108 10 107 113 127 113 11 103 111 111 108 12 54 64 67 62 13 141 145 142 160 14 92 94 95 102 15...