Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Conduct an analysis of the relationship between income (RINCOME) and age (AGE). Estimate with 95% confidence the average increase in income for each additional year

Conduct an analysis of the relationship between income (RINCOME) and age (AGE). Estimate with 95% confidence the average increase in income for each additional year of age. Please use Excel for solving? Thank you

AGE RINCOME
19 500
19 32,500
19 27,500
19 9,000
19 500
19 2,000
19 4,500
19 2,000
19 3,500
19 3,500
20 3,500
20 6,500
20 18,750
20 3,500
20 2,000
20 4,500
20 3,500
20 2,000
20 6,500
20 500
20 7,500
20 2,000
20 5,500
20 4,500
20 4,500
20 500
20 21,250
21 21,250
21 13,750
21 45,000
21 16,250
21 11,250
21 5,500
21 6,500
21 6,500
21 3,500
21 3,500
21 5,500
21 9,000
21 2,000
21 7,500
21 16,250
22 37,500
22 3,500
22 2,000
22 13,750
22 500
22 3,500
22 13,750
22 11,250
22 500
22 21,250
22 5,500
22 7,500
22 11,250
22 500
22 37,500
22 500
23 6,500
23 32,500
23 18,750
23 3,500
23 21,250
23 4,500
23 3,500
23 21,250
23 9,000
23 7,500
23 3,500
23 21,250
23 2,000
23 16,250
23 27,500
23 3,500
23 5,500
24 2,000
24 16,250
24 45,000
24 32,500
24 32,500
24 13,750
24 21,250
24 11,250
24 4,500
24 13,750
24 3,500
24 6,500
24 16,250
24 13,750
24 4,500
24 37,500
24 13,750
24 21,250
24 27,500
24 2,000
24 11,250
25 27,500
25 55,000
25 4,500
25 11,250
25 13,750
25 32,500
25 7,500
25 7,500
25 37,500
25 500
25 67,500
25 13,750
25 21,250
25 55,000
25 11,250
25 2,000
25 27,500
25 32,500
25 27,500
25 13,750
25 16,250
25 2,000
25 32,500
25 4,500
25 11,250
25 2,000
25 45,000
25 11,250
25 27,500
25 21,250
25 6,500
25 7,500
26 82,500
26 32,500
26 45,000
26 13,750
26 27,500
26 45,000
26 45,000
26 11,250
26 23,750
26 37,500
26 5,500
26 37,500
26 21,250
26 3,500
26 2,000
26 13,750
26 21,250
26 55,000
26 16,250
26 11,250
26 500
26 21,250
26 18,750
26 55,000
26 45,000
26 2,000
26 16,250
26 37,500
26 7,500
26 13,750
26 9,000
26 32,500
26 45,000
26 6,500
26 45,000
26 27,500
27 55,000
27 23,750
27 32,500
27 6,500
27 82,500
27 9,000
27 6,500
27 11,250
27 27,500
27 37,500
27 32,500
27 16,250
27 45,000
27 3,500
27 37,500
27 23,750
27 32,500
27 27,500
27 3,500
27 32,500
27 55,000
27 23,750
27 13,750
27 27,500
27 45,000
27 37,500
28 21,250
28 27,500
28 500
28 67,500
28 27,500
28 120,000
28 5,500
28 45,000
28 27,500
28 9,000
28 2,000
28 32,500
28 18,750
28 23,750
28 21,250
28 16,250
28 45,000
28 82,500
28 45,000
28 45,000
28 55,000
29 55,000
29 27,500
29 27,500
29 13,750
29 18,750
29 45,000
29 67,500
29 16,250
29 100,000
29 82,500
29 55,000
29 55,000
29 2,000
29 21,250
29 27,500
29 45,000
29 55,000
29 27,500
29 27,500
29 82,500
29 175,000
29 45,000
29 13,750
29 2,000
29 32,500
29 21,250
29 100,000
29 37,500
29 23,750
29 32,500
29 9,000
29 37,500
29 67,500
29 16,250
29 11,250
29 45,000
30 45,000
30 23,750
30 55,000
30 37,500
30 45,000
30 16,250
30 27,500
30 82,500
30 67,500
30 45,000
30 55,000
30 55,000
30 27,500
30 6,500
30 2,000
30 5,500
30 16,250
30 67,500
30 23,750
30 67,500
30 2,000
30 45,000
30 37,500
30 3,500
30 45,000
30 11,250
30 27,500
30 9,000
30 37,500
30 55,000
30 45,000
30 13,750
30 13,750
30 27,500
30 23,750
30 11,250
30 45,000
30 32,500
30 9,000
30 6,500
30 9,000
30 27,500
30 27,500
30 45,000
30 18,750
30 11,250
30 82,500
30 4,500
31 45,000
31 45,000
31 55,000
31 21,250
31 9,000
31 67,500
31 55,000
31 23,750
31 6,500
31 6,500
31 4,500
31 27,500
31 16,250
31 45,000
31 37,500
31 23,750
31 37,500
31 500
31 82,500
31 45,000
31 23,750
31 5,500
31 5,500
31 16,250
31 55,000
31 120,000
31 45,000
31 5,500
31 82,500
31 55,000
31 2,000
31 32,500
31 9,000
31 100,000
32 120,000
32 32,500
32 23,750
32 21,250
32 67,500
32 27,500
32 67,500
32 55,000
32 37,500
32 82,500
32 21,250
32 100,000
32 37,500
32 500
32 67,500
32 45,000
32 3,500
32 32,500
32 21,250
32 45,000
32 67,500
32 18,750
32 21,250
32 5,500
32 16,250
32 23,750
32 82,500
32 18,750
32 32,500
32 27,500
32 55,000
32 55,000
32 4,500
32 37,500
32 27,500
32 500
32 45,000
32 55,000
32 45,000
32 6,500
32 18,750
32 67,500
32 45,000
32 37,500
32 32,500
32 120,000
33 27,500
33 55,000
33 500
33 120,000
33 16,250
33 55,000
33 32,500
33 21,250
33 21,250
33 37,500
33 67,500
33 13,750
33 13,750
33 500
33 32,500
33 45,000
33 37,500
33 32,500
33 3,500
33 32,500
33 18,750
33 13,750
33 32,500
33 27,500
33 67,500
33 45,000
33 55,000
33 55,000
33 45,000
33 23,750
33 55,000
33 32,500
33 55,000
34 32,500
34 140,000
34 37,500
34 140,000
34 23,750
34 120,000
34 82,500
34 32,500
34 67,500
34 32,500
34 55,000
34 45,000
34 21,250
34 18,750
34 37,500
34 55,000
34 32,500
34 32,500
34 21,250
34 21,250
34 23,750
34 23,750
34 3,500
34 82,500
34 4,500
34 27,500
34 11,250
34 82,500
34 11,250
34 120,000
34 13,750
34 45,000
34 18,750
35 23,750
35 100,000
35 55,000
35 21,250
35 32,500
35 21,250
35 500
35 23,750
35 5,500
35 175,000
35 55,000
35 55,000
35 21,250
35 140,000
35 55,000
35 55,000
35 45,000
35 67,500
35 16,250
35 37,500
35 37,500
35 55,000
35 37,500
35 21,250
35 27,500
35 21,250
35 5,500
35 27,500
35 23,750
35 3,500
35 32,500
35 7,500
36 27,500
36 21,250
36 67,500
36 67,500
36 45,000
36 3,500
36 32,500
36 67,500
36 45,000
36 82,500
36 55,000
36 120,000
36 23,750
36 67,500
36 16,250
36 82,500
36 67,500
36 55,000
36 55,000
36 37,500
36 16,250
36 32,500
36 55,000
36 18,750
36 32,500
36 82,500
36 11,250
37 21,250
37 18,750
37 9,000
37 55,000
37 55,000
37 67,500
37 21,250
37 45,000
37 32,500
37 13,750
37 67,500
37 27,500
37 23,750
37 100,000
37 27,500
37 37,500
37 82,500
37 37,500
37 18,750
37 13,750
37 11,250
37 32,500
37 67,500
37 32,500
37 27,500
37 9,000
37 32,500
37 21,250
37 140,000
37 55,000
37 9,000
37 3,500
37 37,500
37 100,000
37 55,000
37 45,000
37 55,000
37 67,500
37 27,500
38 32,500
38 9,000
38 175,000
38 67,500
38 7,500
38 140,000
38 100,000
38 32,500
38 45,000
38 175,000
38 175,000
38 32,500
38 55,000
38 21,250
38 16,250
38 100,000
38 32,500
38 27,500
38 37,500
38 13,750
38 5,500
38 5,500
38 45,000
38 45,000
38 55,000
38 45,000
38 500
38 45,000
38 18,750
38 175,000
38 3,500
38 11,250
39 6,500
39 120,000
39 23,750
39 2,000
39 3,500
39 45,000
39 67,500
39 37,500
39 9,000
39 21,250
39 45,000
39 5,500
39 21,250
39 82,500
39 32,500
39 18,750
39 82,500
39 45,000
39 45,000
39 67,500
39 11,250
39 5,500
39 67,500
39 37,500
39 23,750
39 45,000
39 2,000
39 67,500
39 175,000
39 21,250
39 55,000
39 27,500
39 11,250
39 67,500
39 100,000
39 21,250
39 82,500
40 23,750
40 55,000
40 27,500
40 175,000
40 120,000
40 55,000
40 55,000
40 37,500
40 37,500
40 23,750
40 100,000
40 18,750
40 120,000
40 37,500
40 100,000
40 32,500
40 16,250
40 27,500
40 120,000
40 175,000
40 16,250
40 100,000
40 120,000
40 37,500
40 55,000
40 45,000
40 32,500
40 67,500
40 23,750
40 175,000
40 23,750
40 45,000
40 23,750
40 2,000
41 67,500
41 45,000
41 82,500
41 100,000
41 55,000
41 67,500
41 21,250
41 67,500
41 37,500
41 175,000
41 16,250
41 45,000
41 5,500
41 100,000
41 55,000
41 100,000
41 37,500
41 100,000
41 67,500
41 32,500
41 120,000
41 37,500
41 45,000
41 4,500
41 67,500
41 23,750
41 37,500
41 32,500
41 55,000
41 9,000
41 82,500
41 67,500
41 27,500
41 67,500
41 27,500
41 55,000
41 32,500
41 55,000
41 13,750
41 67,500
41 27,500
41 32,500
41 23,750
42 55,000
42 120,000
42 55,000
42 23,750
42 16,250
42 82,500
42 16,250
42 500
42 175,000
42 45,000
42 120,000
42 45,000
42 45,000
42 120,000
42 55,000
42 55,000
42 32,500
42 6,500
42 21,250
42 11,250
42 45,000
42 32,500
42 16,250
42 55,000
42 21,250
42 82,500
42 7,500
42 21,250
42 23,750
43 45,000
43 100,000
43 11,250
43 120,000
43 55,000
43 82,500
43 55,000
43 27,500
43 55,000
43 67,500
43 55,000
43 45,000
43 67,500
43 55,000
43 13,750
43 55,000
43 67,500
43 21,250
43 82,500
43 9,000
43 37,500
43 55,000
43 175,000
43 5,500
43 45,000
43 32,500
43 3,500
43 55,000
43 55,000
43 82,500
43 45,000
43 82,500
43 55,000
43 2,000
43 67,500
43 21,250
44 82,500
44 82,500
44 2,000
44 32,500
44 82,500
44 175,000
44 82,500
44 27,500
44 3,500
44 5,500
44 82,500
44 140,000
44 100,000
44 55,000
44 45,000
44 9,000
44 45,000
44 21,250
44 5,500
44 120,000
44 13,750
44 32,500
44 16,250
44 45,000
44 45,000
44 11,250
44 32,500
44 18,750
44 100,000
44 37,500
44 120,000
44 500
44 13,750
44 67,500
44 67,500
45 120,000
45 82,500
45 82,500
45 27,500
45 27,500
45 67,500
45 11,250
45 16,250
45 55,000
45 82,500
45 32,500
45 16,250
45 23,750
45 67,500
45 13,750
45 82,500
45 18,750
45 55,000
45 6,500
45 32,500
45 16,250
45 45,000
45 55,000
45 82,500
45 2,000
45 32,500
45 5,500
45 55,000
45 13,750
46 175,000
46 120,000
46 3,500
46 67,500
46 175,000
46 82,500
46 67,500
46 55,000
46 45,000
46 4,500
46 18,750
46 45,000
46 3,500
46 21,250
46 11,250
46 16,250
46 82,500
46 11,250
46 45,000
46 3,500
46 45,000
46 13,750
46 32,500
47 82,500
47 82,500
47 23,750
47 100,000
47 100,000
47 140,000
47 67,500
47 3,500
47 37,500
47 23,750
47 16,250
47 32,500
47 175,000
47 67,500
47 67,500
47 100,000
47 45,000
47 32,500
47 82,500
47 45,000
47 32,500
47 55,000
47 6,500
47 32,500
47 37,500
47 6,500
47 45,000
47 45,000
47 140,000
47 32,500
47 55,000
47 18,750
47 45,000
47 500
47 21,250
47 7,500
47 55,000
48 55,000
48 100,000
48 67,500
48 27,500
48 67,500
48 67,500
48 32,500
48 67,500
48 23,750
48 67,500
48 67,500
48 23,750
48 4,500
48 45,000
48 45,000
48 27,500
48 16,250
48 37,500
48 175,000
48 21,250
48 55,000
48 82,500
48 18,750
48 23,750
48 9,000
49 175,000
49 140,000
49 140,000
49 45,000
49 32,500
49 500
49 45,000
49 4,500
49 55,000
49 175,000
49 100,000
49 27,500
49 18,750
49 45,000
49 21,250
49 45,000
49 37,500
49 67,500
49 5,500
49 16,250
49 3,500
49 16,250
49 67,500
49 140,000
49 82,500
49 45,000
49 32,500
49 45,000
50 100,000
50 120,000
50 21,250
50 2,000
50 67,500
50 11,250
50 11,250
50 55,000
50 82,500
50 55,000
50 3,500
50 9,000
50 140,000
50 23,750
50 67,500
50 45,000
50 45,000
50 67,500
50 32,500
50 67,500
50 67,500
50 6,500
50 32,500
50 11,250
50 18,750
50 67,500
50 18,750
50 45,000
50 67,500
50 5,500
50 37,500
50 55,000
50 11,250
50 13,750
50 55,000
50 23,750
51 82,500
51 21,250
51 82,500
51 21,250
51 82,500
51 9,000
51 27,500
51 175,000
51 100,000
51 32,500
51 82,500
51 55,000
51 140,000
51 13,750
51 18,750
51 2,000
51 55,000
51 37,500
51 100,000
51 21,250
51 4,500
51 55,000
51 67,500
51 32,500
51 82,500
51 500
51 55,000
51 32,500
51 175,000
51 45,000
51 67,500
51 7,500
52 45,000
52 100,000
52 82,500
52 37,500
52 4,500
52 11,250
52 2,000
52 67,500
52 11,250
52 6,500
52 11,250
52 67,500
52 67,500
52 18,750
52 100,000
52 32,500
52 5,500
52 37,500
52 500
52 45,000
52 27,500
52 140,000
52 11,250
52 67,500
52 45,000
52 2,000
52 55,000
52 21,250
52 27,500
52 82,500
52 27,500
52 55,000
53 82,500
53 120,000
53 9,000
53 32,500
53 23,750
53 55,000
53 32,500
53 82,500
53 55,000
53 55,000
53 140,000
53 13,750
53 13,750
53 120,000
53 37,500
53 23,750
53 100,000
53 67,500
53 67,500
53 27,500
53 27,500
53 23,750
53 82,500
53 27,500
53 18,750
53 120,000
53 55,000
53 16,250
53 32,500
53 32,500
53 45,000
53 175,000
53 32,500
53 18,750
53 67,500
53 55,000
53 23,750
53 23,750
53 11,250
53 82,500
53 11,250
53 67,500
53 23,750
53 27,500
53 45,000
54 45,000
54 140,000
54 100,000
54 27,500
54 32,500
54 6,500
54 5,500
54 82,500
54 175,000
54 18,750
54 67,500
54 45,000
54 45,000
54 37,500
54 82,500
54 6,500
54 21,250
54 11,250
54 32,500
54 100,000
54 55,000
54 55,000
54 32,500
54 45,000
54 11,250
54 45,000
54 32,500
54 100,000
54 55,000
54 37,500
54 11,250
54 45,000
54 45,000
54 45,000
54 55,000
54 32,500
54 32,500
55 55,000
55 37,500
55 45,000
55 82,500
55 21,250
55 45,000
55 27,500
55 45,000
55 45,000
55 37,500
55 67,500
55 82,500
55 45,000
55 55,000
55 67,500
55 175,000
55 27,500
55 32,500
55 55,000
55 55,000
55 140,000
55 82,500
55 9,000
55 37,500
55 18,750
55 175,000
55 120,000
55 82,500
55 9,000
55 37,500
55 27,500
55 11,250
56 13,750
56 175,000
56 23,750
56 100,000
56 23,750
56 16,250
56 175,000
56 4,500
56 16,250
56 100,000
56 13,750
56 55,000
56 55,000
56 82,500
56 27,500
56 13,750
56 23,750
56 32,500
56 16,250
56 100,000
56 55,000
56 23,750
56 23,750
56 67,500
56 45,000
56 18,750
56 55,000
56 175,000
56 82,500
56 45,000
56 67,500
56 37,500
56 120,000
56 45,000
56 82,500
56 45,000
56 23,750
56 45,000
56 32,500
56 55,000
56 23,750
56 21,250
56 45,000
57 100,000
57 175,000
57 82,500
57 4,500
57 27,500
57 67,500
57 27,500
57 82,500
57 55,000
57 175,000
57 55,000
57 27,500
57 55,000
57 45,000
57 82,500
57 2,000
57 11,250
57 27,500
57 32,500
57 55,000
57 82,500
57 37,500
57 27,500
57 45,000
57 37,500
57 27,500
57 45,000
57 45,000
57 100,000
57 55,000
57 45,000
57 27,500
58 175,000
58 27,500
58 55,000
58 45,000
58 55,000
58 67,500
58 55,000
58 82,500
58 100,000
58 32,500
58 27,500
58 100,000
58 3,500
58 120,000
58 55,000
58 45,000
58 45,000
58 27,500
58 16,250
58 32,500
58 13,750
58 37,500
58 37,500
58 55,000
58 32,500
58 100,000
58 45,000
58 13,750
58 67,500
58 37,500
58 37,500
58 100,000
58 82,500
58 55,000
58 16,250
58 23,750
58 2,000
58 55,000
58 21,250
58 45,000
58 67,500
58 32,500
58 55,000
58 82,500
58 67,500
59 67,500
59 500
59 100,000
59 140,000
59 67,500
59 32,500
59 2,000
59 4,500
59 37,500
59 32,500
59 500
59 11,250
59 13,750
59 45,000
59 67,500
59 100,000
59 23,750
59 67,500
59 82,500
59 100,000
59 32,500
59 55,000
59 67,500
59 2,000
59 100,000
59 9,000
59 27,500
60 175,000
60 175,000
60 100,000
60 140,000
60 11,250
60 82,500
60 55,000
60 45,000
60 45,000
60 37,500
60 21,250
60 100,000
60 23,750
60 37,500
60 55,000
60 175,000
60 32,500
60 120,000
60 32,500
60 32,500
60 82,500
60 45,000
60 55,000
60 32,500
60 67,500
60 67,500
60 175,000
60 18,750
60 45,000
60 23,750
60 55,000
60 55,000
60 23,750
61 45,000
61 175,000
61 13,750
61 82,500
61 67,500
61 27,500
61 55,000
61 67,500
61 16,250
61 500
61 82,500
61 82,500
61 21,250
61 32,500
61 82,500
61 45,000
61 13,750
61 175,000
61 23,750
61 21,250
61 11,250
61 27,500
61 100,000
61 37,500
62 45,000
62 45,000
62 27,500
62 32,500
62 32,500
62 175,000
62 100,000
62 27,500
62 37,500
62 27,500
62 13,750
62 27,500
62 11,250
62 5,500
62 120,000
62 11,250
62 27,500
62 175,000
62 32,500
62 100,000
62 175,000
62 82,500
62 175,000
62 45,000
62 67,500
62 32,500
62 16,250
62 18,750
62 5,500
62 45,000
63 67,500
63 32,500
63 175,000
63 55,000
63 175,000
63 37,500
63 120,000
63 23,750
63 13,750
63 55,000
63 175,000
63 4,500
63 82,500
63 3,500
63 21,250
63 45,000
63 16,250
63 11,250
63 55,000
64 82,500
64 16,250
64 9,000
64 120,000
64 7,500
64 4,500
64 45,000
64 67,500
64 67,500
64 175,000
64 67,500
64 67,500
64 67,500
64 120,000
64 37,500
64 37,500
64 45,000
65 175,000
65 27,500
65 55,000
65 82,500
65 55,000
65 175,000
65 37,500
65 45,000
65 175,000
65 21,250
65 13,750
65 67,500
65 13,750
65 21,250
65 55,000
65 3,500
65 500
65 27,500
65 175,000
65 67,500
65 23,750
65 55,000
66 67,500
66 67,500
66 21,250
66 82,500
66 120,000
66 23,750
66 500
66 100,000
66 175,000
66 13,750
66 67,500
66 500
66 67,500
66 13,750
66 11,250
66 120,000
66 5,500
66 175,000
66 45,000
67 175,000
67 32,500
67 500
67 45,000
67 82,500
67 55,000
67 13,750
67 45,000
67 21,250
67 27,500
67 37,500
67 175,000
68 13,750
68 18,750
68 175,000
68 37,500
68 23,750
69 140,000
69 21,250
69 175,000
69 45,000
69 21,250
69 27,500
69 45,000
70 11,250
70 18,750
70 120,000
70 5,500
70 18,750
70 21,250
70 67,500
71 11,250
71 175,000
71 45,000
71 67,500
71 32,500
71 55,000
71 21,250
71 21,250
72 55,000
72 23,750
72 32,500
72 82,500
72 5,500
72 45,000
73 67,500
73 13,750
73 11,250
74 13,750
74 9,000
74 140,000
74 37,500
74 175,000
74 21,250
74 500
74 16,250
75 55,000
75 4,500
75 11,250
75 13,750
76 2,000
76 27,500
77 55,000
78 9,000
78 45,000
79 18,750
79 21,250
80 11,250
83 23,750
86 3,500
87 45,000

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Survey Of Economics

Authors: Irvin B. Tucker

10th Edition

133711152X, 978-1337111522

More Books

Students also viewed these Economics questions

Question

What is a social role? (p. 30)

Answered: 1 week ago