Review!!!

1. Review!!!

2. Assignment 3 issues • Women in the United States continue to be paid less than men overall.   Nationally, in 2007, the median weekly earnings of female full-time wage and salary workers totaled $614, while it was $766 for males. a. Fill in the blank using the data:  In 2007, male full-time wage and salary workers earned _________ % more than female full-time wage and salary workers.

3. Assignment 3 issues b. What percent of male full-time wage and salary worker median weekly earnings does the female median weekly earnings represent?  (This percentage is often called the women-to-men's earning ratio.)

4. Assignment 3 issues

5. Assignment 3 issues

6. Activity 6 Activity 5 • Know how to Sort and Autosum • Looked good

7. Assignment 4 Chicago “drops” in absolute, but not in rate

8. Assignment 4 g.  There were exactly four cities with population greater than 500,000 with a rate higher than Chicago's.  Which were they? • You can be selective using absolute vs. relative quantities and you can be selective in general

9. Midterm Review Highlights • y = mx + b • For predictions, I’m looking for practical / physical sense of the situation and a rough interpretation of r-squared. • y = P*(1 +/- r)x

10. Excel - lent • Excel fill feature for exponentials

11. Midterm Review Highlights • 10, 11, 12, 13, and 14 • Absolute change • The pesky reference value – earlier value, the one being referred to in “more than”

12. Final Project!!! • A note on late work – previous assignments / activities are due by Friday • Write article and present it • Stage 1 – groups of three / two • Find topic • Answer questions regarding table

13. Finding Tables for Project • On the home page for this class • On tabs to the left click on “Excel Files” • At the very bottom of this page there is a link to “2009 US Statistical Abstract” • Your table number should be under the respective topic.