Question 1 Paste into your MS word document (or google doc, or etc ) your Excel results of separate pivot tables for the association between each exposure and the disease, Salmonella There should be three pivot tables in total, each organized like a 2x2 contingency table (above), and they should each include the frequency data Subject Travel outside Canada Took antibiotics Live on Livestock farm Salmonella 1 Yes No No Yes 2 Yes No Yes Yes 3 No No No No 4 No No No No 5 No No No Yes 6 No Yes No Yes 7 No No No Yes 8 No No No No 9 No No No No 10 No No No No 11 No No No No 12 No No Yes Yes 13 No No No Yes 14 No No No No 15 No No No Yes 16 No No No No 17 No Yes No Yes 18 No No No No 19 No Yes No Yes 20 No No No No 21 No No No No 22 No No No No 23 No No No No 24 No No No No 25 No Yes No Yes 26 No No No No 27 No No No No 28 No No No No 29 No No No No 30 No No No No 31 No No No No 32 No No No No 33 Yes No No Yes 34 No No Yes No 35 No No No No 36 No No No Yes 37 No No Yes No 38 No No No No 39 Yes Yes No Yes 40 No No No Yes 41 No Yes No Yes 42 No No Yes Yes 43 No Yes No No 44 No No No No 45 Yes No Yes Yes 46 Yes No No Yes 47 No Yes No Yes 48 No No No No 49 No No No No 50 No No No No 51 Yes No No Yes 52 Yes No No Yes 53 Yes No No Yes 54 No No No No 55 No Yes No No 56 No No No No 57 No Yes No Yes 58 No No No No 59 No Yes No Yes 60 No Yes No No 61 Yes No No Yes 62 No No No No 63 Yes No No Yes 64 Yes No No Yes 65 No No No Yes 66 No No No No 67 No No No Yes 68 No No No No 69 No No No No 70 No No No Yes 71 No No No Yes 72 No No No Yes 73 No No No No 74 No Yes No Yes 75 No No No No 76 No No No Yes 77 No No No Yes 78 No No No No 79 No No No Yes 80 No No No No 81 No No No No 82 No No No Yes 83 No No No Yes 84 No No No No 85 No Yes No Yes 86 No No No Yes 87 No No No No 88 No No No Yes 89 No No No Yes 90 No No No No 91 No No Yes Yes 92 No No No Yes 93 No Yes No No 94 No No No Yes 95 No No No Yes 96 No No No No 97 No No No No 98 No Yes No Yes 99 No No No No 100 No No No Yes 101 No No No Yes 102 No No No No 103 No No No No 104 No No Yes Yes 105 No No No No 106 No No No Yes 107 No No No No 108 No Yes No No 109 No No No No 110 No No Yes Yes 111 No No No No 112 No No No Yes 113 No No No Yes 114 No No No Yes 115 No No No Yes 116 No No Yes Yes 117 No No No No 118 No No No No 119 No No No Yes 120 No No No No 121 No No No Yes 122 No No No Yes 123 No No No No 124 No No No No 125 No No Yes Yes 126 No No No No 127 No No No No 128 No No No Yes 129 No No No Yes 130 No No No Yes 131 No No No Yes 132 No No No No 133 No Yes No Yes 134 No No No Yes 135 No No No No 136 No No No No 137 No No No No 138 No No No Yes 139 No No No No 140 No No No Yes 141 No No No No 142 No No No No 143 No No No No 144 No No No No 145 No No No Yes 146 No No No Yes 147 No No No No 148 No Yes No No 149 No No No Yes 150 No No No Yes 151 No No No Yes 152 No No No No 153 No No No Yes 154 No No No No 155 No No No No 156 No No No Yes 157 No No No Yes 158 No No Yes No 159 No No No No 160 No No No No 161 No No No Yes 162 No No No No 163 No No No Yes 164 No No No No 165 No No No No 166 No No No Yes 167 No Yes No Yes 168 No No No No 169 No No No No 170 No No No Yes 171 No No No No 172 No No No Yes 173 No No No Yes 174 No No No Yes 175 Yes No No Yes 176 No No No Yes 177 No No No No 178 No No No No 179 No No No Yes 180 No No No Yes 181 No No No Yes 182 No No No No 183 No No No Yes 184 No No No No 185 No No No No 186 No No No Yes 187 No No No No 188 No No No No 189 No No No Yes 190 No No No No 191 No No No Yes 192 No No No Yes 193 No No No No 194 No No No Yes 195 No No No No 196 No No No Yes 197 No No No Yes 198 No No No Yes 199 No No No Yes 200 No Yes No No 201 No Yes No Yes 202 No No No No 203 No No No Yes 204 Yes Yes No Yes 205 No No No Yes 206 No No No Yes 207 No No No No 208 No No No No 209 No No No No 210 No No No Yes 211 No No Yes Yes 212 No No No Yes 213 No No No No 214 No No No Yes 215 No No No No 216 No No No No 217 No No No No 218 No No No Yes 219 No No No Yes 220 No No No No 221 No No No Yes 222 No No No No 223 No No No No 224 No No No No 225 No No No No 226 No No No Yes 227 No Yes No Yes 228 No No No Yes 229 No No No Yes 230 No No No Yes 231 No No No No 232 No No No Yes 233 No No No No 234 No No No No 235 No No No Yes 236 No No No No 237 No No No No 238 No Yes No Yes 239 No No No No 240 No No Yes Yes 241 No No No Yes 242 No No Yes Yes 243 No No No No 244 No No No Yes 245 No No No No 246 No No No No 247 No No No Yes 248 No No No No 249 No No No No 250 No No No Yes 251 No No No No 252 No Yes No Yes 253 No Yes No Yes 254 No No No No 255 No No No Yes 256 No No Yes Yes 257 No No No No 258 No No No No 259 No No No No 260 Yes No No No 261 No No No Yes 262 No No No No 263 No No No No 264 No Yes No Yes 265 No No No No 266 No No No Yes 267 No No Yes Yes 268 No Yes No Yes 269 No No No No 270 No No No No 271 No No No No 272 No Yes Yes Yes 273 No No No Yes 274 No No Yes No 275 No No No No 276 No No No No

