ABC Ltd is trying to estimate utility costs based on hours worked and has collected the

following data from the preceding year.

Use Excel or the visualization software of your or your instructor's choice to perform the

following:

a$.$ Calculate the variable costs per unit and fixed costs using regression analysis

for this mixed cost. Use the Intercept and Slope functions in Excel.

b$.$ Prepare a scatter plot $($Graph$)$ using Excel. Present the cost formula line estimated in part $($a$)$ by adding a trendline to your scatter plot.

Graph the data. See video posted on BB

c$.$ What utility cost does the cost formula predict for a level of $148,027$ hours worked?

at $148,027$ Hours using regression;

at $148,027$ hours using High and low Formula

$*$you need to use the formula. Entry oly the answer does not coun