Question: Question 1: Download the Cases.xlsx and study the dataset given in the U.S.Voters 2012 worksheet. Attempt the following parts. Each part will need a 'separate

Question 1: Download the "Cases.xlsx" and study

Question 1: Download the "Cases.xlsx" and study the dataset given in the U.S.Voters 2012" worksheet. Attempt the following parts. Each part will need a 'separate pivot table. So, either create multiple sheets (one for each part) or create a single sheet having multiple pivot tables. If you opt for the later, don't forget to rename your pivot tables. a) Show States by Total Population. Sort the list by descending order (by Total population) (3 Marks) b) Create a Pivot Chart (Pie Chart) for the last part. (3 Marks) c) Add 'age in the filter, and list data for the '65+' segment. Show the top three states that have the highest Total Population. (3 Marks) d) Remove all the previous filters and create a calculated field called 'Voter Population (Confirmed Voters/Citizen Population) How many states had a Voter Population % greater than 70%? Which states? (3 Marks) e) How many confirmed voters in ALASKA were in the 18-24 bracket? What percentage does that represent out of the total confirmed voters in the US? (3 Marks) Question 1: Download the "Cases.xlsx" and study the dataset given in the U.S.Voters 2012" worksheet. Attempt the following parts. Each part will need a 'separate pivot table. So, either create multiple sheets (one for each part) or create a single sheet having multiple pivot tables. If you opt for the later, don't forget to rename your pivot tables. a) Show States by Total Population. Sort the list by descending order (by Total population) (3 Marks) b) Create a Pivot Chart (Pie Chart) for the last part. (3 Marks) c) Add 'age in the filter, and list data for the '65+' segment. Show the top three states that have the highest Total Population. (3 Marks) d) Remove all the previous filters and create a calculated field called 'Voter Population (Confirmed Voters/Citizen Population) How many states had a Voter Population % greater than 70%? Which states? (3 Marks) e) How many confirmed voters in ALASKA were in the 18-24 bracket? What percentage does that represent out of the total confirmed voters in the US

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!