1. Complete a regression analysis using Age (x variable) to predict Payrate (y variable). A.Paste your regression analysis output below.

B.using the output in part a, write out the linear equation to predict payrate based on our data set.

C. Use your regression equation in part b to estimate the payrate of a 45-year-old and a 55-year-old employee.

2. Management wants to know if there are differences in Payrate based on Ethnicity at Company ABC. They ask you to determine if there is an average difference in payrate by ethnicity. Perform an ANOVA to determine how to answer this question using data from Table 1 above. Use a significance level of 0.05.

A. Write out the null and alternative hypothesis for this ANOVA test.

B. The data for the Hypothesis Test can be found in Table 3 below. Enter the data into Excel.

Table 3: Payrate by Ethnicity

White	African American	Hispanic
38.5	33.5	40
50.5	44	55
54	42	48.5
54.5	52	53
53		55
55

C. Use a significance level of 0.05. Run an ANOVA using the data from Table 3. Paste the Excel output below.

D. Using your output in part c, what are the average payrates for White, African American and Hispanic sales representatives at Company ABC?

E. What is the p-value of the ANOVA test?

F. What decision do you make regarding the null hypothesis?

G. How would you answer Managements question: Is there a significant difference in payrate by ethnicity at Company ABC?