Question

In: Statistics and Probability

OrderNo. DeliveryTime NumberOfPizzas Distance Location 1 16.68 7 5.6 Downtown 2 11.5 3 2.2 Not Downtown...

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
  1. Recode any variables that need cleaning/recoding and show a screenshot of the new table. (4 points)

  2. Report the descriptive statistics of the variables of interest. (3 points)

  3. Plot a diagram that explores the relationship between delivery time and number of pizzas (3 points).

  4. Report the correlation matrix of all variables. (3 points)

  5. Discuss the correlation between number of pizzas and delivery time. (2 points)

Solutions

Expert Solution

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.


Related Solutions

OrderNo. DeliveryTime NumberOfPizzas Distance Location 1 16.68 7 5.6 Downtown 2 11.5 3 2.2 Not Downtown...
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...
A= 2 B= 3 C= 7 A student pulls a (25.0+A) kg box a distance of...
A= 2 B= 3 C= 7 A student pulls a (25.0+A) kg box a distance of (4.50 + B) m up a ramp set at 25.8 degrees using a force of (154 + C) N applied parallel to the ramp. Find the efficiency of the ramp. Give your answer in percent (%) and with 3 significant figures.
Gender Caff_Consumption Stress 1 5 1 1 6 3 2 7 3 1 7 2 1...
Gender Caff_Consumption Stress 1 5 1 1 6 3 2 7 3 1 7 2 1 5 3 1 6 1 1 8 2 1 8 2 2 9 1 2 8 1 2 9 1 2 7 2 2 4 1 2 3 1 1 0 1 2 4 2 1 5 1 2 6 2 1 2 2 1 4 3 1 5 3 2 5 3 1 4 2 1 3 2 1 7 3 2 8...
Mother's age 18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,51 Female 1, 0, 2, 2, 3, 4, 7, 3, 2, 4, 7, 1,...
Mother's age 18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,51 Female 1, 0, 2, 2, 3, 4, 7, 3, 2, 4, 7, 1, 6, 4, 5, 3, 1, 4, 0, 1, 1, 1, 0, 1, 0 Use the stem and leaf plots that you previously created to help you draw and label histograms on your scratch paper with bin width of 2 for mothers's age at birth of female students and for mother's age at birth of male students. Make the lower bound of your first bin...
4) Let ? = {2, 3, 5, 7}, ? = {3, 5, 7}, ? = {1,...
4) Let ? = {2, 3, 5, 7}, ? = {3, 5, 7}, ? = {1, 7}. Answer the following questions, giving reasons for your answers. a) Is ? ⊆ ?? b)Is ? ⊆ ?? c) Is ? ⊂ ?? d) Is ? ⊆ ?? e) Is ? ⊆ ?? 5) Let ? = {1, 3, 4} and ? = {2, 3, 6}. Use set-roster notation to write each of the following sets, and indicate the number of elements in...
For the following data set [ 1, 4, 3, 6, 2, 7, 18, 3, 7, 2,...
For the following data set [ 1, 4, 3, 6, 2, 7, 18, 3, 7, 2, 4, 3, 5, 3, 7] please compute the following 1. measures of central tendency (3 points) 2. standard deviation ( 5 points) 3. is 18 an outlier? (5 points) 4. describe the shape of the distribution (2 points)
ID Affiliation Location Education Confidence 1 1 3 0 72 2 1 3 5 65 3...
ID Affiliation Location Education Confidence 1 1 3 0 72 2 1 3 5 65 3 0 4 5 66 4 0 1 4 78 5 0 3 1 81 6 1 2 5 81 7 1 1 2 83 8 1 3 3 74 9 0 4 0 78 10 0 2 2 85 11 0 1 1 85 12 1 3 5 69 13 1 2 0 69 14 1 3 2 79 15 1 4 1 82...
MONTH   ZEMIN CORP.   MARKET 1 7% 4% 2 2% 1% 3 2% 2% 4 -3% -1%...
MONTH   ZEMIN CORP.   MARKET 1 7% 4% 2 2% 1% 3 2% 2% 4 -3% -1% 5 4% 2% 6   2% 3% a. Given the​ holding-period returns shown above, compute the average returns and the standard deviations for the Zemin Corporation and for the market. b. If​ Zemin's beta is 1.04 and the​ risk-free rate is 9 ​percent, what would be an appropriate required return for an investor owning​ Zemin? ​(​Note: Because the returns of Zemin Corporation are based on...
Find the distance from (2, −7, 7) to each of the following. (a) the xy-plane (b)...
Find the distance from (2, −7, 7) to each of the following. (a) the xy-plane (b) the yz-plane (c) the xz-plane (d) the x-axis (e) the y-axis (f) the z-axis
Briefly (2-3 sentences) describe the location of nephrons within the kidney, and relate their location with...
Briefly (2-3 sentences) describe the location of nephrons within the kidney, and relate their location with a gross morphological feature of the kidney (i.e. how can you relate the location and orientation of nephrons to a feature/features that you can observe with the naked eye).  
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT