xlsx.xlsx - ID Salary 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15...

This preview shows page 1 - 8 out of 33 pages.

We have textbook solutions for you!
The document you are viewing contains questions related to this textbook.
Introductory Econometrics: A Modern Approach
The document you are viewing contains questions related to this textbook.
Chapter 7 / Exercise 7.2
Introductory Econometrics: A Modern Approach
Wooldridge
Expert Verified
ID Salary Midpoint Age Service Gender Raise Degree 1 58 1.018 57 34 85 8 0 5.7 0 2 28 0.902 31 52 80 7 0 3.9 0 3 33.8 1.089 31 30 75 5 1 3.6 1 4 64.8 1.137 57 42 100 16 0 5.5 1 5 48.7 1.014 48 36 90 16 0 5.7 1 6 75.4 1.126 67 36 70 12 0 4.5 1 7 41.6 1.039 40 32 100 8 1 5.7 1 8 23.6 1.028 23 32 90 9 1 5.8 1 9 73.8 1.102 67 49 100 10 0 4 1 10 22.5 0.980 23 30 80 7 1 4.7 1 11 24.1 1.046 23 41 100 19 1 4.8 1 12 58.3 1.023 57 52 95 22 0 4.5 0 13 41.4 1.035 40 30 100 2 1 4.7 0 14 23.2 1.008 23 32 90 12 1 6 1 15 22.5 0.978 23 32 80 8 1 4.9 1 16 44.7 1.117 40 44 90 4 0 5.7 0 17 63.8 1.120 57 27 55 3 1 3 1 18 34.9 1.127 31 31 80 11 1 5.6 0 19 24.9 1.083 23 32 85 1 0 4.6 1 20 33.4 1.076 31 44 70 16 1 4.8 0 21 73.5 1.097 67 43 95 13 0 6.3 1 22 51.4 1.071 48 48 65 6 1 3.8 1 23 25.1 1.090 23 36 65 6 1 3.3 0 24 48.6 1.013 48 30 75 9 1 3.8 0 25 24.4 1.062 23 41 70 4 0 4 0 26 24.3 1.058 23 22 95 2 1 6.2 0 27 39.2 0.980 40 35 80 7 0 3.9 1 28 75.8 1.131 67 44 95 9 1 4.4 0 29 76.3 1.139 67 52 95 5 0 5.4 0 30 48.6 1.012 48 45 90 18 0 4.3 0 31 23.4 1.018 23 29 60 4 1 3.9 1 32 27.5 0.886 31 25 95 4 0 5.6 0 33 58 1.018 57 35 90 9 0 5.5 1 34 27 0.871 31 26 80 2 0 4.9 1 35 23 0.998 23 23 90 4 1 5.3 0 36 23 1.001 23 27 75 3 1 4.3 0 37 23.6 1.026 23 22 95 2 1 6.2 0 38 60.8 1.066 57 45 95 11 0 4.5 0 39 35 1.129 31 27 90 6 1 5.5 0 40 24.3 1.056 23 24 90 2 0 6.3 0 41 40.5 1.013 40 25 80 5 0 4.3 0 42 22.6 0.982 23 32 100 8 1 5.7 1 Compa- ratio Performance Rating
We have textbook solutions for you!
The document you are viewing contains questions related to this textbook.
Introductory Econometrics: A Modern Approach
The document you are viewing contains questions related to this textbook.
Chapter 7 / Exercise 7.2
Introductory Econometrics: A Modern Approach
Wooldridge
Expert Verified
43 76 1.134 67 42 95 20 1 5.5 0 44 63.1 1.107 57 45 90 16 0 5.2 1 45 52.9 1.103 48 36 95 8 1 5.2 1 46 59.1 1.036 57 39 75 20 0 3.9 1 47 62.6 1.099 57 37 95 5 0 5.5 1 48 67.4 1.183 57 34 90 11 1 5.3 1 49 58.4 1.025 57 41 95 21 0 6.6 0 50 61.4 1.077 57 38 80 12 0 4.6 0
Gender1 Grade M E The ongoing question that the weekly assignments will focus on is: Are M B Note: to simplfy the analysis, we will assume that jobs within each grad F B M E The column labels in the table mean: M D ID – Employee sample number Salary – Salary in thousands M F Age – Age in years Performance Rating - Appraisal F C Service – Years of service (round Gender – 0 = male, 1 = female F A Midpoint – salary grade midpoint Raise – percent of last raise M F Grade – job/pay grade Degree (0= BS\BA 1 = MS) F A Gender1 (Male or Female) Compa-ratio - salary divided by F A M E F C F A F A M C F E F B M A F B M F F D F A F D M A F A M C F F M F M D F A M B M E M B F A F A F A M E F B M A M C F A Do not manipuilate Data set on this page, copy to another page to make changes
F F M E F D M E M E F E M E M E
e males and females paid the same for equal work (under the Equal Pay Act)? de comprise equal work. l rating (employee evaluation score) y midpoint
Week 1: Descriptive Statistics, including Probability While the lectures will examine our equal pay question from the compa-ratio viewpoint, our weekly assi examining the issue using the salary measure. The purpose of this assignmnent is two fold: 1. Demonstrate mastery with Excel tools. 2. Develop descriptive statistics to help examine the question. 3. Interpret descriptive outcomes The first issue in examining salary data to determine if we - as a company - are paying males and female descriptive statistics to give us something to make a preliminary decision on whether we have an issue o 1 Descriptive Statistics The first step in analyzing data sets is to find some summary descriptive statistics for key vari Suggestion: Copy the gender1 and compa-ratio columns from the Data tab to columns T and U Then use Data Sort (by gender1) to get all the male and female compa-ratio values grouped to a. Use the Descriptive Statistics function in the Data Analysis tab to develop the descriptive statistics summary for the overall C group's overall salary. (Place K19 in output range.)

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture