Assignment ST

profilePErl
AssignmentST.xlsx

Nutrition DATA

Calories Age Fat Fiber Alcohol Cholesterol SmokeCODE Smoke Gender VitaminUse
2558.9 19 116.1 12.3 0 324.5 0 No Female Regular
1511.7 22 64.4 10.2 0 190.3 0 No Female No
2733 22 123.8 5.1 0.3 440.3 0 No Female Regular
2219.1 23 120.9 13.1 2 415.8 0 No Female Regular
3021.9 24 171 11.4 0.1 466.3 0 No Female No
928.4 25 29.7 6 0.5 120.7 0 No Female Occasional
1517.4 25 59.1 5.9 0 127.6 1 Yes Female Regular
1663.3 26 64.6 7.6 2 124.7 0 No Female No
1987.2 26 76.6 9.8 0 156.1 1 Yes Female Regular
1200.6 27 61.5 8.7 1.5 208.7 0 No Female No
1127.6 27 59.4 7.4 0 183.4 1 Yes Female No
2919.5 27 125.3 14.3 1 370 1 Yes Female Occasional
1600.9 28 68 14.2 0.2 171.2 0 No Female Occasional
1041.6 29 45.4 6 3 139.5 0 No Female Occasional
2237.4 29 77.6 22.6 0.7 180.6 0 No Female Regular
1631 29 55.6 13.8 0.5 189.5 0 No Female Regular
2476.2 29 121.1 14.3 0 263.5 1 Yes Female Occasional
1437.3 30 61.5 8.8 2.3 160.9 0 No Female No
2264.3 31 105.5 13.4 3.2 396.5 0 No Female Occasional
1646.2 31 52.2 13.2 5 174.9 0 No Female Regular
2729.6 31 144.4 13.2 2.2 381.8 0 No Female Regular
1456.5 31 56.6 8.5 1 182.7 1 Yes Female Occasional
1631.5 31 75.2 8.5 0.7 277.1 1 Yes Female Occasional
1678.2 32 54.3 12.9 1.5 147.3 0 No Female Occasional
3328.4 32 163.3 20 4.1 425.5 0 No Female Occasional
3511.1 32 114.7 13.9 0.2 444.7 0 No Female Occasional
2703.4 32 120.6 11.4 0.1 284.3 0 No Female Regular
1918.4 32 63.1 16.1 5 202.2 0 No Female Regular
2170.3 32 95.1 15.2 0.2 175.2 0 No Female Regular
1622.4 33 71.5 12.9 1 214.8 0 No Female No
3144.8 33 155 17.6 4.1 308.8 0 No Female Occasional
1878.2 33 81.6 9.6 4.9 265.8 0 No Female Occasional
1366.8 33 55.9 6.2 0 196 0 No Female Occasional
2814.6 33 111.2 16.8 0 399.3 0 No Female Occasional
1835.9 33 74.1 23 0.7 184.2 0 No Female Regular
3228 33 141.1 14.4 0 718.8 1 Yes Female No
2271.1 33 114.6 10.4 0 574.2 0 No Male Occasional
3457.2 33 166 17.5 10.5 452.8 0 No Male Regular
2062.7 34 81.1 13.6 18 190.5 0 No Female No
2118.1 34 93 20.1 0 170 0 No Female No
1076.2 34 52.7 6.1 0 78.3 1 Yes Female No
1148.7 34 41.7 9.8 1 173.4 1 Yes Female No
3103.7 34 124.7 18.1 8.3 431 1 Yes Female Regular
1800.5 35 57.8 20.3 0.6 233.6 0 No Female No
3114 35 160.2 14.9 0.2 432.3 0 No Female No
1884.8 35 91.6 11.1 5 518 0 No Female No
1555.6 35 72.8 11.5 0 174.1 0 No Female Occasional
2466.9 35 112.6 9.6 0.1 331.9 0 No Female Occasional
1575.5 35 53.9 7 1 216.2 1 Yes Female Regular
1887.4 36 110.2 6 0.1 211.7 0 No Female No
798.2 36 30.6 7.9 2.4 46.3 0 No Female No
2342.3 36 95.8 19.2 1.7 389.4 0 No Female Occasional
1240.7 36 50.9 6.9 0.3 116 0 No Female Occasional
1414.6 36 51.2 13.7 0 135.8 0 No Female Occasional
2838.8 36 88.5 24 4.5 252.4 0 No Female Occasional
2045.3 36 84.8 13.2 0.7 271.9 0 No Female Regular
1959.3 36 112.4 6.7 0.5 326.7 1 Yes Female No
1147.9 37 47.6 7.3 0.1 117 0 No Female No
1778.1 37 75.9 10.8 0.5 332.6 0 No Female Occasional
1653.2 37 77.3 12.5 1 162.6 0 No Female Occasional
1645.7 37 76 6.6 4 225.9 0 No Female Occasional
2094.5 37 78.9 17.3 1 193.4 0 No Female Occasional
2010.4 37 101.2 16 0.1 362.4 0 No Female Occasional
2035.5 37 65.7 22.1 0.7 205.3 0 No Female Regular
839 37 29.2 4.7 6.4 66.5 0 No Female Regular
1688.1 37 45 17.1 0.8 141.1 0 No Female Regular
1902.8 37 81.7 8.2 0 178.6 1 Yes Female No
1034.4 37 34.5 8.9 0 118.5 1 Yes Female Regular
1149 38 43.6 8.6 10.5 122.5 0 No Female No
1432.1 38 58.5 6.3 0.2 131.9 0 No Female No
2372.3 38 83.6 19.1 14.1 257.9 0 No Female Occasional
2190.7 38 96.9 17.7 1.3 192.1 0 No Female Occasional
1390.4 38 55.7 10.8 0 195.1 0 No Female Occasional
1619.3 38 83.7 8.4 0.5 310.1 0 No Female Occasional
1550 38 66.8 12.1 0 253.2 0 No Female Regular
2585.3 38 129.8 21.1 4 429.5 0 No Female Regular
1662.7 38 58.7 15.7 3.7 163.7 1 Yes Female No
1256.7 39 43.7 5.3 0.3 133.6 0 No Female No
1187.8 39 32.8 11.6 0 154.9 0 No Female Occasional
1719.3 39 49.7 18.4 11 164.6 0 No Female Occasional
1906.5 39 86.4 10.4 15.5 265.9 0 No Female Occasional
1368.9 39 61.6 14.4 6.7 314.9 0 No Female Regular
1829.2 39 79 15.6 0 178.4 0 No Female Regular
1951.4 39 109.1 4.7 0 461.1 1 Yes Male Regular
2449.5 40 97.5 26.5 0.5 332.6 0 No Female No
1366.9 40 56 9.6 1.3 154.6 0 No Female No
742.3 40 36.5 5.9 2.1 133.9 0 No Female No
1638.2 40 49.3 14.9 0 130.7 0 No Female Occasional
3014.9 40 165.7 14.4 0 900.7 0 No Female Regular
833 40 38.8 5.5 0 145.3 1 Yes Female Occasional
2431.9 40 93.7 17.8 0.1 364.6 0 No Male Regular
2419.3 41 122.7 16.2 0.3 325.2 0 No Female No
1808.4 41 61.5 10.5 17 176.1 0 No Female No
2046.9 41 103 13.1 0 334.2 0 No Female No
1823.7 41 54.7 14.6 0 188 0 No Female Occasional
1823 41 74.8 12.1 1.3 196.9 0 No Female Occasional
3258.3 41 101.2 26.2 0.5 341.7 0 No Female Regular
1372.7 41 61.6 9.5 0 182.5 0 No Female Regular
1197.7 41 54.5 4.9 0 135.6 0 No Female Regular
1496.7 41 64.6 5.9 1 239.8 0 No Female Regular
1102.8 41 56.6 5.3 0 329.8 1 Yes Female No
1444.6 41 89.1 6.8 0 280.1 1 Yes Female Occasional
1055 41 33.2 12.9 0.9 220 0 No Male Occasional
2685.1 41 133.1 11.1 15 432.4 1 Yes Male Regular
1051.2 42 44 10.9 0.2 165.5 0 No Female No
3099.2 42 134.9 19 0.8 469.3 0 No Female No
2347.3 42 104.4 12.5 0 249.3 0 No Female Regular
1737.4 42 62.1 16.3 0.2 211.7 0 No Female Regular
1730.1 42 58.3 16.6 4.5 196.1 0 No Female Regular
1434.9 42 59.3 11.2 0 281.1 0 No Female Regular
1084.3 42 25.2 21.8 1 105.7 1 Yes Female Regular
1785.4 42 94.1 10 0.7 288 0 No Male Regular
1786.9 43 93.9 10.6 0 247 0 No Female No
2075.9 43 96.5 17.3 7 271.8 0 No Female No
1695.3 43 62.4 17.7 0 147.3 0 No Female No
2038.5 43 80.7 17.1 0 232.3 0 No Female Occasional
3449.7 43 172.8 20.5 1.4 381.3 0 No Female Occasional
1472.7 43 61.8 12.2 0 216.3 0 No Female Regular
3711 43 202.7 14.9 18 469.2 0 No Female Regular
2501.6 43 121.1 19.5 0 343 0 No Female Regular
2000.8 43 86.7 14.8 0.9 200.9 0 No Female Regular
1626.3 43 72.2 7.9 0 157.5 0 No Female Regular
1220.9 44 35.1 14 0 99.2 0 No Female No
1148.5 44 50.3 7.1 0.1 139.2 0 No Female No
1292.6 44 49.4 10.4 1.2 186.5 0 No Female Occasional
2391.3 44 95.4 20.6 0 283.3 0 No Female Regular
1660.1 44 80.3 13.6 0.1 89 0 No Female Regular
1525.6 44 85.4 7.9 0.1 179.4 0 No Female Regular
1877.4 44 92.2 7.7 0.2 211.6 1 Yes Female No
1446.2 44 63.2 9.5 3.2 208.8 1 Yes Female Occasional
1427.2 44 60.6 8.3 0.2 195 1 Yes Female Occasional
3183.1 44 119.4 6.9 35 378.8 1 Yes Female Occasional
1810 44 95.3 17.5 0 253.1 1 Yes Female Regular
1126.7 45 20.4 12.5 7.2 71.8 0 No Female No
1366.6 45 42.5 12.9 2.5 141.2 0 No Female Occasional
1601.4 45 93.9 8.8 0 255.8 0 No Female Regular
1827.7 45 71.2 10.4 2 267.5 0 No Female Regular
2319 45 122.1 13.4 0.1 305.7 0 No Female Regular
1841.1 45 84.2 14.1 2.2 257.7 0 No Female Regular
1627 45 77.4 9.9 0.2 195.6 0 No Female Regular
1481.8 45 75.3 10.4 0.2 336.9 1 Yes Female Occasional
1546 46 73.6 10.3 7 284.8 0 No Female No
1182.9 46 60.2 5.2 0.2 164.5 0 No Female No
1207.1 46 42.8 11.6 0 155.1 0 No Female No
1342.2 46 69.7 5.9 1 215.4 0 No Female No
2263.6 46 98.2 19.4 2.6 306.5 0 No Female No
2052.4 46 120.4 10.2 0 195.2 0 No Female Occasional
1581.7 46 64.1 12.3 0.1 170.1 0 No Female Occasional
1422.8 46 58.3 7.8 7.1 206.3 0 No Female Occasional
740.6 46 38.5 5.3 0 113.9 0 No Female Occasional
1570.1 46 74.1 13.7 0.9 145.7 1 Yes Female No
2706.7 46 104.9 16.8 22 416 0 No Male No
2667.5 46 131.6 10.1 0 550.5 1 Yes Male No
2120.8 47 77.4 17 8.4 185.9 0 No Female No
1927.6 47 92.5 10.7 0 359.1 0 No Female No
1076.6 47 33.4 22.5 4.1 138.8 0 No Female Occasional
1612.5 47 45.5 9 15 149.9 0 No Female Regular
1600.7 48 77.7 11.2 7.2 180.1 0 No Female No
2021.1 48 72.2 16.6 9 299.1 0 No Female Occasional
2908.5 48 139.1 16.4 0.2 511.6 0 No Female Regular
2893.3 48 125.8 18.8 1.7 256.7 0 No Female Regular
1242.1 48 37.5 13.3 1 148.4 0 No Female Regular
445.2 48 14.4 5 0 102.8 0 No Female Regular
1849.8 48 80.6 13.8 3.2 549.1 0 No Female Regular
1738.9 48 63.5 12.2 0.5 205.9 0 No Female Regular
1010.6 49 29.4 9.1 6.2 98.8 0 No Female No
1469.9 49 50.4 12.1 0.7 118.8 0 No Female No
1656.3 49 59.5 13.3 0.1 180.3 0 No Female Occasional
1511.7 49 54.4 16.1 4.2 200.5 0 No Female Occasional
1292.8 49 43.1 10.6 11 180.7 0 No Female Occasional
1574 49 74.6 14.1 0 440.6 0 No Female Regular
1099.4 49 56.9 5.2 0.5 169.9 0 No Female Regular
3098.9 49 106.2 25.2 1.2 447.6 0 No Female Regular
2512 49 64.9 30.2 0.6 168.5 0 No Female Regular
1125.6 49 44.8 11.9 4 150.5 0 No Female Regular
784.4 49 40.6 4.9 3 97.4 1 Yes Female Regular
2825.8 49 97.8 7.5 35 374.3 0 No Male No
1902.9 50 72.9 35.4 7.3 175.6 0 No Female No
2012 50 112.9 14.3 6.5 456.9 0 No Female No
2106.4 50 97 12.9 0 344.3 0 No Female Occasional
1113 50 32.8 12.9 3 104.8 0 No Female Regular
2340.4 50 110.4 11.3 14 260.7 1 Yes Female No
2026 50 85.5 11.2 21 268.2 0 No Male Regular
1952.7 51 63.8 17.9 11 201.3 0 No Female No
1324 51 46 12.7 0 151 0 No Female No
2166.9 51 105.8 15.6 0 349.1 0 No Female Occasional
828.2 52 52.3 6.1 1.2 141.1 0 No Female No
1891.6 52 73.8 17.6 0 226 0 No Female No
1749.9 52 81.3 12.1 0 226.5 0 No Female Occasional
2083.9 52 93.1 8.8 0 328.1 0 No Female Regular
1248.6 53 56.9 8.2 0 223.2 0 No Female No
1276.5 53 50.1 9 4.7 143.5 0 No Female Occasional
1576.3 53 54.8 13.5 0.1 308.9 0 No Female Regular
1996.1 53 98.8 9.2 0 436.8 1 Yes Female Occasional
2798.2 53 125.9 17.7 7 239 1 Yes Male No
4373.6 54 235.9 22.9 0.1 814.7 0 No Female Regular
1580.6 54 82.9 9.4 5.2 98.3 0 No Female Regular
1724.7 54 75.1 18.2 0 173.3 0 No Female Regular
1392.2 54 47.8 12.9 0 87.5 0 No Female Regular
1263.6 55 39.6 15.5 0 171.9 0 No Female No
2272.6 55 94.5 10.9 14.2 269.2 0 No Female No
2328.3 55 112.6 13.9 2.9 281.9 0 No Female Occasional
2307.8 55 111 18.4 3.4 487.8 0 No Female Occasional
1162.5 55 54 5.6 0.2 175.2 1 Yes Female No
1896.1 55 82.2 9.3 10 296.8 0 No Male No
1566.5 56 95.2 6.5 7.2 408 0 No Female No
2225.1 56 111.5 10.4 6.8 283.7 0 No Female No
1436.8 56 57.2 9.4 0 183.3 0 No Female Regular
1830 56 52.8 13.8 8.5 689.4 0 No Female Regular
1494.5 56 59.1 6.8 0 111.5 0 No Female Regular
1743.8 56 85.3 13.2 7.2 349.6 1 Yes Female No
2433.6 56 127.6 19.9 7.1 271.2 0 No Male No
2210.7 56 113.1 10.5 6.1 340.1 0 No Male No
2712.7 56 145.3 13.4 8 242.6 0 No Male Occasional
1288.7 57 63.2 10.6 0 200.2 0 No Female Regular
2513.3 57 98.9 10.6 0 428.1 0 No Female Regular
2072.9 57 106.7 9.6 0.9 420 0 No Male No
1101.4 57 48.5 8.5 5 197.2 0 No Male No
1538.1 58 78.7 14.2 0.9 231.2 0 No Female Occasional
2186.2 58 99.3 14.9 0.2 263.8 0 No Female Occasional
1595.6 58 63.4 10.9 0 214.1 0 No Female Regular
1249.6 59 24.2 14.7 0 97.2 0 No Female Regular
1546.6 59 72.9 15.1 0.7 192.8 0 No Female Regular
2192.3 59 78.7 14.2 0 173.5 0 No Female Regular
659.3 60 22.2 7 0.1 102 0 No Female No
1327 60 64.8 9.3 0.1 341 0 No Female No
1333.8 60 37.1 16.9 6.5 84 0 No Female Occasional
2114.8 60 77.6 14.9 0.5 239.9 0 No Female Regular
1506.7 60 76.3 14.6 0 239.2 1 Yes Female No
1570.1 61 58.7 19.3 2 158.3 0 No Female No
2837.3 61 84.2 33.8 0 192.1 0 No Female Regular
2115.4 62 84.1 23.9 0 189.5 0 No Female No
1323 62 60.8 11.4 0 155.8 0 No Female Occasional
1588.1 62 88.9 7.4 0 362.6 0 No Female Regular
1823 62 80.3 17.4 6.2 256.8 0 No Female Regular
1751.1 62 80.7 8.4 14.1 160.3 0 No Male Regular
1655.9 63 70.8 15.1 0.1 177.3 0 No Female No
1282.3 63 26.4 13.6 0.1 100.6 0 No Female Regular
1008.4 64 35.4 5.6 14 37.7 0 No Female No
2055.7 64 114.4 13 0 248.4 0 No Female Occasional
1298.8 64 57 6.3 0 170.3 0 No Female Regular
1828 64 63.4 14.7 0 87.9 0 No Female Regular
2319.9 64 97.6 22.3 0 155.3 0 No Female Regular
2868.5 64 128.8 15 20 379.5 0 No Male No
1747.6 65 83.6 10.9 0 244.8 0 No Female No
1276 65 60.5 12 3.5 87.3 0 No Female No
2213.9 65 52 28.7 0 255.1 0 No Female Occasional
1446.2 65 56.8 10.8 0 127.9 0 No Female Regular
2055.9 65 111.8 15.9 0 226.5 0 No Male No
1220.7 65 34.6 16.5 5.6 152.8 0 No Male No
6662.2 65 164.3 11.3 203 603 1 Yes Male No
3184.8 66 199 16.8 0.2 362.6 0 No Female No
958.5 66 37.7 8.3 0 108.6 0 No Female No
2086.6 66 72.3 16 0 112.8 0 No Female No
1563.7 66 73.3 12 1.1 300.9 0 No Female Occasional
1762.1 66 72.9 16.5 0 240.3 0 No Female Occasional
1460.8 66 58 18.2 1 137.4 0 No Female Regular
987.5 66 35.6 10.3 0 254.9 0 No Female Regular
1574.3 66 75 7.1 0 361.5 0 No Male No
1902.4 66 76.7 17.7 3.1 216.7 0 No Male Regular
849.2 67 25.4 10.9 0 91.7 0 No Female Regular
1049.2 67 44.6 9.6 0 247.2 0 No Female Regular
2021.2 67 94.8 13.3 8 417.6 0 No Male No
1628.5 68 78.6 11.6 0 512.3 0 No Female No
1174.7 69 47.4 9.9 0.1 89.9 0 No Female No
2332.2 69 109.6 19.7 0.1 286.7 0 No Female No
1756.4 69 82.3 8.8 0 500.3 0 No Male No
1711.4 69 98.2 10.8 0.3 332.4 0 No Male Occasional
827.9 69 32.8 8.7 0 79.8 0 No Male Regular
2654.9 69 126 23.3 0 248 1 Yes Male No
2017.2 70 136 7.6 0 195.8 0 No Female No
1387.7 70 55.2 11.2 0 114 0 No Female Occasional
1235.9 70 51.1 9.6 3 142 0 No Female Regular
2005.8 70 89.5 8.5 0.1 121.2 0 No Female Regular
1730.6 70 72.9 14.4 0.2 363.1 0 No Female Regular
1514.4 70 51.7 14.2 7 97.5 1 Yes Female No
1397.4 70 60.5 9.2 0 228.5 0 No Male No
1399.5 71 66.5 9.6 8 260 0 No Female No
1305.4 71 43.3 10.2 0 72.7 0 No Female Regular
1215.8 71 43.8 12.3 5 110.8 0 No Female Regular
1285.8 71 55.4 10.6 2 353.4 0 No Male No
1850.5 71 75.9 16.1 7.2 247.9 0 No Male No
1247.7 72 46.8 10.2 0 347.9 0 No Female No
1952.1 72 82.6 16.2 0 170.8 0 No Female Regular
1111.9 72 47.2 10.2 0.2 69.4 0 No Female Regular
976.7 72 68.4 3.1 0 99.6 0 No Female Regular
840.6 73 34.3 8.2 0.1 81.1 0 No Female No
853.1 73 29.8 6.3 10 160.5 0 No Female Occasional
1186.4 73 46.1 10.5 1.5 119.7 0 No Female Regular
1678.5 73 82.3 6.3 14.1 249.5 1 Yes Female Occasional
2833.7 73 119.9 14.6 18.2 365 0 No Male No
1666.8 73 76.5 13.3 0 747.5 0 No Male Regular
2453.5 73 118.5 10.3 0 516.5 1 Yes Male No
818.1 74 34.3 6.6 3.7 55.4 0 No Female No
1718.9 74 57.9 15 1.2 272.7 0 No Female Occasional
1202 74 46.6 11.4 0 59.2 0 No Female Regular
1512.1 74 73.8 8.7 5.7 182.8 0 No Female Regular
1241 74 53.1 10.8 0.1 206.1 1 Yes Female No
1837 74 76.9 13.6 0 383.6 0 No Male No
2171.6 74 76.6 20.4 0 176.3 0 No Male No
1380.6 75 54.5 13.5 0.1 201.6 0 No Female Occasional
1396.8 75 53.3 13.2 3.2 99.3 0 No Female Regular
1049.1 75 51.7 8 0 188.9 0 No Female Regular
2511.5 75 92.3 36.8 0.6 228.3 0 No Female Regular
1407.6 75 35 20.8 7 144.1 0 No Male Regular
1032.5 76 50.1 15.8 0 75.8 0 No Female Regular
866.9 77 31 9.8 0.2 59.7 0 No Female Regular
1481.4 77 55 11.2 0 191.7 0 No Female Regular
2075.2 77 75.6 21.4 0 228.8 0 No Male Occasional
647.7 78 30.9 3.7 0 87.5 0 No Female Occasional
1531.6 78 69.5 5.4 0 168 0 No Female Regular
1708.1 82 94.2 15.1 2 224.7 0 No Female Regular
1331.2 83 50.6 7.7 0.3 380.7 0 No Female Occasional
1933.6 83 98.8 11.1 0 224.7 0 No Male Regular
1534.7 83 54.9 26.3 0 77.5 0 No Male Regular

