Mason Office Services color copies for various customers.The company has gathered the following data:

Month # Copies Copy Department Costs

July 17,000 $1,445

August 21,2501,685

September 22,9501,785

October 18,7001,530

November 20,4001,615

December 25,5002,040

Required:

(a) Enter the above data onto an Excel worksheet.Then, using the High-Low method, build the applicable regression equation, and

(i)Solve for "f."

(ii)Solve for "v"

(iii)Estimate Copy Department Costs, assuming the number of copies is 23,000.

(b) On the same worksheet, using Excel's Least Squares Regression application,

(i)Solve for "f."

(ii)Solve for "v."

(iii)Estimate Copy Department Costs, assuming the number of copies is23,000.

(iv)Based on the r² measure (coefficient of determination), explainwhat it indicates about how accurate (or inaccurate) the LeastSquares equation is at predicting total costs.