Assignment:
Using the data below, make a graph showing the number of billion dollar disasters, financial damage and number of deaths by year.
Year |
Disaster |
Cost |
Deaths |
2001 |
Tropical Storm Allison |
$5.0 billion |
41 |
2000 |
Drought/Heat Wave (south-central and southeast) |
$4.0 |
0 |
2000 |
Western Fire Season |
$2.0 billion |
0 |
1999 |
Hurricane Floyd |
$6.0 |
77 |
1999 |
Eastern Drought/Heat Wave |
$1.0 billion |
502 |
1999 |
Oklahoma-Kansas Tornadoes |
$1.1 billion |
55 |
1999 |
Arkansas-Tennessee Tornadoes |
$1.3 billion |
17 |
1998 |
Texas Flooding |
$1.0 billion |
31 |
1998 |
Hurricane Georges |
$5.9 billion |
16 |
1998 |
HurricaneBonnie |
$1.0billion |
3 |
1998 |
SouthernDrought/Heat Wave |
$9.0billion |
200 |
1998 |
MinnesotaSevere Storms/Hail |
$1.5billion |
1 |
1998 |
SoutheastSevere Weather |
$1.0billion |
132 |
1998 |
NortheastIce Storm |
$1.4billion |
16 |
1997 |
NorthernPlains Flooding |
$3.7billion |
11 |
1997 |
MS and OH Valleys Flooding and Tornadoes |
$1.0billion |
67 |
1997 |
WestCoast Flooding |
$3.0billion |
36 |
1996 |
HurricaneFran |
$5.0billion |
37 |
1996 |
SouthernPlains Severe Drought |
$5.0billion |
0 |
1996 |
PacificNorthwest Severe Flooding |
$1.0billion |
9 |
1996 |
Blizzardof '96 Followed by Flooding |
$3.0billion |
187 |
1995 |
HurricaneOpal |
$3.0billion |
27 |
1995 |
HurricaneMarilyn |
$2.1billion |
13 |
1995 |
Texas/Oklahoma/Louisiana/Mississippi Flooding |
$6.0billion |
32 |
1995 |
CaliforniaFlooding |
$3.0billion |
27 |
1994 |
WesternFire Season |
$1.0billion |
? |
1994 |
TexasFlooding |
$1.0billion |
19 |
1994 |
TropicalStorm Alberto |
$1.0billion |
32 |
1994 |
SoutheastIce Storm |
$3.0billion |
9 |
1993 |
CaliforniaWildfires |
$1.0billion |
4 |
1993 |
MidwestFlooding |
$21.0 billion |
48 |
1993 |
Drought/HeatWave |
$1.0billion |
16 |
1993 |
Storm/Blizzard |
$6.0 billion |
270 |
1992 |
Nor'easterof 1992 |
$2.0billion |
? |
1992 |
HurricaneIniki |
$1.8billion |
7 |
1992 |
HurricaneAndrew |
$27.0billion |
61 |
1991 |
OaklandFirestorm |
$2.5billion |
25 |
1991 |
HurricaneBob |
$1.5 billion |
18 |
1990 |
Texas/Oklahoma/Louisiana/ArkansasFlooding |
$1.0billion |
13 |
Before you can do the graph you must combine the data from the chart above. Use the worksheetbelow to help you. The years 2001 and 2000 have been done for you.
When you addeverything together you will have the numbers to use in your graph.
Year |
Number of Disasters |
Cost in Billions |
Deaths |
2001 |
1 |
5 |
41 |
2000 |
2 |
6 |
0 |
More help with the assignment:
The table should be set up as follows:
![]() |
Formatthe cells in Row 4 by

![]() |
The table chosen for the assignment should be a stacked column. |
![]() |
The final table should look like this. |
![]() |
Home | About Us | Our Services | Software | Spreadsheets Library | Excel Tutorials | Useful Links | Site Map | Contact Us
Unless otherwise stated, all images and text
Spreadsheet123
Visit our busy book shop, were you can find latest books for beginners as well as advanced excel users.
Spreadsheet 123 Spreadsheet Software Development
See Spreadsheets for:
a.Hotel
Management b.Personal
Budget
c.Corporate
Finance d.Rating
Calculation e.Real
Estate and Mortgage
f.Web Calc