i need the complete answer for this question pmease answer this question carefully with complete answers thanks.

Alice Battle, wer of Flower Potul, operates a local chain of oral shops. Each shop has its own delivery van. Instead of charging a fathery fee Battle wants to set the delivery fee based on the distance driven to deliver the foot wants to serve the feed and variable portions of her van operating costs so that she has a better idea how delivery distance afects theses Assume that lies Power Portal does a regression analysis on the next year's data using Microsoft Excel. The output generated by Excel is as follows m Click the len to view the regression analysis) Requirements 1. mine the fom's contusion (use the from the cel regression) 2. Determine the one the output from the Excel regression What does Flower Petals went? 3. Predivan operating cos w a volume of 1.500 Requirement 1. Determine the firm's cost gusto use the output from the Excel regression (Round your answers to the nearest cant) Requirement 2. Determine the square te (use the output from the Excel regression) The square is What does Flower Petals que indicate? The R-quare indicates that the con quation explains of the way in the data in the worst volumes within the same relevant range Requirement. Predict an operating costa volume of 18.500 km. Round your answer to the nearest cant) The van operating costs at 18.500 km Flower Power confident using this contegion to predict costs at other lis ession analysis Xsion analysis anal -outd am th 18,54 uatio Regression Statistics Multiple R 0.81 R Square 0.85 Adjusted R Square 0.58 Standard Error 202.91 Observations 7 se the ANOVA dr SS MS F Significance F ? 1 9.22 0.0289 n exp Regression Residual Total 379674.00 205868.85 585542.85 379674.00 41173.77 5 cost equation to 6 sata Coefficients Standard Error P.value t Stat 0.31 Intercept X Variable 1 478.30 0.30 1538.00 0.10 0.77 0.03 Lower 95% Upper 95% Lower 95.0% Upper 95.0% -3475.25 4431.85 3475.25 4431.85 0.05 0.55 0.05 0.55 3.04 Print Done boxes! De Battle, owner of Flower Petal, operates a local chain of floral shops. Each shop has its own deliv ants to separate the fixed and variable portions of her van operating costs so that she has a better id crosoft Excel. The output generated by Excel is as follows: Click the icon to view the regression analysis.) _equirements Determine the firm's cost equation (use the output from the Excel regression). . Determine the R-square (use the output from the Excel regression). What does Flower Petal's R-squam 2. Predict van operating costs at a volume of 18,500 km. Requirement 1. Determine the firm's cost equation (use the output from the Excel regression). (Round yo y=$_+$ Requirement 2. Determine the R-square (use the output from the Excel regression) The R-square is What does Flowe 0.81 The R-square in volumes within the 0.65 Requirement 3. uare indicate? cost equation explains of the variability in the data. In other words, it int range. erating costs at a volume of 18,500 km. (Round your answer to the nearest cor 300 km is $ 0.30 The van operatin 0.58 0.77 Enter your answer in each of the answer boxes. MacB esc io FI F2 00 000 F3 DDD Requirement 2. Determine the R-square fuse the output from the Excel regression). The R-square is What does Flower Petal's R-square indicate? The R-square indicates that the cost equation explains volumes within the same relevant range, Requirement 3. Predict van operating costs at a volum of the variability in the data in other words, it Flower Petal 81% 1. (Round your answer to the nearest cent.) The van operating costs at 18,500 km is 65% 77% 58% 30% Enter your answer in each of the answer boxes ression). (Round your answers to the nearest cent.) data. In other words, it Flower Petal feel confident us ur answer to the nearest should be used with caution. fits the data quite well. does not fit the data at all. vor Petal's R-square indicate? gression). (Round your answers to the nearest cent.) e data. In other words, it Flower Petal feel confident using this cost equation to predict total costs at other ur answer to the nearest cent.) may or may not should will not Alice Battle, wer of Flower Potul, operates a local chain of oral shops. Each shop has its own delivery van. Instead of charging a fathery fee Battle wants to set the delivery fee based on the distance driven to deliver the foot wants to serve the feed and variable portions of her van operating costs so that she has a better idea how delivery distance afects theses Assume that lies Power Portal does a regression analysis on the next year's data using Microsoft Excel. The output generated by Excel is as follows m Click the len to view the regression analysis) Requirements 1. mine the fom's contusion (use the from the cel regression) 2. Determine the one the output from the Excel regression What does Flower Petals went? 3. Predivan operating cos w a volume of 1.500 Requirement 1. Determine the firm's cost gusto use the output from the Excel regression (Round your answers to the nearest cant) Requirement 2. Determine the square te (use the output from the Excel regression) The square is What does Flower Petals que indicate? The R-quare indicates that the con quation explains of the way in the data in the worst volumes within the same relevant range Requirement. Predict an operating costa volume of 18.500 km. Round your answer to the nearest cant) The van operating costs at 18.500 km Flower Power confident using this contegion to predict costs at other lis ession analysis Xsion analysis anal -outd am th 18,54 uatio Regression Statistics Multiple R 0.81 R Square 0.85 Adjusted R Square 0.58 Standard Error 202.91 Observations 7 se the ANOVA dr SS MS F Significance F ? 1 9.22 0.0289 n exp Regression Residual Total 379674.00 205868.85 585542.85 379674.00 41173.77 5 cost equation to 6 sata Coefficients Standard Error P.value t Stat 0.31 Intercept X Variable 1 478.30 0.30 1538.00 0.10 0.77 0.03 Lower 95% Upper 95% Lower 95.0% Upper 95.0% -3475.25 4431.85 3475.25 4431.85 0.05 0.55 0.05 0.55 3.04 Print Done boxes! De Battle, owner of Flower Petal, operates a local chain of floral shops. Each shop has its own deliv ants to separate the fixed and variable portions of her van operating costs so that she has a better id crosoft Excel. The output generated by Excel is as follows: Click the icon to view the regression analysis.) _equirements Determine the firm's cost equation (use the output from the Excel regression). . Determine the R-square (use the output from the Excel regression). What does Flower Petal's R-squam 2. Predict van operating costs at a volume of 18,500 km. Requirement 1. Determine the firm's cost equation (use the output from the Excel regression). (Round yo y=$_+$ Requirement 2. Determine the R-square (use the output from the Excel regression) The R-square is What does Flowe 0.81 The R-square in volumes within the 0.65 Requirement 3. uare indicate? cost equation explains of the variability in the data. In other words, it int range. erating costs at a volume of 18,500 km. (Round your answer to the nearest cor 300 km is $ 0.30 The van operatin 0.58 0.77 Enter your answer in each of the answer boxes. MacB esc io FI F2 00 000 F3 DDD Requirement 2. Determine the R-square fuse the output from the Excel regression). The R-square is What does Flower Petal's R-square indicate? The R-square indicates that the cost equation explains volumes within the same relevant range, Requirement 3. Predict van operating costs at a volum of the variability in the data in other words, it Flower Petal 81% 1. (Round your answer to the nearest cent.) The van operating costs at 18,500 km is 65% 77% 58% 30% Enter your answer in each of the answer boxes ression). (Round your answers to the nearest cent.) data. In other words, it Flower Petal feel confident us ur answer to the nearest should be used with caution. fits the data quite well. does not fit the data at all. vor Petal's R-square indicate? gression). (Round your answers to the nearest cent.) e data. In other words, it Flower Petal feel confident using this cost equation to predict total costs at other ur answer to the nearest cent.) may or may not should will not