Texas is home to more than one million undocumented immigrants and most
of them are stuck in low-paying jobs. Meanwhile, the state also suffers
from a lack of skilled workers. The Texas Workforce Commission
estimates that 133,000 jobs are currently unfilled, many because
employers cannot find qualified applicants. Texas was the first state
to pass a law that allows children of undocumented immigrants to pay
in-state college tuition rates if they have lived in Texas for three
years and plan to become permanent residents. The law passed easily
back in 2001 because most legislators believed that producing college
graduates and keeping them in Texas benefits the business community. In
addition, since college graduates earn more money, they also provide
the state with more revenue. Carol Capaldo wishes to estimate the mean
hourly wages of 30 Texas workers with a bachelor's degree or higher, 30
Texas workers with only a high school diploma, and 30 Texas workers who
did not finish high school.
The attached Excel data file contains the hourly wage of Texas
workers based on the three education levels; bachelor's degree, high
school diploma, no high school diploma.
In a report, use the above information to:
1. Use descriptive statistics to compare the hourly wages of the three education levels.
2. Construct and interpret 95% confidence intervals for the mean hourly wage at each education level.