For this quiz, please construct a correlation matrix using Excel. Here are the data for the...

Transcribed Image Text:

For this quiz, please construct a correlation matrix using Excel. Here are the data for the third problem (quiz): 1. Please download Zeanna's data into Excel 2. Create a correlation matrix 3. Interpret the output by answering the questions Zeana runs a human resources department and wants to know about what factors affect salary. So, she surveyed 100 executives and asked them their salary, how many years of experience they have had, how many years of education they have had and the number of people they supervise. She would like to create a correlation matrix. Critical Values of the Pearson Product-Moment Correlation Coefficient Level of significance (p) df=n-2 (# of pain-2) 0.100 1 2 3 10 11 12 13 14 15 16 17 18 19 21 0.050 0.020 0.010 0.988 0.997 0.999 0.999 0.900 0.950 0.980 0.990 0.805 0.878 0.934 0.959 0.729 0.811 0.882 0.917 0.669 0.754 0.833 0.874 0.622 0.707 0.789 0.834 0.582 0.666 0.750 0.798 0.549 0.632 0.716 0.765 0.521 0.602 0.685 0.735 0.497 0.576 0.658 0.708 0.476 0.553 0.634 0.684 0.458 0.532 0.612 0.661 0.441 0.514 0.592 0.641 0.426 0.497 0.574 0.623 0.412 0.482 0.558 0.606 0.400 0.468 0.542 0.590 0.389 0.456 0.528 0.575 0.378 0.444 0.516 0.561 0.369 0.433 0.503 0.549 0.360 0.423 0.492 0.537 0.352 0.413 0.482 0.526 0.344 0.404 0.472 0.515 0.337 0.396 0.462 0.505 0.330 0.388 0.453 0.496 0.323 0.381 0.445 0.487 0.317 0.374 0.437 0.479 45898007234567822222222222237486288 Step 1: Download the data and open it using Excel Step 2: Open the "Data Analysis" tool Step 3: Choose "Correlation" For the "Input Range" we want to choose all of the columns for all 100 executives (Be careful to click "Labels in first Row" option) Step 4: Click OK - Review your correlation matrix results TOO 0.311 0.367 0.430 0.471 0.306 0.361 0.423 0.463 0.301 0.355 0.416 0.456 0.296 0.349 0.409 0.449 0.275 0.325 0.381 0.418 0.257 0.304 0.358 0.393 0.243 0.288 0.338 0.372 0.231 0.273 0.322 0.354 0.211 0.250 0.295 0.325 0.195 0.232 0.274 0.303 0.183 0217 0.256 0.283 0.173 0.205 0.242 0.164 0.195 0.230 0.267 0.254 Correlation Matrix for Executive Salaries, Years of Experience, Years of Education, and the Number of Employees Supervised Once your analysis is complete, please interpret your Excel output by matching it to the appropriate concept. Remember, the critical r = 0.205 (Click - Drag - and Match: Review carefully double-check your matches) Correlation for Salaries and Years of Experience r(98) = +0.0005 Correlation for Salaries and Number of Employees Supervised r(98) = +0.7831 Correlation for Years of Experience and Years of Education r(98) = +0.2370 Correlation for Salaries and Years of Education r(98) = +0.2011 For this quiz, please construct a correlation matrix using Excel. Here are the data for the third problem (quiz): 1. Please download Zeanna's data into Excel 2. Create a correlation matrix 3. Interpret the output by answering the questions Zeana runs a human resources department and wants to know about what factors affect salary. So, she surveyed 100 executives and asked them their salary, how many years of experience they have had, how many years of education they have had and the number of people they supervise. She would like to create a correlation matrix. Critical Values of the Pearson Product-Moment Correlation Coefficient Level of significance (p) df=n-2 (# of pain-2) 0.100 1 2 3 10 11 12 13 14 15 16 17 18 19 21 0.050 0.020 0.010 0.988 0.997 0.999 0.999 0.900 0.950 0.980 0.990 0.805 0.878 0.934 0.959 0.729 0.811 0.882 0.917 0.669 0.754 0.833 0.874 0.622 0.707 0.789 0.834 0.582 0.666 0.750 0.798 0.549 0.632 0.716 0.765 0.521 0.602 0.685 0.735 0.497 0.576 0.658 0.708 0.476 0.553 0.634 0.684 0.458 0.532 0.612 0.661 0.441 0.514 0.592 0.641 0.426 0.497 0.574 0.623 0.412 0.482 0.558 0.606 0.400 0.468 0.542 0.590 0.389 0.456 0.528 0.575 0.378 0.444 0.516 0.561 0.369 0.433 0.503 0.549 0.360 0.423 0.492 0.537 0.352 0.413 0.482 0.526 0.344 0.404 0.472 0.515 0.337 0.396 0.462 0.505 0.330 0.388 0.453 0.496 0.323 0.381 0.445 0.487 0.317 0.374 0.437 0.479 45898007234567822222222222237486288 Step 1: Download the data and open it using Excel Step 2: Open the "Data Analysis" tool Step 3: Choose "Correlation" For the "Input Range" we want to choose all of the columns for all 100 executives (Be careful to click "Labels in first Row" option) Step 4: Click OK - Review your correlation matrix results TOO 0.311 0.367 0.430 0.471 0.306 0.361 0.423 0.463 0.301 0.355 0.416 0.456 0.296 0.349 0.409 0.449 0.275 0.325 0.381 0.418 0.257 0.304 0.358 0.393 0.243 0.288 0.338 0.372 0.231 0.273 0.322 0.354 0.211 0.250 0.295 0.325 0.195 0.232 0.274 0.303 0.183 0217 0.256 0.283 0.173 0.205 0.242 0.164 0.195 0.230 0.267 0.254 Correlation Matrix for Executive Salaries, Years of Experience, Years of Education, and the Number of Employees Supervised Once your analysis is complete, please interpret your Excel output by matching it to the appropriate concept. Remember, the critical r = 0.205 (Click - Drag - and Match: Review carefully double-check your matches) Correlation for Salaries and Years of Experience r(98) = +0.0005 Correlation for Salaries and Number of Employees Supervised r(98) = +0.7831 Correlation for Years of Experience and Years of Education r(98) = +0.2370 Correlation for Salaries and Years of Education r(98) = +0.2011