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…