Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribedimage text in transcribed
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

blur-text-image

Get Instant Access with AI-Powered Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Auditing An International Approach

Authors: Wally J. Smieliauskas, Kathryn Bewley

6th edition

978-0070968295, 9781259087462, 978-0071051415

Students also viewed these Mathematics questions