Bivariate Data & Probability Question 1 Covariance and Correlation coefficient The table below shows a set of bivariate data: X and Y. Calculate the covariance and correlation coefficient by...

Take Home Assignment 2 Bivariate Data & Probability Question 1 Covariance and Correlation coefficient The table below shows a set of bivariate data: X and Y. Calculate the covariance and correlation coefficient by completing the table, assuming sample data. Show all workings. (Note: You can calculate the mean and standard deviation of X & Y with the STAT mode in your calculator and no working is required.) XY(X - X bar)(Y - Y bar)(X - X bar)(Y - Y bar)11038657483 (b)Comment on the strength of the linear association between X and Y. (4 marks) Question 2Corporal Punishment A random sample of 40 students are surveyed on their opinions about reintroducing corporal punishment on a 5 point scale (1 = strongly disagree; 2= disagree; 3 = neither agree nor disagree; 4 = agree; 5 = strongly agree.) The survey results are contained in the data file: Corporal Punishment.xlsx, . (a)Using the Pivot Table in Excel cross tabulate Country of Citizenship and Opinion. Copy and paste the pivot table onto your answer sheet and use the table to answer the following questions. (Show workings.) (i) What is the probability that a randomly selected respondent strongly agrees with corporal punishment? (ii)What is the probability that an Asian strongly agrees with corporal punishment? (iii) What is the probability that a student who strongly agrees with corporal punishment is an Asian? (iv)Would you say respondents’ Opinion and Country of Citizenship are dependent or independent? (5 marks) (b)Use the Pivot Table to find out the average opinion of the male and female respondents. Copy and paste the pivot table onto your answer sheet. (1 marks)