Based on the information below, can you please help me find the Correlation coefficient for each of the possible pairings of variables and describe the relationship in terms of strength and direction. Please note: This website does not allow me to upload the actual excel sheet, just photos
Excel File Edit View Insert Format t Tools Data Window Help 51% Wed 3:35 PM Q DE Log In | LoudCloud Systems X Ho AutoSave OFF 3 Excel data Home Insert Draw Page Layout Formulas Data - > C a coursehero.com/tutors/homework Review View Tell me Share Comments Apps Bookmarks Calibri (Body) v 12 A A = ab v Conditional Formatting Format as Table Paste BIUV MVAv Number Cells 2 7 V Cell Styles v Editing Ideas Sensitivity Favorites Name untitled folder J12 X Recents Formula Bar County of A Applications A 2014 (x ) 2016 (y) Y2 y2 Residence (x) (y) Class 7 2 Alpine O 0 Class 6 Amador 56 36 2,016 3136 1,296 Class 4 Butte 49 251 37,79 301,401 $3,001 Del Norte 91 31 2,821 Class 3 8,281 961 El Dorado 318 143 45,474 101,124 20,449 Class 2 Fresno 2,130 367 1,846,710 4,536,900 751,689 Class 1 Glenn 89 35 3,115 7,921 ,225 Downloads Humbold 322 139 44,758 103,684 19,321 Imperial 364 147 50,862 132,496 21,609 iCloud Kern ,762 794 1,399,028 3,104,644 630,436 . Desktop 12 Lake 11 62 9,282 6,721 3,844 Documents 13 Lassen 551 18 990 3,025 24 iCloud Drive 14 Los Angeles 20,636 3,336 172,021,696 425,844,496 59,488,896 15 Marin 94 48 1,512 3,836 2,304 Locations Mariposa 22 14/ 308 184 196 Network 17 Mendocino 281 140 $9,340 78,961 9,600 Merced 651 274 78,374 423,801 75,076 Media Monterey 377 162 61,074 142,129 26,244 Photos Nap 50 64 ,600 22,5001 4,0961 Tags 21 Nevada 99/ 22 2,178 9,801 84 Red Orange 2,393 ,017 2,433,681 5,726,449 1,034,289 Riverside 4,724 1,688 Orange 7,975,122 22,316,176 2,849,344 24 Sacramento 2,911 1,310 3,813,410 8,473,921 1,716,100 Yellow San Bernardino 4,866 2,210 10,753, 860 23,677,956 4,884,100 Green 26 San Diego 3,505 1,224 4,290,120 12,285,025 1,498,176 Sheet1 Options + Ready - + 70% DEC .. 16 W XExcel File Edit View Insert Format t Tools Data Window Help 51% Wed 3:35 PM Q DE Log In | LoudCloud Systems X Ho AutoSave OFF 3 Excel data Home Insert Draw Page Layout Formulas Data Review View Tell me - > C a coursehero.com/tutors/homework Share Comments Calibri (Body) v 12 A A = ab v Conditional Formatting Apps Bookmarks E V Format as Table Paste BIUV MVAv Number Cells Editing Ideas Name Cell Styles v Sensitivity Favorites untitled folder J12 X V fx Recents 19 Monterey 377 162 61,074 142, 129 26,244 A Applications 20 Napa 150 64 ,600 22,500 4,0961 Class 7 1 0 21 Nevada 991 22 .178 9.801 484 Class 6 22 Orang ,393 1, 017 2,433,681 5,726,449 ,034,289 Class 4 23 Riverside 1, 724 1,688 7,975,122 22,316,176 ,849,344 24 Sacramento 2,911 ,310 3,813,410 8,473,921 1,716,100 Class 3 25 San Bernardino 4,866 ,210 10,753, 860 23,677,956 1,884,100 Class 2 San Diego ,505 ,22 1,290,120 12,285,025 1,498,176 Class 1 San Luis 342 195 66,690 1 16,964 38,025 Downloads Obispo Santa Barbara 498 219 09,062 248,004 47,961 iCloud Santa Cruz 268 137 36,716 1,824 18,769 . Desktop 30 Shasta 25 93 20,625 $90,625 37,249 Documents 31 Sierra iCloud Drive E(x)(y)=205,469,2 Ex2- SUMS Ex=48,489 Zy=19,777 23 508237285 83,199,047 Locations Network Media Photos Tags Red Orange Yellow Green 4 Sheet1 + Options Ready + 70% 1 DEC .(30 16 4 W X
