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

Month#CopiesCopy Department Costs

July17,000$1,445

August21,2501,685

September22,9501,785

October18,7001,530

November20,4001,615

December25,5002,040

(a) In putting this data in excel, and using the High-Low method, what would be the build for the applicable regression equation and how would you solve for:

(i)Solve for "f."

(ii)Solve for "v"

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

(b) Using 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