Math 1010

Statistics Unit

2.3 Tables and Graphs

Frequency Table – Average Teacher Salaries by State 2012-2013

Average Salary	Number of States	Relative Frequency
<$45,000	2	4%
$45,000 - $50,000	15	30%
$50,000 - $55,000	12	24%
$55,000 - $60,000	7	14%
$60,000 - $65,000	5	10%
>$65,000	9	18%

1. Create a bar graph showing average teacher salaries.



2. Create a bar graph showing starting teacher salaries. You will first need to create a frequency table.



Frequency Table – U.S. Vehicle Sales September 2015

Type of Vehicle	Number Sold	Relative Frequency
Cars	619,109	44%
Pickup Trucks	214,743	15%
SUV/Crossovers	529,817	38%
Minivans	43,877	3%
Total	1,407,546	100%

3. Create a pie chart showing percentages of each type of vehicle sold in September 2015.



4. Create a bar graph showing vehicles sold in September 2015.



Time Chart - Percentage of U.S. Population that is Foreign –Born

Year	Percent Foreign-Born
1940	8.8
1950	6.9
1960	5.4
1970	4.7
1980	6.2
1990	8.0
2000	10.4
2010	12.2

5. Create a time series graph showing the percentage of U.S. population that is foreign-born from 1940 to 2010.

Using Excel

Part 1: Teacher Salaries

1. Copy and paste the data into a new sheet so you don’t lose the original data.
2. Delete any columns you don’t need.
   1. Select the column
   2. “delete sheet column.”
3. Sort the salary data smallest to largest.
   1. First highlight the cells you want to sort.
   2. You can choose to sort A-Z or Z-A.
   3. Click yes to expand the selection.
4. Make a frequency table.
   1. For average salaries you can use ranges <45000, 45000-50000, 50000-55000, 55000-60000, 60000-65000, >65000
   2. For starting salaries you can use ranges 25000-30000, 30000-35000, 35000-40000, 40000-45000, 45000-50000
5. Create a graph for the number of states in each salary range.
   1. Highlight the frequency table you made
   2. Click “insert” a graph
   3. Label the axes by adding axis titles and give the graph a descriptive title.
6. Copy and paste the graph into a Word document. Save your Word document on your H drive or One Drive.

Part 2: Number of States in Each Region

1. Copy the original data into another new sheet.
   1. You may delete all columns except state names and regions.
2. Sort the data according to Region.
3. Make a frequency table showing the number of states in each region.
4. Create a bar graph for the number of states in each region.
5. Label the axes and give the bar graph a descriptive title.
6. Save your bar graph to your Word document.

Part 3: Percent of States in Each Region

1. Make another table showing the percentage of states in each region.
2. Create a circle graph for the percentage of states in each region.
3. Choose a style for your circle graph so that the percentages are labeled.
4. Give a descriptive title to your circle graph.
5. Save your circle graph to your Word document.

Part 4: States in Region with Income Tax

1. Copy the original data onto another new sheet.
   1. Delete the first two header rows.
2. Insert an empty row above all the data.
3. Filter the data so that only the states in the Southeast are showing.
   1. Highlight the data
   2. Click “filter.”
4. Sort the data according to whether these states have a state income tax.
5. Start a table showing the percentage of states in a particular region with an income tax. Record the percentage of Southeast states that have an income tax.
6. Clear the filter.
7. Filter the data so that only the Northeast states are showing.
8. Sort the data according to whether these states have a state income tax.
9. Add to your table the percentage of Northeast states with an income tax.
10. Continue with the other three regions.
11. Create a clustered column graph showing the percentage of states in each region with an income tax. Label axes with titles and give a descriptive title to your graph.
12. Save your clustered column graph to your Word document.

Part 5: States in the Region with or without Income Tax

1. Copy the original data onto a new sheet.
   1. Delete the first two header rows
   2. Delete the salary columns.
2. Filter the data so that only the Southeast states are showing.
3. Sort the income tax column.
4. Start a frequency table showing the numbers of Southeast states with and without an income tax.
5. Clear the filter. Now filter so that only the Northeast states are showing. Sort the income tax column.
6. Add to your frequency table the numbers of Northeast states with and without an income tax.
7. Highlight the frequency table and insert a stacked column OR clustered bar graph. Label axes and give a descriptive title.
8. Save graph to your Word document.

Extra note:

To edit the axis numbering on a graph, click on your graph. Then from the drop down menu in the upper left corner of Excel, select Vertical (Value) Axis. Click Format Selection right under the drop down menu. In the box that opens on the right side of your screen, click on the picture of the histogram. Then edit the numbers accordingly. You can also edit the Horizontal Axis if needed.