Dear Tutor,

The following is from an ungraded quiz that I'd need help on how to proceed. Due to the use of an Excel data file, I can't expect you to solve it but please do aid me in how to go about it.

Regards,

"You are tasked by the government to estimate expected hurricane damage in the upcoming year.

The data file "StormData.xlsx" contains information on the 162 Atlantic hurricanes that have made landfall in the United States from 1900 - 2017.

Variables in the dataset include:

• BASE DAMAGE ($): Estimated damage from the storm in the United States in the year the storm made
• CURRENT DAMAGE ($ 2021): Estimated damage from the storm if the storm struck in 2021. Current damage adjusts base damage for inflation, as well as changes in coastal population and changes in the value of coastal
• DAMAGE RANK: Ordinal ranking based on current
• CATEGORY AT LANDFALL: Category on the Saffir-Simpson hurricane scale when the storm made landfall in the United States
• WINDS AT LANDFALL: Maximum sustained wind speed when the storm made landfall on the United

1. Major hurricanes are classified as Category 3, 4 or 5 hurricanes and are considered especially How much damage should we expect if a major hurricane makes landfall in the U.S.? (Note this includes all damage done by a given storm, including 2^nd landings.)
2. If we use the hurricanes from 1900-2017 as a guide, how many hurricanes should we expect in the coming year? How much damage should we expect nationwide? (Hint: first create a table that sums the number of hurricanes and hurricane damage by year)"

STORM NAME LANDFALL DATE YEAR DAMAGE RANK BASE DAMAGE ($) CURRENT DAMAGE ($ 2021) LANDFALL STATE REGION CATEGORY MAJOR HURRICANWINDS(MPH) Galveston Sep 08,1900 1900 2 30,000,000 171,510,000,000 TX Gulf Coast 4 140 Storm 4 in 1901 Aug 14,1901 1901 131 1,000,000 830,000,000 LA Gulf Coast 85 Storm 3 in 1903 Sep 11,1903 1903 56 670,000 7,410,000, FL Southeast 90 Storm 2 in 1904 Sep 14,1904 1904 141 1,000,000 640,000,000 SC Southeast 80 Storm 6 in 1906 Sep 27,1906 1906 85 4,000,000 2,970,000,000 MS Gulf Coast 110 Storm 8 in 1906 Oct 18,1906 1906 97 200,000 2,140,000,000 FL Southeast 120 Grand Isle Sep 20,1909 1909 116 5,000,000 1,400,000,000 LA Gulf Coast w 120 Storm 10 in 1909 Oct 11,1909 1909 50 1,000,000 8,980,000,000 FL Southeast 115 Valasco Jul 21,1909 1909 96 2,000,000 2,210,000,000 TX Gulf Coast 115 Storm 5 in 1910 Oct 17,1910 1910 68 500,000 5,150,000,000 FL Southeast 110 Storm 3 in 1911 Aug 28,1911 1911 155 1,000,000 420,000,000 SC Southeast 100 Storm 4 in 1913 Sep 03,1913 1913 105 3,000,000 1,930,000,000 NC Southeast AWW A H N N W W 85 Galveston Aug 17,1915 1915 5 50,000,000 121,200,000,000 TX Gulf Coast 130 New Orleans Sep 29,1915 1915 84 13,000,000 2,980,000,000 LA Gulf Coast 125 Storm 2 in 1916 Jul 05,1916 1916 107 3,000,000 1,800,000,000 AL Gulf Coast 120 Storm 6 in 1916 Aug 18,1916 1916 91 1,800,000 2,460,000,000 TX Gulf Coast 130 Storm 1 in 1918 Aug 06,1918 1918 25,000,000 OOHH HH OOH HOP HOP H P P P H O O OHH HH OOOOH 154 18,880,000,000 LA Gulf Coast 120 Storm 2 in 1919 Sep 09,1919 1919 148 2,000,000 600,000,000 FL Southeast NOW 150 Storm 2 in 1920 Sep 21,1920 1920 128 1,450,000 1,020,000,000 LA Gulf Coast 100 Tampa Bay Oct 25,1921 1921 66 3,000,000 5,660,000,000 FL Southeast 115 Great Miami Sep 18,1926 1926 105,000,000 255,950,000,000 FL Gulf Coast 145 Storm 1 in 1926 Jul 27,1926 1926 58 3,051,000 7,190,000,000 FL Southeast 105 Storm 3 in 1926 Aug 25,1926 1926 110 7,000,000 1,750,000,000 LA Gulf Coast 115 Lake Okeechobee Sep 16,1928 HAWN 1928 10 25,000,000 63,830,000,000 FL Southeast 145 Storm 1 in 1929 Jun 28,1929 1929 197 675,000 110,000,000 TX Gulf Coast 80 Storm 2 in 1929 Sep 30,1929 1929 178 300,000 390,000,000 FL Southeast 75 Freeport Aug 13,1932 1932 43 7,500,000 12,650,000,000 TX Gulf Coast 145 Storm 11 in 1933 Sep 04,1933 1933 48 16,900,000 9,210,000,000 TX Gulf Coast 120 Storm 12 in 1933 Sep 04,1933 1933 88 1,000,000 2,720,000,000 FL Southeast NHW WW AH 120 Storm 13 in 1933 Sep 16,1933 1933 109 4,750,000 1,770,000,000 NC Southeast 120 Storm 8 in 1933 Aug 23,1933 1933 55 27,000,000 7,410,000,000 NC Southeast 105 Storm 2 in 1934 Jun 16,1934 1934 137 2,605,000 710,000,000 LA Gulf Coast 98 arm 2 in 1021 Jul 25 1024 1024 1 500 0nn san non non TV StormData Gulf Coast +