Please help with solving the below The following tables present number of client

ID: 3324584 • Letter: P

Question

Please help with solving the below The following tables present number of clients visited in four weeks by two different salespeople and number of units of software sold X represents number of clients visited and Y represents the number of software sold during the week. For each salesperson we got 4 sets of data representing 4 weeks Salesperson one is affectionately called Ms. Reliability because she is an organized systematic and reliable employee whose method and results have been consistent salesperson two is affectionately known as Ms. Unpredictable because she is impulsive and disorganized, and her methods and results have been very inconsistent ranging from extreme poor to extremely good. In the long run, they both average about the same number of sales. Here is some data from these two salespeople Linear Regression models are produced and is same for both sets of data. Also SSE for salesperson two is provided Sales Person 1 Sales Person 2 10 20 20 23 230 100 526 27 270 100 729 44 880 400 1936 46 920 400 2116 10 10 20 20 40 25 65 Model (1) Y 5+2X Model (2) y= 5+2x SSE-1250 -Find the value of SSE for sales person one Predict number of software to be sold for both sales persons for 10 visits -Which salesperson's model will you use for forecasting? Why? show steps please!

Explanation / Answer

model1.

calculation procedure for regression

mean of X = X / n = 15

mean of Y = Y / n = 35

(Xi - Mean)^2 = 100

(Yi - Mean)^2 = 410

(Xi-Mean)*(Yi-Mean) = 200

b1 = (Xi-Mean)*(Yi-Mean) / (Xi - Mean)^2

= 200 / 100

= 2

bo = Y / n - b1 * X / n

bo = 35 - 2*15 = 5

value of regression equation is, Y = bo + b1 X

Y'=5+2* X

model2