determine R-square

Kelly Woo, 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, 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 (Click the icon to view the data.) Read the Requirement 1. Determine the company's cost equation (use the output from the Excel regression) (Round the amounts to two decimal places.) 2 of 5 (1 complete) cal chain of floral shops. Each shop has its own delivery van. Instead of chargi deliver the flowers. Woo wants to separate the fixed and variable portions of her se costs. She has the following data from the past seven months: 1 Data Table Miles Driven 15,500 17,500 14,400 16,400 16,900 15,300 13,500 Van Operating Costs $5,400 $5,350 $4,980 $5,280 $5,580 $5,010 $4,590 Month January February. March April May. June July Print Done 13 Kelly Woo, 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, 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 (Click the icon to view the data.) Read the Requirement 1. Determine the company's cost equation (use the output from the Excel regression) (Round the amounts to two decimal places.) 2 of 5 (1 complete) cal chain of floral shops. Each shop has its own delivery van. Instead of chargi deliver the flowers. Woo wants to separate the fixed and variable portions of her se costs. She has the following data from the past seven months: 1 Data Table Miles Driven 15,500 17,500 14,400 16,400 16,900 15,300 13,500 Van Operating Costs $5,400 $5,350 $4,980 $5,280 $5,580 $5,010 $4,590 Month January February. March April May. June July Print Done 13