Assignment Lab 7

profilesaikumar.battula
Datafor_Lab7.xlsx

Data-P09-01

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.

Data-P09-02

Box Amount
Christopher J. Zappe, Ph.D.: Measured in grams.
1 454.54
2 624.83
3 590.83
4 489.21
5 451.17
6 587.00
7 691.45
8 639.36
9 566.83
10 398.53
11 491.43
12 564.74
13 492.30
14 403.60
15 569.00
16 499.95
17 501.19
18 408.54
19 409.48
20 536.08
21 525.91
22 622.91
23 484.38
24 531.88
25 677.56
26 437.61
27 574.11
28 425.42
29 417.39
30 448.59
31 609.73
32 485.50
33 408.87
34 646.30
35 533.23
36 473.36
37 527.50
38 558.64
39 480.63
40 531.41
41 470.53
42 675.10
43 513.33
44 531.92
45 561.41
46 570.61
47 572.58
48 688.70
49 652.79
50 590.96
51 527.44
52 531.17
53 482.93
54 691.13
55 559.99
56 566.67
57 687.72
58 585.02
59 559.95
60 423.32
61 504.87
62 523.31
63 545.58
64 521.31
65 471.16
66 600.68
67 466.97
68 615.45
69 553.24
70 450.54
71 460.37
72 592.05
73 550.87
74 420.84
75 426.61
76 488.35
77 413.97
78 467.98
79 483.21
80 452.91
81 483.77
82 422.81
83 627.47
84 508.39
85 569.39
86 409.81
87 509.94
88 620.98
89 493.66
90 484.60
91 684.94
92 497.19
93 469.03
94 496.13
95 474.51
96 492.15
97 506.46
98 466.49
99 496.91
100 497.52

Data-P08-18

