Question: A B C D E Team Rank Kicks Goals Tackles 2 Geelong Cats 211.5 17.2 58 3 Port Adelaide Power 2 200.2 14.9 50.5 4


A B C D E Team Rank Kicks Goals Tackles 2 Geelong Cats 211.5 17.2 58 3 Port Adelaide Power 2 200.2 14.9 50.5 4 Fremantle Dockers 203.3 15.1 51.9 5 Essendon Bombers 211.9 14.6 48.6 6 Carlton Blues 197.3 14.2 52.4 7 Western Bulldogs 6 206.2 14 51.6 8 West Coast Eagles 204.3 13.8 52.2 9 North Melbourne Kangaroos 8 189 13.6 55 10 Hawthorn Hawks 9 199.3 13.7 46.5 11 Collingwood Magpies 10 220.6 13.1 58.2 12 Sydney Swans 11 199.4 13.5 56.4 13 Brisbane Lions 12 186.9 12.9 58 14 Richmond Tigers 13 201.1 13 44.9 15 Adelaide Crows 14 201.4 12.4 51.4 16 Melbourne Demons 15 196.6 12.4 56 17 St Kilda Saints 16 199.9 12.1 52.6 18 Z 17 186 12.5 41 19QUESTION 5 Open the Excel file DF1.6 that is in the CML 1 Data Files folder under the CML Quizzes tab. Copy the following data below (that is in bold). Add this data as a new row to the existing data file DF1.6. It is easiest to make this new data the last row the existing data file. Team Rank Kicks Goals Tackles Z 17 186 12.5 41 After you add this new row to DF1.6, use Excel to calculate the coefficient of correlation between goals and tackles (as a number between -1 and 1 correct to four decimal places)
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
