Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started