[HW9] Hypothesis Testing and Regression Analysis

xlsx

School

Bloomsburg University *

*We aren’t endorsed by this school

Course

101

Subject

Statistics

Date

Apr 3, 2024

Type

xlsx

Pages

Uploaded by PresidentGrouse4378

SUMMARY OUTPUT Regression Statistics Multiple R 0.8973275062 R Square 0.8051966534 Adjusted R Square 0.7917619398 Standard Error 2.2781474488 Observations 32 ANOVA df SS MS F Significance F Regression 2 622.110031848 311.05501592 59.93403952 5.0020496E-11 Residual 29 150.508718152 5.1899557983 Total 31 772.61875 Coefficients Standard Error t Stat P-value Lower 95% Intercept -13.365770151 7.65113640121 -1.7468999964 0.0912393677 -29.014101115 Yards/Game 0.1220941466 0.0123093957 9.9187766456 7.938703E-11 0.0969186056 Opponent Yards/Game -0.0142907103 0.01617121466 -0.8837128587 0.3841190458 -0.0473645579 Seeing as our yards/game p-value is lower than our alpha, we can say that our yards/game predictor is a However, our opponent yards/game is not a signifigant estimate as its p-value is far larger than our alph So changes in yard/game are associated with points/game, but changes with opponent yards/game are The intercept coefficient shows us that if yards/game and opponent yards/game are zero, then the pred The yards/game coefficient means that as our yards per game increases by one unit while holding all oth Even though our opponent yards/game is not signifigant, we can still explain it. The opponent yards/gam

Upper 95% Lower 95.0% Upper 95.0% 2.2825608123 -29.014101115 2.2825608123 0.1472696876 0.0969186056 0.1472696876 0.0187831372 -0.0473645579 0.0187831372 a signifigant estimate ha value not associated with points/game dicted points/game is -13.365 her variables constant, our points per game increases by 0.122 me coefficient means that as our oppoenent yards per game increases by one unit while holding all other variab

bles constant, our points per game decreases by 0.014

Your preview ends here

Eager to read complete document? Join bartleby learn and gain access to the full version

Access to all documents
Unlimited textbook solutions
24/7 expert homework help

SUMMARY OUTPUT Regression Statistics Multiple R 0.7563284474 R Square 0.5720327203 Adjusted R Square 0.5577671443 Standard Error 3.3199173918 Observations 32 ANOVA df SS MS F Significance F Regression 1 441.963205342 441.96320534 40.098816955 5.5278694E-07 Residual 30 330.655544658 11.021851489 Total 31 772.61875 Coefficients Standard Error t Stat P-value Lower 95% Intercept -0.616076942 3.57169120526 -0.1724888594 0.8642116413 -7.9104435129 Passing Yards/Game 0.1041010312 0.0164395245 6.3323626676 5.527869E-07 0.0705270432 Since as our p-value is less than 1% for our passing yards per game coefficient, we can say that passin Now looking at our intercept, we can say that with 0 passing yards per game, our points per game wil This may seem ridiculuous since it would be impossible to have negative points in a game, but we are Now our passing yards per game coefficient means that if we passing yards per game increases by on With this information, we can say changes in passing yards per game impact our points per game 10 15 20 25 30 35 0 50 100 150 200 250 300 350 Passing Yards/Game vs Points/Game Points/Game Passing Yeards/Game

Upper 95% Lower 95.0% Upper 95.0% 6.6782896289 -7.9104435129 6.6782896289 0.1376750193 0.0705270432 0.1376750193 ng yards is a signifigant estimator for points per game ll be -0.61608 e using linear regression so this is just where our intercept happens to fall and it is almost impossible to have ze ne, the points per game will increase by 0.104101 The graph shows a strong positive relationship between these two variables. In other words, as passing yards per game increases, so does points per game (in general). 5 40

ero passing yards in a game

Your preview ends here

Eager to read complete document? Join bartleby learn and gain access to the full version

Access to all documents
Unlimited textbook solutions
24/7 expert homework help

