Question

In: Statistics and Probability

A researcher interviews 50 employees of a large manufacturer and collects data on each worker’s hourly...

A researcher interviews 50 employees of a large manufacturer and collects data on each worker’s hourly wage (Wage), years of higher education (EDUC), experience (EXPER), and age (AGE). The data is shown below; the data set can also be found on the text website; labeled Hourly Wage. You will be examining the relationships between the following variables: wage and any relationship of this variable to 1) education and 2) experience. Must use either Minitab or Excel to develop both the scatter plots and find the correlation coefficients.

Wage

EDUC EXPER AGE Gender
37.85 11 2 40 1
21.72 4 1 39 0
14.34 4 2 38 0
21.26 5 9 53 1
24.65 6 15 59 1
25.65 6 12 36 1
15.45 9 5 45 0
20.39 4 12 37 0
29.13 5 14 37 1
27.33 11 3 43 1
18.02 8 5 32 0
20.39 9 18 40 1
24.18 7 1 49 1
17.29 4 10 43 0
15.61 1 9 31 0
35.07 9 22 45 0
40.33 11 3 31 1
20.39 4 14 55 0
16.61 6 5 30 1
16.33 9 3 28 0
23.15 6 15 60 1
20.39 4 13 32 0
14.88 4 9 58 1
13.88 5 4 28 0
17.65 6 5 40 1
15.45 6 2 37 0
26.35 4 18 52 1
19.15 6 4 44 0
16.61 6 4 57 0
18.39 9 3 30 1
15.45 5 8 43 0
18.02 7 6 31 1
13.44 4 3 33 0
17.66 6 23 51 1
16.96 4 15 37 0
14.34 4 9 45 0
15.45 6 3 55 0
17.43 5 14 57 0
35.89 9 16 36 1
20.39 4 20 60 1
11.81 4 5 35 0
15.45 9 10 34 0
17.66 5 4 28 1
13.87 6 1 25 0
16.35 7 10 43 1
15.45 9 2 42 1
23.67 4 17 47 0
16.02 11 2 46 1
23.15 4 15 52 0
24.18 8 11 64 0

Please use either Minitab or Excel to develop both the scatter plots and find the correlation coefficients.



A. Which variable is the response variable? Which variables are the explanatory variables?

B. Develop a scatter plot comparing wage to education. Interpret the plot.

C. Develop a scatter plot comparing wage to experience. Interpret the plot.

D. Compute the correlation coefficients for wage and education and wage and experience. Then perform a hypothesis test for both correlations to determine if the correlations are statistically significant. Be sure to show the null and alternative hypotheses, decision rule, decisions and conclusions. Use alpha = .05. Note: Since the hypotheses and decision rule are the same for both tests, only need to write those steps once.  

E. Which of the explanatory variables provides the best predictor of the response variable? Support your response by citing both the scatter plot and correlation test.

Solutions

Expert Solution



Related Solutions

A researcher interviews 50 employees of a large manufacturer and collects data on each worker’s hourly...
A researcher interviews 50 employees of a large manufacturer and collects data on each worker’s hourly wage (Wage), years of higher education (EDUC), experience (EXPER), and age (AGE). The data is shown below; the data set can also be found on the text website; labeled Hourly Wage. Wage EDUC EXPER AGE 37.85 11 2 40 21.72 4 1 39 14.34 4 2 38 21.26 5 9 53 24.65 6 15 59 25.65 6 12 36 15.45 9 5 45 20.39...
A researcher interviews 50 employees of a large manufacturer and collects data on each worker’s hourly...
A researcher interviews 50 employees of a large manufacturer and collects data on each worker’s hourly wage (Wage), years of higher education (EDUC), experience (EXPER), and age (AGE). The data is shown below; the data set can also be found on the text website; labeled Hourly Wage. You will be examining the relationships between the following variables: wage and any relationship of this variable to 1) education and 2) experience. Must use either Minitab or Excel to develop both the...
Statistics Homework The management staff of a grocery products manufacturer collects data on 50 routes. For...
Statistics Homework The management staff of a grocery products manufacturer collects data on 50 routes. For each route the factor variable is the mileage and response variable is the shipping rate (dollars per 100 pound). 1. Make a scatterplot and add the regression line. 2. Interpret the slope in the words of the problem. 3. Find the coefficient of determination and interpret. 4. Find the correlation coefficient and interpret. 5. Find and interpret a 95% Confidence Interval for the true...
Statistics Homework The management staff of a grocery products manufacturer collects data on 50 routes. For...
Statistics Homework The management staff of a grocery products manufacturer collects data on 50 routes. For each route the factor variable is the mileage and response variable is the shipping rate (dollars per 100 pound). 1. Make a scatterplot and add the regression line. 2. Interpret the slope in the words of the problem. 3. Find the coefficient of determination and interpret. 4. Find the correlation coefficient and interpret. 5. Find and interpret a 95% Confidence Interval for the true...
The file Assign1_Data contains data on the hourly wages (Hourly Wage) of all employees of a...
The file Assign1_Data contains data on the hourly wages (Hourly Wage) of all employees of a grocery chain in the Ottawa region. (a) Treating this set of data as the population, use Minitab to calculate the population mean and the population standard deviation for the Hourly Wage variable. (b) Examine a boxplot and histogram of the population data. Explain if the means of all possible random samples of size 40 from this population would form a normal distribution. (c) Using...
The research center of a university collects data on employment and hourly earnings in private industry...
The research center of a university collects data on employment and hourly earnings in private industry groups. Eighteen people working in the manufacturing industry are selected at random. Their average hourly earnings, in dollars, are as follows. 52.6 45.9 62.0 74.2 80.6 77.5 34.8 46.8 48.4 68.7 41.2 52.5 58.9 66.2 69.9 57.1 63.3 102.9 (a) Construct a frequency distribution and a relative frequency distribution for these hourly earnings. Use a first cutpoint of 34 and classes of equal width...
A researcher doing interviews with immigrants in the U.S. records the place of birth for each...
A researcher doing interviews with immigrants in the U.S. records the place of birth for each of her ten respondents. Her data is shown in the following table. Person Place of Birth Person Place of Birth 1 North America 6 Africa 2 Central America 7 Africa 3 Central America 8 Africa 4 South America 9 Europe 5 Asia 10 Europe Complete the following frequency table. (10 points) Place of Birth (X) f % Sketch a bar graph or histogram for...
A researcher is collecting data in a large community. For each scenario identify the bias. Match...
A researcher is collecting data in a large community. For each scenario identify the bias. Match the number with the letter. 1. The researcher begins with mentioning that the survey will take 30 minutes of their time. 2. No one seems to be home at four houses on her route. She does not return at a later time to try to find residents at home, but leaves them a phone number to contact her. 3. She selects a block where...
Assume that a researcher wants to collect data to make inference about the hourly wage in...
Assume that a researcher wants to collect data to make inference about the hourly wage in New Paltz area. The hourly wage in New Paltz area also follows a normal distribution and the standard deviation is also $5. What will be the required sample size, if the researcher wants to achieve a desired margin of error at $1.00 at the significant level of 95%. What will be the required sample size, if the researcher wants to achieve a desired margin...
Imagine a researcher collects data on drivers’ Gender, Type of Vehicle, and Speed of Travel. Which...
Imagine a researcher collects data on drivers’ Gender, Type of Vehicle, and Speed of Travel. Which measure of central tendency would be appropriate for each of these variables?
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT