Is there a way to make a pivot table from a data set to show the...

Is there a way to make a pivot table from a data set to show the following:

- make gender the columns (one column for male and one for female)
- rows are age increments (18 - 30, 31 - 40, 41 - 50, 51 - 60, 61 - 70)
- information provided within the pivot table is the average salary of everyone within the age increment (for example, I want to find the average salary of a male between the ages of 41 - 50, or the average salary of a female between the ages of 31 - 40). I'm not able to provide a data set because it's too large, but if instructions can be provided, that would be amazing!

Solutions

Expert Solution

Go to Insert in the menu bar and choose pivot table. After you have selected the range of the table with all the columns with unique header names click OK.

Choose gender in columns, Age in rows and salary in Values. Then click on the option as shown below and go to Value Field Settings.

Chosse Average as shown below and click OK. You will get your required pivot table.

orchestra answered 1 year ago

Next > < Previous

Related Solutions

Construct a pivot table (frequency table) of the data from Manufacturing Example xlsx What is the...

Construct a pivot table (frequency table) of the data from Manufacturing Example xlsx What is the probability that a randomly selected piece is out of spec? Round to 2 decimals (ie, 0.04) Inspection Data L1 1.062 1.066 1.066 1.060 1.066 1.066 1.060 1.059 1.067 1.064 1.066 1.063 1.06 1.06 1.067 1.065 1.059 1.066 1.07 1.063 1.062 1.071 1.061 1.061 1.071 1.066 1.063 1.070 1.069 1.059 1.059 1.067 1.063 1.062 1.07 1.061 1.070 1.069 1.071

1. The basic data structure for a Pivot Table is A. a pie chart B. a...

1. The basic data structure for a Pivot Table is A. a pie chart B. a line chart C. a decision variable D. an uncontrollable E. a multidimensional cube 2. Which traits can describe big data? A. All of the above B. None of the above C. High speed D. High variety E. High volume 3. When you only have one data series to visualize, you do need to add a legend. True False 4. Which of the following would...

Problem Statement: 1: Using a pivot table, show in an appropriate chart the total number of...

Problem Statement: 1: Using a pivot table, show in an appropriate chart the total number of confirmed voters by percentage and by age group in the United States 2: What conclusions do you draw from the study and chart? State Age Total Population Citizen Population Registered Voters Confirmed Voters Alabama 18 to 24 439000 428000 212000 155000 Alabama 25 to 34 576000 535000 359000 271000 Alabama 35 to 44 615000 582000 410000 330000 Alabama 45 to 64 1297000 1275000 1051000...

(Data structure) Show the contents of the array below, once the “pivot” element is placed at...

(Data structure) Show the contents of the array below, once the “pivot” element is placed at its appropriate location after each call of the “Partition” algorithm, in the process of running Quick-Sort on said array. Arrange the data in descending order (from largest to smallest value). Always select the first element of the partition as “pivot” Apply sorting on the following data set s, f, p, a, g, e, v, q, i, c

Construct a table to show how to make the standard solutions from serial dilution, starting with...

Construct a table to show how to make the standard solutions from serial dilution, starting with a stock solution of 1000 ppm in 100 mL volumetric flask. Use 1000 ppm standard soltuions of Co, Cr, Pb, Cd, and Zn to prepare the following five standard solutions with 10% HNO3 in 100 mL volumetric flask: Std 1: 100 ppm of Co, Cr, Pb, Cd, Zn Std 2: 50 ppm of Co, Cr, Pb, Cd, Zn Std 3: 10 ppm of Co,...

Consider the data in the table collected from four independent populations. The conclusion of a one-way...

Consider the data in the table collected from four independent populations. The conclusion of a one-way ANOVA test using alphaαequals=0.05 is that the population means are not all the same. Determine which means are different using alphaαequals=0.05 Sample 1 Sample 2 Sample 3 Sample 4 6 13 23 9 7 16 13 8 8 19 19 10 9 22 Click here to view the ANOVA summary table. LOADING... Click here to view a table of critical values for the studentized...

1. When you used a data model to create a Pivot Table, you receive some errors....

1. When you used a data model to create a Pivot Table, you receive some errors. Which is the likely reason? Select an answer: Your Pivot Table was created from an Excel table. Your Pivot Table contains empty cells. Your Pivot Table did not update changes to your Excel table. Your relationships were not properly defined. 2. When you are creating relationships between tables, the unique values for each row are known as the _____. Select an answer: index data...

How do you design a pivot table in Excel?

A previous semester's set of data from the initial questionnaire results in the following frequency table...

A previous semester's set of data from the initial questionnaire results in the following frequency table (some minor adjustments were made). Eye color +8 hours of sleep <8 hours of sleep Brown 6 7 Blue 4 1 Other 1 3 (a) If the possibilities for eye color are brown (Br), blue (Bl), and other (O), and the possibilities for sleep are at least 8 hours (Y) and less than 8 hours (N), one possible outcome for eye color and sleep...

Management and leadership are having to pivot in a big way because of the COVID19 pandemic....

Management and leadership are having to pivot in a big way because of the COVID19 pandemic. More and more people are working remotely and not under the microscope as if they were in an office setting. This experiment is where we are really seeing the distinction between carious worker styles and the effect leadership has on them. In what way do you see the new work from home phenomenon changing the way we manage?

Subjects