Week 5 Lab 5 cont.
This deliverable is a hands-on task that you should complete in an Excel file and upload
Submit an Excel file as the deliverable
To complete today’s deliverable (due before next class), please download the database below and replicate today’s lecture on how to create graphs in Excel.
The database below is the deliverable from Lab 4.
After creating all charts, rename, save and upload your file to the upload page.
At the end of the deliverable, you should have an Excel file with the following charts:
- One Bar chart of Country of Birth
- One Pie chart of Gender
- One Column chart of Major
- One Pie chart of Liking stats or not
- Three column charts of Liking stats by gender (one clustered, one stacked, one 100% stacked)
- One Scatterplot of the Age variable
In total, the deliverable Excel file will have 8 charts.
This entry is licensed under a Creative Commons Attribution-NonCommercial-ShareAlike 4.0 International license.
1) 25
2) 11
3) 35
4) 16
5) 36.811
6) Mean and Median are close: No skew
7) 27; 25% of the age found in the database fall below age 27