310homework5data.xlsx

Data #1

Customer Preference
Christopher J. Zappe, Ph.D.: Others include such brands as Arm & Hammer, Sensodyn, Listerine, Rembrandt, and Closeup.
1 Colgate
2 Mentadent
3 Crest
4 Colgate
5 Aquafresh
6 Others
7 Others
8 Aquafresh
9 Crest
10 Others
11 Crest
12 Crest
13 Colgate
14 Colgate
15 Others
16 Colgate
17 Crest
18 Colgate
19 Others
20 Colgate
21 Others
22 Aquafresh
23 Crest
24 Crest
25 Mentadent
26 Others
27 Crest
28 Mentadent
29 Others
30 Colgate
31 Others
32 Crest
33 Mentadent
34 Others
35 Crest
36 Others
37 Others
38 Others
39 Crest
40 Mentadent
41 Crest
42 Colgate
43 Aquafresh
44 Crest
45 Others
46 Others
47 Mentadent
48 Others
49 Mentadent
50 Crest
51 Others
52 Others
53 Crest
54 Others
55 Crest
56 Crest
57 Mentadent
58 Others
59 Colgate
60 Mentadent
61 Crest
62 Mentadent
63 Others
64 Colgate
65 Crest
66 Crest
67 Colgate
68 Others
69 Colgate
70 Crest
71 Mentadent
72 Crest
73 Colgate
74 Colgate
75 Crest
76 Crest
77 Crest
78 Aquafresh
79 Aquafresh
80 Crest
81 Colgate
82 Crest
83 Others
84 Colgate
85 Crest
86 Others
87 Crest
88 Others
89 Crest
90 Crest
91 Mentadent
92 Mentadent
93 Others
94 Others
95 Colgate
96 Crest
97 Crest
98 Others
99 Colgate
100 Mentadent
101 Others
102 Aquafresh
103 Colgate
104 Others
105 Mentadent
106 Crest
107 Mentadent
108 Colgate
109 Colgate
110 Aquafresh
111 Crest
112 Crest
113 Aquafresh
114 Crest
115 Others
116 Aquafresh
117 Others
118 Aquafresh
119 Others
120 Crest
121 Crest
122 Crest
123 Colgate
124 Others
125 Others
126 Aquafresh
127 Others
128 Colgate
129 Crest
130 Mentadent
131 Others
132 Others
133 Crest
134 Others
135 Aquafresh
136 Others
137 Others
138 Crest
139 Mentadent
140 Others
141 Crest
142 Aquafresh
143 Crest
144 Mentadent
145 Mentadent
146 Crest
147 Others
148 Others
149 Others
150 Crest
151 Colgate
152 Aquafresh
153 Crest
154 Others
155 Mentadent
156 Crest
157 Others
158 Crest
159 Mentadent
160 Crest
161 Crest
162 Others
163 Crest
164 Others
165 Mentadent
166 Colgate
167 Others
168 Others
169 Others
170 Others
171 Crest
172 Others
173 Mentadent
174 Colgate
175 Crest
176 Others
177 Mentadent
178 Others
179 Others
180 Mentadent
181 Crest
182 Mentadent
183 Crest
184 Colgate
185 Colgate
186 Aquafresh
187 Crest
188 Others
189 Others
190 Others
191 Others
192 Colgate
193 Crest
194 Aquafresh
195 Aquafresh
196 Others
197 Colgate
198 Others
199 Others
200 Crest

This is fictitious data.

Counts #1

Preference Count
Aquafresh 18
Colgate 31
Crest 60
Mentadent 27
Others 64

Proportions #1

Preference Proportion
Aquafresh 0.09
Colgate 0.155
Crest 0.3
Mentadent 0.135
Others 0.32

Data #2

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

This is fictitious data.