Question: Please copy ( Ctrl C ) and paste ( Ctrl V ) the following data into Excel. Use regression analysis to predict Maintenance Costs as

Please copy (Ctrl C) and paste (Ctrl V) the following data into Excel. Use regression analysis to predict Maintenance Costs as a function of Patient Days for a local hospital:
MonthPatient DaysMaintenance CostsJanuary6,600$26,700February8,505$33,250March6,000$33,600April8,250$36,800May7,885$35,350June8,100$32,400July5,200$30,800August7,260$39,160September9,356$36,575October7,260$36,960November4,940$29,260December6,552$32,552
What is the estimated total maintenance cost for an expected 5,000 patient days?
Enter your answer rounded to the nearest dollar; for instance, 1234.567=1,235. Do not include the dollar sign ($) in your answer.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!