Reference no: EM132376653

Data Analysis and Management

Case Study:

Part A

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 estimate 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 rate 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 that 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 rate of wages of workers with various levels of education. She collects a sample of the hourly wages in $ of 30 workers who did not finish high school.

Using the excel file Texas Wages, report using the following:

1. Calculate descriptive statistics to compare the hourly wages for the three education levels. Then discuss the results by providing interpretation of these using the correct terminology and values.

2. Construct and interpret 95% confidence intervals for the mean hourly wages at each education level.

Part B.

Hypothesis Testing

The data of MPG file shows the miles per gallon (MPG)

1. Calculate descriptive statistics to provide an understanding of MPG first. Provide an interpretation of what the data is stated from the summary.

2. a. State the null and alternative hypothesis in order to test whether the average MPG differs from 95.

2. b. Calculate the value of the test statistic and the p-value

2. c. At a=0.05 can you conclude that the average MPG Differs from 95?

Part C

Statistical Interference with two Populations

Using data of Tractor Times:

1. Calculate descriptive statistics to provide an understanding of Tractor Times first. Provide an interpretation of what the data is stated from the summary.

2. a. Set up the hypotheses to test the claim that the mean assembly time using the new method is less that the old method.

2. b. Calculate the value of the test statistic and the p-value. Assume that population variance are not equal.

c. At the 5% significance level, what is the conclusion.

Attachment:- Case Study.zip