Here y variable is the van operating costs and x variable is the miles driven. The above data is inputted in excel and then “regression” function is used which yields the following result:
Coefficients | |
Intercept | 2163.80 |
X Variable 1 | 0.19 |
(1): Thus the cost equation will be: y = $0.19x + $2,163.80
(2): The r-square is 0.4746 (4 decimal places) or 0.47 (2 decimal places). Broadway Floral's r square indicates that around 47.46% of variation in the dependent variable (i.e. costs) is explained by the independent variable (i.e. miles driven) in this case.
(3): Here x = 16,500 miles. Thus cost = 0.19*16,500 + 2163.80
= $5,298.80
No the company should not rely on this cost estimate too much because of the fact that R square value is low and hence the data are not too closely fitting the regression line. As the fit for the model is not very good we can say that the company should not rely too much on this cost estimate.
The summary output of regression function in excel is attached below for your reference:
(3):
all 3 requirments Question 8, E6-27A (book/static) IE Question Help a flat delivery fee Logh wants...
Save -Homework: Ch. 6 Assignment Score: 0 of 12 pts 8 of 16 (13 complete) Question 8, E6-27A (book/static) HW SC59.69%, 59.69 of 100 pts Question Help Melody Leigh, owner of Broadway Floral operates a local chain of floral shops Each shop has its own delivery van Instond of charging a flat delivery foo, Leigh wants to set the delivery fee based on the distance driven to deliver the flowers Leigh wants to separate the fixed and vonate portions of...
Please help me solve this.
XxE6-26A (book/static) Question Help Melody Leigh, owner of Broadway Floral, operates a local chain of floral shops. Each shop has its own delivery van. Instead of charging a flat delivery fee, Leigh wants to set the delivery fee based on the distance driven to deliver the flowers. Leigh wants to separate the fixed and variable portions of her van operating costs so that she has a better idea how delivery distance affects these costs. She...
THANK YOU! please answer, If you know any part of this please
help! anything helps!
Kristen Chen owner of Flower Paradise, operates a local chain
of floral shops. Each shop has its own delivery van. Instead of
charging a flat delivery fee, Chen wants to set the delivery fee
based on the distance driven to deliver the flowers. Chen wants to
separate the fixed and variable portions of her van operating costs
so that she has a better idea how...
Homework: Chapter 6 Homework Save Score: 0 of 2 pts 6 of 7 (6 complete) HW Score: 80%, 8 of 10 pts E6-27A (similar to) Question Help O Kim Chen, owner of Rose Red, operates a local chain of floral shops. Each shop has its own delivery van. Instead of charging a flat delivery fee, Chen wants to set the delivery fee based on the distance driven to deliver the flowers. Chen wants to separate the fixed and variable portions...
Karen Woo, owner of Flower Petal, operates a local chain of floral shops. Each shop has its own delivery van. Instead of charging a flat delivery fee, Woo wants to set the delivery fee based on the distance driven to deliver the flowers. Woo wants to separate the fixed and variable portions of her van operating costs so that she has a better idea how delivery distance affects these costs. She has the following data from the past seven months...
Kerri Rafferty, owner of Tulip Time, operates a local chain of
floral shops. Each shop has its own delivery van. Instead of
charging a flat delivery fee, Rafferty wants to set the delivery
fee based on the distance driven to deliver the flowers. Rafferty
wants to separate the fixed and variable portions of her van
operating costs so that she has a better idea how delivery distance
affects these costs. She has the following data from the past
seven months...
0 Regression analysis Regression Statistics Multiple R 0.86 R Square 0.75 Adjusted R Square 0.70 Standard Error 171.55 Observations 7 ANOVA of SS Significance F 0 .0120 Regression 1 M SF 435,336.22 29,429.90 435,336.22 147,149.49 14.79 Residual 6 582,485.71 Total Coefficients 709.81 0.29 Standard Error t 1,150.73 0.07 Stat 0.62 3.85 Lower P-value 95% 0.56 -2,248.24 0.010.09 Intercept X Variable 1 Upper 95% 3,667.85 0.48 Print Done E6-28A (similar to) Question Help Kim Meyer, owner of Tulip Time, operates a...
Kerri Tran, owner of Flower Hour, operates a local chain of floral shops. Each shop has its own delivery van. Instead of charging a flat delivery fee, Tran wants to set the delivery fee based on the distance driven to deliver the flowers. Tran wants to separate the fixed and variable portions of her van operating costs so that she has a better idea how delivery distance affects these costs. Flower Hour does a regression analysis on the next year's...
ABCDEFG1SUMMARY OUTPUT2Regression Statistics3Multiple R0.854R Square0.725Adjusted R Square0.666Standard Error207.237Observations78ANOVA9dfSSMSFSignificance F10Regression1545,878.49545,878.4912.710.016111Residual5214,721.5142,944.3012Total6760,600.0013CoefficientsStandard Errort StatP-valueLower 95%Upper 95%14Intercept947.201,217.790.780.47-2,183.234,077.6415X Variable 10.270.083.570.020.080.46 Dialog content ends
Kristen Battle, owner of Tulip Time, operates a local chain of floral shops. Each shop has its own delivery van. Instead of charging a flat delivery fee, Battle wants to set the delivery fee based on the distance driven to deliver the flowers. Battle wants to separate the fixed and variable portions of her van operating costs...
101-131, Management Accounting Ex. 6-27A Insert Insert blue yellow cells with formulas or cell references cells with text or numbers Fill in the table below with the data from the exercise in the textbook Month January February March April May June July Miles Driven Van Operating Costs 15,500 $5,390 17,400 $5,280 15,400 $4,960 16,300 $5,340 16,500 $5,450 15,200 $5,230 14,400 $4,680 Requirement 1 Use the directions on page 329 of the textbook to help you run the regression analysis. Possible...