Kale Chen, owner of Flower Decoperes a local chain offertshops. Each shop has its own delivery van tead of charging alat delivery fee, Chen wants to see a very fee based on the distance driver to dever the Powers Chen wants to separate the free and a portion of her an operating so that she has a better idea how delivery dancefects these costs. She has the following som he past seven months Click the loon to view the data) Read the r es O Data Table Requirement 1. O n the company on the output from the Exegreso de oro decimos) Miles Driven van dating costs Requirement 2. Determine r le the output from the Excel regression 15.70 The Reus What does Power Divers are indicate? The R-quare indicates the cost equation explains of the variability in the data in other words, Flower Direct volumes within the same relevant range Requirement 3. Predict an operating costs at a volume of 14,500 miles assuming the company would use the cost equation from the Excel regression The operating costs at a volume of 14.500 miles Show the company rely on is cost estimate? Why or why not? The company Ele Chen owner of Flower Direct, operates a local chain of for shops. Each shop has its own delivery van. Instead of charging a fat delivery fee. Chen wants to set the delivery fee based on the distance driven to deliver the flowers. Chen wants to separate the food and variable portions of her van operating costs so that she has a better idea how delivery distance a t these costs. She has the following data from the past seven months Ch o on to view Pa data) Read the requirements Requirement 1. Determine the company's cost in use output from the Excel regression (Round the amounts to two decimal places) Requirement 2. Determine the square use the output from the Excel regression The R-quares What does Flower Direct's R-que indicate? foal confident using this contequation to predict total costs at other The R-square indicates that he couleuation explains of the variety in the data. In other words, it Flower Direct wolumes within esame relevant range. Requirement. Predict van pering costs at a volume of 14,000 miles assuming company would use the cost equation from the Excel regression regardess of Round your answer to the nearest cont.) R-square. Should the company rely on this cost estimate? Why or why not? The operating costs at a volume of 14 500 miles is $ Should the company rely on this cost estimate? Why or why not? Since the r e is the company A Data Table Month January ........ February..... March........ April ....... May ... Miles Driven 15,900 17,300 14,600 16,300 17,200 15,200 Van Operating Costs $5,430 $5,740 $4,940 $5,270 $5,820 $5,400 $4,990 su June.... July...... 14,300 Print Done Kale Chen, owner of Flower Decoperes a local chain offertshops. Each shop has its own delivery van tead of charging alat delivery fee, Chen wants to see a very fee based on the distance driver to dever the Powers Chen wants to separate the free and a portion of her an operating so that she has a better idea how delivery dancefects these costs. She has the following som he past seven months Click the loon to view the data) Read the r es O Data Table Requirement 1. O n the company on the output from the Exegreso de oro decimos) Miles Driven van dating costs Requirement 2. Determine r le the output from the Excel regression 15.70 The Reus What does Power Divers are indicate? The R-quare indicates the cost equation explains of the variability in the data in other words, Flower Direct volumes within the same relevant range Requirement 3. Predict an operating costs at a volume of 14,500 miles assuming the company would use the cost equation from the Excel regression The operating costs at a volume of 14.500 miles Show the company rely on is cost estimate? Why or why not? The company Ele Chen owner of Flower Direct, operates a local chain of for shops. Each shop has its own delivery van. Instead of charging a fat delivery fee. Chen wants to set the delivery fee based on the distance driven to deliver the flowers. Chen wants to separate the food and variable portions of her van operating costs so that she has a better idea how delivery distance a t these costs. She has the following data from the past seven months Ch o on to view Pa data) Read the requirements Requirement 1. Determine the company's cost in use output from the Excel regression (Round the amounts to two decimal places) Requirement 2. Determine the square use the output from the Excel regression The R-quares What does Flower Direct's R-que indicate? foal confident using this contequation to predict total costs at other The R-square indicates that he couleuation explains of the variety in the data. In other words, it Flower Direct wolumes within esame relevant range. Requirement. Predict van pering costs at a volume of 14,000 miles assuming company would use the cost equation from the Excel regression regardess of Round your answer to the nearest cont.) R-square. Should the company rely on this cost estimate? Why or why not? The operating costs at a volume of 14 500 miles is $ Should the company rely on this cost estimate? Why or why not? Since the r e is the company A Data Table Month January ........ February..... March........ April ....... May ... Miles Driven 15,900 17,300 14,600 16,300 17,200 15,200 Van Operating Costs $5,430 $5,740 $4,940 $5,270 $5,820 $5,400 $4,990 su June.... July...... 14,300 Print Done