Wage Graduate Age Wage Graduate Age Wage Graduate Age Wage Graduate Age 53 1 47 0 32 0 43 0 42 1 47 0 41 1 55 1 48 1 46 1 42 0 40 39 0 54 1 5228222483722 53 1 38 49 0 50 47 1 27 40 1 23 53 1 40 46 1 32 40 1 24 46 0 60 0 48 39 34 0 73 57 1 48 44 1 28 44 1 28 42 0 71 54 1 46 44 1 27 44 0 51 49 1 31 51 1 65 37 1 23 50 1 54 46 43 0 33 32 0 23 49 40 68 53 1 53 52 1 62 50 0 52 49 1 65 55 1 45 50 1 39 48 1 35 45 0 54 46 56 49 0 46 47 1 33 37 0 32 41 0 31 48 1 66 48 1 39 44 1 70 49 0 56 47 0 55 48 1 43 41 0 31 45 0 43 48 0 51 45 40 56 1 50 50 0 39 144 0 65 47 1 66 39 0 28 47 0 47 50 1 35 50 61 45 0 64 38 0 71 50 1 58 55 1 57 56 57 50 1 60 44 1 29 51 39 49 1 33 50 0 49 49 0 44 51 1 55 45 1 28 39 0 30 46 1 26 39 1 24 53 1 38 43 0 55 50 1 44 50 1 62 45 1 72 41 0 28 38 0 28 48 55 55 1 37 53 1 55 48 0 45 54 1 52 41 0 64 50 1 61 48 0 44 52 53 46 1 64 49 1 37 49 1 32 42 1 25 57 1 51 45 1 71 55 1 58 52 58 46 0 57 51 1 56 47 1 68 39 1 23 45 0 62 51 1 33 42 0 63 55 1 47 57 1 51 57 1 55 39 0 24 44 0 64 35 0 44 1 46 0 50 0 47 1 52 1 47 0 51 1 53 1 45 1 45 1 48 1 44 0 FE86622736233 71 34 0 25 45 0 34 44 1 30 71 47 1 25 46 1 30 56 52 1 35 48 1 70 57 53 1 49 50 1 38 34 0 23 45 0 51 48 43 0 64 54 1 42 59 53 1 39 51 1 65 54 53 1 63 52 1 41 47 1 31 44 1 72 42 0 64 54 1 45 55 1 46 55 1 53 65 53 1 59 48 0 42 53 1 41 43 0 30
Use Excel to Run the Regressions:
1. Wage and Age: Do you think a worker’s wage is related to his/her age? It is expected that wages
increase with age up to certain age, after that wages go down. The “Wage Quadratic Data” file
posted contains data on the hourly wage (in $) for construction workers, workers’ age
and whether the worker has a bachelor’s degree or not (Graduate equals 1 if the worker has a
bachelor’s degree and 0 otherwise). Use the data file to answer the following questions:
A) Build a model to predict the hourly wage of construction workers based on their education and
age.
B) Use the model to predict the hourly wage for a college graduate construction worker if his/her
age is 30, 50, and 70
c) Based on your model, calculate the age at which the hourly wage for construction workers is
maximized.
Unlock instant AI solutions
Tap the button
to generate a solution