Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started