b) b1 is the estimated increase in Direct Labor Cost for every 1 unit increase in batch size.
b0 is the estimated Direct Labor Cost when batch size = 0
c) yhat = 250.6179 + 6.534x
d) yhat(60) = 250.6179 + 6.534(60) = 642.658
NOTE:
1) Ybar = 593.9167, Xbar = 53.1667, Σ(Xi - Xbar)2 = 8681.677, Σ(Yi - Ybar)2 = 896108.9167, Σ(XiYi - Xbar Ybar)= 54646.1667
2) I have left empty cells as they can be calculated easily.
please explain how to get answers! i rate! :) thank you An accountant wishes to predict...
can somebody please tell me how to do it on excel
An accountant wishes to predict direct labor cost (y) on the basis of the batch size (x) of a product produced in a job shop. Data for 12 production runs are given in the table below, along with the Excel output from fitting a least squares regression line to the data. Direct Labor Cost Data Direct Labor Batch Cost, y ($100s) 908 Size, x 71 177 80 514 41...