Practice Midterm
Instructions:
1. Put your answers into a Word document. Show your work; I give partial credit if a problem is set up right and a calculation error makes the answer wrong.
2. Do not copy the questions, but do enter the question number for each answer.
3. If there are questions you want to answer using pen or pencil, write the answers on a worksheet (a blank sheet of paper). Note in the Word document that the answer is on the worksheet. Staple the worksheet to the printed Word document.
4. Do not include your name in the Word document. Rather, put your DePaul id# in the upper left-hand corner. If you don't remember your DePaul id#, I can tell you.
5. Do not use any technology other than Word and Excel on the lab's computer. No calculators, no phones, no nothing. Any deviation from this policy will result in a grade of F on the exam.
6. Once the exam has started you may not leave the room until you have finished and handed in your answers. This includes runs to the bathroom.
Questions:
1. Open the file teen births 1995-2004. If you automatically open up a chart, click the tab on the bottom left to move to the worksheet named "Data."
a. Would a pie graph be appropriate for these data? State the most important reason why or why not.
b. Would a bar or column graph be appropriate for these data? Briefly explain why or why not.
c. Would a line or xy scatter graph be appropriate for these data? Briefly explain why or why not.
2. What was the percentage change in the number of teen births between 1995 and 2004?
3. Create an effective chart of the teen birth data and copy it into your Word document.
4. Open the file on smoking behavior. The data show how many people in a 1997 survey of Chicagoans said that they smoked and how many said they did not smoke.
a. Would a pie graph be appropriate for these data? State the most important reason why or why not.
b. Would a bar or column graph be appropriate for these data? Briefly explain why or why not.
c. Would a line or xy scatter graph be appropriate for these data? Briefly explain why or why not.
5. What is the number of smokers as a percentage of nonsmokers?
6. In percentage terms, how many more nonsmokers are there than smokers?
7. Open the file RacebyState. [If it opens to a column graph, click the worksheet tab named "Data" in the lower left-hand portion of the screen.] Sort the data [which is in rows 6-56] according to the percentage of the population that is African-American. Copy the information for the three states having the largest percentage of African-Americans and for the three having the smallest.
8. State for each of these variables [found in the Excel files for questions 1, 2, and 4] whether it is an absolute or relative quantity and briefly explain why.
a. Number of women aged 15-19 (in thousands)
b. Percent white Hispanic
c. Number of smokers
9. Compute the rate of teen births per 1000. Round your results to one decimal place. Copy the results for the most recent three years into your Word document.
10. In the teen birth data, select the worksheet named "Chart 1." Fix the error in the chart. Copy the repaired chart into your Word document.
11. Evaluate the following chart in terms of the qualities of good charts and bad charts.
12. In three consecutive years, the price of a share of International Widgets, Inc. rose 8%, then rose 7%, then fell 4%. What was the percentage change in the price of the stock in those three years?