Homework 7: A Warning Exercise

• Demonstrate your ability to split text in excel.
• Demonstrate your ability to format tables in excel.

1. [1 pt] Obtain a copy of the historical snowfall data for Edinboro. Place this into a worksheet.
   • Unfortunately, I think you will need to copy and paste this data.
   • Importing the data is not recommended as it will hang excel.
2. [1 pt] Rename this worksheet to be "Raw Data".
3. [1 pt] Make a copy of the worksheet, name this worksheet "Working Copy"
4. [1 pt] Remove "inches" from the measurement column (This should be done via a tool, not by editing the fields individually)
5. [1 pt] Sort the data by total inches, high to low.
6. [2 pts] Format the table as pictured below
   • 
7. [3 pts] Build a box an whisker plot of the snowfall. It should match the one pictured below
   • 

Submit