The Answer is in the image, click to view ...

Question: Question 1: Paste into your MS word document (or google doc, or etc.) your Excel results of separate pivot tables for the association between each

Question 1: Paste into your MS word document (or google doc, or etc.) your Excel results of separate pivot tables for the association between each exposure and the disease, Salmonella. There should be three pivot tables in total, each organized like a 2x2 contingency table (above), and they should each include the frequency data.

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

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Mathematics Questions!

Hi Akshya, plz find the attachments and let me know if you can help me in completing the finance problems in worh or excel formats. FINA 6301 HW Problems - 10TH Edition Chapters 10 and 11 - Session 8...

This is a financial cost-benefit analysis class. I need help with the case study with the computations of the case study. The files are provided in the link below or is attached. Willing to pay to...

Hello, I'm having difficulty with Case Study #5-5, starting on page 22 of the attachment. I've also included the calc sheet I started as I'm stuck on question 2, which corresponds to my worksheet...

Journal Selection/Research Manuscript Outline Assignment Title: " Understanding how exercise impacts mental health" INSTRUCTIONS BELOW: This assignment requires the selection of an appropriate...

Hi, I need help with a statistics assignment related to excel. Properties sold in Melboune Property Location 3 1 8 1 28 1 29 1 30 1 31 1 34 1 37 1 45 1 47 1 51 1 54 1 55 1 56 1 57 1 58 1 60 1 61 1 62...

UTS Business Statistics 26134 Report (Group Assignment) SPRING 2017 Assessment Value: This assignment is worth 20% It is be completed in: A GROUP OF 3, 4 or 5 STUDENTS Due times and dates: Due...

Background: A new ownership group has recently purchased ABC Graphics. You have been hired by the new management team to analyze their sales data for the past year and provide them with insights...

Description The assignment requires that you analyse a data set, interpret, and draw conclusions from your analysis, and then convey your conclusions in a written report. The assignment must be...

Project 1: Loans Winter 2023 Brief Description You will use Google Sheets or Excel to construct several amortization tables for a potential home or vehicle loan. You will answer questions based on...

Write a brief paper on Abortion as a Social Problem

In how many ways can a photographer at a wedding arrange six people in a row, including the bride and groom, if a) The bride must be next to the groom? b) The bride is not next to the groom? c) The...

Question 2 7 of 4 9 . Which of the following taxpayers is considered unmarried for the current tax year?Adam. He and Sam were married on August 1 2 , 2 0 2 2 . Adam moved out on May 5 , 2 0 2 4 , but...

An F&B manager wants to determine whether there is any significant difference in the diameter of the cutlet between two units. A randomly selected sample of cutlets was collected from both units...

If y = ax one of the lines belonging to the family of lines representing the sides of an equilateral triangle with one vertex at the origin. Then the product of the slopes of all the lines of this...

If the joint equation of lines making angle 'a' with the line a +y = 0and passing through the origin be r? + 2hay+ y? = 0, (h > 1) then (A) sin a = 1-h V 2h (B) h+1 cos a = (C) sin a = V 2h (D) sec...

If 2hxy + 2gx + 2fy+c= 0 represents a pair of straight lines then area of the quadrilateral it form with the coordinate axis is (A) fg (B) h? (C) |fg| ch (D) fg

Briefly discuss the values and principles of democracy?

Determine if the overhead allocated to the product relates to a single plantwide overhead rate method, multiple production department factory overhead rate method, or activity-based costing...

Researchers studying pleasant touch sensations measured the firing frequency (impulses per second) of nerves that were stimulated by a light brushing stroke on the forearm and also recorded the...

The authors of the paper Decreased Brain Volume in Adults with Childhood Lead Exposure (Public Library of Science Medicine [May 27, 2008]: e112) studied the relationship between childhood...

The accompanying data were read from a plot (and are a subset of the complete data set) given in the article Cognitive Slowing in Closed-Head Injury (Brain and Cognition [1996]: 429 440). The data...