Accounting Practice Question – Allen County Community College

Step Instructions Points Possible
1 1. Run a regression analysis using data for January through July. Determine the company’s cost equation (use the output from the regression analysis you performed using Excel).
(Always use cell references and formulas where appropriate to receive full credit. If you copy/paste from the Instructions tab you will be marked wrong.)
a. Rename the regression output tab “REGRESSION”
4
2 2. Determine the R-square (use the output from the Excel regression).
(Always use cell references and formulas where appropriate to receive full credit. If you copy/paste from the Instructions tab you will be marked wrong.)
2
3 3. Predict van operating costs at a volume of 16,500 miles assuming the company would use the cost equation from the Excel regression regardless of its R-square.
(Always use cell references and formulas where appropriate to receive full credit. If you copy/paste from the Instructions tab you will be marked wrong.)
a. Reference values calculated in previous requirements as needed.