help

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: Number of Units Total Month Shipped Shipping cost January 40 $2,950 February 75 3,650 March 25 2,250 April 35 1,850 May 30 2,300 June 55 3,250 July 50 3,000 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 ly = a + bx) for estimating Odessa's shipping costs. Complete this question by entering your answers in the tabs below. Next regression output, create a linear equation (y= a + bx) for estimating Odessa 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 intermediate calculations to 2 decimal places and final answers to the nearest dollar) Fixed Cost Variable Cost per Unit Required 3 Required 4 5. Using the regression output, create a linear equation (y= a +bx) for estimating Odessa's ship 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 pac coefficients using least-squares regression. Round your answers to 2 decimal places.) Coefficients Intercept X Variable