National Football League Data 2017 Season Team Points/Game Yards/Game Opponent Yards/Game Rushing Yards/Game Arizona Cardinals 25.2 344.1 330.2 90 Atlanta Falcons 16.2 301 355.5 95 Baltimore Ravens 17.2 302 301.6 112.3 Buffalo Bills 15.8 277.1 362.9 112.5 Carolina Panthers 16.7 284.9 324.8 114 Chicago Bears 20.9 293.2 354.7 83.1 Cincinnati Bengals 23.8 348 348.8 97.3 Cleveland Browns 25.1 351.3 359.6 118.4 Dallas Cowboys 28.4 365.7 307.6 109.1 Denver Broncos 20 346.3 336 122.3 Detroit Lions 21.6 322.9 377.6 80.5 Green Bay Packers 27.2 370.7 313.3 99.8 Houston Texans 23.7 333.6 344.2 99.1 Indianapolis Colts 28.1 358.7 279.7 106.6 Jacksonville Jaguars 25.7 357.4 313.8 149.4 Kansas City Chiefs 14.1 276.8 319.4 78 Miami Dolphins 16.7 287.5 342.2 98.1 Minnesota Vikings 22.8 336.2 338.1 164.6 New England Patriots 36.8 411.2 288.3 115.6 New Orleans Saints 23.7 361.2 348.1 91.6 New York Giants 23.3 331.4 305 134.3 New York Jets 16.8 294.7 331.9 106.3 Oakland Raiders 17.7 294.8 341.6 130.4 Philadelphia Eagles 21 358.1 311.4 123.4 Pittsburgh Steelers 24.6 327.4 266.4 135.5 San Diego Chargers 25.8 315.2 320.3 127.4 San Francisco 49ers 13.7 237.3 346.2 92.3 Seattle Seahawks 24.6 348.9 321.8 101.2 St. Louis Rams 16.4 297.5 341.1 95.4 Tampa Bay Buccaneers 20.9 326.8 278.4 117 Tennessee Titans 18.8 311.7 291.6 131.8 Washington Football Team 20.9 333.4 305.3 116.9

Passing Yards/Game Opponent Rushing Yards/Game Opponent Passing Yards/Game Penalties 254.1 97.9 232.3 137 206 127.1 228.4 105 189.7 79.3 222.3 107 164.6 124.6 238.4 78 170.9 110.7 214.1 95 210.1 122.9 231.8 111 250.8 118.3 230.4 90 232.9 129.5 230.1 114 256.6 94.6 213.1 104 224 142.6 193.4 90 242.4 119.4 258.2 100 270.9 102.9 210.4 113 234.4 114.1 230.1 82 252.1 106.9 172.8 67 208 100.3 213.5 76 198.8 130.6 188.9 101 189.4 153.5 188.7 91 171.6 74.1 264.1 86 295.7 98.3 190.1 78 269.6 102.9 245.3 68 197.1 97.7 207.3 77 188.4 134.8 197.1 63 164.4 145.9 195.8 120 234.7 95.8 215.6 83 191.9 89.9 176.5 80 187.8 107 213.3 94 145 118.5 227.7 97 247.8 102.8 219.1 59 202.1 115.3 225.8 94 209.8 107.9 170.5 81 179.9 92.4 199.2 101 216.4 91.3 214 90

Penalty Yards Interceptions Fumbles Passes Intercepted Fumbles Recovered 1,128 18 11 24 12 891 16 12 15 9 873 17 6 14 26 633 18 12 14 7 801 14 16 17 12 839 16 17 21 13 670 19 16 20 10 868 17 10 20 9 815 19 10 19 5 610 14 16 15 14 676 17 18 22 14 1,006 19 9 15 9 636 11 14 21 17 515 22 15 14 5 594 20 10 8 13 697 14 8 20 13 732 14 8 16 13 662 15 16 14 16 690 19 12 9 6 581 13 10 18 12 652 15 10 20 14 486 15 6 19 6 864 18 8 20 17 649 11 8 15 12 651 11 14 14 8 761 30 18 16 8 702 12 10 17 17 428 20 14 13 11 794 18 9 28 9 614 16 19 8 12 773 22 12 17 17 751 14 10 11 18

Your preview ends here

Eager to read complete document? Join bartleby learn and gain access to the full version

Access to all documents
Unlimited textbook solutions
24/7 expert homework help

