In: Statistics and Probability
Use the Tornadoes data and your statistical expertise to answer the questions: Is it reasonable to claim that on average there are more than 45, tornado-related deaths in the month of April (per year)?
9. What test/procedure did you perform?
10. What is the P-Value/margin of error?
11. Statistical Interpretation
12. Conclusion
Paste content below in a text document and then open that text document with excel.
Tornadoes and Deaths by Year and Month (1950-1994)                                                                                                                                                                                                              
                                                                                                                                                                                                                
Year    Total Tornadoes Tornadoes by Month                                                                                              Total Deaths    Deaths by Month                                                                                 
                Jan     Feb     Mar     Apr     May     June    July    Aug     Sept    Oct     Nov     Dec             Jan     Feb     Mar     Apr     May     June    July    Aug     Sept    Oct     Nov     Dec
1950    201     7       20      21      15      61      28      23      13      3       2       4       4       70      1       45      1       12      2       6       0       0       0       0       0       3
1951    260     2       10      6       26      57      76      23      27      9       2       12      10      34      0       1       0       2       7       9       5       0       8       0       1       1
1952    240     12      27      43      37      34      34      27      16      1       0       6       3       230     0       10      209     4       2       2       2       1       0       0       0       0
1953    422     14      16      40      47      94      111     32      24      5       6       12      21      519     0       3       24      36      163     244     0       0       0       0       0       49
1954    550     2       17      62      113     101     107     45      49      21      14      2       17      36      0       2       10      2       9       5       0       1       3       2       0       2
1955    593     3       4       43      99      148     153     49      33      15      23      20      3       129     0       0       5       7       106     2       5       0       2       1       1       0
1956    504     2       47      31      85      79      65      92      42      16      29      7       9       83      0       8       1       67      4       0       1       2       0       0       0       0
1957    858     17      5       38      216     228     147     55      20      17      18      59      38      193     13      0       1       30      87      14      0       0       2       2       25      19
1958    564     11      20      15      76      68      128     121     46      24      9       45      1       67      0       13      0       4       0       43      1       1       1       4       0       0
1959    604     16      20      43      30      226     73      63      38      58      24      11      2       58      3       21      9       1       8       2       0       0       14      0       0       0
1960    616     9       28      28      70      201     125     42      48      21      18      25      1       46      0       0       0       7       34      3       0       1       0       1       0       0
1961    697     1       31      124     74      137     107     77      27      53      14      36      16      52      0       0       7       4       23      2       0       0       15      0       1       0
1962    657     12      25      37      41      200     171     78      51      24      11      5       2       30      1       0       17      2       4       0       0       6       0       0       0       0
1963    463     15      6       48      84      71      90      62      26      33      13      15      0       31      1       0       8       16      1       0       0       2       3       0       0       0
1964    704     14      2       36      157     134     137     63      79      25      22      17      18      73      10      0       6       15      16      0       0       2       0       22      0       2
1965    897     21      32      34      123     273     147     85      61      64      16      34      7       301     0       0       2       268     17      7       0       1       0       1       5       0
1966    585     1       28      12      80      98      126     100     58      22      29      20      11      98      0       0       58      12      0       19      3       0       0       6       0       0
1967    926     39      8       42      149     116     210     90      28      139     36      8       61      114     7       0       3       73      3       6       1       2       5       4       0       10
1968    660     5       7       28      102     145     136     56      66      25      14      44      32      131     0       0       0       40      72      11      2       2       0       0       3       1
1969    608     3       5       8       68      145     137     98      70      20      26      5       23      66      32      0       1       2       4       7       0       19      0       0       0       1
1970    654     9       16      25      117     88      134     82      55      54      50      10      14      73      0       0       2       30      26      6       3       0       0       6       0       0
1971    889     19      83      40      75      166     199     100     50      47      38      16      56      159     1       134     2       11      7       1       1       0       0       0       0       2
1972    741     33      7       69      96      140     114     115     59      49      34      17      8       27      5       0       0       16      0       2       0       2       0       0       2       0
1973    1102    33      10      80      150     250     224     80      51      69      25      81      49      89      1       0       17      10      35      3       1       4       3       0       12      3
1974    945     24      23      36      267     144     194     59      107     25      45      13      8       366     2       0       1       317     10      31      0       0       0       5       0       0
1975    919     52      45      84      108     188     196     79      60      34      12      39      22      60      12      7       12      13      5       6       2       2       0       0       0       1
1976    834     12      36      180     113     155     169     84      38      35      11      0       1       44      0       5       21      1       8       3       2       1       3       0       0       0
1977    852     5       17      64      88      228     132     99      82      65      25      24      23      43      0       2       0       26      4       0       1       6       1       1       0       2
1978    789     23      7       17      107     213     148     143     65      20      7       9       30      53      2       0       0       4       7       17      11      1       6       0       0       5
1979    855     16      4       53      123     112     150     132     126     69      47      21      2       84      0       0       1       58      2       8       1       5       2       7       0       0
1980    866     5       11      41      137     203     217     95      73      37      43      3       1       28      0       0       2       4       8       7       5       0       1       1       0       0
1981    782     2       25      33      84      187     223     98      64      26      32      7       1       24      0       2       1       13      0       8       0       0       0       0       0       0
1982    1047    18      3       60      150     329     196     95      34      38      9       19      96      64      1       0       6       30      14      4       0       0       2       0       0       7
1983    931     13      41      71      65      249     178     99      76      19      13      49      58      34      2       1       0       6       14      2       4       0       0       0       0       5
1984    907     1       27      73      176     169     242     72      47      17      49      30      4       122     0       0       64      33      6       14      0       0       0       4       1       0
1985    684     2       7       38      134     182     82      51      108     40      18      19      3       94      0       0       2       5       78      3       0       3       0       0       3       0
1986    765     0       30      76      84      173     134     88      67      65      26      17      5       15      0       2       6       2       1       0       3       1       0       0       0       0
1987    656     6       19      38      20      126     132     163     63      19      1       55      14      59      0       6       1       1       31      2       0       1       0       0       11      6
1988    702     17      4       28      58      132     63      103     61      76      19      121     20      32      5       0       1       4       3       0       0       3       1       0       14      1
1989    856     14      18      43      82      231     252     59      36      31      30      57      3       50      0       0       1       0       9       5       0       0       0       4       31      0
1990    1133    11      57      86      108     243     329     106     60      45      35      18      35      53      0       1       3       0       5       11      0       29      0       2       0       2
1991    1132    29      11      157     204     335     216     64      46      26      21      20      3       39      1       0       13      21      0       1       1       0       0       0       2       0
1992    1297    15      29      55      53      137     399     213     115     81      34      146     20      39      0       0       5       0       0       1       0       3       0       4       26      0
1993    1173    17      34      48      85      177     313     242     112     65      55      19      6       33      0       3       5       10      2       1       0       6       2       4       0       0
1994    1082    13      9       58      205     161     234     155     120     30      51      42      4       69      0       0       40      12      0       3       3       4       0       0       7       0