Question

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 (The Boston Globe, September 29, 2011). 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 wage of workers with various levels of education. She collects a sample of the 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. A portion of the data is shown in the accompanying table; the complete data.

In a report, use the above information in SPSS to:

1. Use descriptive statistics to compare the hourly wages of the three education levels. Include description/summary of appropriate graphs.
2. Construct and interpret 95% confidence intervals for the mean hourly wage at each education level.

Analysis should be typed, double spaced, 12 pt font, times new roman, ariel, or Calibri.

TEXT only. How do I do both questions in excel?

Answer 1