Business Finance Homework Help
Allen County Community College Accounting Practice Question
Project Description:
BT6e E6-29A LO5 v1
Steps to Perform:
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). a. Rename the regression output tab “REGRESSION” |
4 |
2 |
2. Determine the R-square (use the output from the Excel regression). |
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. a. Reference values calculated in previous requirements as needed. |
1 |