Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

A student-run non-profit goods delivery company called InstaGoods, based in Tempe, AZ, provides goods delivery services to local communities with severe disabilities. The delivery service

A student-run non-profit goods delivery company called InstaGoods, based in Tempe, AZ, provides goods delivery services to local communities with severe disabilities. The delivery service operates from 4.00 pm to midnight every day of the week. After an order for delivery is phoned in, one of the students in immediate proximity leaves for a local retail store to buy the requested goods and then drives to the customer's location to deliver the goods. Students only collect tips for their service and receive karma points for their graduate school applications from non-profit organizations.

A sample data (InstaGoods.xlsx) on goods delivery activity was collected for a month to understand if a change to the business operation strategy is necessary. The variables in the sample data are defined as follows:

  • Day: Day of the week (Day 1=Monday, ....., Day 7=Sunday)
  • Shopping Time: Time required (minutes) to shop for the goods to be delivered
  • Checkout Time: Time (minutes) from completing checkout at the goods store
  • Travel Time: Time (minutes) it took the car to reach the delivery location
  • Distance: Distance (miles) from the goods store to the delivery location.

The time to deliver goods at customers' location (Delivery Time) is computed by combining Shopping Time, Checkout Time, and Travel Time.

Use the following data to answer the questions....

Day Shopping Time Checkout Time Travel time Distance
Day 1 15.01 0.8 6.44 2.5
Day 1 14.71 0.2 10.88 5
Day 1 15.6 1.02 4.91 2.4
Day 1 13.95 1.46 3.12 1.7
Day 1 13.5 5.47 7.98 4.1
Day 1 15.46 6.67 6.43 3.2
Day 1 14.08 0.25 8.54 4.3
Day 1 13.98 1.01 7.19 3.3
Day 1 14.61 9.74 5.85 2
Day 1 14.06 2.12 6.71 2.9
Day 1 17.43 11.38 4.07 1.2
Day 1 13.76 4.56 9.39 5
Day 1 15.48 0.58 4.72 1.9
Day 1 14.25 0.83 4.12 2.2
Day 1 13.92 1.07 5.88 3.7
Day 1 16.48 1.31 6.9 2.9
Day 1 15.99 0.44 7 3.6
Day 1 13.81 0.63 8.88 4.6
Day 1 15.07 0.17 7.09 3.5
Day 1 15.78 2.18 8.29 3.7
Day 1 13.87 0.06 8.52 3.6
Day 1 15.28 3.77 5.86 2.7
Day 1 14.26 1.97 5.8 2.6
Day 1 14.42 0.24 11.85 5.8
Day 1 14.71 1.21 8.48 3.9
Day 1 12.99 1.92 10.74 6.1
Day 1 15.19 0.19 7.03 3.4
Day 1 15.76 4.19 8.83 4.6
Day 1 13.22 0.3 6.61 3.3
Day 1 15.58 0.94 5.83 2.4
Day 1 14.69 1.01 7.94 3.9
Day 1 13.87 0.08 3.92 2.3
Day 2 14.45 0.04 8.98 4.4
Day 2 14.35 0.85 8.25 3.4
Day 2 15.18 1.04 8.45 4
Day 2 16.45 0.16 12.25 5.5
Day 2 14.77 6.8 7.93 3.9
Day 2 14.32 1.61 6.93 3.8
Day 2 16.06 6.78 6.59 2.8
Day 2 13.58 1 9.9 5.3
Day 2 12.93 0.66 10.31 4.8
Day 2 13.34 0.58 7.81 3.9
Day 2 12.81 1.33 10.75 5.4
Day 2 13.25 8.7 8.68 4.1
Day 2 16.18 13 4.86 2.1
Day 2 16.49 5.07 9.33 5
Day 2 14.33 2.43 8.68 3.6
Day 2 16.02 0.88 8.97 4
Day 2 14.99 1.37 8.9 4.7
Day 2 16.49 0.99 6.04 3.2
Day 2 15.27 0.49 6.05 3
Day 2 13.75 0.22 9.56 4.7
Day 2 14.13 3.51 8.78 4.6
Day 2 15.96 0.17 5.6 3
Day 2 12.96 0.44 8.3 4.2
Day 2 14.4 1.14 8.65 4.6
Day 2 17.02 2.27 6.27 3.3
Day 2 15.98 0.02 7.04 3.2
Day 2 14.93 1.04 8.53 3.7
Day 2 13.85 0.39 10.49 5.3
Day 2 15.51 0.16 8.83 3.7
Day 2 15.71 0.21 9.41 4.9
Day 2 15.28 0.03 5.96 2.7
Day 2 13.5 0.16 6.87 3
Day 3 14.74 0.51 7.54 3.6
Day 3 15.35 1.63 10.93 5.1
Day 3 16.25 0.9 8.2 3.2
Day 3 15.34 0.7 4.86 2.5
Day 3 15.59 0.88 10.49 5.8
Day 3 13.15 6.96 8.14 4.1
Day 3 16 0.32 5.67 3.2
Day 3 16.79 0.94 11.14 6.1
Day 3 15.46 0.54 8.33 4.2
Day 3 14.97 1.48 6.46 3.2
Day 3 14.44 2.38 8.85 4.6
Day 3 15.46 0.66 8.76 4.6
Day 3 15.3 2.55 7.76 3.6
Day 3 14.13 4.83 7.79 3.9
Day 3 14.13 0.07 9.02 4.5
Day 3 14.42 6.14 9.41 4.4
Day 3 14.52 1.31 8.88 4
Day 3 16 0.55 7.06 3.1
Day 3 15.78 0.41 6.65 3.5
Day 3 14.65 3.31 3.93 2.5
Day 3 15.27 1.28 7.17 4
Day 3 12.49 0.14 4.27 2.3
Day 3 13.69 0.47 10.36 5.1
Day 3 14.76 2 9.98 4.2
Day 3 14.65 0.4 8.98 4.4
Day 3 14.19 0.72 8.87 4.5
Day 3 16.05 0.71 7.9 4.4
Day 3 13.6 1.91 6.32 3.3
Day 3 15.58 0.13 7.06 3.8
Day 3 15.33 0.2 10.19 4.9
Day 3 14.42 0.65 8.51 4.3
Day 3 14.24 1.19 9.4 4.5
Day 4 15.69 0.21 9.86 4.9
Day 4 16.53 1.18 8.14 4.8
Day 4 14.78 0.28 7.73 4.1
Day 4 15.7 1.77 6.54 3.3
Day 4 16.54 2.16 5.71 2.8
Day 4 14.18 0.82 7.91 4.5
Day 4 16.26 0.66 9.24 4.3
Day 4 15.51 4.83 8.45 4.2
Day 4 13.81 0.1 7.12 4
Day 4 15.68 0.04 8.28 4.7
Day 4 16.7 0.85 9.91 5.1
Day 4 14.05 0.68 5.3 2.5
Day 4 15.74 1.26 6.08 3.1
Day 4 15.64 0.2 4.85 2.5
Day 4 14.37 0.58 5.85 2.4
Day 4 15.6 3.5 6.96 3.6
Day 4 13.68 0.7 7.91 4
Day 4 14.34 1.43 8.02 3.7
Day 4 15.87 0.5 4.68 3.1
Day 4 15.54 1.73 6.88 2.9
Day 4 15.54 0.32 6.05 3.3
Day 4 15.01 0.6 9.36 5.6
Day 4 14.85 0.07 8.47 4.6
Day 4 13.49 1.29 8.22 4.7
Day 4 14.15 2.18 5.91 2.7
Day 4 15.72 0.19 8.52 3.8
Day 4 14.8 0.63 9.02 4.9
Day 4 15.46 1.49 8.06 4.1
Day 4 14.13 1.19 7.53 4.1
Day 4 14.68 0.44 7.35 2.7
Day 4 16.48 0.38 10.57 5.2
Day 4 15.58 0.31 12.55 6.4
Day 5 14.86 3.08 6.02 2.5
Day 5 15.07 0.69 6.31 3.3
Day 5 14.88 11.11 7.59 4
Day 5 13.14 4.02 10.71 5.2
Day 5 14.06 1.33 9 4.7
Day 5 14.84 13.81 5.47 3.3
Day 5 16.05 2.44 7.37 3.9
Day 5 15.42 1.7 8.33 3.8
Day 5 13.54 4.01 3.52 1.9
Day 5 15.53 2.2 8.25 4.1
Day 5 15.41 9.91 8.99 4.9
Day 5 12.63 3.42 4.27 2.1
Day 5 15.73 1.02 11.22 5.9
Day 5 15.01 1.83 10.56 5.8
Day 5 15.94 2.27 12.58 6.4
Day 5 16.34 2.08 7.98 3.8
Day 5 14.8 3.04 7.87 4.4
Day 5 15.09 2.12 5.97 2.6
Day 5 13.67 0.63 5.09 2.7
Day 5 15.08 8.31 9.63 5
Day 5 15.19 2.69 9.01 4.9
Day 5 14.84 0.37 7.11 3.8
Day 5 15.45 0.52 8.28 4.2
Day 5 16.49 3.63 8.47 4.2
Day 5 15.46 1.61 10.42 5
Day 5 16.32 0.29 10.86 5.3
Day 5 16.27 2.77 7.28 3.5
Day 5 15.24 1.75 6.63 3
Day 5 14.94 0.96 6.81 3.4
Day 5 15.73 3.45 7.69 3.8
Day 5 15.32 4.12 6.31 2.9
Day 5 15.14 1.51 9.83 4.8
Day 5 13.52 8.82 9.56 4.9
Day 5 14.86 4.99 10.84 5.5
Day 5 15.21 7.22 7.88 4
Day 5 14.06 0.27 7.87 3.5
Day 5 14.12 3.04 6.28 2.9
Day 5 14.29 8.07 6.7 3.8
Day 5 14.01 7.64 6.47 3.4
Day 5 13.3 3.57 7.43 3.6
Day 6 15.6 11.35 12.47 6.4
Day 6 13.97 4.17 5.83 3
Day 6 16.48 1.49 5.83 2.6
Day 6 13.73 0.48 7.33 3.5
Day 6 14.14 5.94 6.56 3.1
Day 6 15.16 11.98 7.58 3.5
Day 6 16.27 1.27 5.5 2.9
Day 6 14.82 8.81 6.02 3
Day 6 14.89 5.65 8.82 4.6
Day 6 14.59 1.1 4.72 2.9
Day 6 14.37 0.36 10.65 5.1
Day 6 13.45 2.49 8.89 4.3
Day 6 15.64 4.68 6.47 2.6
Day 6 15.84 0.74 9.34 4.3
Day 6 15.77 2.14 8.58 4.9
Day 6 14.24 1.21 7.83 3.7
Day 6 14.98 4.46 7.08 3.8
Day 6 13.96 2.72 8.16 4.3
Day 6 15.99 8.32 8.24 3.9
Day 6 12.64 8.2 8.83 5.1
Day 6 16.17 4.32 6.75 3.6
Day 6 15.36 0.28 5.57 2.8
Day 6 16.03 3.11 6.55 3.9
Day 6 16.17 1.75 7.54 4.1
Day 6 16.69 21.66 7.65 4
Day 6 15.48 1.54 9.59 5.2
Day 6 12.56 2.46 7.83 4.4
Day 6 16.81 13.32 7.17 3.4
Day 6 15.64 15.15 9.43 5.2
Day 6 16.82 0.72 12.43 5.4
Day 6 14.56 0.13 6.99 3.4
Day 6 14.1 4.16 7.74 3.4
Day 6 15.69 1.5 8.62 4.3
Day 6 14.13 0.14 11.21 5.5
Day 6 16.71 2.08 6.09 2.7
Day 6 11.65 2.67 8.94 4.8
Day 6 16.06 4.41 11.29 5.3
Day 6 15.91 3.94 8.81 4.2
Day 6 14.62 11.19 10.67 5.9
Day 6 14.2 5.28 7.79 4
Day 7 15.6 0.78 8.38 3.7
Day 7 14.64 0.44 8.72 3.9
Day 7 13.58 0.11 9.62 4.6
Day 7 16.83 0.23 7.7 3.7
Day 7 15.65 0.84 5.62 2.4
Day 7 16.24 10.5 6.31 3.5
Day 7 14.85 0.18 9.39 4.6
Day 7 15.44 10.14 6.37 2.8
Day 7 16.59 3.36 5.67 3.1
Day 7 16.16 0.92 9.69 4.9
Day 7 14.55 2.36 4.88 2.5
Day 7 13.27 1.86 8.14 3.7
Day 7 14.51 6.05 9.18 4.4
Day 7 6.42 10.02 4.9
Day 7 0.27 9.21 4.7
Day 7 16.43 2.13 8.22 3.8
Day 7 14.8 1.14 5.04 2.2
Day 7 15.55 0.52 11.41 5.7
Day 7 14.39 1.22 5.18 2
Day 7 15.55 0.18 9.41 4
Day 7 17.02 1.35 8.16 3.8
Day 7 12.95 1.15 5.87 2.9
Day 7 14.52 1.43 9.17 4.7
Day 7 14.47 3.32 6.62 3.1
Day 7 12.89 0.2 6.81 3.5
Day 7 14.07 0.67 6.64 3.2
Day 7 16.18 0.86 7.78 4.3
Day 7 15.09 0.49 4.83 3
Day 7 14.53 1.25 3.71 1.7
Day 7 14.15 0.4 9.65 5.2
Day 7 14.52 0.97 10.49 5.1
Day 7 16.57 0.04 6.55 3.2

