CORRELATION (Coursework Sample)

A manager at a small organization is interested in determining the impact of the recent company outing to Camp Feel-Good on job satisfaction. She would like to compare those who attended and completed the individual and team building exercises during the weekend event to those who did not attend, without making any assumptions regarding which group will have higher job satisfaction. A job satisfaction survey is administered 1 month after the event to 40 employees (20 who attended and 20 who did not attend). The survey is a 10 item Likert scale measure (scale: 1=”Very Dissatisfied" to 5=”Very Satisfied”) with a range of total scores from 10-50, where the higher the score, the greater the level of job satisfaction. Participants Father`s GPA(x) Child`s Socialskills(y) xy x² y² 1 3.24 65 210.6 10.4976 4225 2 2.68 63 168.84 7.1824 3969 3 2.1 61 128.1 4.41 3721 4 3.8 67 254.6 14.44 4489 5 3.26 67 218.42 10.6276 4489 6 3.21 61 195.81 10.3041 3721 7 3.8 70 266 14.44 4900 8 2.5 54 135 6.25 2916 9 2.64 54 142.56 6.9696 2916 10 3.12 58 180.96 9.7344 3364 11 3.08 57 175.56 9.4864 3249 12 3.28 62 203.36 10.7584 3844 13 2.45 59 144.55 6.0025 3481 14 2.83 61 172.63 8.0089 3721 TOTAL 41.99 859 2596.99 129.112 53005 * Table showing fathers Gpa In relation to child social skills My workings as per the above table: r =n(∑xy)-(∑x)(∑y)(n∑x2-(∑x)2}{n∑y2-∑y}2 r =14(2596.99)-(41.99)(859)(14(129.112)-(41.99)2}-(859)²) r = 0.002 b.) For the scatter plot please view the excel file have uploaded to get clear understanding. c. Coefficient of correlation r =n(∑xy)-(∑x)(∑y)[n(∑x2)-(∑x)2][n(∑y2)-(∑y)2] r =14(2596.99)-(∑41.99)(859)[14(129.112)-(41.99)2][14(53005)-(859)2] r = 0.0689 Therefore r²,which is the coefficient of determination will be r² = (0.0689)² r² = 0.004747 That is; 4.747% which we could now use to make our conclusion. Correlation effect is how set of given data are related to each other and from the above result we can confidently conclude that the relationship between the father gpa and child`s social skills is very low. b.) t = r√n-21-(r)² t = 0.002√14-21-(0.002)² t = 0.006928 From this data and tests from the sample we can conclude that based on the workings, there is significant correlation between the fathers GPA and child's social skills. e.) Given the result obtained from the correlation effects calculation(r=0.002), I can tell my friend that the given data are related to each other but the relationship is not strong enoug...