Variable INFO

A random sample of 315 patients involved in a nutrition study.
Source
Variables
Calories
Age Age in years
Fat
Fiber
Alcohol
Cholesterol
Smoke 1=Yes 0=No
Gender (Male, Female)
VitaminUse (Regular, Occasional, No)

Q1

Q1 There is a general perception that males' intake of average calories is significantly higher than that of females. The data below has been extracted form the
Original data.
Female Male Q1A Write the null and alternate hypotheses.
2449.5 2072.9 What test would you use and why?
1366.9 1574.3
1800.5 2868.5
1263.6 1101.4
1628.5 2433.6
1437.3 2055.9 Q1B Conduct the test and explain the results.
2062.7 1285.8
1786.9 1896.1
2419.3 1220.7
1147.9 2833.7
1248.6 1756.4
3184.8 2021.2
1566.5 1837
1902.9 2706.7
1247.7 2825.8
818.1 1397.4
1570.1 1850.5
1126.7 2210.7
1747.6 2171.6
1887.4 2712.7
2225.1 1055
1952.7 1711.4
1256.7 2075.2
958.5 2271.1
2075.9 1751.1
1663.3 1407.6
1010.6 827.9
1546 1902.4
1324 3457.2
1220.9 2026
1174.7 1785.4
828.2 1666.8
1182.9 1933.6
1207.1 2431.9
1622.4 1534.7
3114 6662.2
2012 2798.2
1149 2654.9
659.3 2667.5
1884.8 2453.5
742.3 1951.4
1148.5 2685.1
1432.1
1051.2
2017.2
1342.2
1511.7
1200.6
1891.6
2118.1
1600.7
840.6
2120.8
1008.4
798.2
3099.2
1399.5
1655.9
3021.9
2086.6
2272.6
1469.9
2332.2
1808.4
2115.4
1695.3
1276
1327
1927.6
2046.9
2263.6
2372.3
2213.9
1638.2
1276.5
1323
3144.8
1778.1
1538.1
1656.3
1333.8
2190.7
1878.2
1331.2
2052.4
2264.3
2186.2
1653.2
1076.6
1511.7
1823.7
2328.3
1645.7
1563.7
1718.9
1187.8
928.4
1387.7
1555.6
1581.7
1719.3
2106.4
1366.6
1678.2
1390.4
1749.9
2342.3
1292.8
2038.5
1366.8
1240.7
2814.6
3328.4
1414.6
1380.6
2094.5
1823
1041.6
2010.4
2055.7
1906.5
1422.8
740.6
1292.6
3449.7
1619.3
1600.9
647.7
2166.9
2307.8
3511.1
853.1
2466.9
1762.1
2838.8
2021.1
1298.8
1032.5
1952.1
1595.6
1460.8
987.5
2114.8
1113
2837.3
2035.5
1396.8
1588.1
1111.9
1472.7
2237.4
2908.5
1436.8
2893.3
1531.6
1823
3258.3
2558.9
839
2391.3
1202
1235.9
866.9
3711
2733
1660.1
1830
1574
1646.2
1828
1288.7
1601.4
1372.7
2005.8
1446.2
976.7
1368.9
1708.1
4373.6
1305.4
1249.6
2347.3
1688.1
2501.6
2219.1
1827.7
1282.3
2000.8
1546.6
1580.6
1242.1
1099.4
1049.1
1494.5
445.2
1849.8
1730.6
1738.9
3098.9
2319.9
1550
1612.5
1576.3
1197.7
2045.3
2513.3
1737.4
2083.9
1730.1
1496.7
1525.6
2703.4
1434.9
2192.3
1626.3
1512.1
1481.4
1829.2
2585.3
3014.9
1631
2319
2511.5
1918.4
1186.4
1724.7
2170.3
2512
849.2
1392.2
1215.8
1835.9
1049.2
1841.1
1125.6
2729.6
1627

