a)(2 points) Test the hypothesis that the operating costs per revenue ton-mile decreases as the ton-mile load factor increases when all other variables are held constant.Use? = 0.01.

a)(2 points) Is there sufficient evidence that the overall model is useful for predicting the operating costs per revenue ton-mile? Test using ? = 0.01.

Please use excel if possible, thanks.

Airline Y X1 X2 X3 X4 All American 116.3 57 133 6.1 0.4 American 43 270 216 6.93 0.689 Bonanza 141.5 100 140 4.45 0.358 Braniff 50.6 176 182 6.6 0.557 Capital 51 142 167 7.47 0.51 Central 318.5 51 134 4.67 0.167 C&S 59.2 175 175 8.6 0.558 Colonial 77 112 150 6.87 0.505 Continental 62.3 131 179 6.5 0.537 Delta 45.3 174 191 7.6 0.598 Eastern 42.6 182 187 9.5 0.528 Empire 112.4 59 143 4.83 0.313 Frontier 125.2 81 141 7.47 0.398 Lake Central 169.3 73 142 3.85 0.212 Mid-Continent 64.8 144 167 6.2 0.565 Mohawk 100.5 79 137 5.88 0.476 National 42.9 199 207 8.28 0.567 Northeast 81.1 94 150 6.77 0.597 Northwest 56.7 271 202 6.88 0.57 Piedmont 75.4 90 153 8.13 0.449 Pioneer 71.3 89 150 7.05 0.483 Southern 150.1 67 147 6.15 0.317 Southwest 78.9 54 127 5.85 0.491 Trans-Texas 130.3 78 147 6.08 0.372 TWA 46.2 293 193 6.4 0.67 United 42.3 270 207 6.63 0.63 West Coast 103.3 58 135 4.5 0.421 Western 44.2 172 181 6.67 0.656 Inland 64.7 147 158 9.38 0.575 Wiggins 137.7 69 142 5.72 0.43\f