Solve the following:
Q1: 1. There are two data tables above, one for the election in November, 2004 and one for the election in November, 2000. Organize the data into one table that will show year to year changes.
2. Format the new table so that it is easy to read. You may change the appearance in any way that you feel is more effective.
3. Calculate and add to the table the following (insert rows and columns as needed):
the total population for 2004 and for 2000
the total number of registered voters for 2004 and for 2000
the percentage registered and percent voted for the total population 18+
calculate the change for each category from 2000 to 2004
Be sure to enter formulas so that Excel does the calculations for you. Do not use a calculator!
4. Create a chart (graph) that tells a story about some aspect of the information. Do not put all of the information in your chart. Include labels/titles as needed.
5. Write a paragraph that explains what the table and chart tell you.
Q2. On the right is a table showing births for each day of the week.
What is the average number of births per day? [Use an Excel function.]
Show the data in the table in a chart.
Write a sentence or two about your conclusions.
| day |
births |
| Sun |
7563 |
| Mon |
11733 |
| Tues |
13001 |
| Wed |
12598 |
| Thurs |
12514 |
| Fri |
12396 |
| Sat |
8605 |
Q3: When you have loaded the Data Analysis Toolpak, highlight the data set below and use Descriptive Statistics in the Toolpak.
If you are not using Excel or have difficulty loading it, please let your instructor know in this space.
Below is data for the 50 countries with the lowest GDP per capita. Use the Data Analysis Toolpak to generate Descriptive Statistics for this data set.
In the Descriptive Statistics dialogue box, you will select the data.
Check "Summary Statistics."
Select an Output Range on this worksheet.
| Zimbabwe |
$200 |
| Congo, Democratic Republic of the |
$300 |
| Burundi |
$400 |
| Liberia |
$500 |
| Guinea-Bissau |
$600 |
| Somalia |
$600 |
| Central African Republic |
$700 |
| Niger |
$700 |
| Sierra Leone |
$700 |
| Eritrea |
$700 |
| Afghanistan |
$800 |
| Malawi |
$800 |
| Ethiopia |
$800 |
| Mozambique |
$900 |
| Togo |
$900 |
| Rwanda |
$900 |
| Comoros |
$1,000 |
| Madagascar |
$1,000 |
| Tokelau |
$1,000 |
| Guinea |
$1,100 |
| Nepal |
$1,100 |
| Uganda |
$1,100 |
| Burma |
$1,200 |
| Burkina Faso |
$1,200 |
| Mali |
$1,200 |
| Gambia, The |
$1,300 |
| Haiti |
$1,300 |
| Tanzania |
$1,300 |
| Sao Tome and Principe |
$1,300 |
| Bangladesh |
$1,500 |
| Ghana |
$1,500 |
| Zambia |
$1,500 |
| Benin |
$1,500 |
| Chad |
$1,600 |
| Kenya |
$1,600 |
| Lesotho |
$1,600 |
| Tuvalu |
$1,600 |
| Senegal |
$1,600 |
| Cote d'Ivoire |
$1,700 |
| Korea, North |
$1,700 |
| Solomon Islands |
$1,900 |
| Cambodia |
$2,000 |
| Kyrgyzstan |
$2,100 |
| Laos |
$2,100 |
| Mauritania |
$2,100 |
| Tajikistan |
$2,100 |
| Micronesia, Federated States of |
$2,200 |
| Sudan |
$2,200 |
| Papua New Guinea |
$2,200 |
| Cameroon |
$2,300 |
| Kosovo |
$2,300 |