Directions ***Use the data from Table 1 above to answer Questions 9- 14.** 8) If you conduct a survey and there is a 75% chance of selecting someone who will complete the survey, what is the probability of selecting someone who will not complete the survey? Make sure to show your calculations for full credit. 9) You want to randomly select two employee surveys to review. ** If you randomly select two employee surveys with replacement, what is probability of selecting 2 males? Make sure to show your calculations for full credit. ** ** If you randomly select two employee surveys without replacement, what is the probability of selecting 2 males? Make sure to show your calculations for full credit. ** 10) What is the probability of randomly selecting an employee survey that is female and hispanic? Make sure to show your calculations for full credit. 11) You create a distribution of payrate of our employees. The mean pay rate is 48. The standard deviation is 7. **What is the z-score for a pay rate of 34? Make sure to show your calculations for full credit. 12) In 2-3 sentences, explain what this z score tells us. 13) You want to determine which factors are associated with Payrate. • Create a scatterplot of Payrate and Employee Satisfaction in Excel. Paste your graph below. Make sure your graph has a proper title and axes labels. • Find the correlation coefficient of Payrate and Employee Satisfaction. Paste your correlation coefficient below. Interpret the direction and strength of the correlation coefficient in 2-3 sentences. • Create a scatterplot of Payrate and Age in Excel. Paste your graph below. Make sure your graph has a proper title and axes labels. • Find the correlation coefficient of Payrate and Age. Paste your correlation coefficient below. Interpret the direction and strength of the correlation coefficient in 2-3 sentences. • Using your answers from part B and part D, is employee satisfaction or age more strongly correlated with Payrate? Explain in 2-3 sentences. 14) Complete a regression analysis using Age (x variable) to predict Payrate (y variable). • Paste your regression analysis output from Excel below. • Using the output in part a, write out the linear equation to predict payrate based on your data set. • Use your regression equation in part B to estimate the payrate of a 45-year-old and a 55-year-old employee. Make sure to show your calculations for full credit.