Consumer Gender Age Preference
1 F Over 60 Our brand
2 F Between 40 and 60 Our brand
3 M Between 40 and 60 Our brand
4 F Over 60 Competing brand
5 M Between 20 and 40 Our brand
6 F Between 20 and 40 Competing brand
7 F Between 20 and 40 Our brand
8 F Between 40 and 60 Competing brand
9 F Between 20 and 40 Competing brand
10 F Between 40 and 60 Competing brand
11 F Over 60 Competing brand
12 F Between 20 and 40 Our brand
13 F Over 60 Competing brand
14 F Between 40 and 60 Competing brand
15 F Between 40 and 60 Competing brand
16 F Between 20 and 40 Our brand
17 F Between 20 and 40 Competing brand
18 F Between 40 and 60 Competing brand
19 F Over 60 Our brand
20 F Between 20 and 40 Our brand
21 M Over 60 Our brand
22 F Between 40 and 60 Competing brand
23 F Between 40 and 60 Competing brand
24 F Between 40 and 60 Our brand
25 F Between 20 and 40 Our brand
26 M Between 20 and 40 Our brand
27 M Between 20 and 40 Our brand
28 F Over 60 Competing brand
29 F Between 20 and 40 Competing brand
30 F Between 40 and 60 Competing brand
31 F Between 20 and 40 Our brand
32 F Between 20 and 40 Our brand
33 F Between 20 and 40 Competing brand
34 F Between 40 and 60 Competing brand
35 F Between 20 and 40 Competing brand
36 F Between 40 and 60 Our brand
37 F Between 40 and 60 Our brand
38 M Between 20 and 40 Our brand
39 F Between 20 and 40 Competing brand
40 F Between 40 and 60 Competing brand
41 M Less than 20 Our brand
42 M Less than 20 Our brand
43 F Between 40 and 60 Our brand
44 F Over 60 Competing brand
45 M Less than 20 Competing brand
46 F Between 20 and 40 Competing brand
47 M Between 20 and 40 Our brand
48 F Over 60 Our brand
49 F Between 20 and 40 Competing brand
50 F Between 20 and 40 Our brand
51 F Between 40 and 60 Our brand
52 F Between 20 and 40 Our brand
53 F Over 60 Competing brand
54 F Between 40 and 60 Competing brand
55 F Between 20 and 40 Competing brand
56 F Over 60 Competing brand
57 F Between 40 and 60 Competing brand
58 M Between 40 and 60 Our brand
59 F Between 20 and 40 Competing brand
60 M Over 60 Our brand
61 F Between 20 and 40 Our brand
62 M Between 20 and 40 Competing brand
63 F Over 60 Competing brand
64 M Between 40 and 60 Our brand
65 M Between 40 and 60 Our brand
66 F Between 20 and 40 Competing brand
67 F Between 40 and 60 Our brand
68 M Over 60 Competing brand
69 F Between 20 and 40 Our brand
70 M Between 20 and 40 Competing brand
71 F Over 60 Competing brand
72 M Over 60 Competing brand
73 F Between 40 and 60 Competing brand
74 F Between 20 and 40 Our brand
75 F Between 40 and 60 Our brand
76 M Between 40 and 60 Competing brand
77 F Between 40 and 60 Our brand
78 M Between 20 and 40 Our brand
79 F Between 40 and 60 Our brand
80 F Between 20 and 40 Competing brand
81 M Over 60 Our brand
82 M Between 40 and 60 Competing brand
83 F Between 40 and 60 Our brand
84 F Between 20 and 40 Our brand
85 M Less than 20 Our brand
86 F Between 40 and 60 Our brand
87 M Between 40 and 60 Our brand
88 M Between 20 and 40 Our brand
89 F Between 40 and 60 Our brand
90 M Between 40 and 60 Competing brand
91 M Between 40 and 60 Competing brand
92 M Between 20 and 40 Our brand
93 F Between 20 and 40 Competing brand
94 F Over 60 Competing brand
95 F Between 20 and 40 Competing brand
96 F Between 20 and 40 Our brand
97 F Between 20 and 40 Competing brand
98 F Over 60 Competing brand
99 F Between 20 and 40 Competing brand
100 F Between 20 and 40 Competing brand
101 F Less than 20 Competing brand
102 F Over 60 Competing brand
103 F Less than 20 Competing brand
104 F Between 20 and 40 Our brand
105 M Less than 20 Our brand
106 F Between 20 and 40 Our brand
107 F Between 20 and 40 Our brand
108 M Less than 20 Our brand
109 M Between 20 and 40 Competing brand
110 F Between 40 and 60 Competing brand
111 F Between 40 and 60 Our brand
112 F Between 20 and 40 Our brand
113 M Less than 20 Our brand
114 M Between 40 and 60 Our brand
115 F Between 20 and 40 Competing brand
116 M Over 60 Competing brand
117 M Over 60 Our brand
118 F Between 20 and 40 Competing brand
119 F Between 20 and 40 Competing brand
120 F Between 20 and 40 Competing brand
121 F Over 60 Competing brand
122 F Between 20 and 40 Our brand
123 F Between 40 and 60 Competing brand
124 F Between 40 and 60 Our brand
125 F Between 20 and 40 Our brand
126 F Between 20 and 40 Competing brand
127 M Between 40 and 60 Competing brand
128 M Between 20 and 40 Our brand
129 F Between 40 and 60 Our brand
130 F Between 20 and 40 Competing brand
131 F Over 60 Our brand
132 M Over 60 Competing brand
133 M Between 20 and 40 Our brand
134 F Between 20 and 40 Competing brand
135 F Between 40 and 60 Our brand
136 F Over 60 Competing brand
137 F Over 60 Competing brand
138 F Between 20 and 40 Competing brand
139 F Between 20 and 40 Competing brand
140 F Between 40 and 60 Our brand
141 F Between 20 and 40 Our brand
142 M Over 60 Our brand
143 F Between 40 and 60 Competing brand
144 F Between 20 and 40 Competing brand
145 F Less than 20 Competing brand
146 F Between 20 and 40 Competing brand
147 M Between 20 and 40 Competing brand
148 F Between 20 and 40 Our brand
149 M Over 60 Competing brand
150 M Over 60 Our brand
151 F Between 20 and 40 Competing brand
152 F Between 40 and 60 Competing brand
153 F Between 20 and 40 Our brand
154 F Between 20 and 40 Competing brand
155 F Between 40 and 60 Competing brand
156 M Between 20 and 40 Our brand
157 F Between 40 and 60 Our brand
158 F Between 20 and 40 Our brand
159 F Over 60 Our brand
160 F Between 20 and 40 Our brand
161 F Over 60 Our brand
162 F Between 20 and 40 Competing brand
163 F Between 20 and 40 Competing brand
164 F Between 20 and 40 Competing brand
165 F Between 20 and 40 Competing brand
166 F Between 20 and 40 Competing brand
167 F Between 40 and 60 Competing brand
168 M Between 20 and 40 Our brand
169 M Less than 20 Our brand
170 F Between 40 and 60 Our brand
171 F Over 60 Our brand
172 M Over 60 Our brand
173 F Between 20 and 40 Competing brand
174 M Less than 20 Competing brand
175 F Less than 20 Our brand
176 M Between 20 and 40 Our brand
177 F Between 20 and 40 Competing brand
178 F Between 20 and 40 Our brand
179 F Between 20 and 40 Our brand
180 F Between 20 and 40 Our brand
181 M Less than 20 Our brand
182 F Between 20 and 40 Our brand
183 F Over 60 Competing brand
184 M Between 20 and 40 Our brand
185 F Less than 20 Our brand
186 F Between 20 and 40 Our brand
187 F Between 40 and 60 Our brand
188 M Between 40 and 60 Competing brand
189 M Between 40 and 60 Competing brand
190 F Between 20 and 40 Our brand
191 F Less than 20 Competing brand
192 F Less than 20 Our brand
193 F Over 60 Our brand
194 F Between 20 and 40 Our brand
195 M Between 40 and 60 Competing brand
196 F Between 40 and 60 Our brand
197 M Over 60 Our brand
198 F Between 40 and 60 Our brand
199 F Over 60 Competing brand
200 F Between 20 and 40 Our brand
201 F Between 40 and 60 Our brand
202 M Between 40 and 60 Our brand
203 F Over 60 Competing brand
204 F Less than 20 Our brand
205 F Between 40 and 60 Competing brand
206 F Between 20 and 40 Our brand
207 F Between 20 and 40 Our brand
208 F Between 20 and 40 Our brand
209 M Between 20 and 40 Competing brand
210 F Over 60 Our brand
211 F Between 40 and 60 Our brand
212 F Between 20 and 40 Competing brand
213 F Less than 20 Our brand
214 F Between 20 and 40 Our brand
215 M Over 60 Our brand
216 F Between 20 and 40 Competing brand
217 F Between 40 and 60 Our brand
218 M Between 40 and 60 Our brand
219 F Between 20 and 40 Our brand
220 F Less than 20 Our brand
221 F Between 20 and 40 Our brand
222 F Between 40 and 60 Our brand
223 M Between 40 and 60 Competing brand
224 F Over 60 Our brand
225 F Between 20 and 40 Competing brand
226 M Between 40 and 60 Competing brand
227 F Over 60 Competing brand
228 M Less than 20 Our brand
229 F Over 60 Competing brand
230 F Between 20 and 40 Our brand
231 F Between 20 and 40 Competing brand
232 F Over 60 Our brand
233 F Over 60 Our brand
234 M Between 40 and 60 Competing brand
235 F Between 20 and 40 Our brand
236 F Between 40 and 60 Our brand
237 F Between 20 and 40 Our brand
238 F Between 40 and 60 Our brand
239 F Between 40 and 60 Our brand
240 F Between 40 and 60 Competing brand
241 F Between 40 and 60 Our brand
242 F Between 20 and 40 Our brand
243 F Between 20 and 40 Competing brand
244 F Over 60 Our brand
245 F Between 40 and 60 Competing brand
246 M Between 40 and 60 Competing brand
247 F Between 20 and 40 Competing brand
248 F Between 40 and 60 Our brand
249 M Between 20 and 40 Competing brand
250 M Over 60 Competing brand