The data for this assignment is provided in the attached Excel file labeled "Weather data Plains." This data is from the weather station at the Experiment Station in Plain, Sumter County, Georgia. Daily maximum and minimum temperatures are given $($in o F$)$ as well as any rainfall $($in inches$)$ is given for each day. Note that Data contains the full date $($although only the day and month are viewed$)$ while year column is just a numeric value.

With the data provided you will need preform the following actions. Multiple manipulation may be required for each. Save each numbered problem to a new sheet and label the sheet appropriate.

$1.$ Start by copying all the data from the RAWDATA sheet to a new sheet labeled Problem#$1-2.$ On this new sheet convert measurement into the appropriate SI units using appropriate formulas$/$functions$.$ In doing so you should create new columns for each. $($Use SI units for all analysis and reporting$)$

$2.$ Since we want to look at changes on a monthly bases $-$ create a column for the Month using the appropriate formula$/$functions on this same sheet. This can be extracted from the "Date" information.

$3.$ Based on the SI data in your Problem#$1-2$ sheet, create a pivot table that provides, by year and month, the average Max and Min Temp and the total precipitation for the month. $($Label sheet with this pivot table as Problem#$3).$ Change pivot table heading to custom ones that adequately describe the data.

$4.$ Create a new data sheet $($Problem#$4$A$)$ copying the data from the pivot table from Problem#$3$ using paste "values". Then create a graph to do the following. The graph should not be linked to the live pivot table in Problem #$3-$ or they will impact each other negatively $-$ thus the reason for copying it to a new sheet. Demonstrate the change in max temperature by month such that the reader can easily compare the $5$ years. $($Put on a new sheet $-$ label it Problem#$4$B$).$ It should have all the required components for a graph that will included in a paper.

$5.$ You want the reader of your paper to visualize the average daily temperate fluctuation by month averaged across all $5$ years. $($That means not by year.$)$ What information do you have? How could you do this? May require multiple steps. Place your results on a new sheet within the workbook and label that sheet $-$ Problem#$5.$

$6.$ You want to create a table for your paper that will provide the reader with the mean $($with standard deviation$)$ for max and min and mean month precipitation for each month $($across all years, not by the years$).$ Create the publishable table either directly in Excel or you can create it in Word or PowerPt and paste it in a new sheet $($label it Problem#$6).$ Remember this table should be "paper ready" even if you create it in Excel, so no gridlines or other extraneous Excel stuff.

$7.$ You have heard many locals exclaim that $2021$ temperatures fluctuation have been the most extreme in the past $5$ years. What specific statistical analysis would you preform it determine the validity of their statement? YOU ARE NOT REQUIRED TO DO IT$.$ On a new sheet $($labeled Problem#$7)$ descript what analysis you would do and why. Based on your analysis from the earlier problems, what would be your prediction?

What should you submit to the assignment? Your single Excel File. IT MUST BE IN THIS FORMAT.