creating graph by excel

IS 100 Critical Thinking and Information Technology Literacy Homework 4 for Fall 2018

Using Excel to Present Data Findings - Visual Support 1. This project is due by 11:59 pm on Wednesday, November 7, 2018. You will be uploading your

Visual support document and the excel file containing the work. You are to upload your work using a Microsoft Word (*.doc or *docx) format in one file which contains all the graphs, short description of each one and works cited. In Addition, you will also upload the Excel file that contains the actual work. Upload to Beachboard (Under “Dropbox”) that has been created for this purpose. There is no late work accepted.

2. You will be using the census dataset. Each graph has specific census data assigned and a link is provided.

3. Each graph will include (see example at end of instructions):

a. Isolated data set used to produce graph b. The specified graph with a descriptive title, labeled axis and legend. c. Specify Work Cited d. Description of what your graph is representing e. Consider using fill colors, textures, grids and/or clip art to enhance style and readability of chart.

4. Develop the following original charts from the data tables.

a. 3 D Pie Chart – Must show percentages in each slice and must contain a descriptive heading (not the title of the dataset used). Don’t forget a legend.

Use Table 31. Unemployed persons by age, sex, race, Hispanic or Latino ethnicity, marital status, and duration of unemployment. http://www.bls.gov/opub/ee/2015/cps/annavg31_2014.pdf

Hint: You may want to select by Age for combined male and females or you may want to select by race for combined male and females.

There is an example of a pie chart at the end of this assignment.

b. Column Chart

Use Table 31. Unemployed persons by age, sex, race, Hispanic or Latino ethnicity, marital status, and duration of unemployment. http://www.bls.gov/opub/ee/2015/cps/annavg31_2014.pdf

You may use the same data from the Pie chart. The only difference will be that the data will be displayed in a column chart. Format Chart. In Design view add Horizontal and vertical labels. Add a Heading.

c. Clustered Column Chart – must contain

Example:

Hint: When preparing your data in excel do not put a title for the first column the year. See example of a simple excel spreadsheet that achieved the above results:

married single divorces widow

1970 10 14 14 6 1980 12 12 16 8 1990 15 15 20 10 2000 18 19 22 15 2010 22 22 16 18

The data above is just demonstration data. Actual data combines divorces and widow.

You will be using data from:

Table 598: Marital Status of Women in Civilian Workforce. Selected years 1970 to 2010. Labor Force, Employment, and Earnings.

http://www.census.gov/prod/2011pubs/12statab/labor.pdf

5. You must provide a copy of the data that you used to develop the charts. Print the excel tables with labels and references to which chart they were used for and provide the excel table that supports the chart. You will use an appendix to show the original tables from the census data set.

7. You must have an APA or MLA citation of the source included as a “works cited” and each chart should be presented with a proper source.

0

5

10

15

20

25

1970 1980 1990 2000 2010

N um

be r

in la

bo r

fo rc

e

Year

Your title Goes Here

married

single

divorces

widow

Hint: Create all your Graphs using excel, then copy and Paste to the word document.

I am providing an example of the first graph with a different dataset. In order to create this graph we need to extrapolate the information from the table. You are not going to graph the entire table. You need to understand the data, then decide what information should be shown graphically. There are wonderful videos on YouTube which will teach you step by step how to create a graph. The following example is how your document should look like. See example on next page.

Table 610. Multiple Jobholders: 2010 (in thousands) Total 25 - 54 Years 4797 55 - 64 Years 1021 20 - 24 Years 695 65 Years and Above 197 16 - 19 Years 167

Source: U.S. Bureau of Labor Statistics, "Employment and Earnings Online," January 2011 issue, March 2011, <http://www.bls.gov/opub/ee/home.htm> , <http://www.bls.gov/cps/home.htm>.

This Pie chart represents the percentage of all multiple jobholders in 2010 by age distribution. This would include the population of 16 years and older. The data came from table 610.

70%

15%

10% 3%

2%

Multiple Jobholders By Age Groups in 2010

25 - 54 Years 20 - 24 Years 65 Years and Above 16 - 19 Years

Appendix

Works Cited

U.S. Bureau of Labor Statistics (2012). Table 610. Multiple Jobholders: 2010. Selected year 2010. Labor

Force, Employment, and Earnings (2011, March). Retrieved from

http://www.census.gov/prod/2011pubs/12statab/labor.pdf on February 18, 2015.