Required information 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: 80 Number of Units Month Shipped January 65 February March April 30 May June July Total Shipping Cost $4,050 3,600 3,800 1,600 3,900 2,600 1,950 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 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 Required 4 > Complete this question by entering your answers in the tabs below. Required 3 Required 4 Required 5 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 Required 3 Required 6 > Complete this question by entering your answers in the tabs below. Required 3 Required 4 Required 5 Using the regression output, create a linear equation (y = a + bx) for estimating Odessa's shipping costs. Total Shipping Cost Number of Units Shipped