1 342 350 300 200 400 400 311 317 300 214 400 400 350 200 238 1 442 400 417 425

1 342 350 300 200 400 400 311 317 300 214 400 400 350

This preview shows page 34 - 37 out of 198 pages.

1 3.42 3.50 3.00 2.00 4.00 4.00 3.11 3.17 3.00 2.14 4.00 4.00 3.50 2.00 2.38 1 4.42 4.00 4.17 4.25 4.00 3.75 4.00 3.83 3.00 4.00 4.40 4.00 4.00 3.00 4.31 1 3.58 3.50 3.00 3.25 3.67 3.25 3.56 2.83 3.50 3.71 3.60 4.00 4.00 3.00 3.63 1 3.91 4.50 3.33 3.25 4.00 4.25 2.89 2.50 2.50 3.57 4.80 5.00 3.00 4.33 3.63 1 4.42 3.00 2.83 3.00 4.00 4.00 2.33 3.08 2.50 3.71 3.80 5.00 4.50 4.00 3.06 1 2.25 2.50 2.00 2.50 3.00 3.25 3.22 2.75 2.00 2.00 2.80 1.50 3.50 4.00 2.75 1 4.00 4.00 3.33 4.00 4.67 2.75 4.11 2.67 3.50 3.71 4.80 4.50 5.00 3.33 3.44 1 3.75 4.00 4.00 3.25 4.00 4.25 3.33 3.00 2.50 4.00 4.20 3.00 3.50 4.33 2.19 1 3.25 3.00 3.00 2.75 3.33 3.75 1.44 2.08 1.50 3.29 4.40 4.00 4.50 3.67 2.69 1 3.92 4.50 3.17 2.00 4.33 4.00 2.89 2.75 4.00 3.43 4.80 4.00 3.50 3.00 3.50 1 3.08 3.00 3.50 3.25 3.67 4.00 2.44 2.17 1.50 2.83 4.60 4.00 3.50 3.00 2.56 1 3.33 4.00 3.67 3.75 3.33 3.25 3.50 2.75 4.00 2.57 4.80 4.50 2.00 3.33 3.47 1 3.83 4.00 4.00 4.00 4.00 4.00 3.89 3.58 4.00 2.86 4.20 4.00 3.00 3.00 3.94 1 3.83 2.00 2.50 3.25 2.67 3.50 1.33 1.25 1.50 2.43 5.00 4.00 1.00 3.00 2.31 1 3.67 5.00 3.33 5.00 5.00 3.50 2.89 1.75 1.50 3.57 4.20 5.00 5.00 3.00 3.25 1 3.75 3.50 3.83 3.00 4.00 3.25 3.22 2.67 2.00 3.57 4.20 4.00 2.50 2.33 3.31 1 4.00 3.50 3.50 4.25 4.00 4.75 3.00 2.08 1.50 3.43 4.80 5.00 5.00 3.67 2.69 1 3.17 4.00 2.67 3.00 3.67 4.25 3.78 2.75 3.00 3.00 4.40 3.50 5.00 2.33 3.06 1 3.67 2.50 3.50 3.25 4.33 3.25 2.11 2.25 2.00 3.14 4.80 5.00 3.50 2.33 2.56 1 4.42 3.50 3.67 3.00 4.33 4.00 3.89 3.00 4.00 3.71 3.80 5.00 3.50 3.67 3.50 1 3.08 4.50 4.00 4.00 4.33 4.50 3.11 2.33 1.50 3.00 5.00 4.00 3.50 2.00 3.44 1 3.67 3.00 3.83 3.50 3.67 4.00 2.56 2.42 2.00 3.43 4.20 2.00 3.00 3.33 2.00 1 4.67 3.50 4.00 4.00 3.33 4.50 3.67 3.00 3.00 3.57 4.20 4.50 3.50 3.00 3.75 1 4.33 4.00 4.33 3.50 4.00 3.50 2.67 3.08 4.00 3.43 3.60 4.00 3.50 2.00 3.69 1 4.00 4.00 3.67 4.00 4.33 3.50 2.78 2.33 2.50 3.14 4.80 5.00 3.00 1.67 4.00 1 3.92 3.00 2.67 2.75 3.50 3.50 2.29 2.90 3.00 2.33 4.60 4.00 4.50 2.33 2.77 1 3.75 3.50 3.67 3.75 5.00 4.00 3.56 3.33 3.00 3.43 4.40 4.50 3.00 3.33 2.75 2 4.70 4.00 4.00 2.25 5.00 4.50 3.78 3.38 3.00 3.67 5.00 5.00 3.00 4.00 3.71 2 2.64 2.50 1.83 2.25 3.67 2.00 2.78 1.58 2.00 2.71 3.80 4.50 3.50 3.33 1.44 2 4.67 3.50 4.50 4.00 4.00 4.25 3.44 3.92 4.00 3.71 4.20 4.50 4.00 3.67 4.19
Image of page 34
2 3.92 2.50 3.83 4.25 3.67 3.25 4.22 2.33 2.50 3.29 4.80 5.00 3.50 2.33 2.63 2 3.83 4.00 4.17 3.75 4.00 4.00 3.56 2.67 3.50 4.00 4.40 4.00 2.50 2.67 3.63 2 3.75 3.50 3.83 3.50 4.00 3.25 3.56 2.75 3.00 4.14 4.60 4.00 3.50 2.67 3.63 2 3.83 3.50 4.17 4.00 3.67 3.50 3.50 2.58 2.50 4.00 4.20 4.00 4.00 3.67 4.06 2 4.33 3.50 3.83 4.00 4.33 4.25 4.22 3.08 4.00 3.14 4.60 4.50 4.00 2.33 3.38 2 2.58 2.50 2.83 1.75 3.33 1.25 1.56 1.50 1.50 1.86 4.60 3.00 3.00 2.00 2.13 2 2.92 3.00 2.83 2.00 3.00 2.75 2.56 1.92 2.50 3.43 4.20 4.00 2.00 3.00 2.81 2 3.42 4.00 3.00 3.33 4.00 3.50 3.11 2.42 3.00 3.00 4.60 4.50 3.50 4.00 2.50 2 3.73 3.50 4.00 4.00 4.00 3.00 3.00 2.75 2.50 3.14 4.00 4.00 3.00 3.00 3.63 2 4.25 3.00 3.83 3.75 4.33 4.00 2.89 2.92 3.50 3.00 4.00 4.00 3.00 2.33 3.69 2 4.70 3.00 3.50 4.00 5.00 3.75 4.33 3.67 4.50 3.86 4.80 5.00 3.50 4.33 4.31 2 3.67 4.00 3.67 4.00 4.00 3.50 3.78 3.27 4.50 2.71 4.20 4.50 4.00 3.33 3.81 2 4.17 3.00 3.83 3.50 4.33 3.00 3.22 2.50 4.00 3.57 4.20 2.50 4.00 4.33 4.19 2 3.58 3.50 3.83 1.75 2.67 4.00 1.89 2.25 1.50 2.43 3.80 4.50 1.50 3.67 2.69 2 2.67 3.00 2.67 2.75 3.67 3.50 3.00 2.33 2.00 3.14 4.80 2.00 4.00 2.33 2.56 2 4.09 4.00 3.50 5.00 3.67 4.25 2.67 3.08 2.00 3.29 4.60 3.50 2.50 2.67 3.06 2 2.92 4.00 3.50 4.25 3.00 4.25 3.00 3.08 3.00 2.86 4.60 4.50 3.00 2.67 3.50 2 3.64 2.50 3.50 3.50 4.00 3.00 2.78 3.08 4.00 3.14 4.00 4.50 2.00 2.33 3.00 2 4.17 4.00 3.50 2.75 4.67 4.00 2.78 2.92 4.00 3.71 4.60 4.50 3.00 3.00 3.33 sex Gender: 1=Male; 2=Female org The Organization ini Information indi Direction inf Feedback prwe Work Environment preq Equipment & Supplies prwd Work Disorganization prwc Working Conditions prwco Working Conditions Outcome icad Advancement icim Impact icimo Impact Outcome icpa Pay Administration icpy Pay & Benefits su Immediate Supervisor tr Training cptw Compelling Place to Work itl Intention to Leave
Image of page 35
tr cptw itl PR 1 Define correlation and describe how it's typically u 4.75 4.80 5.00 5.63 3.75 3.70 5.00 4.53 3.50 3.50 3.25 4.02 3.75 3.20 4.00 3.93 3.75 3.80 4.00 4.06 3.25 4.00 4.75 4.16 4.00 4.40 3.00 5.02 2 Calculate the correlation between cptw & itl using 4.00 3.40 4.75 4.35 0.4991 =CORREL(R2:R118,S2:S118) 3.00 4.20 5.00 5.07 3.00 3.90 5.00 4.40 3.25 3.80 4.75 4.62 3 Calculate the correlation between cptw & itl using 3.75 4.20 4.50 4.49 cptw itl 2.75 3.90 4.00 4.19 cptw 1 3.50 4.00 4.50 4.44 itl 0.4991 1 2.33 3.38 4.00 3.85 3.00 4.00 3.50 4.33 3.00 3.30 5.00 3.75 4 What does the term best linear combination mean 4.50 3.50 5.00 4.69 3.25 3.40 4.00 4.16 3.00 3.60 4.00 4.28 3.25 3.50 4.00 4.05 3.50 3.70 5.00 4.93 3.00 4.00 5.00 4.40 3.00 4.30 5.00 4.53 1.25 3.00 3.00 3.95 3.00 2.60 2.75 2.97 5 4.00 4.30 5.00 4.77 3.75 4.20 5.00 4.73 3.25 4.00 4.75 4.37 3.50 3.70 4.75 4.40 6 3.25 2.60 4.25 3.72 4.50 4.60 5.00 5.17 2.50 3.30 3.50 3.94 0.0536 0.4821 0.0683 4.25 4.60 5.00 4.81 0.0561 0.0545 0.0469 3.25 4.10 5.00 4.80 0.4959 0.3662 #N/A 3.00 3.00 4.00 3.81 37.0580 113.0000 #N/A 1.50 3.00 3.75 3.39 2.50 4.40 5.00 5.23 2.00 3.90 3.50 3.88 7 Create a one-way Pivot Table tabulating the freque 3.25 2.70 3.50 3.84 3.67 4.30 4.25 4.99 sex Sum - sex 2.75 3.50 3.50 4.19 1 95 3.00 3.50 4.25 4.00 2 44 3.75 4.30 5.00 4.73 Total Result 139 4.00 3.80 4.00 3.98 3.50 3.60 5.00 4.23 3.00 3.60 5.00 4.37 8 Create a Scatterplot (Scatter Diagram) of itl and the 3.75 3.80 3.50 4.31 3.75 3.90 3.50 4.39 Correlation, represented by the letter r, is the degree meaning the variables vary inversely (negative corre relationship, i.e., r=0. Correlation is typically used to
Image of page 36
Image of page 37

You've reached the end of your free preview.

Want to read all 198 pages?

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

Stuck? We have tutors online 24/7 who can help you get unstuck.
A+ icon
Ask Expert Tutors You can ask You can ask You can ask (will expire )
Answers in as fast as 15 minutes