{[ promptMessage ]}

Bookmark it

{[ promptMessage ]}

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

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

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

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

View Full Document
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

{[ snackBarMessage ]}