10.75 Vehicle congestion study. Modern warehouses employ computerized and automated guided vehicles for materials handling. Consequently, the physical layout of the warehouse must be carefully designed to prevent vehicle congestion and optimize response time. Optimal design of an automated warehouse was studied in The Journal of Engineering for Industry (Aug. 1993). The layout employed assumes that vehicles do not block each other when they travel within the warehouse, i.e., that there is no congestion. The validity of this assumption was checked by simulating (on a computer) warehouse operations. In each simulation, the number of vehicles was varied and the congestion time (total time one vehicle blocked another) was recorded. The data are shown in the accompanying table. Of interest to the researchers is the relationship between congestion time (y) and number of vehicles (x).
Use EXCEL to conduct a complete simple linear regression analysis of the data, including a residual analysis. What conclusions can you draw from the data?
Note: show the equations used in excel please so I can learn how to solve.
Number of vehicles |
Congestion Time, min |
1 |
0 |
2 |
0 |
3 |
0.02 |
4 |
0.01 |
5 |
0.01 |
6 |
0.01 |
7 |
0.03 |
8 |
0.03 |
9 |
0.02 |
10 |
0.04 |
11 |
0.04 |
12 |
0.04 |
13 |
0.03 |
14 |
0.04 |
15 |
0.05 |
Coefficient of Determination(R-squared):
It gives the measure of how close the data points are to the best fit line. In other words, it gives the proportion of variability in dependent variable that can be explained by the independent variable. Higher the Rsquared value, better the model is.
Please hit thumbs up if the answer helped you.
Get Answers For Free
Most questions answered within 1 hours.