hmw7

profileSam321
310homework7data.xlsx

#1 Data

Lightbulb Lifetime
Christopher J. Zappe, Ph.D.: Measured in hours.
1 840.08
2 960.00
3 953.38
4 981.14
5 938.66
6 1051.14
7 907.84
8 1000.10
9 1073.20
10 1150.66
11 1010.57
12 791.59
13 896.24
14 955.35
15 937.94
16 1113.18
17 1108.81
18 773.62
19 1038.43
20 1126.55
21 950.23
22 1038.19
23 1136.67
24 1031.55
25 1074.28
26 976.90
27 1046.30
28 986.54
29 1014.83
30 920.73
31 1083.41
32 873.59
33 902.92
34 1049.17
35 998.58
36 1010.89
37 1028.71
38 1049.92
39 1080.95
40 1026.41
41 958.95
42 985.17
43 988.49
44 1012.99
45 1070.82
46 1063.13
47 948.57
48 1156.42
49 973.79
50 845.85
51 1025.35
52 931.60
53 931.69
54 1063.00
55 971.95
56 689.52
57 999.63
58 966.65
59 1022.77
60 1041.44
61 987.74
62 887.28
63 975.27
64 904.52
65 937.41
66 964.32
67 1047.56
68 1109.78
69 1053.21
70 1091.02
71 1114.46
72 967.33
73 1131.02
74 920.96
75 983.79
76 972.49
77 1001.50
78 811.08
79 1035.06
80 1001.30
81 970.45
82 1111.68
83 955.20
84 920.79
85 941.75
86 937.89
87 1024.13
88 952.33
89 879.74
90 866.77
91 1080.00
92 1002.06
93 1038.74
94 1017.37
95 988.42
96 893.74
97 1022.92
98 1081.83
99 1154.07
100 827.85

This is fictitious data.

#2 Data

Recruit Height
1 74.5
2 74.0
3 74.6
4 69.8
5 76.0
6 72.3
7 66.0
8 70.6
9 71.9
10 71.4
11 70.6
12 73.9
13 69.3
14 75.3
15 71.5
16 65.5
17 60.5
18 71.9
19 70.7
20 70.6
21 73.4
22 72.1
23 69.3
24 74.7
25 68.5
26 70.5
27 70.0
28 69.9
29 71.7
30 73.0
31 68.8
32 75.0
33 67.5
34 71.3
35 69.5
36 65.3
37 74.8
38 70.5
39 71.5
40 67.6
41 69.1
42 72.1
43 72.8
44 68.3
45 71.8
46 67.1
47 72.3
48 70.7
49 70.4
50 69.1
51 70.8
52 71.6
53 73.6
54 64.8
55 68.5
56 68.5
57 74.3
58 66.5
59 74.8
60 74.1
61 71.6
62 66.3
63 67.1
64 71.7

This is fictitious data.

#3 Data

Family Weekly food expense
1 $198.23
2 $143.53
3 $207.48
4 $134.55
5 $182.01
6 $189.84
7 $170.36
8 $163.72
9 $155.73
10 $203.73
11 $191.19
12 $172.66
13 $154.25
14 $179.03
15 $130.29
16 $170.73
17 $194.50
18 $171.14
19 $175.19
20 $177.25
21 $166.62
22 $135.54
23 $141.18
24 $158.48
25 $159.78
26 $157.42
27 $98.40
28 $181.63
29 $128.45
30 $190.84
31 $154.04
32 $190.22
33 $161.48
34 $113.42
35 $148.83
36 $197.68
37 $135.49
38 $146.72
39 $176.62
40 $154.60
41 $178.39
42 $186.32
43 $157.94
44 $116.35
45 $136.81
46 $195.58
47 $129.44
48 $146.84
49 $165.63
50 $158.97
51 $210.00
52 $175.46
53 $159.69
54 $154.56
55 $152.95
56 $177.30
57 $129.23
58 $127.40
59 $167.48
60 $183.83
61 $157.39
62 $163.24
63 $165.01
64 $137.43
65 $177.37
66 $142.68
67 $150.04
68 $161.44
69 $166.13
70 $190.96
71 $187.19
72 $116.63
73 $159.73
74 $159.64
75 $142.44
76 $153.03
77 $143.12
78 $156.35
79 $182.70
80 $129.03
81 $119.06
82 $137.99
83 $144.20
84 $183.51
85 $169.67
86 $134.66
87 $202.94
88 $143.43
89 $170.52
90 $139.53
91 $159.31
92 $134.77
93 $165.48
94 $127.20
95 $168.16
96 $125.39
97 $167.96
98 $178.64
99 $134.38
100 $111.87

This is fictitious data.

#4 Data 2011

