Question
Just need the correct excel formula to calculate how many cents per dollar a woman with a Baccalaureate degree earns compared to a man with
Just need the correct excel formula to calculate how many cents per dollar a woman with a Baccalaureate degree earns compared to a man with a high school diploma for each of the years.
| Year | Men, high school graduates | Women, bachelor's degree or higher |
| 1979 | $936 | $802 |
| 1980 | 896 | 795 |
| 1981 | 890 | 795 |
| 1982 | 882 | 816 |
| 1983 | 878 | 835 |
| 1984 | 866 | 846 |
| 1985 | 855 | 870 |
| 1986 | 858 | 899 |
| 1987 | 844 | 930 |
| 1988 | 840 | 933 |
| 1989 | 830 | 935 |
| 1990 | 807 | 940 |
| 1991 | 797 | 953 |
| 1992 | 792 | 982 |
| 1993 | 785 | 985 |
| 1994 | 784 | 1,002 |
| 1995 | 782 | 994 |
| 1996 | 776 | 988 |
| 1997 | 787 | 988 |
| 1998 | 811 | 1,026 |
| 1999 | 824 | 1,051 |
| 2000 | 813 | 1,040 |
| 2001 | 814 | 1,051 |
| 2002 | 812 | 1,064 |
| 2003 | 808 | 1,071 |
| 2004 | 808 | 1,078 |
| 2005 | 790 | 1,070 |
| 2006 | 796 | 1,062 |
| 2007 | 787 | 1,064 |
| 2008 | 780 | 1,051 |
| 2009 | 790 | 1,071 |
| 2010 | 771 | 1,071 |
| 2011 | 758 | 1,051 |
| 2012 | 758 | 1,032 |
| 2013 | 744 | 1,060 |
| 2014 | 751 | 1,049 |
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started
Statistics Principles And Methods
Authors: Richard A. Johnson, Gouri K. Bhattacharyya
7th Edition
8126557745, 470904119, 978-0470904114
