[The following information applies to the questions displayed below) Odessa, Inc., manufactures one model of computer desk. The following data are available regarding units shipped and total shipping costs Number of Units Shipped 55 Month January February March April May June July Anna Total Shipping cost $3,100 3,700 2,550 3,900 1,85 3,450 2,350 Part 2 ces Required: 3. Using the high-low method, calculate Odessa's total fixed shipping costs and variable shipping cost per unit. 4. Perform a least-squares regression analysis on Odessa's data. 5. Using the regression output, create a linear equation (ya+bx) for estimating Odessa's shipping costs. Complete this question by entering your answers in the tabs below. Required 3 Required 4 Required Using the high-low method, calculate Odessa's total fixed shipping costs and variable shipping cost per unit. (Round your Intermediate calculations to 2 decimal places and final answers to the nearest dollar) Fixed Cost Variable Cost per Unit $ 82 7 The following information applies to the questions displayed below.) Odessa, Inc., manufactures one model of computer desk. The following data are available regarding units shipped and total shipping costs: Number of Units Month Shipped January 55 February 70 March 45 April 60 May 35 June 50 July 25 Total Shipping cost $3,100 3,700 2,550 3.900 1,850 3,450 2,350 . OK ht Part 2 ances Required: 3. Using the high-low method, calculate Odessa's total fixed shipping costs and variable shipping cost per unit 4. Perform a least-squares regression analysis on Odessa's data. 5. Using the regression output, create a linear equation (y= a + bx) for estimating Odessa's shipping costs. Complete this question by entering your answers in the tabs below. Required 3 Required 4 Required Perform a least squares regression analysis on Odessa's data. (Use Microsoft Excel or a statistical package to find the coefficients using least-squares regression. Round your answers to 2 decimal places) Coefficients Intercept X Variable The following information applies to the questions displayed below.) Odessa, Inc., manufactures one model of computer desk. The following data are available regarding units shipped and total shipping costs: Number of Units Month Shipped January 55 February 70 March 45 April 60 May 35 June 50 July 25 Total Shipping Cost $3,100 3,700 2,550 3,900 1,850 3,450 2,350 Part 2 cos Required: 3. Using the high-low method, calculate Odessa's total fixed shipping costs and variable shipping cost per unit. 4. Perform a least-squares regression analysis on Odessa's data. 5. Using the regression output, create a linear equation (y = a + bx) for estimating Odessa's shipping costs. Complete this question by entering your answers in the tabs below. Required 3 Required 4 Required 5 Using the regression output, create linear equation (y = a + bx ) for estimating Odessa's shipping costs. Total Shipping Cost Number of Units Shipped