Salesperson Gender
1 Male
2 Female
3 Male
4 Male
5 Male
6 Male
7 Male
8 Female
9 Male
10 Male
11 Male
12 Female
13 Male
14 Male
15 Female
16 Male
17 Male
18 Male
19 Female
20 Male
21 Male
22 Male
23 Male
24 Male
25 Male
26 Female
27 Male
28 Male
29 Female
30 Female
31 Male
32 Male
33 Male
34 Male
35 Female
36 Female
37 Male
38 Male
39 Female
40 Female
41 Female
42 Female
43 Male
44 Male
45 Female
46 Male
47 Female
48 Male
49 Male
50 Male

#4 Data 2016

Salesperson Gender
1 Male
2 Female
3 Male
4 Male
5 Male
6 Female
7 Male
8 Female
9 Female
10 Female
11 Male
12 Male
13 Male
14 Male
15 Male
16 Male
17 Female
18 Female
19 Female
20 Male
21 Female
22 Male
23 Male
24 Male
25 Male
26 Male
27 Female
28 Male
29 Male
30 Male
31 Male
32 Female
33 Male
34 Male
35 Female
36 Female
37 Male
38 Male
39 Male
40 Male
41 Male
42 Female
43 Female
44 Male
45 Male
46 Male
47 Male
48 Female
49 Male
50 Female

#5 Data

House Value Price
1 119.37 121.87
2 148.93 150.25
3 130.39 122.78
4 135.70 144.35
5 126.30 116.20
6 137.08 139.49
7 123.49 115.73
8 150.83 140.59
9 123.48 120.29
10 132.05 147.25
11 148.21 152.26
12 139.53 144.80
13 114.34 107.06
14 140.04 147.47
15 136.01 135.12
16 140.93 140.24
17 132.42 129.89
18 118.30 121.14
19 122.14 111.23
20 149.82 145.14
21 128.91 139.01
22 134.61 129.34
23 121.99 113.61
24 150.50 141.05
25 142.87 152.90
26 155.55 157.79
27 128.50 135.57
28 143.36 151.99
29 119.65 120.53
30 122.57 118.64
31 145.27 149.51
32 149.73 146.86
33 147.70 143.88
34 117.53 118.52
35 140.13 146.07
36 136.57 135.35
37 130.44 121.54
38 118.13 132.98
39 130.98 147.53
40 131.33 128.49
41 141.10 141.93
42 117.87 123.55
43 160.58 162.03
44 151.10 157.39
45 120.15 114.55
46 133.17 139.54
47 140.16 149.92
48 124.56 122.08
49 127.97 136.51
50 101.93 109.41
51 131.47 127.29
52 121.27 120.45
53 143.55 151.96
54 136.89 132.54
55 106.11 114.33
56 137.54 141.32
57 134.33 83.76
58 127.59 118.20
59 137.44 140.20
60 114.09 113.55
61 145.46 156.52
62 141.90 137.35
63 116.34 110.61
64 149.20 153.69
65 141.81 153.33
66 116.44 111.95
67 137.74 143.46
68 144.70 142.13
69 149.66 155.46
70 118.17 135.44
71 137.66 127.30
72 119.70 113.77
73 143.12 141.11
74 129.91 130.08
75 141.78 139.35

This is fictitious data.

#6 Marketing Data

Graduate Salary
1 39,639
2 37,401
3 38,917
4 38,873
5 39,240
6 39,925
7 33,989
8 36,065
9 38,977
10 43,400
11 38,215
12 35,259
13 33,955
14 33,348
15 37,619
16 33,963
17 37,655
18 40,058
19 41,410
20 33,268
21 39,054
22 38,201
23 39,009
24 39,604
25 36,661
26 36,094
27 32,900
28 34,939
29 33,071
30 39,852
31 37,213
32 33,935
33 35,794
34 38,897
35 37,890
36 37,400
37 36,818
38 37,603
39 36,880
40 40,791
41 34,000
42 35,877
43 34,825
44 39,423
45 38,985
46 36,930
47 39,807
48 34,733
49 37,605
50 33,810

#6 Finance Data

Graduate Salary
1 45,379
2 42,578
3 43,446
4 42,112
5 40,954
6 43,197
7 43,662
8 39,973
9 43,319
10 40,167
11 41,647
12 41,870
13 39,781
14 43,913
15 40,853
16 39,315
17 42,983
18 41,750
19 41,658
20 42,377
21 46,575
22 41,522
23 43,444
24 41,275
25 38,803
26 40,727
27 44,531
28 45,373
29 43,755
30 43,393
31 38,124
32 42,653
33 42,795
34 42,319
35 43,654
36 39,214
37 42,579
38 42,249
39 43,024
40 43,940
41 43,387
42 41,479
43 42,735
44 41,271
45 43,720
46 42,510
47 42,701
48 37,200
49 43,505
50 40,928

This is fictitious data.