an owner of a flower shop operates a local chain of floral shops. Each shop has its own delivery van. Instead of charging a flight 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 cost so that she has a better idea on how to delivery distance affects these costs. Flowers for you does a regression analysis on the next years data using excel. Requirement one. Determine the firms cost equation

- X Regression analysis C D E F G N 2 A B 1 SUMMARY OUTPUT Regression Statistics 3 Multiple R 4 R Square 5 Adjusted R Square 6 Standard Error 0.83 0.69 0.63 127.8 7 Observations 7 8 ANOVA 9 df SS MS F Significance F 1 11.36 0.0199 10 Regression 11 Residual 185,536.45 81,663.55 267,200.00 185,536.45 16,332.71 5 12 Total 6 13 Coefficients Standard Error Stat P-value Lower 95% Upper 95% Homework: HW 4 - Chapter 6 Question 7, E6-30A (similar to HW Score 60%. 8of 10 points O Points of 1 Save Kalie Tran, owner of Flowers 4 You are loc chain of floral shops. Each who has its own delivery van Indoney Tran wants to set the deler for based on the store for to wants to separate the food and variable portions of her van opening center de tow delvery distance in these comes ou des gewys on the next years ago. The duke benerated by Excel is as follows: ixte con to view igressions) Rond the emert Requirement 1, Derin 's coat equations from the cele trebuie y - X Regression analysis C D E F G N 2 A B 1 SUMMARY OUTPUT Regression Statistics 3 Multiple R 4 R Square 5 Adjusted R Square 6 Standard Error 0.83 0.69 0.63 127.8 7 Observations 7 8 ANOVA 9 df SS MS F Significance F 1 11.36 0.0199 10 Regression 11 Residual 185,536.45 81,663.55 267,200.00 185,536.45 16,332.71 5 12 Total 6 13 Coefficients Standard Error Stat P-value Lower 95% Upper 95% Homework: HW 4 - Chapter 6 Question 7, E6-30A (similar to HW Score 60%. 8of 10 points O Points of 1 Save Kalie Tran, owner of Flowers 4 You are loc chain of floral shops. Each who has its own delivery van Indoney Tran wants to set the deler for based on the store for to wants to separate the food and variable portions of her van opening center de tow delvery distance in these comes ou des gewys on the next years ago. The duke benerated by Excel is as follows: ixte con to view igressions) Rond the emert Requirement 1, Derin 's coat equations from the cele trebuie y