Q2

Q2 Some analyst wants to see if the intake of calories varies significantly among various age groups as given below.
Age Groups
16-25 26-35 36-45 46-55 56-65 66 -75 76 Plus Q2A Write the null and alternate hypotheses.
2558.9 1663.3 1887.4 1546 1566.5 1574.3 1032.5 What methodology would you use to test the hypothesis? Why?
1511.7 1987.2 798.2 1182.9 2225.1 1902.4 866.9
2733 1200.6 2342.3 1207.1 1436.8 849.2 1481.4
2219.1 1127.6 1240.7 1342.2 1830 1049.2 2075.2
3021.9 2919.5 1414.6 2263.6 1494.5 2021.2 647.7
928.4 1600.9 2838.8 2052.4 1743.8 1628.5 1531.6
1517.4 1041.6 2045.3 1581.7 2433.6 1174.7 1708.1 Q2B One of the key assumption is that the variances are equal.
2237.4 1959.3 1422.8 2210.7 2332.2 1331.2 Please conduct that test.
1631 1147.9 740.6 2712.7 1756.4 1933.6
2476.2 1778.1 1570.1 1288.7 1711.4 1534.7
1437.3 1653.2 2706.7 2513.3 827.9
2264.3 1645.7 2667.5 2072.9 2654.9 Q2C Assuming that you found in part B that the variances are equal,
1646.2 2094.5 2120.8 1101.4 2017.2 Run the test for the hypothesis in part A.
2729.6 2010.4 1927.6 1538.1 1387.7
1456.5 2035.5 1076.6 2186.2 1235.9
1631.5 839 1612.5 1595.6 2005.8 Q2 D Interpret the test results
1678.2 1688.1 1600.7 1249.6 1730.6
3328.4 1902.8 2021.1 1546.6 1514.4
3511.1 1034.4 2908.5 2192.3 1397.4
2703.4 1149 2893.3 659.3 1399.5
1918.4 1432.1 1242.1 1327 1305.4
2170.3 2372.3 445.2 1333.8 1215.8
1622.4 2190.7 1849.8 2114.8 1285.8
3144.8 1390.4 1738.9 1506.7 1850.5
1878.2 1619.3 1010.6 1570.1 1247.7
1366.8 1550 1469.9 2837.3 1952.1
2814.6 2585.3 1656.3 2115.4 1111.9
1835.9 1662.7 1511.7 1323 976.7
3228 1256.7 1292.8 1588.1 840.6
2271.1 1187.8 1574 1823 853.1
3457.2 1719.3 1099.4 1751.1 1186.4
2062.7 1906.5 3098.9 1655.9 1678.5
2118.1 1368.9 2512 1282.3 2833.7
1076.2 1829.2 1125.6 1008.4 1666.8
1148.7 1951.4 784.4 2055.7 2453.5
3103.7 2449.5 2825.8 1298.8 818.1
1800.5 1366.9 1902.9 1828 1718.9
3114 742.3 2012 2319.9 1202
1884.8 1638.2 2106.4 2868.5 1512.1
1555.6 3014.9 1113 1747.6 1241
2466.9 833 2340.4 1276 1837
1575.5 2431.9 2026 2213.9 2171.6
2419.3 1952.7 1446.2 1380.6
1808.4 1324 2055.9 1396.8
2046.9 2166.9 1220.7 1049.1
1823.7 828.2 6662.2 2511.5
1823 1891.6 1407.6
3258.3 1749.9
1372.7 2083.9
1197.7 1248.6
1496.7 1276.5
1102.8 1576.3
1444.6 1996.1
1055 2798.2
2685.1 4373.6
1051.2 1580.6
3099.2 1724.7
2347.3 1392.2
1737.4 1263.6
1730.1 2272.6
1434.9 2328.3
1084.3 2307.8
1785.4 1162.5
1786.9 1896.1
2075.9
1695.3
2038.5
3449.7
1472.7
3711
2501.6
2000.8
1626.3
1220.9
1148.5
1292.6
2391.3
1660.1
1525.6
1877.4
1446.2
1427.2
3183.1
1810
1126.7
1366.6
1601.4
1827.7
2319
1841.1
1627
1481.8

