Question

Better Blooms is a florist shop which takes orders by internet and phone, prepares the desired floral arrangements, and delivers within a 25-mile radius of the shop. Since the profit margin on the business is small for each arrangement and the competition from other florists in the area is high, the owner is concerned about setting the appropriate costs for each delivery to be profitable while still being competitive. To investigate, the owner has gathered information on a random sample of 50 recent orders and has asked you to analyze the data using statistical methods and to report to her your findings. Factors thought to be related to the cost of delivering a floral arrangement are thought to be: (1) Preparation Time – the time in minutes between when the customer has placed an order and when it is ready for delivery; more expensive arrangements take longer to prepare, (2) Delivery Time – the travel time in minutes from the shop to the recipient of the arrangement, and (3) Mileage – the distance in miles from the shop to the customer (mileage and delivery time are sometimes inversely proportional when the delivery truck can use an interstate instead of traveling through heavy downtown traffic, for instance).

1. Develop a multiple linear regression equation that describes the relationship between the cost of delivery and the other variables. Do these three variables explain a reasonable amount of the variation in the dependent variable? Estimate the delivery cost for an arrangement that takes 20 minutes for preparation, takes 30 minutes to deliver, and must cover a distance of 12 miles.
2. Test to determine that at least one regression coefficient differs from zero. Also test to see whether any of the variables can be dropped, rerun the regression equation until only significant variables are included.
3. Write management report interpreting the final regression equation, show your analysis in charts, tables, graphs so it is easy for the owner to see the analysis and conclusions, and back up your charts with detailed analysis using formulas and explanations of your statistical analysis steps. The owner wants to know your report is credible, but is not a statistician, so make your explanations clear.

Report length: 5-10 pages

Use the Dataset: BUS 277 Better Blooms Case Study Data Set

Cost   Prep   Delivery   Distance
22.60   20   51   20
23.37   11   33   12
31.49   16   47   19
19.31   22   18   8
28.35   18   88   17
22.63   19   20   11
22.63   29   39   11
11.53   10   23   10
21.16   13   20   8
11.53   20   32   10
28.17   15   35   16
20.42   18   23   9
21.53   19   21   10
27.55   17   37   16
23.37   19   25   12
17.10   15   15   6
27.06   13   34   15
15.99   18   13   4
17.96   12   12   4
25.22   16   41   14
24.29   13   28   13
22.76   24   26   10
28.17   19   54   16
19.68   17   18   8
25.15   16   50   13
20.36   19   19   7
21.16   13   19   8
15.22   10   45   14
18.76   12   12   5
18.76   18   16   5
24.29   17   35   13
19.56   12   12   6
22.63   18   30   11
21.16   15   13   8
21.16   11   20   8
19.68   15   19   8
18.76   17   14   7
17.96   15   11   4
23.37   10   25   12
25.22   16   32   14
27.06   18   44   16
21.96   19   28   9
22.63   18   31   11
19.68   17   19   8
22.76   18   28   10
21.96   13   18   9
26.95   10   32   14
26.14   18   44   15
24.29   20   34   13
24.35   16   33   12

Answer 1