10 point 1 January Sumber of Bottles Sold 1,390 1,820 Operating $10,680 15,450 FTT February March April 2,410 3,550 16.076 19,900 27,500 34.640 June Sipped elock Ave Required: 3. Using the high-low method, calculate Garfield's total fixed operating costs and variable operating cost per bottle. 4. Perform a least-squares regression analysis on Garfield's data 5. Determine how well this regression analysis explains the data. 6. Using the regression output, create a linear cost equation (ya+ bid for estimating Garfield's operating costs Complete this question by entering your answers in the tabs below. ferences Required 3 Required 4 Required 5 Required 6 Perform a least-squares regression analysis on Garfield's data. (Use Microsoft Excel or a statistics package to fit the coefficients using least-squares regression. Round your answers to 3 decimal places.) Intercept X Variable 1 Coefficient Check my work