Westonci.ca makes finding answers easy, with a community of experts ready to provide you with the information you seek. Discover a wealth of knowledge from professionals across various disciplines on our user-friendly Q&A platform. Discover in-depth answers to your questions from a wide network of professionals on our user-friendly Q&A platform.

​, 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: