# University of Wisconsin Wk 7 Making Statistical on Linear Relationships Excel Task

For each prompt, show a scatterplot of the relationship between the two variables that
includes a trendline, compute the Pearson Linear Correlation Coefficient and estimate a
simple linear regression for the two variables in the question and use these results to answer
the prompt. Include in your answers a hypothesis test on the appropriate regression
coefficient. Therefore, every answer should include the following:
1. Is there evidence of a relationship between satisfaction with one’s supervisors and
overall job satisfaction? If so, is the relationship positive or negative? Is this what you
would expect?
• Start by identifying which is the dependent variable (y) and which is the independent
variable (x) where the value of y depends on the value of x

Scatterplot of the two variables that includes a trendline Note: put (y) on vertical axis

Report of the Pearson Linear Correlation Coefficient value

An interpretation of the magnitude of the Pearson Linear Correlation Coefficient

The equation of the regression line
• Null and alternative hypotheses for the hypothesis test on the coefficient for x (but not
for coefficient for constant)

Show the Excel output for the regression analysis

Identify the x coefficient value and the p-value
• Report the conclusion to either “fail to reject the null hypothesis” or “reject the null
hypothesis”
• Give a plain English conclusion to the statistical test that answers the plain English
question in the prompt.
2. Is there evidence of a relationship between satisfaction with one’s colleagues and overall
job satisfaction? If so, is the relationship positive or negative? Is this what you would
expect?
• Start by identifying which is the dependent variable (y) and which is the independent
variable (x) where the value of y depends on the value of x

Scatterplot of the two variables that includes a trendline Note: put (y) on vertical axis

Report of the Pearson Linear Correlation Coefficient value

An interpretation of the magnitude of the Pearson Linear Correlation Coefficient

The equation of the regression line
• Null and alternative hypotheses for the hypothesis test on the coefficient for x (but not
for coefficient for constant)

Show the Excel output for the regression analysis

Identify the x coefficient value and the p-value
• Report the conclusion to either “fail to reject the null hypothesis” or “reject the null
hypothesis”
• Give a plain English conclusion to the statistical test that answers the plain English
question in the prompt.
3. Is there evidence of a relationship between satisfaction with one’s salary and overall job
satisfaction? If so, is the relationship positive or negative? Is this what you would expect?

Start by identifying which is the dependent variable (y) and which is the independent
variable (x) where the value of y depends on the value of x

Scatterplot of the two variables that includes a trendline Note: put (y) on vertical axis

Report of the Pearson Linear Correlation Coefficient value

An interpretation of the magnitude of the Pearson Linear Correlation Coefficient

The equation of the regression line

Null and alternative hypotheses for the hypothesis test on the coefficient for x (but not
for coefficient for constant)

Show the Excel output for the regression analysis

Identify the x coefficient value and the p-value

Report the conclusion to either “fail to reject the null hypothesis” or “reject the null
hypothesis”

