What % of the increase in sales is explained by the lineaer trend over the time series?

  

What % of the increase in sales is explained by the lineaer trend over the time series? 4. The data below represent Y, sales in thousands of dollars; X1, price in cents; X2, promotion in dollars. Sales Price Promotion 53 674 3250 59 628 3589 61 536 4266 63 521 4875 65 528 4912 71 506 5763 76 453 6173 83 399 6369 a) Give the equation of the regression line. Round to 3 decimal places. b) Give the value of the slope for price c) Interpret its meaning in the context of this problem. Move ethe decimal appropriately d) Give the value of the slope for promotion. e) Interpret its meaning in the context of this problem. Move the decimal appropriately. f) Predict sales for price of $4.50 and $6000 spent on promotion. Move the decimal appropriately. g) Give the calculated F for testing if the relationship is significant between sales & price and promition. h) What is its p-value? i) Is the relationship significant? Please answer yes or no. j) Give the coefficient of determination. k) Interpret its meaning in the context of this problem. l) Give the coefficient of partial determination for price. Show your calculations. m) Interpret its meaning in the context of this problem. n) Give the coefficient of partial determination for promotion. Show your calculations. o) Interpret its meaning in the context of this problem. 5. Your factory produces 5 styles of coats. There are 5 rectangular areas (length and width in ft. are given) for each style of coat. Workers are paid $25 per hour. From the data below, find for each style: 1) the total wholesale $, 2) the total wages paid, 3) the total production cost, 4) the costs + wages as % of wholesale $. Remember wholesale $ is only for acceptable coats as we don’t sell rejects. Production costs are in dollars. Style of coat: length of area width of area #acceptable #rejected prod. cost$ each coat/sq. ft. wholesale$/coat # worker hrs/coat 1 135 95 5786 452 .02 435 3.5 2 120 105 4468 354 .04 347 4.1 3 140 120 5637 259 .03 320 3.9 4 130 80 4903 395 .01 310 3.1 5 125 90 4039 349 .02 298 2.9