Computer Science homework help
1)Open this up in Excel and follow the below steps. https://content.grantham.edu/at/CS165/OregonStartupOrganizations.xlsx
2)Select-all your data and create a pivot table. Rename your pivot table tab to “List by Type”
3)Create a new row in your pivot table with “Type” as your identifier.
4)Uncheck the “show totals” option in your new row
5)Create a new value with “Type” as your identifier, and use COUNTA as your function.
6)Look at your counted data and insert a note with the type of organization (makerspace, accelerator, incubator) that has the highest number of data rows.
7)Insert a pie chart next to your pivot table that graphically displays the breakdown of organizations by type.
8)Return to your original spreadsheet, select all again, and create a second pivot chart. Rename the tab for this pivot chart “List by Area”
9)Create a new row with “Service Area” as your identifier and deselect the “show totals” option.
Create a new value with “Service Area” as your identifier and use the COUNTA function to tally the organizations by area.
Create a new Column with “Type” as the identifier. This will break down the data even further into types of organizations ordered by service area.
11)Insert a note about the area or areas where you could target the most incubators.
12)On the main spreadsheet, use conditional formatting to highlight any organization type that’s labeled “incubator” in Column G with light green.
13)Use conditional formatting in Column F to highlight any cell that has the word “Metro” in it with light blue