Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

The Expense sheet in the accompanying data file contains the responses of 500 randomly selected residents of our city to a survey that asked about

The Expense sheet in the accompanying data file contains the responses of 500 randomly selected residents of our city to a survey that asked about their annual household expenditures on food and travel. The survey also asked about home ownership and car ownership of the households. Use this data to answer the following questions. Do not impute or remove rows with missing values.

a) Report the count of missing values and no-missing values of each variable in the data set.

b) Create separate histograms for food and travel expenses. Determine whether each variable is left skewed or right-skewed. Explain your reasoning.

c) Make a scatterplot to visualize the relationship between food and travel expenditure for all households. Comment on the degree of linearity between the two variables.

d) Would it be reasonable to report (without scatterplot) the correlation between the amount spent on food and travel?

EXPENSE SHEET:

ID OwnHome OwnCar Food Travel
1 Yes Yes 5472.43 827.4
2 No Yes 9130.73 863.55
3 No Yes 4450.67 1180.05
4 No Yes 5020.72 755.7
5 No Yes 3408.11 851.4
6 No No 2850.33 1751.7
7 No No 3680.6 4557.3
8 No Yes 2863.2 3294.45
9 No No 6754.48 3420
10 No No 2902.44 4526.85
11 No No 4317.49 2938.65
12 No Yes 4729.11 851.85
13 No Yes 1843.52 1740
14 No Yes 3442.98 1219.8
15 No No 6317.55 3514.65
16 No Yes 3391.87 2370
17 Yes No 2494.45 2488.5
18 No No 6798.94 2151.6
19 No No 4347.48 2002.5
20 No No 2487.89 1715.25
21 No No 5736.34 3150
22 No No 3046.45 2623.05
23 No Yes 4935.72 1151.85
24 Yes No 6134.26 1585.95
25 No Yes 6167 824.4
26 No No 6275.61 3924.45
27 No Yes 2711.42 2784.75
28 No Yes 3059.78 1114.2
29 Yes No 3305.7 1723.95
30 Yes Yes 2260.17 1905.9
31 Yes No 7032.27 1576.5
32 Yes Yes 4070.45 2386.8
33 No Yes 3296.05 1135.65
34 Yes No 2386.85 1859.55
35 No Yes 2621.01 1992.75
36 Yes Yes 1853.53 1825.05
37 No No 5898.74 2548.5
38 No No 2850.33 1751.7
39 No No 3316.9 2395.65
40 No No 2995.1 3130.65
41 No No 2295.23 4197.45
42 No No 3543.34 2934.6
43 No No 2850.33 1751.7
44 No No 6102.03 3075
45 Yes No 2985.42 1573.05
46 No No 4289.78 4432.35
47 Yes No 5307.27 2456.7
48 No No 1710.9 2961.3
49 Yes Yes 3757.25 1204.65
50 Yes No 3840.28 2751.45
51 No No 3585.86 2251.95
52 Yes No 2447.14 2656.35
53 No No 2019.98 4338.75
54 No Yes 6269.39 1006.5
55 No Yes 4417.16 2044.05
56 No No 6722.01 1742.7
57 No Yes 6362.24 855.75
58 No Yes 5293.05 896.55
59 No No 3863.5 3889.8
60 No No 4593.38 2434.2
61 Yes No 3951.55 1952.25
62 No Yes 2621.01 1992.75
63 Yes No 2216.7 1944.45
64 Yes No 3651.91 3021.45
65 No No 5450.85 1525.2
66 No Yes 6583.72 4562.7
67 No Yes 4386.55 1179.3
68 No Yes 2517.74 4897.05
69 No No 4215.01 1403.25
70 No No 4146.13 3613.2
71 No No 6269.75 1810.5
72 No No 4124.55 3290.7
73 No No 3863.5 3889.8
74 No Yes 3405.75 1282.8
75 No No 2892.9 4096.8
76 No No 9129.66 2653.2
77 Yes Yes 5550.56 1028.85
78 No No 1892.37 2361.75
79 No No 2295.23 4197.45
80 Yes No 2263.81 2541.15
81 No Yes 7746.63 2493.75
82 No No 1940.17 3131.85
83 Yes Yes 2044.21 1856.1
84 No No 2225.74 3233.55
85 Yes No 6166.33 1839.3
86 No Yes 5193.61 988.65
87 Yes Yes 4548.61 1088.7
88 No No 2548.46 4534.95
89 Yes No 5566.43 1944.3
90 No No 4593.38 2434.2
91 Yes No 4516.9 1622.25
92 Yes No 6172.24 1844.85
93 No No 3910.81 2708.4
94 Yes No 2263.81 2541.15
95 No Yes 4417.16 2044.05
96 No No 2019.98 4338.75
97 No No 7046.11 1851.6
98 No No 5180.13 1646.7
99 No No 3266.44 1641.6
100 Yes Yes 2082.23 1564.95
101 No No 8369.88 3089.4
102 No No 4947.28 3132.9
103 Yes Yes 5201.34 1601.55
104 No Yes 3905.34 1524.6
105 No No 5124.22 1219.2
106 No No 4275.35 3001.35
107 Yes No 3787.29 2058.75
108 No No 3543.34 2934.6
109 No Yes 8795.73 846.45
110 No No 4040.09 2014.5
111 No No 3474.23 2320.95
112 No No 6798.94 2151.6
113 No No 6769.31 2826.9
114 Yes No 5149.7 1447.95
115 No No 4358.51 4215.9
116 No No 4641.26 4458
117 No No 6102.03 3075
118 No No 2313.6 4487.55
119 Yes No 3760.1 1342.05
120 No No 3789.64 2153.85
121 No No 6397.4 1326.9
122 Yes 3285.29 1763.85
123 No Yes 4191.24 1495.5
124 No No 3654.11 4412.7
125 Yes No 3465.14 864.3
126 No No 6102.03 3075
127 No No 3046.45 2623.05
128 No Yes 4722.17 1617.9
129 Yes 2238.08 1934.55
130 No Yes 3100.41 2224.2
131 No No 4487.07 3594.9
132 Yes No 2216.7 1944.45
133 No No 3316.9 2395.65
134 No No 2487.89 1715.25
135 No No 5560.73 2184.15
136 No No 4840.48 2712.75
137 Yes Yes 2424.61 1385.25
138 No No 8714.03 3760.95
139 Yes No 5963.75 1313.85
140 No No 9350.13 3237.45
141 No Yes 3932.29 3434.85
142 Yes No 3840.28 2751.45
143 No 4809.1 4055.4
144 No No 3413.42 3506.7
145 No Yes 2617 1721.4
146 No No 3447.63 4308.45
147 No No 4840.48 2712.75
148 Yes No 3333.11 3328.35
149 No Yes 2863.2 3294.45
150 Yes No 2040.42 2182.95
151 No Yes 5751.82 958.8
152 No No 2905.97 4102.95
153 Yes No 2216.7 1944.45
154 No Yes 5391.08 807
155 No Yes 3098.74 735.3
156 No Yes 5101.83 880.2
157 No No 4593.38 2434.2
158 No No 5011.88 3065.25
159 No No 3647.27 3225.15
160 No Yes 3042.25 1154.4
161 Yes Yes 5706.76 1591.65
162 No No 7046.98 3607.2
163 Yes No 5565.54 3010.35
164 No Yes 3702.18 939.45
165 Yes No 5121.24 2217
166 No 3123.35 1769.55
167 Yes No 3536.16 2148
168 No No 4523.31 3512.25
169 No Yes 4601.96 974.55
170 No No 1940.17 3131.85
171 No No 2617.87 3359.85
172 No No 7617.69 3458.4
173 Yes No 3362.86 5616
174 Yes No 5313.07 2083.2
175 No Yes 4662.44 2589.45
176 Yes No 2422.98 1858.35
177 No Yes 5266.72 859.95
178 Yes Yes 2844.24 1173.6
179 No No 9185.28 3116.4
180 No No 6140.91 4671.9
181 No No 6334.03 2500.05
182 No Yes 3059.78 1114.2
183 No No 4597.29 2634.9
184 No No 3911.17 2353.95
185 No No 4840.48 2712.75
186 No Yes 4992.63 1016.7
187 No No 2617.87 3359.85
188 No No 3316.9 2395.65
189 Yes No 3787.29 2058.75
190 No No 4947.28 3132.9
191 No No 4146.13 3613.2
192 Yes No 6865.77 5217.3
193 No Yes 5198.85 987
194 No No 5472.07 3775.95
195 Yes No 1706.89 2507.4
196 No No 3647.27 3225.15
197 No No 3105.31 1056.15
198 Yes Yes 3362.86 5616
199 No No 5560.73 2184.15
200 No No 4384.63 1570.8
201 Yes Yes 5619.02 796.05
202 No Yes 3042.25 1154.4
203 Yes No 3042.09 1873.8
204 No No 3428.64 1910.7
205 No Yes 3702.18 939.45
206 No No 5465.98 3383.4
207 No No 5560.73 2184.15
208 Yes No 2682.54 1816.35
209 No Yes 3725.96 1282.2
210 Yes Yes 3690.13 1694.85
211 No No 7138.34 2729.85
212 No No 3447.63 4308.45
213 Yes No 3375.37 1581.75
214 No Yes 5222.3 1266.9
215 Yes No 6037.84 3069.3
216 No No 8117.12 3875.55
217 No Yes 6337.2
218 No No 2487.89 1715.25
219 No 2225.74 3233.55
220 No No 5570.8 3794.55
221 No No 3863.5 3889.8
222 No No 3264.94 4398.15
223 No No 5921.73 3741.75
224 No No 3329.81 4107.45
225 Yes Yes 5265.15 904.2
226 No Yes 2000.67 2362.5
227 No No 5155.47 6030.3
228 No No 2487.89 1715.25
229 No No 5317.36 2172.9
230 No No 3316.9 2395.65
231 No No 1550.16 2688.45
232 No No 3127.59 4376.7
233 No No 8714.03 3760.95
234 No No 2548.46 4534.95
235 No Yes 5034.18 852
236 No No 5006.45 3278.1
237 No No 9935.07 2011.35
238 No Yes 5117.49 1152.15
239 No No 3910.81 2708.4
240 No No 6131.6 2097.15
241 No Yes 2800.91 1036.5
242 Yes No 5566.43 1944.3
243 No No 3428.64 1910.7
244 Yes No 2828.16 1847.7
245 Yes No 5335.32 1714.2
246 No Yes 7262.65 3006.15
247 No No 5898.74 2548.5
248 No No 4636 2997
249 No Yes 5552.01 769.5
250 No No 2587.58 1044
251 No Yes 3262.15 1925.4
252 No No 6275.61 3924.45
253 No No 4439.86 3047.55
254 Yes No 2012.46 3580.95
255 Yes No 4112.44 2154.3
256 No 7251.37 2534.4
257 No Yes 6172.95 2874.45
258 No No 3977.23 3463.05
259 No No 7968.63 3526.5
260 No No 9978.49 1256.1
261 No No 2517.74 4897.05
262 No No 3300.08 3479.55
263 Yes No 4014.79 1888.5
264 No No 2626.9 1758.45
265 No Yes 5583.02 4723.2
266 No No 5898.74 2548.5
267 Yes Yes 2781.55 1052.4
268 Yes No 2263.81 2541.15
269 No No 2967.59 3702.75
270 No No 4579.82 2905.05
271 Yes No 6172.12 2575.05
272 No No 6143.2 4175.85
273 Yes No 2386.85 1859.55
274 No No 8369.88 3089.4
275 No No 3362.86 5616
276 No Yes 5255.24 1036.8
277 Yes Yes 7641.73 1086.45
278 Yes No 3198.81 2379.45
279 No No 3748.6 3225.9
280 No Yes 4471.62 1187.55
281 Yes No 4074.1 3925.05
282 No No 3977.23 3463.05
283 No No 4128.6 3107.55
284 No No 5560.73 2184.15
285 No No 7664.03 1188.45
286 No No 4935.18 4467.45
287 No No 5898.74 2548.5
288 No No 4542.83 2101.05
289 No No 9649.01 2078.4
290 No No 5792.28 2610.9
291 No Yes 3923.94 775.95
292 No No 5840.94 5033.25
293 Yes Yes 5182.37 815.7
294 Yes Yes 4843.94 2250.6
295 No No 4491.65 1277.85
296 Yes No 3819.52 2303.7
297 No No 4312.95 1598.4
298 No No 4523.31 3512.25
299 Yes No 4191.14 2290.05
300 No No 4809.1 4055.4
301 No No 2806.92 1812.6
302 No No 6583.72 4562.7
303 No Yes 3106.38 2715.3
304 No Yes 2963.01 1650
305 No Yes 2668.2 1126.05
306 No Yes 2297.85 2281.5
307 No No 2946.23 2464.5
308 No Yes 2572.42 2093.4
309 No Yes 5291.99 961.65
310 Yes Yes 3935.01 861
311 Yes No 2982.62 1872.3
312 No Yes 3262.15 1925.4
313 Yes Yes 10000 717.75
314 No Yes 4730.96 987.6
315 No Yes 4116.08 2874.9
316 No Yes 3570.78 1105.35
317 No No 2487.89 1715.25
318 No No 4148.56 3902.4
319 No No 5110.54 1377.45
320 Yes Yes 2482.76 2309.25
321 Yes No 2638.87 3926.1
322 No No 3152 2169
323 No No 4641.26 4458
324 Yes No 5791.78 1284.3
325 No Yes 5918.84 751.5
326 Yes Yes 4860.36 1086.3
327 No Yes 2605.05 3030
328 No No 6460.84 3852.9
329 No No 4157.61 2337.15
330 No Yes 5089.75 996.9
331 No No 3474.23 2320.95
332 No Yes 4959.21 1505.4
333 Yes No 5433.17 1915.05
334 No No 2548.46 4534.95
335 No No 6589.49 1947
336 No No 6334.03 2500.05
337 No No 2626.9 1758.45
338 No No 7702.88 3882.75
339 No Yes 2659.94 2499.9
340 Yes No 5433.17 1915.05
341 Yes No 2796.6 2195.4
342 Yes No 2883.65 1711.95
343 No No 4351.31 1169.7
344 No No 6205.97 3667.5
345 Yes No 2386.85 1859.55
346 No No 2421.04 2321.1
347 No No 6166.1 3691.5
348 Yes No 3784.94 3082.65
349 No No 9174.83 2794.2
350 No Yes 9819.56 787.95
351 No No 4033.32 3679.2
352 No No 1888.3 4372.65
353 No No 7520.09 1748.55
354 No No 2617.87 3359.85
355 No No 2946.23 2464.5
356 Yes No 4580.05 1994.1
357 No Yes 5588.72 1512
358 No No 2587.89 1784.25
359 No No 5976.02 4080.9
360 No No 2712.37 1599
361 Yes No 2828.16 1847.7
362 No No 5505.79 1653.75
363 Yes No 3247.31 2050.2
364 Yes No 4633.51 1878.75
365 No No 5430.52 3140.25
366 Yes No 7577.56 1991.55
367 No Yes 5130.29 955.35
368 No Yes 3363.8 1161.9
369 No No 2587.89 1784.25
370 No No 4037.09 1674.9
371 No No 2487.89 1715.25
372 Yes No 3503.11 1798.5
373 Yes Yes 9062.95 870.45
374 Yes Yes 2044.21 1856.1
375 No Yes 5328.85 945.9
376 Yes Yes 5454.19 637.05
377 No No 8714.03 3760.95
378 No Yes 2668.2 1126.05
379 Yes Yes 2482.76 2309.25
380 Yes No 4568.58 2113.5
381 Yes No 3472.17 2902.5
382 Yes No 4133.35 2377.5
383 No No 2892.9 4096.8
384 No No 6372.59 2142.45
385 No No 6438.27 5242.95
386 No No 5605.06 4805.55
387 No No 4409.42 4194.15
388 No No 4988.83 1059.3
389 No Yes 2710.38 1724.25
390 Yes Yes 3699.42 2122.2
391 Yes Yes 2553.17 1599.75
392 No No 2421.04 2321.1
393 No Yes 8437.67 2543.7
394 Yes No 4581.03 1391.7
395 No No 7046.98 3607.2
396 No Yes 5826.14 979.65
397 Yes Yes 2366.36 1772.55
398 No Yes 5281.56 956.4
399 No Yes 3627.46 1702.5
400 Yes No 4567.2 3117.45
401 No Yes 4343.85 1916.7
402 Yes No 3081.34 1887
403 No No 3152 2169
404 No Yes 2909.15 1951.35
405 No No 4358.51 4215.9
406 No No 3585.86 2251.95
407 No Yes 5497.26 5249.55
408 No No 6825.49 2548.8
409 No Yes 7231.62 910.95
410 No Yes 2297.85 2281.5
411 Yes Yes 8072.26 853.65
412 No Yes 4787.55 1262.25
413 No No 2421.04 2321.1
414 Yes No 2040.42 2182.95
415 No No 6108.57 2851.35
416 No Yes 3153.68 1379.55
417 Yes Yes 2173.45 1317
418 No No 2517.74 4897.05
419 No No 7516.35 4875.3
420 No Yes 5135.88 1174.5
421 No No 4040.09 2014.5
422 No No 3146.68 2310.9
423 Yes Yes 9592.99 793.8
424 No Yes 6039.76 1461.9
425 Yes No 4891.84 1310.25
426 Yes Yes 2275.24 2437.95
427 No No 5137.41 2637.15
428 Yes No 2422.98 1858.35
429 No Yes 4745.3 3615.6
430 No No 5068.53 4374.9
431 No Yes 5502.33 1007.55
432 Yes Yes 1771.85 1820.25
433 Yes No 2828.16 1847.7
434 Yes Yes 6906.75 797.1
435 No No 3266.44 1641.6
436 No No 3289.86 1514.25
437 Yes Yes 2522.01 833.55
438 Yes Yes 5553.16 1300.65
439 No Yes 5569.75 1849.05
440 No No 4468.8 3497.4
441 No Yes 5201.65 949.5
442 No Yes 4876.68 1448.7
443 Yes Yes 5296.51 673.35
444 Yes Yes 2318.28 1037.85
445 No Yes 5218.38 1049.25
446 No No 6108.57 2851.35
447 No No 5792.28 2610.9
448 No No 4103.1 3070.2
449 No No 3647.27 3225.15
450 No No 2313.6 4487.55
451 No Yes 4109.87 1020.9
452 Yes No 4681.68 1700.85
453 No Yes 5230.32 1016.55
454 No No 8117.12 3875.55
455 Yes No 4580.05 1994.1
456 No No 3911.17 2353.95
457 No Yes 2657.35 1282.05
458 No Yes 2711.42 2784.75
459 No No 2024.97 1747.8
460 No No 4317.66 4041.45
461 No No 4579.82 2905.05
462 No Yes 3942.83 2929.2
463 No No 4478.87 2956.5
464 No Yes 5149.03 992.1
465 Yes Yes 3552.11 746.55
466 Yes Yes 3076.53 1491.45
467 No No 6317.55 3514.65
468 No No 9249.13 4298.1
469 No Yes 4956.27 950.85
470 No No 4624.9 1709.85
471 No Yes 4109.87 1020.9
472 No No 3543.34 2934.6
473 No Yes 3467.7 1576.95
474 No No 4248.47 1876.35
475 No No 4213.71 3847.2
476 Yes No 4956.58 1737.6
477 No No 4221.56 2738.4
478 No No 6143.2 4175.85
479 No No 2806.92 1812.6
480 No Yes 3503.22 2058
481 No No 2626.9 1758.45
482 No No 4202.66 3163.5
483 No No 2712.37 1599
484 Yes No 7105.01 1797.6
485 Yes No 3081.34 1887
486 No No 4409.42 4194.15
487 Yes No 4628.94 3876.45
488 No Yes 4356.12 1980.75
489 No No 5559.43 5515.8
490 No No 4148.56 3902.4
491 No No 3654.11 4412.7
492 No No 2995.1 3130.65
493 Yes No 3947.24 2533.8
494 No Yes 1572.93 3003
495 No No 4711.47 3447.6
496 Yes No 3787.29 2058.75
497 No No 6460.84 3852.9
498 No No 3585.86 2251.95
499 Yes No 1833.95 2000.25
500 No No 6205.97 3667.5

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Principles Of Topology

Authors: Fred H Croom

1st Edition

0486810445, 9780486810447

More Books

Students also viewed these Mathematics questions

Question

Trace Greek medical thought from Aesculapius to Hippocrates.

Answered: 1 week ago

Question

scenario nela or Law contracts criminal Law

Answered: 1 week ago