Being a science major i have a lot of experience with excel. In almost every science class i have to use excel very often to create tables and graphs representing scientific and experimental data. During this project i chose to do the percentage of accepted RWU students according to GPA. Before I even began to experiment with different chart types I had a feeling the best way to represent the data would be though a pie chart. Although each of these charts represent the same data it is obvious that the last pie chart is the most successful. The only difference between the first pie chart and the last one is I decided to put in the percentage of students right into the chart. This helps because you are able to visualize the actual area each percent takes up and you can also see the statistical data to get a visual and statistical representation.
After doing this experiment I learned that although every chart represents the same data, there are some that represent the data better than others. For example in my chart i experimented with three different types of charts: a bar chart, a donut chart and a pie chart. I posted them in order of success. The bar chart represents the data but it is not easy to compare the area of each part. The donut is better than the pie chart but the whole in the middle also makes it hard to compare data. The pie chart is most successful because each art is touching and you can actually visualize one are being different size than the other.
No comments:
Post a Comment