Excel Assignment- Relative Frequency Open up the Excel Spreadsheet Mod 5 Excel

Excel Assignment- Relative Frequency
Open up the Excel Spreadsheet Mod 5 Excel Assignment.xlsx.

2. On Sheet 1, you will see data about Social Media preferences.

First, make a relative frequency column next to the frequency column.
Second, make a BAR graph from this data. For Vertical (Legend Entries) use the Frequency. For the Horizontal Axis, use the Categories (Facebook, Twitter, etc.) Make sure the bars do not touch and that both axes have desсrіptive labels.
Third, make a PIE chart from this data. For the Legend Entries use the Relative Frequency. For the Horizontal Axis, (X axis) use the categories. Your pie chart should display the numerical data in the pie slice.

3. On Sheet 2, you will see data about the PM2.5. This is particulate matter air pollution where the particles have diameters of 2.5 micrometers or less. The data in our assignment shows the levels for various urban areas in the United States. https://stats.oecd.org/
You will complete this assignment with the 2017 data ONLY.

Use Excel functions to find and label the maximum value in the data set.
Use Excel functions to find and label the minimum value in the data set.
Use the Max and Min value to construct appropriate bins for the data.
(Remember, it′s often to have 5~6 bins. One way to find the bins is to start by finding the range and dividing by 5 or 6. This will give you the bin width. Now, pick your lowest bin to be just a bit higher than your minimum value. Next, let your bins go up by the bid width that you calculated a moment before. Keep going until you reach a bin that is higher than your maximum data value. At this point, you have all of your bins.)
Use Excel (through Data Analysis in the Data Tab) to construct a frequency table for this data.
4. Make sure your name is one the file.
5. Save the file and submit it to Module 5: Excel Assignments in D2L Brightspace.