Refer to the orginal data in the preceding problem for Martha’s Vineyard Marine Supply.
Required:
1. Build a spreadsheet:Construct an Excel spreadsheet and use the Excel commands to perform a least-squares regression. Estimate of the variable- and fixed-cost components in the company’s material-handling department costs.
2. Write the least-squares regression equation for the department’s costs.
3. Predict the firm’s material-handling department’s costs for a month when 2,300 units of activity are recorded.
4. Why do the three cost predictions computed in this and the preceding problem differ? Which method do you recommend? Why?
5. Build a spreadsheet: Use your Excel spreadsheet from requirement (1) to compute the R2 value for the regression. Interpret the R2value.
We need at least 10 more requests to produce the solution.
0 / 10 have requested this problem solution
The more requests, the faster the answer.