PLEASE USE EXCEL OR MINITAB

PLEASE PROVIDE STEP BY STEP SOLUTIONS

Airfreight breakage. A substance used in biological and medical research is shipped by airfreight to users in cartons of 1,000 ampules. The data below, involving 10 shipments, were collected on the number of times the carton was transferred from one aircraft to another over the shipment route (X) and the number of ampules found to be broken upon arrival (Y). Assume that first-order regression model (1.1) is appropriate. 1: 1 2 3 4 5 6 7 8 9 10 Xi: Y: 1 16 0 9 2. 17 0 12 3 22 1 13 0 8 1 15 2 19 0 11 a. Prepare a dot plot for the number of transfers X;. Does the distribution of number of transfers appear to be asymmetrical? b. The cases are given in time order. Prepare a time plot for the number of transfers. Is any systematic pattern evident in your plot? Discuss. c. Obtain the residuals e; and prepare a stem-and-leaf plot of the residuals. What information is provided by your plot? d. Plot the residuals e; against X; to ascertain whether any departures from regression model (2.1) are evident. What is your conclusion? e. Prepare a normal probability plot of the residuals. Also obtain the coefficient of correlation between the ordered residuals and their expected values under normality to ascertain whether the normality assumption is reasonable here. Use Table B.6 and a =.01. What do you conclude? f. Prepare a time plot of the residuals. What information is provided by your plot? g. Assume that (3.10) is applicable and conduct the Breusch-Pagan test to determine whether or not the error variance varies with the level of X. Use a =.10. State the alternatives, decision rule, and conclusion. Does your conclusion support your preliminary findings in part (d)? Airfreight breakage. A substance used in biological and medical research is shipped by airfreight to users in cartons of 1,000 ampules. The data below, involving 10 shipments, were collected on the number of times the carton was transferred from one aircraft to another over the shipment route (X) and the number of ampules found to be broken upon arrival (Y). Assume that first-order regression model (1.1) is appropriate. 1: 1 2 3 4 5 6 7 8 9 10 Xi: Y: 1 16 0 9 2. 17 0 12 3 22 1 13 0 8 1 15 2 19 0 11 a. Prepare a dot plot for the number of transfers X;. Does the distribution of number of transfers appear to be asymmetrical? b. The cases are given in time order. Prepare a time plot for the number of transfers. Is any systematic pattern evident in your plot? Discuss. c. Obtain the residuals e; and prepare a stem-and-leaf plot of the residuals. What information is provided by your plot? d. Plot the residuals e; against X; to ascertain whether any departures from regression model (2.1) are evident. What is your conclusion? e. Prepare a normal probability plot of the residuals. Also obtain the coefficient of correlation between the ordered residuals and their expected values under normality to ascertain whether the normality assumption is reasonable here. Use Table B.6 and a =.01. What do you conclude? f. Prepare a time plot of the residuals. What information is provided by your plot? g. Assume that (3.10) is applicable and conduct the Breusch-Pagan test to determine whether or not the error variance varies with the level of X. Use a =.10. State the alternatives, decision rule, and conclusion. Does your conclusion support your preliminary findings in part (d)