homw11

profileSam321
310homework11data.xlsx

#1 Data

Student Midterm Final
1 72 70
2 95 100
3 83 88
4 85 75
5 65 73
6 82 86
7 84 85
8 74 69
9 74 76
10 82 73
11 81 71
12 75 80
13 78 72
14 78 83
15 72 68
16 73 83
17 75 76
18 79 69
19 72 76
20 75 79
21 77 74
22 71 80
23 78 70
24 83 93
25 84 78
26 71 81
27 81 73
28 82 88
29 79 83
30 71 69
31 73 77
32 89 87
33 74 74
34 75 78
35 93 96
36 74 84
37 88 90
38 83 89
39 90 100
40 82 82
41 79 85
42 62 60
43 73 70
44 88 88
45 76 80
46 76 86
47 76 68
48 80 84
49 84 92
50 84 74
51 91 98
52 70 64
53 76 78
54 74 79
55 68 76
56 80 88
57 87 94
58 92 86
59 84 87
60 79 75
61 80 75
62 91 84
63 74 77
64 69 62
65 88 92
66 84 79
67 83 82
68 87 81
69 82 89
70 72 63
71 97 87
72 88 91
73 70 71
74 83 78
75 92 97
76 94 92
77 63 56
78 83 91
79 81 78
80 84 94
81 78 71
82 84 93
83 91 88
84 78 88
85 71 76
86 77 79
87 78 78
88 70 74
89 86 89
90 79 85
91 70 60
92 75 78
93 80 84
94 75 66
95 77 80
96 74 65

This data is from an actual finance course, but the students' names have been omitted.

#2 Data

Year Number Size
Christopher J. Zappe, Ph.D.: Average size in acres.
1950 5,647,800 213
1951 5,427,600 222
1952 5,197,500 232
1953 4,983,600 242
1954 4,798,200 251
1955 4,653,800 258
1956 4,514,100 265
1957 4,371,700 273
1958 4,232,900 280
1959 4,104,520 288
1960 3,962,520 297
1961 3,825,410 305
1962 3,692,410 314
1963 3,572,200 322
1964 3,456,690 332
1965 3,356,170 340
1966 3,257,040 348
1967 3,161,730 355
1968 3,070,860 363
1969 3,000,180 369
1970 2,949,140 374
1971 2,902,310 378
1972 2,859,880 382
1973 2,823,260 385
1974 2,795,460 388
1975 2,521,420 420
1976 2,497,270 422
1977 2,455,830 427
1978 2,436,250 429
1979 2,437,300 428
1980 2,439,510 426
1981 2,439,920 424
1982 2,406,550 427
1983 2,378,620 430
1984 2,333,810 436
1985 2,292,530 441
1986 2,249,820 447
1987 2,212,960 451
1988 2,200,940 452
1989 2,174,520 456
1990 2,145,820 460
1991 2,116,760 464
1992 2,107,840 464
1993 2,201,590 440
1994 2,197,690 440
1995 2,196,400 438
1996 2,190,500 438
1997 2,190,510 436
1998 2,192,330 434
1999 2,187,280 434
2000 2,166,780 436
2001 2,148,630 438
2002 2,135,360 440
2003 2,126,860 440
2004 2,112,970 441
2005 2,098,690 442
2006 2,088,970 443
2007 2,204,950 418
2008 2,200,000 418

U.S. Department of Agriculture

#3 Data

Employee Salary Years Previous Experience Years Employed Years Education Gender Department Number Supervised
1 $65,487 0 27 12 1 4 44
2 $46,184 3 20 4 0 4 1
3 $32,782 1 0 7 0 1 0
4 $54,899 5 12 8 1 4 0
5 $34,869 5 7 4 1 4 1
6 $35,487 2 8 2 1 4 2
7 $26,548 1 5 0 0 4 2
8 $32,920 3 15 9 1 1 4
9 $29,548 6 5 1 0 1 0
10 $34,231 2 6 6 0 4 3
11 $23,654 0 0 0 1 3 2
12 $39,331 3 9 6 1 4 1
13 $36,512 6 6 4 1 4 2
14 $35,467 6 3 6 1 2 3
15 $68,425 2 25 12 0 4 1
16 $35,468 5 9 4 1 2 5
17 $36,578 4 4 8 0 3 8
18 $39,828 6 18 5 1 1 5
19 $36,487 5 6 2 0 4 3
20 $37,548 9 19 4 0 3 6
21 $31,528 11 3 3 0 1 6
22 $34,632 4 5 4 0 4 0
23 $46,211 5 14 6 1 4 5
24 $29,876 0 2 3 1 2 5
25 $43,674 9 6 4 0 2 2
26 $38,985 7 18 9 0 1 5
27 $53,234 0 25 6 0 3 3
28 $51,698 6 18 6 0 4 1
29 $41,889 16 22 7 0 1 7
30 $38,791 4 21 5 0 1 9
31 $69,246 3 22 10 0 4 45
32 $48,695 19 6 8 0 4 40
33 $34,987 6 9 2 1 4 3
34 $28,985 1 0 4 1 1 4
35 $35,631 4 6 4 0 4 2
36 $54,679 3 20 6 1 3 4
37 $39,743 6 9 5 1 4 1
38 $41,255 4 9 6 0 4 4
39 $36,431 4 9 4 1 2 2
40 $26,578 6 0 2 1 2 2
41 $47,536 5 15 6 0 3 4
42 $36,571 1 6 4 0 2 2
43 $56,326 3 12 8 0 2 6
44 $31,425 6 7 5 1 3 6
45 $24,749 2 6 0 1 1 1
46 $26,452 3 1 2 1 4 0

This is fictitious data.