Each question involves statistical inference regarding bivariate relationships. In addition to providing relevant MINITAB 18 output, clearly state your conclusion within the context of the question.
statistics
Description
MBA 501A – [STATISTICS]
ASSIGNMENT 4
INSTRUCTIONS: Each
question involves statistical inference regarding bivariate relationships. In addition to providing relevant MINITAB 18
output, clearly state your conclusion within the context of the question. All data sets for this assignment are
provided (you can download them from Engage).
Paste relevant Minitab output into one WORD document, and submit this WORD document to the drop box by
the deadline. Separate Minitab files
will not be accepted. This assignment is
worth 50 points.
[12 pts] 1. Use the data set EXECUTIVE.MTW. A leading CEO mentoring organization
offers a program for chief
executives, presidents and business owners with a focus on developing entrepreneurial
skills. Are perceptions of the program’s
value the same for men and women? Perform
the Chi Square test for independence. Use α = 0.05. Explain your results.
[12 pts] 2. Use the data set ACADEMIC SALARIES.MTW. Perform the Chi Square test for independence to determine
whether subject and degree are related. Use α =
0.05. Explain your results.
[26 pts] 3. Use the data set POLICE SALARIES.MTW. What
affects the amount of
violent crime? This file contains
data on amount of Violent Crime (crimes per 100,000 population), Police
Officer Wage (mean$/hour) and Graduation Rate (%) for 40
states.
[6 pts] (a) Is
Police Officer Wage significant in
explaining violent
crime rate at
? Justify your conclusion.
[5 pts] (b) What percent of the variability in violent
crime rate is
explained by Police Officer Wage?
[6 pts] (c) Is
Graduation Rate significant in explaining violent crime
rate at? Justify your
conclusion.
[3 pts] (d) Which
model is better for predicting violent crime rate?
Explain.
[6 pts] (e) Construct
residual plots for the “better” model and interpret.