Give a plain English conclusion to the statistical test that answers the plain English
question in the prompt.
Hi Sophia. Your pivot tables are correct and accurate, but your interpretation of the promotion satisfaction question is a bit mistaken. Your table shows that 84.7
s a bit mistaken. Your table shows that 84.73% of the sample have an undergraduate education; it’s not indicating the proportion of undergraduates who are satisfied with their
undergraduates who are satisfied with their promotion.
Gender
Female
Male
Female
Male
Female
Female
Female
Female
Female
Male
Male
Female
Male
Female
Female
Female
Female
Male
Male
Female
Female
Female
Female
Male
Female
Female
Female
Female
Female
Female
Female
Female
Female
Female
Female
Female
Female
Female
Female
Female
Female
Male
Female
Female
Female
Female
Female
Female
Female
Age
NumberChildren
37
56
32
30
41
55
27
34
49
51
28
31
30
43
44
30
27
41
28
42
36
36
45
40
48
24
42
61
30
31
38
33
34
42
36
36
41
36
41
47
33
33
58
39
27
27
29
25
36
Edu
MaritalStatus
Tenure
5
29
8
3
15
12
5
2
20
4
3
5.5
6
22
21
3
1
2
4
10
5
12
17
4
28
1
4
7
4
5
11
12
6
12
2
10
8
4
18
4
8
2
6
12
3.5
5
6
3
15
Female
Female
Female
Female
Male
Female
Female
Female
Male
Female
Male
Female
Female
Female
Female
Female
Male
Female
Female
Female
Female
Female
Female
Female
Male
Male
Female
Female
Female
Female
Female
Female
Female
Female
Male
Female
Female
Female
Female
Female
Female
Male
Female
Female
Female
Female
Female
Female
Female
Female
40
25
43
39
33
34
42
30
49
30
34
33
34
34
27
33
32
38
41
49
30
52
25
47
40
30
43
33
38
28
34
39
46
25
42
30
39
28
27
31
30
31
35
32
31
26
36
25
37
51
5
2
18
2
1
3
9
6
18
5
10
5
2
9
1.5
6
10
11
15
18
5
2
2
14
15
3
6
7
15
4
10
4
7
3
18
10
3
2
1.5
8
6
5
13
10
9
2
8
1.5
16
20
Male
Female
Male
Female
Male
Female
Female
Female
Male
Female
Female
Female
Female
Female
Female
Female
Female
Male
Female
Female
Male
Female
Female
Female
Female
Male
Female
Female
Female
Female
Female
Female
Female
Female
Female
Female
Female
Female
Male
Female
Female
Female
Female
Male
Female
Female
Male
Female
Female
Female
27
26
40
36
41
27
45
26
42
29
32
33
28
24
31
25
39
27
33
49
24
26
25
29
26
27
33
22
23
24
25
26
26
24
26
24
44
25
25
31
22
37
29
24
23
26
28
23
22
24
5
1
3
4.5
8
2
19
1
16
2
1
6
4
1
9
1
5
1
1
14
1
2
3
2
1
4
2
1
1
2
1.5
2
1
1
1
1
7
2
1
2
1
8
2.5
1
1
4
5
1.8
1
1.5
Female
Female
Female
Female
Female
Female
Female
Female
Female
Female
Male
Female
Female
Female
Female
Female
Female
Female
Female
Female
Female
Female
Female
Male
Female
Male
Female
Female
Female
Female
Male
Female
Female
Female
Female
Male
Female
Female
Female
Male
Female
Female
Female
Female
Male
Female
Female
Female
Female
Male
45
45
37
54
38
53
37
33
40
53
42
32
35
57
43
36
42
38
62
56
55
47
37
31
39
37
41
47
47
48
31
44
45
43
25
35
28
32
29
34
35
30
33
49
42
50
50
42
53
32
Married
Married
Married
Married
Married
Married
Married
Married
Married
Married
Married
Married
Married
Married
Married
Married
Married
Married
Married
Married
Married
Married
Single
Single
Divorced
Divorced
Divorced
Divorced
Divorced
Divorced
Married
7
6
1
16
10
26
4
10
14
9.5
2
6
11
22
5
1
9
9
17
24
13
16
14
2
15
10
16
20
25
4
7
15
8
20
1
10
4
6
7
5
4
3
10
19
20
19
2
5
22
2
Female
Female
Female
Female
45
44
43
43
12
11
16
20
Region
North
South
Center
North
South
Center
Center
South
South
South
South
Center
North
South
South
South
South
North
North
South
South
North
Center
Center
South
South
South
South
South
South
South
Center
Center
Center
Center
North
South
North
Center
South
South
South
Center
Center
Center
North
North
North
South
Ethnicity
Jewish
Jewish
Arab
Arab
Jewish
Jewish
Jewish
Jewish
Jewish
Jewish
Jewish
Jewish
Arab
Jewish
Jewish
Jewish
Jewish
Arab
Arab
Jewish
Jewish
Jewish
Jewish
Jewish
Jewish
Jewish
Jewish
Jewish
Jewish
Jewish
Jewish
Arab
Arab
Jewish
Jewish
Arab
Jewish
Jewish
Jewish
Jewish
Jewish
Arab
Jewish
Jewish
Jewish
Arab
Arab
Arab
Jewish
Overall_Satisfaction
Colleague_Satisfaction
42
89
76
51
75
68
62
90
68
76
81
69
72
60
68
90
72
65
71
75
76
72
56
68
57
67
86
72
82
72
51
49
75
75
67
69
76
82
75
69
75
64
49
71
64
61
71
64
65
62
92
92
62
79
71
92
87
92
83
100
85
73
69
98
92
90
75
81
77
81
92
60
44
94
98
83
46
73
73
56
48
77
77
79
67
60
75
73
60
81
60
69
79
65
73
85
63
73
South
South
South
South
Center
Center
Center
North
North
North
North
North
North
North
South
South
Center
Center
South
South
South
South
South
South
South
Center
Center
North
North
North
North
Center
South
Center
Center
Center
Center
Center
North
North
South
South
Center
Center
North
South
South
South
Center
Center
Jewish
Jewish
Jewish
Jewish
Arab
Jewish
Jewish
Arab
Arab
Arab
Arab
Jewish
Jewish
Jewish
Jewish
Jewish
Arab
Jewish
Jewish
Jewish
Jewish
Jewish
Jewish
Jewish
Arab
Jewish
Jewish
Arab
Arab
Jewish
Jewish
Jewish
Jewish
Arab
Arab
Arab
Jewish
Jewish
Arab
Jewish
Jewish
Arab
Arab
Arab
Arab
Jewish
Jewish
Jewish
Arab
Jewish
50
60
50
69
54
71
51
42
62
49
81
64
61
69
68
76
57
67
61
64
75
86
57
60
61
56
51
57
53
69
65
58
69
53
61
60
64
68
58
60
81
61
71
29
53
47
60
69
49
64
71
67
90
40
50
65
60
62
75
73
73
79
69
79
88
27
50
48
67
69
69
79
81
92
52
85
69
69
67
77
71
52
62
54
71
60
77
77
58
75
71
67
62
46
52
62
27
62
62
71
North
North
South
Center
Center
Center
South
South
Center
South
South
Center
North
South
North
South
South
North
South
South
South
South
North
North
South
South
South
Center
North
North
North
South
South
North
North
South
South
South
South
South
North
North
South
South
Center
North
North
North
North
Center
Arab
Arab
Arab
Arab
Arab
Arab
Jewish
Jewish
Arab
Jewish
Jewish
Jewish
Jewish
Jewish
Arab
Jewish
Jewish
Arab
Arab
Jewish
Arab
Jewish
Arab
Jewish
Jewish
Arab
Jewish
Arab
Arab
Arab
Jewish
Jewish
Jewish
Arab
Jewish
Jewish
Jewish
Jewish
Arab
Jewish
Arab
Jewish
Jewish
Arab
Arab
Arab
Arab
Arab
Arab
Arab
57
43
54
71
61
46
60
39
35
78
79
75
81
92
67
79
61
53
81
74
78
74
53
64
75
72
88
72
68
61
78
56
58
64
64
64
72
36
50
64
68
62
78
33
61
49
79
39
57
74
54
48
42
60
44
40
50
54
69
92
69
75
81
96
88
90
69
65
62
60
62
96
69
67
90
73
77
69
73
56
73
60
83
65
54
67
60
54
46
71
40
63
83
77
54
69
33
60
69
81
Center
South
South
South
South
South
South
North
South
South
South
South
Center
South
North
Center
South
Center
South
Center
Center
Center
South
South
Center
South
South
Center
South
South
South
Center
Center
Center
South
South
North
North
Center
South
Center
Center
North
Center
South
Center
South
Center
South
South
Jewish
Jewish
Jewish
Jewish
Arab
Jewish
Jewish
Jewish
Jewish
Jewish
Arab
Arab
Jewish
Jewish
Jewish
Arab
Jewish
Jewish
Jewish
Jewish
Jewish
Jewish
Jewish
Arab
Jewish
Jewish
Jewish
Jewish
Jewish
Jewish
Arab
Jewish
Jewish
Jewish
Jewish
Arab
Arab
Jewish
Jewish
Arab
Jewish
Arab
Jewish
Jewish
Arab
Jewish
Jewish
Jewish
Jewish
Arab
83
78
68
64
82
71
74
67
60
78
72
81
68
72
65
60
74
72
61
68
75
71
64
68
68
64
81
40
75
76
68
57
68
69
53
78
46
83
61
79
64
93
51
76
74
89
93
69
82
65
88
69
96
67
88
96
87
88
85
77
69
73
33
79
56
85
88
88
63
79
77
75
46
73
58
63
79
65
63
81
52
90
79
75
65
44
44
75
73
75
44
65
71
67
65
56
83
77
15
60
South
North
South
South
Jewish
Arab
Jewish
Jewish
51
68
67
92
31
73
63
0
Supervision_Satisfaction
Salary_Satisfaction
50
95
86
28
88
54
86
91
88
90
88
73
87
63
87
85
85
72
79
79
67
97
59
76
72
41
79
62
60
92
71
64
22
87
79
67
32
63
88
59
92
74
77
88
85
49
83
63
85
Promotion_Satisfaction
13
45
77
100
52
58
42
52
42
42
74
58
52
61
84
32
29
58
65
77
71
68
58
39
26
48
35
77
29
55
58
39
71
16
19
42
10
55
42
48
39
58
58
35
58
42
45
35
52
12
78
57
90
72
45
50
82
82
82
82
57
60
38
75
70
68
72
40
55
45
40
50
42
48
95
55
60
75
42
60
10
62
48
48
50
18
32
55
60
75
55
55
57
45
45
72
35
60
79
77
77
13
67
81
65
58
72
50
87
77
71
69
78
59
56
44
82
63
69
85
78
71
62
83
62
76
1
79
62
41
67
50
72
12
85
74
71
4
73
62
55
19
58
60
58
83
59
67
29
52
74
48
32
26
32
35
26
35
68
29
35
39
23
77
61
29
58
45
61
55
61
65
48
23
48
39
29
55
29
58
39
52
68
45
55
39
45
68
71
58
55
26
29
26
65
16
45
32
75
45
78
40
57
38
52
45
35
28
45
55
55
40
55
52
40
32
62
72
68
55
60
60
40
55
25
32
85
50
40
20
57
30
78
40
57
38
48
57
45
52
32
20
32
45
48
65
32
30
65
83
62
54
55
47
35
53
55
92
72
78
78
94
83
73
78
69
91
74
85
82
79
74
72
74
78
65
88
68
79
74
65
78
82
68
77
51
55
62
56
53
62
59
73
64
58
49
50
74
42
19
19
26
48
26
26
13
13
45
71
35
71
61
61
42
45
58
39
52
39
45
55
65
19
42
48
74
29
45
42
39
29
13
10
55
48
71
52
77
23
26
32
52
19
65
68
71
32
23
65
65
50
18
30
18
10
62
22
50
25
62
88
95
70
72
35
62
52
65
60
80
50
48
45
80
52
68
38
35
62
25
52
62
40
65
32
40
55
75
40
15
50
52
65
38
38
52
35
22
67
81
99
38
76
1
67
72
83
74
81
72
47
82
69
97
91
90
55
63
73
86
68
85
60
74
78
74
72
50
41
0
86
67
62
63
50
81
73
13
51
79
64
69
59
82
83
45
38
42
16
39
10
58
55
61
71
13
74
45
77
52
35
48
42
32
23
52
68
77
52
35
42
65
45
48
48
55
32
32
45
23
19
29
16
39
87
29
39
52
48
48
45
35
65
65
45
35
58
29
18
57
48
50
85
62
90
48
80
50
65
65
32
78
42
28
57
52
70
72
42
45
25
75
48
68
60
65
20
40
55
25
42
45
48
40
38
52
48
78
62
62
12
52
48
60
30
22
15
32
42
59
63
33
29
42
65
52
25
42
40
5
PhysicalWorkspace_Satisfaction
Burnout_Rate
57
38
33
14
29
10
43
38
33
29
38
38
19
24
48
29
33
38
29
29
29
19
33
48
67
43
14
29
48
48
14
33
38
57
33
48
52
67
24
24
29
38
48
38
38
71
33
52
43
Turnover_Rate
55
7
36
43
19
29
36
10
19
24
21
17
14
40
21
21
12
40
19
33
17
29
38
21
29
24
12
33
29
38
43
52
26
40
29
33
17
31
26
64
17
33
31
26
29
36
14
31
31
Autonomy_Rate
85
18
18
21
24
24
27
30
33
33
33
33
33
36
36
39
42
42
42
42
42
42
42
42
45
45
45
45
45
45
45
45
45
45
45
45
45
45
45
48
48
48
48
48
48
48
48
48
52
70
40
25
55
55
60
35
40
55
40
40
25
45
20
55
65
55
50
50
40
50
25
75
50
35
60
55
60
50
45
40
60
45
30
50
60
50
50
35
25
45
60
45
35
30
55
65
70
50
52
71
48
62
38
14
38
52
48
62
48
43
29
38
19
33
52
24
33
33
38
14
29
38
86
48
38
67
48
29
57
19
19
33
33
57
62
38
52
52
52
52
48
71
57
48
19
38
52
48
24
24
43
26
36
26
26
33
33
40
33
29
36
36
26
79
55
36
38
14
29
10
31
40
71
43
33
29
14
14
38
31
26
43
29
38
40
43
50
24
26
50
48
40
60
31
67
26
55
33
52
52
52
52
52
52
52
52
52
52
52
52
52
52
55
55
55
55
58
58
58
58
58
58
58
58
58
58
58
58
58
58
61
61
61
61
61
61
61
61
64
64
64
64
64
64
64
67
67
67
65
50
35
75
55
55
55
55
70
55
60
35
60
45
55
40
55
65
25
45
25
40
45
35
45
50
55
50
55
50
40
60
50
35
50
50
60
55
70
70
40
40
75
90
65
45
45
55
60
55
33
43
71
57
62
81
10
38
57
33
10
43
43
29
10
29
48
48
43
38
38
38
29
29
38
19
29
33
33
43
33
38
29
52
38
38
52
29
38
14
52
52
48
57
33
43
43
76
62
38
31
62
50
48
45
57
36
40
57
7
29
26
24
5
36
26
17
40
26
10
31
24
45
45
26
31
26
31
29
33
26
36
38
29
29
33
31
52
50
45
33
45
45
60
48
36
88
45
57
21
67
67
70
76
76
82
85
85
85
30
30
30
30
33
39
45
45
45
48
48
52
52
52
52
55
55
55
55
55
55
55
58
61
61
61
64
64
64
64
64
67
67
70
70
70
70
73
76
82
36
60
45
70
55
35
85
40
50
60
30
45
40
30
45
75
40
65
25
40
25
45
35
50
80
40
55
35
45
55
60
65
45
50
50
70
55
70
55
45
15
30
60
60
55
50
30
40
45
55
50
48
33
86
43
33
29
33
33
10
43
14
71
57
38
43
10
5
62
33
29
33
48
33
48
33
29
38
48
29
10
62
43
38
48
33
76
81
29
43
48
0
38
38
38
57
14
38
10
33
52
10
26
24
29
29
29
36
29
19
31
19
31
24
21
26
24
17
21
60
29
31
19
31
24
17
21
17
57
21
31
60
48
17
24
36
48
36
17
29
55
19
17
45
33
19
24
26
19
74
36
36
39
39
39
39
39
39
39
42
42
42
42
42
30
30
36
42
45
67
30
42
42
45
45
45
48
48
52
55
55
58
58
58
58
61
61
61
61
64
70
70
42
64
36
42
33
42
48
76
64
60
55
45
50
15
40
50
40
45
60
25
60
65
50
45
30
55
45
40
45
25
45
60
45
25
55
40
55
55
20
50
45
40
35
55
75
70
35
25
40
45
35
55
45
40
40
50
45
35
55
48
29
38
81
31
43
29
98
36
42
55
97
85
50
50
25
Conflict_Rate
69
62
31
56
56
56
56
69
56
56
38
56
50
44
69
75
38
38
75
69
50
50
94
31
62
38
31
94
62
88
31
31
56
75
81
50
81
75
38
75
62
38
25
69
75
62
50
44
69
21
36
50
57
57
79
0
50
57
50
64
57
64
64
43
29
57
71
50
21
64
64
36
57
14
36
50
50
21
50
57
50
64
43
43
50
43
29
64
36
64
50
43
43
21
57
50
57
57
75
81
62
62
50
38
62
50
31
38
56
75
50
62
62
75
44
75
69
69
50
56
62
44
69
44
38
38
69
44
88
56
25
62
69
75
62
81
50
31
62
31
88
94
38
75
19
81
75
56
57
50
36
57
50
57
64
57
50
50
36
50
36
57
57
36
36
29
29
50
50
71
50
64
21
21
57
43
36
79
29
36
64
86
50
50
29
36
86
57
29
64
29
21
64
29
71
29
29
29
56
69
69
94
38
56
50
69
69
69
62
31
69
19
38
75
75
38
62
100
50
75
38
50
31
56
56
69
44
50
69
56
31
44
31
38
50
31
69
25
50
69
62
62
50
75
75
94
25
69
57
57
43
29
50
36
50
29
64
50
50
64
36
79
71
43
50
50
57
71
43
57
50
43
71
50
71
71
43
43
64
64
64
43
64
43
57
71
57
93
50
50
50
43
50
36
43
43
50
57
75
50
69
56
38
62
75
44
69
69
19
50
94
81
69
50
25
62
50
62
44
75
69
56
62
25
56
81
81
44
50
56
62
69
50
50
81
81
62
88
44
62
38
44
25
88
75
50
56
31
29
21
21
57
64
50
43
36
57
21
64
36
64
57
43
50
57
50
36
57
71
50
43
50
36
57
50
14
21
50
64
43
43
43
57
57
43
43
29
21
57
57
57
57
71
36
36
14
36
50
75
50
56
12
29
50
29
43
Row Labels
Arab
Jewish
Grand Total
Mean of Overall_Satisfaction
Mean of Colleague_Satisfaction
62.01449275
63.66666667
68.39552239
71.50746269
66.22660099
68.84236453
There is highest Job satisfaction among Jewish, with an average
satisfaction rate of 68.3, compared to Arabs with 62.01. Colleague
Satisfaction has highest average rate among all factors.
Mean of Supervision_Satisfaction
Mean of Salary_Satisfaction
62.56521739
46.68115942
69.46268657
45.06716418
67.1182266
45.61576355
Mean of Promotion_Satisfaction
Mean of PhysicalWorkspace_Satisfaction
48.89855072
46.5942029
51.3880597
36.62686567
50.54187192
40.01477833
Row Labels
Arab
Jewish
Grand Total
Count of Ethnicity
33.99%
66.01%
100.00%
From the sample, 66.01% are identified as Jewish and Arab 33.99
respectively. Jews are above half the population.
and Arab 33.99%,
Row Labels
Grand Total
Education
15.27%
84.73%
100.00%
Undergraduates are far satisfied with promotion,
with 84.73% of the population indicating so,
compared to 15.27% of the graduate.
Row Labels
Center
North
South
Grand Total
60.72
54.82
56.66
57.35
Workers in the central part seem to have a high average
workload rate at 60.72%, higher than the overate
workload rate, compared to the north and south, which
have 54.82 and 56.66%, respectively. All rates are rounded
eem to have a high average
her than the overate
the north and south, which
ectively. All rates are rounded
Row Labels
Center
North
South
Grand Total
Samle of Burnout_Rate
33.09
35.57
31.93
33.13
The overall average burnout stands at
33.13. The north part account for the
highest burnout rate at 35.57.
1
6.7 | Unit 6 Assignment: Making Statistical Inferences on Means
Sophia Choi
Question1 : Do Jewish social workers and Arab social workers have different average levels of
overall job satisfaction? Test the appropriate hypothesis. If there is evidence for a difference,
which ethnicity of worker on average has a higher level of job satisfaction?
t-Test: Two-Sample Assuming Unequal Variances
Mean
Variance
Observations
Hypothesized Mean
Difference
df
t Stat
P(T

Don't use plagiarized sources. Get Your Custom Essay on
University of Wisconsin Wk 7 Making Statistical on Linear Relationships Excel Task
Just from \$13/Page
Calculator

Total price:\$26
Our features

## Need a better grade? We've got you covered.

Order your essay today and save 20% with the discount code GOLDEN