Question: Kim Wilson, controller for Max Enterprises, has decided to estimate the fixed and variable components associated with the company's shipping activity. She has collected
Kim Wilson, controller for Max Enterprises, has decided to estimate the fixed and variable components associated with the company's shipping activity. She has collected the following data for the past six months: Packages Shipped 10 20 15 12 18 25 Total Shipping Costs $ 800 1,100 900 900 1,050 1,250 2. The output of a spreadsheet regression routine is as follows: Regression Output: Constant Std Err of Y Est R Squared No. of Observations Degrees of Freedom X Coefficient(s) 29.4052863436125 Std Err of Coef 2.61723229918858 509.911894273125 32.1965672507378. 0.96928536465981 4 Required 1. Estimate the fixed and variable components for the shipping costs using the high-low method. Using the cost formula, predict the total cost of shipping if 14 packages are shipped. 2. Estimate the fixed and variable components using the method of least squares. Using the cost formula, predict the total cost of shipping if 14 packages are shipped. 3. For the method of least squares, explain what the coefficient of determination tells us. Compute the coefficient of correlation.
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
