Here you will learn to create an accurate pie chart to display comparative data.
Kalena’s cheerleading squad is raising money for prom by selling candy at school football games. After a month of sales, the squad is running low on candy and decides to review the sales so far to help them decide what to order when they restock.
The table below describes the sales that the girls have recorded. How could the girls create a visual representation of the data so they can more easily present their findings to the purchasing committee? Ideally, they would like to order more of the item that is proving the most profitable, and so they want to present the data to the committee in a way that highlights this. We will review this question after the lesson.
|Item||# of Sales|
|Popsicles $1 ea||850|
|Chocolate Bars $0.85 ea||1300|
|Bag of Lemon Drops $1.25 ea||340|
|Ice Cream Bars $1 ea||670|
There are two videos applicable to this lesson, the first is a demonstration of creating a pie chart with the use of spreadsheet software, the second explains creation by hand.
http://youtu.be/lVlXbH4nczI eoloughlin – How To… Draw a Simple Pie Chart in Excel 2010
Just for clarity, note that this video shows the same pie chart created twice , once incorrectly, and then once correctly, as stated in the first few seconds of the video.
http://youtu.be/W60F_517PVY krmathsandscience – How to Construct a Pie Chart
Pie charts are an excellent way to compare multiple values that make up parts of a whole. Each piece of the pie is called a sector, and each sector encompasses an angle that is proportional to the frequency of the data it represents. The formula relating the angle of a sector to frequency is:
In order to construct an accurate pie chart, you will need to calculate the sector angles for each of the categories or intervals in your sample, verifying that they total .
Once you know the angles for each sector construct a circle and mark the sectors within it with lines running from the center of the circle to the edge (radii). Make sure that the angle between the lines is equal to the calculated sector angle for each category.
Finally you need to either label the sectors directly or create a key similar to the one in the concept question above so your audience can easily identify which sector corresponds to each category in your sample.
In Karen’s school, there were 480 students in 1997, 540 students in 2000, 710 students in 2003, and 900 students in 2006. Construct a pie chart to represent the relative numbers of students each year.
First, calculate the total number of students over all four categories (years):
Now calculate the angle of each sector with
Verify that your degree measures total :
Finally, construct your circle and draw the internal angles equal to the calculated sector angles, and color-code and/or directly label each sector:
Create a pie chart to display the data from the table below:
Solution: First total the number of cars in the entire population:
Now find the degree measure of each sector using:
- All Others:
Verify that the total is :
Construct a circle with sectors representing each degree measure and label directly or create a key:
Use a spreadsheet or compass and protractor to create two related pie charts of the data in the table below. If using a modern spreadsheet, create a 3-D graph. Highlight the data from the soccer participants in both graphs.
|Sport||Count of Middle School Participants||Count of High School Participants|
Solution: By now you are familiar with creating charts using a pencil and paper, so let’s walk through creating a chart in a modern spreadsheet.
If you do not have spreadsheet software on your computer, you can download the free ‘Open Office Calc’ spreadsheet software from http://www.openoffice.org/ . The process described here is essentially the same in any modern spreadsheet software such as Open Office Calc, Microsoft Excel or Numbers.
First, highlight and copy the two columns of data under ‘Sport’ and ‘Count of Middle School Participants’ from the table in the question, include the column headers.
Now open a blank spreadsheet in your software and paste the two columns of data.
Highlight the data in the spreadsheet (including the headers), and either choose ‘Charts : Pie’ from the toolbar or click the icon that looks like a bar graph and choose ‘Pie.’
The data will be immediately converted to a pie chart for you! Now pick a 3-D style (since that is what was specified in the question), and press ‘enter’ to get a chart like the one below.
To highlight the soccer data, simply select the sector representing the soccer participants and drag it away from the center of the circle just slightly. Finally, select the entire chart in the spreadsheet and copy/paste it into your answer document or print it out to turn it in.
To create the chart for the high school data, just copy the data from the single ‘Count of High School Participants’ category and paste it right overtop of the Middle School column in your spreadsheet and repeat the steps above to convert the revised table into a chart.
The two final products should look something like these:
Concept Problem Revisited
Create a pie chart that compares the income from each product for the cheerleading squad. Use the data in the table of candy sales.
In the example problems, the first step was to total the number of items sold. However, in this problem, we need to compare the dollar value of the items rather than just the number of items. That means we need to first evaluate the dollar value of each product sale, and then calculate the angle of each slice based on a comparison of the dollar value of each product with the total income from sales. Just to keep things neat, let’s add another column to the original table called “dollar value”, and another row at the bottom for the total.
|Item||# of Sales||$ Value|
|Popsicles $1 ea||850||$850.00|
|Chocolate Bars $0.85 ea||1300||$1,105.00|
|Bag of Lemon Drops $1.25 ea||340||$425.00|
|Ice Cream Bars $1 ea||670||$670.00|
Now we can use the formula to calculate the angle of each slice:
- Chocolate Bars:
- Lemon Drops:
- Ice Cream Bars:
Finally, we construct our circle and mark the divisions of the sectors based on the angles we have calculated, label the sectors, and label the graph.
A sector is a single ‘pie slice’ in a circle graph.
The whole relationship is represented by the entire circle.
1. Larry Bird was a well know basketball player. He played for the Boston Celtics. Use the following information to create a pie chart.
|Season:||# of Points Scored|
2. What percent of his career points came from the 1988 season?
3. What percent of his career points came from the 1980 season?
The following table shows the grades achieved by 30 pupils in their end of year exam.
4. Based on the number of pupils, how many degrees of a circle graph are allotted per student? What percentage of the pie cart is allotted to “C” grades?
5. Create a pie chart for the information.
2. First we must find the total number of baskets Larry made in the portion of his career represented by the chart. The answer is 21,792. This number represents 100 percent of our chart. To find what percentage of those shots were made in 1988, we write an algebraic word problem that looks this:
What percent of 21,792 is 2275? As an equation:
Pecent of career shots made in 1988 is 10.4%
3. Calculate this the same way:
Percent of shots made in his career in 1980 is 8%
4. There are 31 total grades, 7 of which are “C’s”. To find percentage, just divide: , and then multiply by 100 to get percentage. “C” grades make up 22.5% of the chart .
5. Your pie chart should look something like the image below, with sectors measuring:
- Grade A: Convert to degrees:
- Grade B: Convert to degrees:
- Grade C: Convert to degrees:
- Grade D: Convert to degrees:
- Grade F: Convert to degrees:
1. What is each part of a pie chart called?
2. What part of the circle represents the whole relationship?
3. Based on the data in the table below, which candy sold the most, and which the least?
|Candy Bar||Number sold at the school store||Percentage of Total Sales||Number of Degrees on a Pie Chart|
4. Fill in the chart above with percentages of each candy type sold.
5. Fill in the chart with degrees of a circle required to represent this amount on a pie chart.
6. Create a Pie Chart to represent this data.
7. Based on the data in the table below, which stock has the greatest potential for making money for the investor who owns the stock?
|Company||Shares Owned||Percentage of Total Portfolio||Number of Degrees on a Pie Chart|
8. Fill in the chart with relative percentages of each type of stock.
9. Fill in the chart with degrees of a circle required to represent this amount on a pie chart.
10. Create a Pie Chart to represent this data.
Use the data presented in questions 11-15 to create pie charts for each:
11. Julie runs for one hour per day, reads for two and sleeps nine. She spends about two hours eating, at least one hour on the phone with friends. She hangs out with her family on average 4 hours a day, and spends at least five hours a day studying.
12. Mrs. Garcia makes $1200.00 a month. She puts 10% in savings, spends 20% on her car payment and insurance, and another 20% on groceries. She likes clothes, so 10% of her income goes towards her wardrobe. Of her remaining money she spends 30% on her mortgage, and the remainder on miscellaneous expenses. Determine exactly how much Mrs. Garcia spends in each category. What percent of her income goes to miscellaneous expenses?
13. Katie earned 500.00 doing odd jobs for people in her neighborhood. She spent of her money on the movies, she spent of her money going out with friends. She spent on clothes, and the remainder on books. How much money did Katie spend on movies? What percentage was spent on books?
14. The state of Colorado receives 28 inches of precipitation a year. The winter is when it gets most of it, but it does not see it until it melts and runs off in the spring. However, inches are counted when they accumulate, and so they represent precipitation for Colorado based on a 4 season year. Colorado receives of its precipitation in the winter, in the spring and the rest in the summer and fall months.
15. Students were preparing to go on a field trip, and their teacher let them choose the destination. There were 36 students in the class. 44.4% choose the Nature Preserve, 25% chose an Art Gallery. Half as many students wanted to go to the Symphony as the Nature Preserve, and the rest wanted to go to the Museum of Nature and Science. How many more students were there that wanted to go to the Nature Preserve than wanted to go to the Museum of Nature and Science?