Patient Load	Administrative Cost
January	1540	13900
February	550	7000
March	440	6000
April	1100	9800
May	1430	11900
June	990	9600
July	1210	10200
August	220	4100
September	770	9300
October	1320	11100
November	660	8300
December	1980	16100

Estimated range of monthly activity in the future will be 750-1,500 patients.

A. Prepare a scatter diagram in Excel, then MANUALLY draw a best fit line that you feel fits the data. Clearly present a cost equation based on your scatter diagram line. (Noteyou may use the insert, then shapes function in Excel to manually draw a line, or you can print your diagram and draw the line in pen. HOWEVERif you have Excel insert a line, the program will run regression on the data to put in the line and thus you will NOT have fulfilled the requirements.)

B. Use the high-low method to estimate the cost behavior for the clinics administrative costs. Clearly label the final cost formula.

C. Perform a least squares regression analysis on the data to estimate the cost behavior. Clearly present the final cost formula. Include a brief analysis of the R2 factor for the regression on your Excel sheet.