Dataset: 1.
Recode any variables that need cleaning/recoding and show a screenshot of the new table.
2. Report the descriptive statistics of the variables of interest.
3. Plot a diagram that explores the relationship between delivery time and number of pizza
4. Report the correlation matrix of all variables.
5. Discuss the correlation between number of pizzas and delivery time.
6. What is the correlation between downtown variable (1= downtown, 0=not downtown) and each of the other three variables? Discuss. What does each of the relationship suggest?
7. Model A. Run a linear regression that predicts delivery time using number of pizzas, distance, and downtown as independent variables. Summarize and show results in a table. Explain each relationship.
8. What is R2 ? What does it mean?
9. What are the business implications of the regression results?
10. Model B. Run a linear regression that predicts delivery time using number of pizzas and distance. Summarize and show results in a table. Explain any differences from the previous model.
11. Using model B, what is the variable with the highest influence on delivery time? Explain why?
12. Using model B, predict the delivery time for the new orders in tab “New orders”
Get Free Quote!
329 Experts Online