Your job is to understand this data well enough to make char…
Your job is to understand this data well enough to make charts which provide insight to certain data analysis questions. Don’t worry, you are not expected to provide oceanographic insights. Import the following data file to a blank excel workbook and make a table from the data. Be sure to save your work as an excel workbook or your changes will be lost. 462580-2024.csv Tips: The wave height column i in meters: wave height (m) Water temperature is in °C: WTMP sometimes default values are NA, null, or some other number that is obviously not valid. When you detect a column with invalid data, feel free to delete it. Save your work in an excel notebook. Saving the datafile will loose all your work! Using Excel pivot tables and charts, analyze the buoy data to answer the following questions. Support each answer with appropriate visualizations and specific data values from your analysis. Seasonal Wave Height Patterns (8 points) Which month has the highest average wave height? Create a pivot table and chart showing average wave height by month on a tab called Seasonal Wave Height. Daily Wave Height Variation (8 points) Do wave heights vary by time of day? Create a pivot table and chart showing average wave height by hour on a tab called Daily Height Variation. Water Temperature Trends (8 points) How does water temperature change throughout the year? Create a pivot table and chart showing average water temperature by month on a tab called Monthly Temperature Variation. Dashboard (6 points) Create a dashboard on a new tab called dashboard. The dashboard should clearly show the answers to the three questions and include 2 slicers that allow users to explore the data.to display all three charts, include appropriate slicers.
Read Details
