Data containing the two variables, COLLEGE and INCOME, for 40 adults, assignment help
Attached are data containing the two variables, COLLEGE and INCOME, for 40 adults. COLLEGE is operationalized as number of years of college completed and INCOME is operationalized as gross annual income in $1,000. The data are to be used as specified in the questions.
1. a) For INCOME, construct a frequency distribution with an interval width of 20 and 19as the minimum income limit of the lowest interval.
b) Construct a histogram of the above (i.e., 1a) frequency distribution.
c) What are the characteristics of this distribution (i.e., 1c)?
2. For INCOME, what are the range, mode, and median?
3. a) Convert INCOME to standard scores.
b) Calculate the mean and standard deviation for the above (question 3a) standard scores.
4. In a normal distribution, what proportion of the cases fall between:
a) z = -1.50 and z = +1.50?
b) z = -2.28 and z = O?
c) z = -0.80 and z = -1.60?
The mean age of your sample is 39 with a standard deviation of 5.
d) What percent of the persons are between 40 and 50?
5. a) Construct a scatterplot showing the relationship between COLLEGE and INCOME.
b) Describe the relationship between COLLEGE and INCOME based on the above scatterplot
(i.e., question 5a).
c) For COLLEGE and INCOME, calculate the Pearson coefficient of correlation.
d) Describe the relationship between COLLEGE and INCOME based on the Pearson
coefficient of correlation.
6. a) For COLLEGE and INCOME compute the intercept and slope for the Y-on-X regression equation; state the regression equation.
Based on the findings from question 6a:
b) Compute the standard error of the mean.
c) For 5 years of college, what would the predicted income be?
d) What would income be if college = 8?
7. Studies have found that the national average of hours worked per week for college students is 20. For a sample of UGF students, the hours worked per week are as follows: 18, 20, 25, 26, and 31. You would like to determine whether UGF students tend to work more hours per week than the national average.
a) State the null and alternative hypotheses in text form.
b) Calculate the test statistic (determine which test you should use).
c) Determine the critical value (t_{.05}).
d) Make decision on the null hypothesis and draw conclusions.
8. Formulate an applicable research (i.e., substantive) question that would use a one-way (simple) analysis of variance. In describing your research question specify the following.
a) the dependent variable;
b) the independent variable and the treatment conditions or the populations
c) the null and alternative hypotheses in text form.
9. The Office of Institutional Research at UGF would like to examine the age distribution of the student population. The office would like to determine whether the distribution of ages for a sample is different from the distribution of ages for the student population. A sample of students is selected and the relative frequencies for the age categories are as follows for the sample (observed frequency) and the population (expected frequency):
Age group: 18-20 21-24 25-29 Over 30
Sample: 33 42 18 7
Population: 27 30 26 17
a) State the null and alternative hypotheses in text form.
b) Compute the Chi-square.
c) Draw conclusions at the 0.05 level of significance.
CASE |
COLLEGE |
INCOME |
1 |
4 |
72 |
2 |
1 |
59 |
3 |
0 |
26 |
4 |
12 |
83 |
5 |
3 |
28 |
6 |
10 |
97 |
7 |
2 |
45 |
8 |
1 |
33 |
9 |
0 |
28 |
10 |
12 |
82 |
11 |
1 |
35 |
12 |
21 |
83 |
13 |
1 |
29 |
14 |
2 |
25 |
15 |
1 |
52 |
16 |
2 |
19 |
17 |
3 |
66 |
18 |
2 |
70 |
19 |
16 |
93 |
20 |
15 |
88 |
21 |
18 |
242 |
22 |
0 |
240 |
23 |
0 |
35 |
24 |
17 |
93 |
25 |
1 |
42 |
26 |
21 |
98 |
27 |
7 |
55 |
28 |
15 |
69 |
29 |
4 |
63 |
30 |
4 |
58 |
31 |
1 |
25 |
32 |
3 |
65 |
33 |
2 |
33 |
34 |
5 |
66 |
35 |
12 |
71 |
36 |
6 |
78 |
37 |
26 |
311 |
38 |
0 |
27 |
39 |
20 |
132 |
40 |
11 |
56 |
Tutor Answer
hello,just finalising.here is the excel document
COLLEGE
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
4
1
0
12
3
10
2
1
0
12
1
21
1
2
1
2
3
2
16
15
18
0
0
17
1
21
7
15
4
4
1
3
2
5
12
6
26
0
20
11
INCOME
4
59
26
83
28
97
45
33
28
82
35
83
29
25
52
19
66
70
93
88
242
240
35
93
42
98
55
69
63
58
25
65
33
66
71
78
311
27
132
56
labels
19-38
39-58
59-78
79-98
99-118
119-138
139-158
159-178
179-198
199-218
219-238
239-258
259-278
279-298
299-318
upper limit
38
58
78
98
118
138
158
178
198
218
238
258
278
298
318
Bin
38
58
78
98
118
138
158
178
198
218
238
258
278
298
318
More
350
300
250
iincome
CASE
200
150
100
50
0
0
5
Frequency
12
6
10...
Brown University
1271 Tutors
California Institute of Technology
2131 Tutors
Carnegie Mellon University
982 Tutors
Columbia University
1256 Tutors
Dartmouth University
2113 Tutors
Emory University
2279 Tutors
Harvard University
599 Tutors
Massachusetts Institute of Technology
2319 Tutors
New York University
1645 Tutors
Notre Dam University
1911 Tutors
Oklahoma University
2122 Tutors
Pennsylvania State University
932 Tutors
Princeton University
1211 Tutors
Stanford University
983 Tutors
University of California
1282 Tutors
Oxford University
123 Tutors
Yale University
2325 Tutors