In: Statistics and Probability
OrderNo. | DeliveryTime | NumberOfPizzas | Distance | Location |
1 | 16.68 | 7 | 5.6 | Downtown |
2 | 11.5 | 3 | 2.2 | Not Downtown |
3 | 12.03 | 3 | 3.4 | Downtown |
4 | 14.88 | 8 | 0.8 | Not Downtown |
5 | 13.75 | 6 | 1.5 | Not Downtown |
6 | 18.11 | 7 | 3.3 | Downtown |
7 | 8 | 2 | 1.1 | Downtown |
8 | 17.83 | 7 | 2.1 | Downtown |
9 | 79.24 | 30 | 14.6 | Not Downtown |
10 | 21.5 | 5 | 6.05 | Not Downtown |
11 | 40.33 | 16 | 6.88 | Downtown |
12 | 21 | 10 | 2.15 | Not Downtown |
13 | 13.5 | 4 | 2.55 | Not Downtown |
14 | 19.75 | 6 | 4.62 | Not Downtown |
15 | 24 | 9 | 4.48 | Not Downtown |
16 | 29 | 10 | 7.76 | Not Downtown |
17 | 15.35 | 6 | 2 | Not Downtown |
18 | 19 | 7 | 1.32 | Downtown |
19 | 9.5 | 3 | 0.36 | Not Downtown |
20 | 35.1 | 17 | 7.7 | Downtown |
21 | 17.9 | 10 | 1.4 | Downtown |
22 | 52.32 | 26 | 8.1 | Not Downtown |
23 | 18.75 | 9 | 4.5 | Downtown |
24 | 19.83 | 8 | 6.35 | Not Downtown |
25 | 10.75 | 4 | 1.5 | Downtown |
26 | 26 | 9 | 7.3 | Not Downtown |
27 | 14.21 | 5 | 2.4 | Not Downtown |
28 | 21 | 8 | 1.4 | Downtown |
29 | 10 | 4 | 0.9 | Not Downtown |
30 | 36 | 18 | 8 | Downtown |
31 | 18.1 | 9 | 1.5 | Downtown |
Recode any variables that need cleaning/recoding and show a screenshot of the new table. (4 points)
Report the descriptive statistics of the variables of interest. (3 points)
Plot a diagram that explores the relationship between delivery time and number of pizzas (3 points).
Report the correlation matrix of all variables. (3 points)
Discuss the correlation between number of pizzas and delivery time. (2 points)
The variable "Location" is recoded as 1 for "Downtown" and 0 for "Not Downtown".
It is a nominal variable.
The descriptive statistics associated with nominal variables are frequencies and percentages.
Frequency | Percentage | |
Downtown(1) | 14 | 45.16 |
Not Downtown(0) | 17 | 54.84 |
Scatterplot that explores the relationship between delivery time and number of pizzas:
Correlation matrix:
DeliveryTime | NumberOfPizzas | Distance | Location | |
DeliveryTime | 1.0000 | 0.9594 | 0.8787 | -0.0903 |
NumberOfPizzas | 0.9594 | 1.0000 | 0.7961 | -0.0066 |
Distance | 0.8787 | 0.7961 | 1.0000 | -0.1283 |
Location | -0.0903 | -0.0066 | -0.1283 | 1.0000 |
The correlation between number of pizzas and delivery time is 0.9594. So number of pizzas and delivery time has a very strong positive correlation. As one of the variable increases, the other also tend to increase.