Selecting a Basis for Predicting Shipping Expenses $($Requires Computer Spreadsheet$*)$

has the closest relationship with shipping expenses. The following information is available:

Required

a$.$ With the aid of a spreadsheet program, 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.

Based on the coefficient of determination,

has the closest relationship with shipping expenses.

b$.$ Using the independent variable that appears to have the closest relationship to shipping expenses, develop a cost$-$estimating equation for total monthly shipping expenses.

Round answers to two decimal places.

c$.$ Use the equation developed in requirement $($b$)$ to predict total shipping expenses in a month when $14,000$ units, weighing $9,380$ lbs$.,$ with a total sales value of $$420,000$ are shipped.

Round answer to the nearest whole number.

$$0$