Question: help please! Regression analysis distance driven so deliver the flowers. Jungemann warts to separale the fixed and veriable portions of her van operating costs so


Regression analysis distance driven so deliver the flowers. Jungemann warts to separale the fixed and veriable portions of her van operating costs so that she has a beffer idea how delivery distance alfects these costs. Rose Ready does a regression analysis on the next year's data using Excat. The oulput penerated by Expet is as follows: Click the laon to verw the regression analysis.) Rosd the toouiremerts Requirement 1. Determine the firms cost equation (use the oupur fom the Exce regession). (Enter amounts to two decimal places) y=x+ Requirements 1. Determine the firm's cost equation (use the output from the Excel regression). 2. Determine the R-squared (use the output from the Excel regression). What does Rose Ready's R-squared indicate? 3. Predict van operating costs at a volume of 16,500 miles assuming the company would use the cost equation from the Excel regression regardless of its R-squared. Should the company rely on this cost estimate? Why or why not
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
