A soft drink bottler is analyzing the vending machine service routes in his distribution system.He is interested in predicting the amount of time required by the route driver to service thevending machines in an outlet. This service activity includes stocking the machine with beverageproducts and minor maintenance or housekeeping. The industrial engineer responsible for thestudy has suggested that the two most important variables affecting the delivery time (y) are thenumber of cases of product stocked (x1) and the distance walked by the route driver (x2). Thecollected 25 observations on delivery time are shown in the following table. Use any software to do the calculations like Excel. But please show all thedetailed steps (a) With several proper scatter plots check the relationship between the response and theindependent variables(b) Use matrix notation and find estimator for the regression coefficients(c) Write the equation of the fitted model based on least squared method(d) Interpret each estimated regression coefficients(e) Find an estimator for the total variation of the model.(f) Test significance of each regression coefficients at level a = 0.05(g) Find 95% C.I. for each regression coefficients(h) Test significance of the whole regression model(i) Find R² and Raj. Comment on the values. Observation Number1235678910111213141516171819202122232425Delivery Time,y (min)16.6811.5012.0314.8813.7518.118.0017.8379.2421.5040.3321.0013.5019.7524.0029.0015.3519.009.5035.1017.9052.3218.7519.8310.75Number of Cases, x₁73346727305161046910673171026984Distance, x₂ (ft)56022034080150330110210146060568821525546244877620013236770140810450635150

Regression Model A regression model is a statistical technique to estimate the constant dependent…

Answered: 16.68 11.50 12.03 14.88 13.75 18.11…

MATLAB: An Introduction with Applications

6th Edition

ISBN:9781119256830

Author:Amos Gilat

Publisher:Amos Gilat

Chapter1: Starting With Matlab

Section: Chapter Questions

Problem 1P

See similar textbooks

Related questions

Question

A soft drink bottler is analyzing the vending machine service routes in his distribution system.
He is interested in predicting the amount of time required by the route driver to service the
vending machines in an outlet. This service activity includes stocking the machine with beverage
products and minor maintenance or housekeeping. The industrial engineer responsible for the
study has suggested that the two most important variables affecting the delivery time (y) are the
number of cases of product stocked (x1) and the distance walked by the route driver (x2). The
collected 25 observations on delivery time are shown in the following table.

Use any software to do the calculations like Excel. But please show all the
detailed steps