CoursHeroTranscribedText: 1. Use the high- low method to estimate the cost behavior for the clinic's administrative costs. Express the cost behavior in formula form (Y = a + bX ). What is the variable cost per patient? 2. Build a spreadsheet: Construct an Excel spreadsheet and use the Excel commands to perform a least squares regression and estimate the administrative cost behavior. Express the cost behavior in formula form. What is the variable cost per patient? Compute and interpret the R'2 value for the regression. 3. Write a memo to the hospital administrator comparing the cost estimates using [ a ) least- squares regression, ( b } the high- low method, and [ c ) the scatter diagram and visually fit semivariable- cost line from the preceding case [requirements (4) and ( 5)]. Make a recommendation as to which esti-mate should be used, and support your recommendation. Make any other suggestions you feel are appropriate