Q3

Q3 Conduct the Tukey- Kramer test to determine which age groups consume calories significantly different from each other.

Q4

Q4 Now you want to explore if a regression model could be developed to predict calories in take based on the relevant variables in the data.
Q4A Run a correlation matrix involving all numerical variables in the data.
Q4B Run simple regression with most promising variable to predict calories.
Make sure that you click on residual plots and normality curve.
Q4C Test all four assumptions of regression analysis.

Q5

Q5 Going back to the correlation matrix, add more independent variables as appropriate to determine the best regression model.
Explain why the model selected is the best.

Q6

Q6 One analyst is curious if one can predict using this data if someone is a smoker.
To this end, she wants you to develop a logistic regression model using only the numerical variables.
A Develop such a model using age, Fat and alcohol.
B Remove the insignificant variables ad rerun the logistic regression.
C Assuming some reasonable values of the significant variables, calculate the probability of
predicting of someone is a smoker.

Q7

Q7
A What kinds of non-parametric tests can you conduct on this data?
Please explain the purpose of each of the tests suggested.
B Going back to questions 2, could we have done two way ANOVA analyses? If so, how?
(You do not need to do any analysis.)
C What kind of Chi-Square tests could you do using the nutrition data?
(You do not need to do any analysis.)

% Polygons 2 Groups

Histogram

Freq & % Distribution

Frequency Distribution for Calories
bins Midpts. Frequency Percentage
-0.01 -- 0 0.00%
999.99 500 20 6.35%
1999.99 1500 194 61.59%
2999.99 2500 83 26.35%
3999.99 3500 16 5.08%
4999.99 4500 1 0.32%
5999.99 5500 0 0.00%
6999.99 6500 1 0.32%
Total 315 100.00%