Question 1)

Based on the available sample data, what is the variance of time taken by the student worker to deliver goods for a given order? Note: The values below are rounded to one decimal point.

Group of answer choices:

0.3 min

8.3 min

3.2 min

15.4 min

Question 2)

Based on the sample, is there sufficient evidence in the data to conclude that the population's average time to deliver goods (Delivery Time) once the order is placed is greater than 25 minutes? What is your conclusion based on the statistical analysis (with a margin of error = 5%)?

Group of answer choices:

- We could not reject the null hypothesis, and hence conclude the mean delivery time is less than 25 min

- We accept the null hypothesis and hence conclude that the delivery time is more than 25 min

- We could not conclude anything

- We reject the null hypothesis, and hence conclude that the delivery time is more than 25 min

Question 3)

You are instructed to perform a statistical test to find out if the "day of the week" influences the mean goods "Delivery Time".

Group of answer choices:

- We could not reject the null hypothesis; the mean delivery time is not different for different days of the week

- We accept the null hypothesis; the mean delivery time is not different for different days of the week

- We reject the null hypothesis; the mean delivery time is different for every day of the week

- We reject the null hypothesis; the mean delivery time is different at least on one of the days of the week

Question 4)

The average distance traveled by a student to deliver goods is:

Group of answer choices:

1.01 miles

3.76 miles

3.89 miles

4.02 miles

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

Algebra And Trigonometry Enhanced With Graphing Utilities (Subscription)

Authors: Michael Sullivan, Michael Sullivan III

8th Edition

0135813158, 9780135813157

More Books

Students also viewed these Mathematics questions

Question

2. How do I perform this role?

Answered: 1 week ago