Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Method of Least Squares Using Computer Spreadsheet Program Susan Lewis, owner of a florist shop, is interested in predicting the cost of delivering floral arrangements.

image text in transcribed

Method of Least Squares Using Computer Spreadsheet Program Susan Lewis, owner of a florist shop, is interested in predicting the cost of delivering floral arrangements. She collected monthly data on the number of deliveries and the total monthly delivery cost (depreciation on the van, wages of the driver, and fuel) for the past year. Required: 1. Using a computer spreadsheet program such as Excel, run a regression on these data. Enter the amount of the intercept (rounded to the nearest whole dollar) and the amount of the X Variable 1 (rounded to the nearest cent). Intercept: $ ______ X Variable 1: $ ________ 2. Using the above results, enter the cost formula for overhead cost. Delivery cost. = $ ____ + ($ ____ times ) 3. Conceptual Connection: What is R^2 based on your results? State the answer as a percent to one decimal place. ______ % Do you think that the number of deliveries is a good predictor of delivery cost? 4. Using the cost formula in Requirement 2, what would predicted cost be for a month wit 300 deliveries? $ _____

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Software Quality Assurance A Guide For Developers And Auditors

Authors: Howard T. Garst Smith

1st Edition

1574910493, 978-1574910490

More Books

Students also viewed these Accounting questions