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 30 45 75 80 60 55 40 Total Shipping Cost $1,950 2,800 4,200 4,000 3,500 3,250 2,800 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 dolar) Fored Cost Variable Cost per Unit Required 4 > Odessa, Inc., manufactures one model of computer desk. The following data are available regarding units shipped and total shipping costs: Number of Units Shipped 3e 45 Month January February March April May June July Total Shipping Cost 51,950 2,800 4,200 4,000 3,500 3,250 2,80 60 55 40 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. Required 3 Required 4 Required 5 Perform a least squares regression analysis on Odessa's data. (Use Microsoft Excel ora statistical package to find the coefficients using least squares regression. Round your answers to 2 decimal places.) Coefficients Intercept X Variable Odessa, Inc., manufactures one model of computer desk. The following data are available regarding units shipped and total shipping costs: Total Shipping Cast 51,950 2,800 Month January February March April May June July Number of Units Shipped Be 45 75 80 60 55 40 4,200 4,000 3,50e 3,250 2,800 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 - 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 a linear equation by a + bx ) for estimating Odessa's shipping costs. Total Shipping cost + Number of Units Shipped
