Find your Own Data and Graph it on the Computer First, find some real data from research already…

Find your Own Data and Graph it on the Computer First, find some real data from research already…

Find your Own Data and Graph it on the Computer

First, find some real data from research already done on the internet or in a book. The data can be raw or aggregated (summarized) data for this project. Raw data gives you the data values for each subject in the study and aggregated data is data that has already been collected into groups of interest. This data could involve an interest of yours or a future profession. Once you have your data, write a short report about it. Your report should contain an explanation of how the data was collected, where you obtained the data, at least one appropriate graph of the data created using the computer on a program similar to Microsoft Excel, explanation why that graph is appropriate, and an explanation of what the graph tells you about the data. The graph you create should be a part of your paper, not a separate document. You can find a document explaining how to create a graph in Excel on Blackboard.

You should only submit one document for your assignment. Any graphs you create must be copied and pasted directly into your paper.

You can collect the data from any reliable website or other source (use your own judgment). Do not re-create a graph you find on that website, but instead use data to create your own different, but appropriate, graph. Ideally, you would find data that has not yet been graphed. Be sure to cite where you got the data in the report.

Examples:

  • Data on mathematics PhD’s granted to women was collected from a professional website, http://www.ams.org/employment/docsgrtd.html. Use it to make a graph of the percentage of female PhD’s granted over time, and then explain words what the graph tells you.

Year

Total Female PhDs Granted

Total PhDs Granted

Percentage Female PhDs

2010

472

1475

32.00%

2009

462

1430

32.31%

2008

435

1378

31.57%

2007

365

1157

31.55%

2006

394

1245

31.65%

2005

363

1222

29.71%

2004

331

1081

30.62%

2003

307

1037

29.60%

2002

295

960

30.73%

2001

311

1065

29.20%

2000

302

1119

26.99%

1999

318

1133

28.07%

1998

297

1216

24.42%

1997

287

1158

24.78%

1996

230

1076

21.38%

1995

281

1226

22.92%

1994

229

1076

21.28%

1993

286

1214

23.56%

1992

223

1050

21.24%

I used “Insert Chart”, “Scatterplot” on Excel to make the following graph, which shows a general increase in the percentage of math PhDs granted to women over the years between 1992 and 2010.

Note: Your paper should explain in more detail why you chose the graph you did, what the graph tells you, and how you got your data, but this is the basic idea of what I would like to see.

Possible websites where you may find the kind of data you need for this project:

  • You may go to a sports website and find data on the statistics of a particular player for each game played during the season. You could then choose one statistic (like batting average), and graph the batting average of that person throughout the season on a line graph. Then explain what you see in the graph. Perhaps the player has improved throughout the season, or the player is a very consistent player so the graph is quite flat, or perhaps you see something else.
  • Professional websites with data about salaries over time or in different regions, or data on minorities represented in the field, or some other type of data. Another option is the US Department of health or the World Health Organization, which has a lot of data at your disposal through http://www.who.int/globalatlas/DataQuery/default.asp

Find your Own Data and Graph it on the Computer First, find some real data from research already…

TALK TO SUPPORT VIA LIVE CHAT TO SEE THIS ANSWER AT $ 10 ONLY