Answered step by step
Verified Expert Solution
Question
1 Approved Answer
CniZ-E-pizza, a family owned pizzeria, Is famous not only for its Innovative flavors, but also for delivering incredibly on time. However, during the last few
CniZ-E-pizza, a family owned pizzeria, Is famous not only for its Innovative flavors, but also for delivering incredibly on time. However, during the last few weeks, the company has been facing an increase in customers complaints about late deliveries. Bobby Henderson, the owner, suspects that the problem is related to the GPS platform they are currently using to calculate the estimated delivery time that is informed to customers. "This is affecting customer's expectations and compromising our level of service", he says. Julia, his tech loving daughter, replies: "The platform is probably underestimating some important factors that impact on traffic. Let me investigate this". Julia wants to investigate what factors could be impacting the difference from the Estimated Time of Arrival - ETA from the current GPS platform to the actual delivery time. "It's been raining more than usual during the last month", she says, "I am convinced that it impacts traffic, and I guess the platform does not take this rain factor into account". Therefore, she takes precipitation reports from the last 30 days in order to analyze if rain is somehow related to the daily average delays. The following table includes information about daily average delay and precipitation for the last 30 days. Day Daily Average Delay (minutes) Precipitation (in) 15 0.76 1.5 10.07 12 10.5 16.5 10.06 1.5 10.27 10.5 0.29 7.5 10.24 19.5 1.1 10 12 0.31 11 12 28.5 1.06 13 1.5 10.03 14 22.5 10.7 15 1.5 10.01 16 17 1.5 10.04 18 130 1.27 19 |13.5 10.42 20 1.5 0 21 48 2.25 22 |4.5 10.02 23 79 0 24 3 0.01 1.5 0.14 1.5 10 1.5 1.5 0.13 10 5 0.51Create a linear regression model to verify Julia's assumption, that is, if there is a relation between precipitation and delays. What is the R of this model? Enter your answer as a decimal number with four decimal places (e.g., if your R is equal to 71.37%, input 0.7137). 0.8939 0.8939 What is the model's intercept value? Round your answer to two decimal places (e.g., if your answer is 5.569734, input 5.57). 2.94 2.94 What is the model's slope value? Round your answer to two decimal places (e.g., if your answer is 5.569734, input 5.57). 20.21 20.21Question 2 8.0 points possible (graded, results hidden} Bobby is impressed by his daughter's insight to associate the delays to the weather. However, he did not understand how her findings could be used to improve deliveries level of service. Julia explains that, at the beginning of each day, they could take the forecasted precipitation volume for that day, and then use her equation to estimate an average delay for that day. Wlth that, they could add the estimated average delayr provided by her model to each of the ETAs provided by the GPS platform during that day. Then, they could inform a more accurate delivery time to each customer. 'We can avoid frustrating customers expectations by providing a more accurate ETA'I Based on the regression model, hovuI much time [in minutes} should ChizEpizza add to the ETA provided by the GPS platform in a day in which the forecasted precipitation volume is 1.15 inches? Round your answer to two decimal places [e.g., if your answer is 5.56934, input 55?]. "What if the forecast for a specific day is no precipitation? Or an extreme amount of precipitation. like 10 inches?", Bobby asks. Considering Bobby's question, and the model created with the dataset above, choose the correct option: Select the best answer Q It is recommended to use this model only for the first option, that is, no precipitation. Q It is recommended to use this model only for the second option, that is, 10 inches precipitation. O This model cannot be used in any of these two situations. O This model can confidently be used in both situations. 0 None of the above Question 3 8.0 points possible (graded, results hidden) Bobby liked Julia's approach. They started to discuss what other factors could be somehow related to those delays. She remembered that two months ago the local government launched a parking restriction policy, on Tuesdays, Wednesdays and Thursdays. She suspects this may be causing difficulties for delivery drivers to park, and increasing delays in orders delivered during the parking restriction days. To investigate this hypothesis, Julia decides to include Parking Restriction as an additional variable in her regression model. The following table includes information about daily average delay, precipitation and day of the week, for the last 30 days. Day Daily Average Delay (minutes) Precipitation (in) Day of the week 15 0.7 Sunday 1.5 10.07 Monday 12 0.5 Tuesday 16.5 0.06 Wednesday 1.5 Thursday 10.27 Friday 10.5 0.29 Saturday 7.5 0.24 Sunday 19.5 1.1 Monday 10 12 10.31 Tuesday 3 Wednesday 12 28.5 1.06 Thursday 13 1.5 0.03 Friday 14 22.5 0.7 Saturday 1.5 10.01 Sunday 16 3 Monday 17 1.5 0.04 Tuesday 18 30 1.27 Wednesday 13.5 10.42 Thursday 1.5 Friday 2.25 Saturday 4.5 0.02 Sunday Monday 0.01 Tuesday 1.5 10.14 Wednesday Thursday riday 0.13 Saturday Sunday 0.51 MondayWhat is the R of this model? Enter your answer as a decimal number with four decimal places (e.g., if your R is equal to 71.37%, input 0.7137). 0.8999 0.8999 Based on the new regression model, how much time should Chiz-E-pizza add to the ETA provided by the GPS platform in a Friday in which the forecasted precipitation volume is 0.5 inches? Round your answer to two decimal places (e.g., if your answer is 5.569734, input 5.57)
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