Discover how IDNLearn.com can help you find the answers you need quickly and easily. Discover thorough and trustworthy answers from our community of knowledgeable professionals, tailored to meet your specific needs.

​, owner of ​, operates a local chain of floral shops. each shop has its own delivery van. instead of charging a flat delivery​ fee, wants to set the delivery fee based on the distance driven to deliver the flowers. wants to separate the fixed and variable portions of van operating costs so that has a better idea how delivery distance affects these costs. does a regression analysis on the next​ year's data using excel. the output generated by excel is as​ follows: