gg-4 - pivot table to show the number of records in the...

Info iconThis preview shows pages 1–2. Sign up to view the full content.

View Full Document Right Arrow Icon
PivotTables Day 2 Preparation Problems (Key) Rev: 8/25/09 dd Assume you have been asked to analyze the annual salary data contained on the Data tab in the Excel file named SalarySurvey.xlsx. In the data, Education Level reflects the terminal education degree received by the person. Career Stage indicates whether the person is in the first half or second half of their career. In the file, a pivot table has already been created on the PivTable tab, which reflects average salary by Education Level and Career Stage. A picture of the PivotTable is shown below. Questions 1. (3 pts) Create a PivotChart based on the existing PivotTable. Use the bar-chart chart format. Print a copy. 2. (7 pts) Below is a picture of an inside-out pivot table with part of the Data Area hidden. Create the
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Background image of page 2
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: pivot table to show the number of records in the sample that fit each intersection of Education Level $0 $20,000 $40,000 $60,000 $80,000 $100,000 $120,000 $140,000 1st Half 2nd Half and Career Stage. For example, it should count the number of people whose terminal degree was a Bachelors Degree and who are in the 1 st half of their Career. It should also count the number of people whose terminal degree was a Bachelors Degrees who are in the 2 nd half of their career and so forth for each education level. It should also calculate the percent of row for each education level. Required Print out the pivot chart from Question 1 and the pivot table from Question 2. Include your name and section number at the top of the first page....
View Full Document

This note was uploaded on 04/07/2011 for the course ISYS 200 taught by Professor Dean during the Winter '11 term at BYU.

Page1 / 2

gg-4 - pivot table to show the number of records in the...

This preview shows document pages 1 - 2. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online