Consumer Transportation Survey Vehicle Driven Type Satisfaction with vehicle Gender Age Truck Domestic Yes Male 31 Truck Domestic Yes Male 29 Truck Foreign No Male 26 Truck Domestic No Male 18 SUV Domestic Yes Male 49 SUV Foreign Yes Male 50 SUV Domestic Yes Male 48 SUV Foreign Yes Male 45 SUV Domestic Yes Male 45 SUV Domestic Yes Male 44 SUV Foreign Yes Male 41 SUV Domestic Yes Male 41 SUV Foreign No Female 39 SUV Foreign Yes Female 36 SUV Foreign Yes Female 33 SUV Domestic Yes Male 31 SUV Domestic No Female 31 SUV Domestic No Female 29 SUV Domestic Yes Male 28 Mini Van Domestic Yes Female 55 Mini Van Domestic No Female 43 Mini Van Domestic Yes Female 41 Mini Van Foreign Yes Female 38 Mini Van Foreign Yes Female 39 Mini Van Domestic No Male 35 Mini Van Domestic Yes Female 33 Mini Van Foreign Yes Female 32 Mini Van Foreign Yes Female 28 Car Domestic Yes Female 21 Car Domestic No Female 62 Car Domestic Yes Female 61 Car Foreign Yes Male 60 Car Domestic No Male 58 Car Domestic Yes Female 51 Car Domestic Yes Female 47 Car Domestic No Male 46 Car Domestic No Male 44 Car Foreign No Female 42 Car Foreign Yes Female 41 Car Domestic No Female 41 Car Domestic Yes Female 39 Car Foreign Yes Female 34

Car Foreign Yes Male 33 Car Foreign Yes Male 30 Car Domestic Yes Female 29 Car Foreign Yes Female 27 Car Foreign Yes Female 26 Car Domestic No Female 24 Car Domestic Yes Female 22 Car Foreign No Female 19

# of hours per week in vehicle Miles driven per week Number of Children Average number of riders 10 450 0 1 5 370 1 1 12 580 0 1 6 300 0 1 21 1000 0 1 16 840 2 1 15 1400 3 4 5 300 2 2 15 850 0 1 10 700 2 1 5 350 1 1 30 1500 4 3 6 280 1 1 4 400 0 1 3 420 0 1 10 675 0 1 15 800 1 1 4 300 1 1 3 400 1 1 8 400 0 2 10 700 2 3 10 720 1 2 10 450 4 5 15 1000 1 2 5 350 2 2 10 800 2 3 2 200 4 5 8 350 3 4 4 150 0 1 5 175 0 2 5 355 0 1 5 150 0 1 10 600 0 1 11 600 0 1 4 300 0 1 4 275 0 1 6 285 2 3 5 400 2 3 5 350 2 2 10 600 1 2 10 700 1 2 10 600 1 2

Your preview ends here

Eager to read complete document? Join bartleby learn and gain access to the full version

Access to all documents
Unlimited textbook solutions
24/7 expert homework help

5 400 1 2 5 350 1 2 5 250 0 1 6 355 0 2 5 175 0 1 5 300 0 1 5 350 0 1 5 500 0 2

Miles from work a. Sample Mean 18 30 Sample Std Dev 13.23878 22 Sample Size 50 15 20 Hypothesis Testing (Two-Side 22 Step 1. Formulate null and alternative hypotheses 45 b 25 25 mu = b vs. 20 25 40 Step 2. Set up a level of significance and a critical t-va 20 alpha 0.01 15 2.679952 17 20 25 Step 3. Calculate t-statistics 35 |t*| 3.7388244 50 20 15 Step 4. Draw a Conclusion 0 0 15 0 b. Sample Mean 0.6 0 Sample Std Dev 0.4948717 0 Sample Size 50 0 5 Hypothesis Testing Using p-value (O 0 Step 1. Formulate null and alternative hypotheses 0 b 60% 0 mu >= b vs. 15 10 35 Step 2. Set up a level of significance 40 alpha 0.01 21 18 16 Step 3. Calculate t-statistics and p-value 22 t* 0 23 p-value 0.5 34 45 16 Step 4. Draw a Conclusion H 0 : H 1 : t c Since |t*| > t c , we can reject H0 and conclude that the sam H 0 : H 1 :