INCERT BOXPLOT IN EXCEL 2016 HOW TO
INCERT BOXPLOT IN EXCEL 2016 DOWNLOAD

Make the numbers in the Male % column negative. Manually type (do not copy and paste) the number from column D “Male Percentage (%) into the corresponding rows in Column H. Under the Number tab, change the Category selection to ‘Number.’ In the ‘Decimal places’ field, enter 2. Highlight the column, right click and select Format Cells. In a new column, retype the Male Percentage data as numbers. Be careful of copying and pasting the equation that the denominator does not change, but always remains B3 (the total population of both sexes).ĩ. Repeat this process for every Female age cohort: cells F4 through F24. Then do the same for the Female age cohorts starting with females ages 0-4 in cell F4. Repeat this process for every Male age cohort: cells D4 through D24. So for Males ages 5-9, the equation is: =C5/B3. For every new age/sex cohort, you need to enter the appropriate data as the numerator, but always the total population of both sexes as the denominator. You cannot simply click outside the cell. Note: After you’ve entered the equation, you must hit enter for the calculation to happen. What you’ve done, is divided the males ages O-4 (cell C4) by the total population (cell B3). Click on cell D4 and enter the equation =C4/B3 and hit Enter. We’ll start with finding the percentage of Males ages 0-4 (so we’re filling in cell D4). For each age/sex cohort, set up an equation to calculate the what percentage of the total population it represents. Under the Number tab, select ‘Percentage’ and change the Decimal Places to 1.Ĩ. Highlight column D, right click, and select Format Cells. For both of these new columns, format the cells to represent data as a percentage. Insert a new column between Male Population and Female Population and label it ‘Male Percentage (%).’ Label the column to the right of Female Population column as ‘Female Percentage (%).’ħ.

To calculate the total for the Female Population, select cell D3 and type the equation: =SUM(D4:D24) Hit enter on your keyboard.Ħ.

To calculate the total for the Male Population, select cell C3 and type the equation: =SUM(C4:C24) Hit enter on your keyboard.

To calculate the total for Both Sexes, select cell B3 and type the following equation: =SUM(B4:B24) Hit enter on your keyboard.

Calculate the total for all three population groups. Insert a new row under the headings that will become row 3 and include the Total for each population group. You’ll be left with four columns: Age Group Both Sexes Population Male Population Female Population.Ĥ. You may need to re-type the ages 5-9 and 10-14.ģ. In the ‘Number’ tab, select ‘Text’ from the list on the left and click OK. To do this: Highlight cells A4 and A5, right click, and select Format Cells.

For the cells with ages ‘5-9′ and ’10-14’, you may need to change the cell category to Text. Delete the word ‘years’ from all of the age range cells in column A (cells A3 through A23). Type in new name.) Add a new row 1 above the headings and in cell A1 write the country name.Ģ. (Rename by right clicking on ‘Sheet1’ and selecting Rename so the text ‘Sheet1’ is highlighted. Organize and Clean your Population Dataġ. It will be the file where you’ll build your population pyramid. The data will be entered into a new excel document.ħ.

INCERT BOXPLOT IN EXCEL 2016 DOWNLOAD

Click the icon and select Excel as your Download Format. In the upper left you’ll see a download icon (circled in red above). The generated report will look like this:Ħ.

This is what the selection column looks like:ĥ. Under ‘Report’ click ‘Population by Age’ and then choose ‘Five Year Age Groups.’Ĥ. In the column on the left, select the country of your choice under ‘Select by Country/Area.’ I chose Guatemala for this example.ģ. Census Bureau’s International Database.Ģ. Get the Population Data for your Countryġ.

Where I say “click” you might need to double click.

This guide is based on using Microsoft Excel 2016.

Making a population pyramid, or age-sex distribution graph, in Excel has never been easier than with this step-by-step guide that takes you all the way from gathering the needed demographic data to the finished product – a graphically-accurate (and beautiful!) population pyramid.

INCERT BOXPLOT IN EXCEL 2016 HOW TO

How to Build a Population Pyramid in Excel: Step-by-Step Guide

Incert boxplot in excel 2016