Need help with this assignment. From: New Perspectives Comprehensive Excel 2010 1st edition

Documentation

Midwest Tornado Institute
Author	Donna McClanahan
Date	Monday, May 05, 2014
Purpose	To record the prevalence of minor, moderate, and major tornados from 1950 to 1999

Sightings Chart

Tornado Sightings 1950-1999

Minor 1950-1954 1955-1959 1960-1964 1965-1969 1970-1974 1975-1979 1980-1984 1985-1989 1990-1994 1995-1999 31 84 47 50 37 42 127 80 274 257 Moderate 1950-1954 1955-1959 1960-1964 1965-1969 1970-1974 1975-1979 1980-1984 1985-1989 1990-1994 1995-1999 68 79 69 32 68 41 53 35 120 70 Major 1950-1954 1955-1959 1960-1964 1965-1969 1970-1974 1975-1979 1980-1984 1985-1989 1990-1994 1995-1999 77 89 97 48 97 17 32 16 62 21 All 1950-1954 1955-1959 1960-1964 1965-1969 1970-1974 1975-1979 1980-1984 1985-1989 1990-1994 1995-1999 176 252 213 130 202 100 212 131 456 348

Years

Sightings

Sightings History

Tornado Sightings 1950 - 1999
Year	Minor	Moderate	Major	All
1950-1954	31	68	77	176
1955-1959	84	79	89	252
1960-1964	47	69	97	213
1965-1969	50	32	48	130
1970-1974	37	68	97	202
1975-1979	42	41	17	100
1980-1984	127	53	32	212
1985-1989	80	35	16	131
1990-1994	274	120	62	456
1995-1999	257	70	21	348
All	1,029	635	556	2,220