Hi, can you please provide an answer for the attached document?

Last 3 digits are 028.

Thank you!!

EXCEL ASSIGNMENT Assume the following data (where the xxx is the last three digits of your id): Month 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 Machine Hours (hrs.) 1,330 1,400 1,250 1,470 1,620 1,680 1,490 1,280 1,450 1,580 1,300 1,600 1,650 1,440 1,350 1,670 1,480 1,360 1,340 1,540 1,320 1,410 1,270 Maintenance Costs ($) 102,xxx 103,xxx 103,xxx 108,xxx 116,xxx 115,xxx 107,xxx 101,xxx 106,xxx 113,xxx 100,xxx 113,xxx 113,xxx 109,xxx 102,xxx 114,xxx 106,xxx 103,xxx 103,xxx 112,xxx 102,xxx 104,xxx 101,xxx For example, if your id is 1234567, then your maintenance costs would be $102,567 in month 1; $103,567 is month 2; $113, 567 in months 10, 12, and 13. Assume that the following relationship holds: Maintenance Costs = a + (b * Machine Hours) REQUIRED Estimate the values of a and b, using, 1. the High-Low Method, and 2. the Linear Regression method.(for help try \"Linear Regression in Excel\" on YouTube) Note, to use the linear regression method, you MUST use the Microsoft Excel program. Make sure to report a. the values of a and b; b. a scatter plot of the data points, and c. the R-square or the adjusted R-square 3. Which of the above two methods is more appropriate? Why