Cameron Company is interested in establishing the relationship between utility costs and machine hours. Data has been collected and a regression analysis prepared using Excel. The monthly data and the regression output follow:

Required: a. Using Excel, perform a regression analysis on the above data and generate a summary output. (Follow the instructions in your text book on pages 181-185). b. What is the equation for utility costs using the regression analysis?

c. Prepare an estimate of utility costs for a month when 3,000 machine hours are worked.