! 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: Month January February March April May June July Number of Units Shipped 35 75 45 25 70 80 50 Total Shipping Cost $1,500 3,500 2,500 2,350 3,500 4,000 3,450 Required: 3. Using the high-low method, calculate Odessa's total fixed shipping costs and variable shipping cost per unit. 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) Cost Variable Cost per Unit 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 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 Prev 7 of 7 Next 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 Odessas data. 5. Using the regression output, create a linear equation (y= a + bx) for estimating Odessas shipping costs. 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