A | B | C | D | E | F | G | |
1 | SUMMARY OUTPUT | ||||||
2 | Regression Statistics | ||||||
3 | Multiple R | 0.85 | |||||
4 | R Square | 0.72 | |||||
5 | Adjusted R Square | 0.66 | |||||
6 | Standard Error | 207.23 | |||||
7 | Observations | 7 | |||||
8 | ANOVA | ||||||
9 | df | SS | MS | F | Significance F | ||
10 | Regression | 1 | 545,878.49 | 545,878.49 | 12.71 | 0.0161 | |
11 | Residual | 5 | 214,721.51 | 42,944.30 | |||
12 | Total | 6 | 760,600.00 | ||||
13 | Coefficients | Standard Error | t Stat | P-value | Lower 95% | Upper 95% | |
14 | Intercept | 947.20 | 1,217.79 | 0.78 | 0.47 | -2,183.23 | 4,077.64 |
15 | X Variable 1 | 0.27 | 0.08 | 3.57 | 0.02 | 0.08 | 0.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 so that she has a better idea how delivery distance affects these costs. Tulip Time does a regression analysis on the next year's data using Excel. The output generated by Excel is as follows:
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 Tulip Time's R-squared indicate?
3. Predict van operating costs at a volume of 16,000 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?
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 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...
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...
all 3 requirments Question 8, E6-27A (book/static) IE Question Help a flat delivery fee Logh wants van operating costs so that she Melody Leigh, owner of Broadway Floral operates a local chain of floral Shops. Each shop has its own delivery van. Instead of ch to set the delivery fee based on the distance driven to deliver the flowers Leigh wants to separate the fixed and variable portions has a better idea how delivery distance affects these costs. She has...
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...
to deliver the flowers Buite angol. The pred Kali Batte, owner of Tulip Time, operates a local chain of floralshops. Each shop has its own delivery van. Instead of charging a fal ellery for Bare wait to set the delivery fee based on the danced wants to separate the food and variable portions of her an operating costs so that she has a better idea how delivery distance affects theseos Tulip Time does regression analysis on the rest year's d...
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...
Kim Jungemann owner of Tulip Time, operates a local chain of floral shops. Each shop has its own delivery van. Instead of charging a flat delivery tes Jungemann wants to set the delivery fee based on the distance driven to deliver the flowers Jungemann wants to separate the foxed 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...
Kim Jungemann, owner of Tulip Time, operates a local chain of floral shops Each shop has its own delivery van instead of charging a flat delivery foe, Jungemann wants to set the delivery fee based on the distance driven to deliver the flowers. Jungemann wants to separate the foxed 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...
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...