Please explain each of these answers step-by-step.
Thank you!
Cambridge Soundworks sell portable speakers systems and bluetooth headphones. In an effort to improve the planning and control of shipping expenses, management is trying to determine which of three variables-units shipp weight shipped, or sales value of units shipped-has the closest relationship with shipping exoenses. The following information is available: Weight Sales Value of Shipping Month Units Shipped shipped lbs) Units Shipped Expenses 7.900 8.78 133CC0D 58.00 4202 10,000 12,2 13,000 22330 1296 DOC JOOD . La. eyler October 72.963 HUU E.CO 320 COD 35.00 Required a. With the aid ol a spreadsheel programi, determine whether units shipped, weight shipped, or Sales value of units shipped has the closest relationship with shipping expenses. Complete the r-squared values between each possible independent variable and shipping expenses: Round answers to two decimal places. Veight chips Based on the coefficient of determination, units shipped has the closest relationship with shipping expenses. b. Using the independent variable that appears to have the closest relationship to shipping exoenses, develop a cost-estimating equation for total monthly shipping expenses. Round answers to two decimal places. Shipre expenses - $ 0.19381 c. Use the equation developed in requirement (b) to predict total shipping expenses in a month when 14,000 units, weighing 9380 lbs., with a total sales value of $420,000 are shipped. $ 50,154 Cambridge Soundworks sell portable speakers systems and bluetooth headphones. In an effort to improve the planning and control of shipping expenses, management is trying to determine which of three variables-units shipp weight shipped, or sales value of units shipped-has the closest relationship with shipping exoenses. The following information is available: Weight Sales Value of Shipping Month Units Shipped shipped lbs) Units Shipped Expenses 7.900 8.78 133CC0D 58.00 4202 10,000 12,2 13,000 22330 1296 DOC JOOD . La. eyler October 72.963 HUU E.CO 320 COD 35.00 Required a. With the aid ol a spreadsheel programi, determine whether units shipped, weight shipped, or Sales value of units shipped has the closest relationship with shipping expenses. Complete the r-squared values between each possible independent variable and shipping expenses: Round answers to two decimal places. Veight chips Based on the coefficient of determination, units shipped has the closest relationship with shipping expenses. b. Using the independent variable that appears to have the closest relationship to shipping exoenses, develop a cost-estimating equation for total monthly shipping expenses. Round answers to two decimal places. Shipre expenses - $ 0.19381 c. Use the equation developed in requirement (b) to predict total shipping expenses in a month when 14,000 units, weighing 9380 lbs., with a total sales value of $420,000 are shipped. $ 50,154
