Question
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
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started