Please use minitab or excel to solve it

1.After some discussion within your project group, an additional sample is collected, but this time, additional variables are collected along with the measured thrust.The data shown are from Table 12-22 in your textbook. (A separate Excel file is provided with these data.)

They represent:

y= the thrust of a jet-turbine engine

x1 = primary speed of rotation

x2 = secondary speed of rotation

x3 = fuel flow rate

x4 = pressure

x5 = exhaust temperature

x6 = ambient temperature at time of test

a.Provide descriptive statistics for y= the thrust of a jet-turbine engine and x1 = primary speed of rotation.Include box plots.Explain the statistics and graphs provided.

b.Fit a multiple linear regression model using x1 = primary speed of rotation, x3 = fuel flow rate, x4 = pressure, and x5 = exhaust temperature as the regressors.

c.Test for significance of regression in part b. using alpha = 0.05. Find the P-value for this test. Explain the results of your test.

d.Find the t-test statistic for each regressor. Using alpha = 0.05, explain carefully the conclusion you can draw from these statistics.

y 4540 4315 4095 3650 3200 4833 4617 4340 3820 3368 4445 4188 3981 3622 3125 4560 4340 4115 3630 3210 4330 4119 3891 3467 3045 4411 4203 3968 3531 3074 4350 4128 3940 3480 3064 4402 4180 3973 3530 3080 x1 2140 2016 1905 1675 1474 2239 2120 1990 1702 1487 2107 1973 1864 1674 1440 2165 2048 1916 1658 1489 2062 1929 1815 1595 1400 2047 1935 1807 1591 1388 2071 1944 1830 1612 1410 2066 1954 1835 1616 1407 x2 20640 20280 19860 18980 18100 20740 20305 19961 18916 18012 20520 20130 19780 19020 18030 20680 20340 19860 18950 18700 20500 20050 19680 18890 17870 20540 20160 19750 18890 17870 20460 20010 19640 18710 17780 20520 20150 19750 18850 17910 x3 30250 30010 29780 29330 28960 30083 29831 29604 29088 28675 30120 29920 29720 29370 28940 30160 29960 29710 29250 28890 30190 29960 29770 29360 28960 30160 29940 29760 29350 28910 30180 29940 29750 29360 28900 30170 29950 29740 29320 28910 x4 205 195 184 164 144 215 206 195 171 149 195 190 180 161 139 208 199 187 164 145 193 183 173 153 134 193 184 173 153 133 198 186 178 156 136 197 188 178 156 137 x5 1732 1697 1662 1598 1541 1709 1669 1640 1572 1522 1740 1711 1682 1630 1572 1704 1679 1642 1576 1528 1748 1713 1684 1624 1569 1746 1714 1679 1621 1561 1729 1692 1667 1609 1552 1758 1729 1690 1616 1569 x6 99 100 97 97 97 87 87 87 85 85 101 100 100 100 101 98 96 94 94 94 101 100 100 99 100 99 99 99 99 99 102 101 101 101 101 100 99 99 99 100