Statistics Question

statistics question and need the explanation and answer to help me learn.

everything is solved in chegg and course hero so yours is to compile and give me answers but you should remove plag for the report
there are two assignment here so ineed to submissions
so start with week 10assignment fisrt and send it as soon as u finish
Requirements: good no plag
MTBEpHSpConductDissOxyRoadsPctIndPctUrbanPctDevPctWellClassAquiÞerDepthSafeYldDistanceMTBE-DetectMTBEHouseDenPopDen7.872900.581.34017.7717.77PrivateBedrock60.96*2386.29Below Limit0.2131.1643.198.63225.90.840.72010.4310.43PrivateBedrock36.576*3667.69Below Limit0.247.6924.527.11157.48.371.92029.6250.01PrivateBedrock152.4*2324.15Below Limit0.285.1633.327.98723.60.412.76041.6541.65PrivateBedrock**788.88Below Limit0.2134.7746.617.88148.71.443.51051.2151.21PrivateBedrock91.44*1337.88Below Limit0.2198.5478.588.36198.20.181.48022.4929.19PrivateBedrock115.824*2396.74Below Limit0.2206.7359.476.92807.21.852.86040.5943.44PrivateBedrock92.964*1425.59Detect0.51272.5481.027.1567.66.160.781.3514.5415.56PrivateBedrock85.344*2053.95Below Limit0.227.359.247.5510773.931.5016.7916.79PrivateBedrock**1672.33Detect1.3286.8926.616.25320.17.143.6061.1764.18PrivateBedrock48.768*1374.62Below Limit0.2919.12331.96.81381.30.311.79028.6728.67PrivateBedrock40.8432*1212.42Detect0.95223.8785.437.02494.81.542.76077.4589.34PrivateBedrock**564.99Below Limit0.2206.4955.488.52198.40.221.01015.721.17PrivateBedrock126.492*1530.39Below Limit0.224.38.956.3995.11.820.7907.87.8PrivateBedrock76.2*1402.41Below Limit0.220.548.57.37207.41.522.6046.554.81PrivateBedrock91.44*2345.26Detect0.53275.9786.027.55656.23.034.421.7152.9152.91PrivateBedrock**2319.45Below Limit0.2902.32231.088.14209.30.592.93049.4749.47PrivateBedrock92.964*2652Below Limit0.2159.7807.3629320.412.31.9146.0746.07PrivateBedrock**2079.43Below Limit0.2278.9584.247.95655.20.53.99015.6615.66PrivateBedrock36.576*1289.45Below Limit0.239.6513.838.1253.90.33.11.7640.7440.75PrivateBedrock55.7784*704.54Below Limit0.2189.2750.476.91801.94.733.467.6366.1866.59PrivateBedrock**534.73Below Limit0.2624.61280.687.56516.10.516.04050.2150.21PrivateBedrock42.672*1953.26Detect2.44798.59244.477.15482.63.430.4807.177.17PrivateBedrock159.4104*3073.95Below Limit0.293.8830.297.82573.622.06039.1839.18PrivateBedrock**3758.84Below Limit0.2164.7759.928.672132.453.85057.5877.19PrivateBedrock115.824*852.4Below Limit0.21425.35457.197.17275.64.311.71028.0329.14PrivateBedrock76.2*1846.88Below Limit0.2109.2138.658.49163.581.1206.8218.41PrivateBedrock**2761.02Below Limit0.2887.15142.40.342.29042.2242.22PrivateBedrock54.864*3660.18Below Limit0.2102.0632.368.12217.60.361.85013.6914.38PrivateBedrock91.44*4464.04Below Limit0.262.7419.038.48299.70.11.39020.7720.77PrivateBedrock137.16*4326.18Below Limit0.277.3728.137.07418.42.953036.3836.38PrivateBedrock43.2816*1748.02Below Limit0.299.4933.167.87209.33.290.8107.2915.61PrivateBedrock103.632*1643.68Detect0.3118.767.259.46238.37.760.7206.756.75PrivateBedrock129.2352*3060.33Below Limit0.223.527.138.66425.712.9041.3641.36PrivateBedrock**1891.51Below Limit0.251.719.197.87528.52.213.56081.1396.04PrivateBedrock76.2*1714.4Detect0.97269.5788.067.13542.62.730.92014.6919.32PrivateBedrock60.96*1980.28Below Limit0.2168.7771.348.08574.80.722.582.4633.4837.27PrivateBedrock**495.66Below Limit0.2234.92113.418.07344.20.553.65070.8471.97PrivateBedrock48.768*1067.79Detect1.71392.65127.036.56199.12.064.732.2593.4293.42PrivateBedrock**1312.44Below Limit0.21025.48384.567.73386.12.290.6208.8114.04PrivateBedrock92.3544*3649.14Below Limit0.266.2921.647.8918070.442.172.2638.9551PrivateBedrock110.0328*1632.66Below Limit0.222.618.418.521620.241.07017.231.89PrivateBedrock98.4504*2378.3Below Limit0.266.2921.646.7402.841.3024.5224.52PrivateBedrock**1582.48Below Limit0.2437.77116.437.29577.12.461.0902020PrivateBedrock**1590.87Below Limit0.271.5820.216.67615.32.384.18068.5968.59PrivateBedrock**2552.87Detect0.26405.37127.069.192032.670.4903.753.75PrivateBedrock182.88*2685.3Detect2.6745.6715.446.771910.681.85010.9210.92PrivateBedrock**4671.88Below Limit0.236.9517.248.11650.423.08063.5966.62PrivateBedrock**2277.12Below Limit0.2204.4363.77.972250.332.264.4140.2955.52PrivateBedrock153.924*1584.78Below Limit0.2120.151.998.21153.91.832.090.2447.5565.61PrivateBedrock68.58*2154.46Below Limit0.2204.4363.78.32240.80.931.87035.0235.02PrivateBedrock137.16*3438.3Below Limit0.2245.1775.58.3277.40.52.025.8717.9829.35PrivateBedrock**1542.17Below Limit0.283.4531.299.48409.70.253.31.1623.9230.79PrivateBedrock121.92*296.95Detect0.3339.5632.621
7.19419.62.141.76034.1234.12PrivateBedrock76.2*1348.52Below Limit0.296.4129.297.06138.74.880.8808.5111.14PrivateBedrock54.864*582.1Below Limit0.248.7218.565.58865.22.861.970.5617.4925.99PrivateBedrock47.244*384.69Below Limit0.223.527.138.33201.50.183.1036.4236.42PrivateBedrock153.924*898.79Below Limit0.2274.7282.647.246930.391.93027.4827.48PrivateBedrock115.824*2167.92Detect0.24169.6956.168.36272.10.312.682.6640.9145.08PrivateBedrock159.4104*200.47Below Limit0.2290.94100.828.341781.692.58048.9148.91PrivateBedrock254.508*2806.03Below Limit0.2215.4670.797.97231.90.82.08033.7734.54PrivateBedrock**2530.6Below Limit0.2428.05115.747.7341.11.022.65045.3145.31PrivateBedrock111.252*4902.19Detect0.93298.1391.095.62883.73.133.071.9244.0150.34PrivateBedrock**1319.92Detect0.34335100.246.6614723.612.955.142.3449.68PrivateBedrock67.056*972.24Detect0.37335100.245.94216.97.862.2024.6425.42PrivateBedrock36.2712*1129.44Below Limit0.2169.5473.328.02164.15.780.1404.634.63PrivateBedrock114.3*1519.17Below Limit0.251.0817.777.37338.65.251.7021.5957.54PrivateBedrock30.48*2527.29Below Limit0.270.1336.365.83454.55.981.6207.8319.92PrivateBedrock91.44*3249.34Below Limit0.232.3722.377.12180.84.591.76028.2228.22PrivateBedrock174.9552*1849.1Below Limit0.239.9212.226.65362.63.881.52020.9221.22PrivateBedrock**1214.51Below Limit0.2439.55109.896.2611306.994.21.3747.0147.01PrivateBedrock103.632*1579.3Below Limit0.2431.12130.346.42622.36.980.76011.4516.78PrivateBedrock53.34*4467.88Below Limit0.234.0111.516.06886.612.64011.1911.19PrivateBedrock92.6592*1728Below Limit0.297.7837.616.43466.22.182.43044.3344.33PrivateBedrock91.44*2757.15Below Limit0.2273.483.57.45265.74.853.79058.7258.72PrivateBedrock245.364*951.09Below Limit0.254.8519.518.16161.90.42.98039.3739.37PrivateBedrock**1351.95Below Limit0.254.8519.517.31227.31.562.4042.3342.34PrivateBedrock**1266.05Below Limit0.243.5816.347.5911.361.021.28022.7828.49PrivateBedrock91.44*2624.08Below Limit0.2108.8140.997.51410.30.492.14035.0235.02PrivateBedrock**1441.05Detect1.16166.1352.087.13536.60.44.82.1556.9956.99PrivateBedrock91.44*2407.7Detect1.6215.4477.058.09465.10.434.92.9136.3254.99PrivateBedrock121.92*747.75Below Limit0.2138.1258.578.3312310.440.971.112.750.78PrivateBedrock121.92*1179.23Below Limit0.284.2530.767.4220.61.362.264.940.1652.01PrivateBedrock73.152*754.58Below Limit0.2203.2983.165.66473.24.981015.2815.57PrivateBedrock51.816*2694.44Below Limit0.2138.0543.928.36277.90.273.24034.1136.18PrivateBedrock36.576*3322.18Detect0.33590162.257.642014.440.817.887.88PrivateBedrock152.4*2224.19Below Limit0.220.796.88.39236.70.560.8602438.13PrivateBedrock128.3208*2682.48Below Limit0.243.8515.585.91387.86.724.56044.2244.22PrivateBedrock38.1*2944.24Detect3.86741.85209.248.26204.62.71.93031.3435PrivateBedrock243.84*1522.78Detect0.3157.8619.026.18190.34.170.85012.425.56PrivateBedrock159.4104*5180.58Below Limit0.23.091.336.72280.40.780.8107.637.63PrivateBedrock85.344*3458.03Below Limit0.220.127.048.22175.91.320.4805.595.59PrivateBedrock128.9304*2762.89Below Limit0.220.127.047.97331.70.440000PrivateBedrock**365.9Below Limit0.2**6.59265.16.292.580.5923.4323.43PrivateBedrock18.8976*784.06Below Limit0.242.114.528.24694.33.273.5049.3549.35PrivateBedrock91.44*1711.46Detect0.39174.7785.677.15545.70.111016.0919.34PrivateBedrock**3181.14Detect0.4830.8910.597.43165.11.682.26027.3131.68PrivateBedrock79.248*3094.32Below Limit0.240.9413.827.87199.20.241.993.5633.2233.22PrivateBedrock45.72*687.07Below Limit0.2417.65159.698.11227.90.230.76015.1815.18PrivateBedrock45.72*1082.94Below Limit0.28.174.228.22135.40.441.86043.7143.71PrivateBedrock88.392*1832.5Below Limit0.2206.6877.747.61608.10.612.05038.5838.58PrivateBedrock121.92*2685.91Below Limit0.262.8729.946.6893.54.391.83020.7321.68PrivateBedrock30.48*2772.19Below Limit0.2233.866.87.52265.20.463.14031.1531.15PrivateBedrock47.244*831.1Below Limit0.2113.9848.57.43663.20.562.26027.4227.42PublicUnconsoli15.241514.004541142.56Detect0.2517.717.387.76919.36.6310.6222.4172.0272.71PublicUnconsoli15.241324.75397274.61Below Limit0.2132.2246.27.01409.95.941.580.8420.8820.88PublicUnconsoli19.20241052.23316775.4Below Limit0.292.2433.896.55248.67.072.091.3440.5949.97PublicUnconsoli15.24946.252839685.17Below Limit0.2375.34114.847.9122310.64.16.5443.0843.08PublicUnconsoli14.6304946.2528393192.79Below Limit0.277.0134.232
7.51428.57.941.95035.4251.9PublicUnconsoli24.9936946.2528392440.35Detect1.06146.1152.567.7558.11.431.9208.2422.54PublicUnconsoli18.288757.0022712573.78Below Limit0.263.7620.56.1188.20.740.73.525.414.01PublicUnconsoli*757.002271804.76Below Limit0.253.0322.276.57460.41.260.5406.8467.8PublicUnconsoli15.24567.7517033009.59Below Limit0.224.477.717.644830.355.4056.3356.33PublicBedrock48.768492.0514761059.41Detect0.35698.3255.297.58399.71.742.7318.3540.8340.83PublicBedrock99.06473.126419130.48Detect3.1150.5156.717.87225.15.221.42018.6318.63PublicBedrock42.672378.5011363627.21Below Limit0.254.7417.428.09248.50.373.0411.852.5456.8PublicBedrock106.68378.5011361090.68Below Limit0.285.0727.317.9516.60.43.421.9166.4371.67PublicBedrock68.58325.5109771478.05Below Limit0.2278.9584.246.4527.82.142.41029.0331.36PublicBedrock42.672264.9507951945.64Detect0.39221.4192.238.05199.90.42000.520.52PublicBedrock80.772246.0257381049.97Below Limit0.237.9213.977.66293.70.793.553.236.8136.81PublicBedrock91.44227.1006811346.78Below Limit0.2479.3282.698.08387.80.712.864.2162.7162.71PublicBedrock155.448227.1006811379.81Below Limit0.2913.53393.527.282943.332.591.6745.2245.64PublicBedrock60.96227.100681891.93Detect0.36352.28115.776.31165.73.073.73058.8360.84PublicUnconsoli13.4112189.2505681941.97Below Limit0.2554.57163.117.2211780.394.573.1142.942.92PublicBedrock286.8168189.250568996.74Detect1.01199.2968.727.98240.70.34000.520.99PublicBedrock68.58170.325511953.12Below Limit0.237.9213.978.39413.50.482.972.232.5632.56PublicBedrock81.6864158.970477610.9Detect0.33500.28200.117.84439.15.073.11064.8866.4PublicBedrock100.584151.4004541007.11Detect1.48553.21146.586.28360.32.982.33027.529.67PublicBedrock77.724151.4004541978.78Detect0.35221.4192.236.94428.20.363.623.0941.1650.71PublicBedrock121.92143.830431335.22Below Limit0.2221.4192.237.47871.50.394.623.0743.5543.55PublicBedrock225.552140.045421006.58Detect0.83199.2968.726.49287.54.773.5714.1444.6150.17PublicBedrock53.34132.475397264.93Detect0.2399.7947.596.0578.66.933.570.6852.6260.2PublicUnconsoli10.668132.4753971664.94Below Limit0.2367.48146.056.41444.22.523.970.8562.0262.02PublicBedrock54.864132.4753971516.36Below Limit0.2156.8549.188.73541.37.815.1617.1134.1741.15PublicBedrock182.88121.120363111.42Detect0.49164.307.22286.50.63.28040.7840.78PublicBedrock45.72113.550341367.52Below Limit0.2117.2207.0810346.894.22066.8970.52PublicBedrock79.248113.5503411245.9Below Limit0.21225.49318.637.1410681.234.62070.6774.3PublicBedrock79.248113.5503411244.09Below Limit0.21225.49318.637.45359.51.531.36020.6626.7PublicBedrock42.672113.5503412487.94Below Limit0.2269.2482.937.47359.21.531.37020.6526.86PublicBedrock42.672113.5503412487.54Below Limit0.2269.2482.937.86493.90.474.538.9258.5666.52PublicBedrock45.72113.550341738.61Detect4.02699.43310.988.04306.10.283.1048.4251.4PublicBedrock109.728113.5503411729.81Below Limit0.2129.4256.627.64103.76.821.8037.2262.56PublicBedrock45.72113.5503413632.06Below Limit0.2143.8441.956.12395.13.224.39061.9766.88PublicBedrock182.88113.5503412193.56Detect2.97336.82129.058.56623.10.411.8823.7730.3257.13PublicBedrock57.912113.550341406.54Below Limit0.2164.5656.047.61497.77.841.150.1619.2521.5PublicBedrock54.864109.765329786.84Below Limit0.2176.1760.917.441440.392.95040.8243.1PublicBedrock200.5584105.980318405.78Detect1.29314.98224.987.5712351.144.11069.4569.45PublicBedrock91.44102.1953071075.11Detect2.06712.04265.15.28671.24.721.37.4418.6118.61PublicBedrock42.67298.410295256.25Detect2.92672.16339.545.34625.94.451.37.4418.6118.61PublicBedrock73.15298.410295251.53Detect2.23672.16339.546.5287.94.183.12047.5748.39PublicBedrock121.9294.6252839549.75Detect1.5247.2307.66114.12.744.7035.8435.95PublicBedrock97.53694.62528392861.51Below Limit0.28626.418.1200.20.721.60.2122.9522.95PublicBedrock97.53694.6252839574.59Detect0.26103.0358.237392.30.423.713.0941.450.07PublicBedrock153.92494.6252839330.46Below Limit0.2221.4192.237.97304.80.483.148.8726.6826.68PublicBedrock182.8894.6252839391.18Detect6.43141.8468.937.96318.50.363.158.8126.6126.61PublicBedrock182.8894.6252839386.26Detect3.57141.8468.937.82203.50.515.3513.0262.1770.43PublicBedrock152.494.6252839470.44Below Limit0.2240.1587.658.06273.10.41.25022.6125.19PublicBedrock42.67290.84027252493.96Below Limit0.283.6624.526.33420.93.321.484.8623.0232.98PublicBedrock48.76883.2702498597.65Below Limit0.251.518.278.38562.70.552030.7436.45PublicBedrock48.76883.27024982270.32Below Limit0.2158.4572.985.7737.38.314.44021.4721.82PublicUnconsoli5.791275.70022712181.65Below Limit0.265.12417.666.15291.48.143.1610.841.7852.06PublicUnconsoli7.924875.7002271929.21Below Limit0.293.8830.296.53221.80.391.28010.1423.11PublicBedrock48.76875.70022711084.34Below Limit0.2152.1145.638.22584.74.52.26025.5939.68PublicBedrock152.468.13020442832.47Below Limit0.2202.03114.413
7.75408.87.522.14023.4132.28PublicBedrock89.91664.3451934147.82Detect4.16178.2952.885.59906.73.611.734.8414.9514.95PublicBedrock76.256.7751703265.08Detect0.26142.9668.648.02399.30.351.97022.430.36PublicBedrock214.88456.77517031098.26Below Limit0.289.7630.778.04238.40.461.6022.3623.99PublicBedrock140.20856.7751703553.67Below Limit0.231.7813.847.415701.761.6613.7532.8332.83PublicBedrock146.30456.7751703911.75Below Limit0.279.5628.786.65405.50.534.41062.0166.96PublicBedrock134.11256.77517032197.44Detect2.21336.82129.057.87304.21.570.0704.544.54PublicBedrock129.5456.77517031150.91Below Limit0.2102.3335.76.53304.86.330.0600.060.06PublicBedrock99.0645.42013633632.12Detect0.2725.859.97.32209.53.510000PublicBedrock152.441.63512492315.74Detect3.33127.54*6.321760.413.13037.0737.07PublicBedrock60.9637.8501136162.03Detect0.39800.1373.387.81189.58.260.7108.2419.35PublicBedrock79.24837.85011361842.73Below Limit0.218.767.257.74411.841.42026.5931.87PublicBedrock91.4437.85011363084.46Detect0.72160.7179.867.49873.50.452.62059.6661.18PublicBedrock77.114437.85011361114.43Below Limit0.2553.21146.587.59390.42.254.2317.4641.1353.45PublicBedrock112.77637.8501136782.47Detect2.7134.0457.456.95532.60.413.75054.8554.85PublicBedrock61.569637.8501136626.39Below Limit0.2370.43166.266.58577.23.191.4511.4717.0817.99PublicBedrock76.237.85011361193.43Below Limit0.263.0321.016.91293.90.442.888.1127.6127.61PublicBedrock152.434.0651022888.77Detect0.31059.28437.538.17301.71.11.57026.5429.36PublicBedrock152.434.06510222909.45Detect2.14160.7179.868.96213.30.13.2212.4422.9930.56PublicBedrock134.11234.06510222957.61Below Limit0.234.9711.777.78352.34.793.178.4225.5825.58PublicBedrock182.8832.1725965333.35Detect2.61141.8468.937.24101.34.32.451.9626.7931.79PublicBedrock90.525630.2800908604.23Below Limit0.299.7947.597.7577.40.51.4212.9117.0536.81PublicBedrock188.97630.2800908599.11Below Limit0.2240.4167.027.27256.27.542.19025.125.1PublicBedrock160.0230.28009081451.97Detect46.2155.0874.178.81241.40.364.72050.455.44PublicBedrock70.10426.49507951272.95Below Limit0.2471.21178.38.05399.20.354.9436.4270.0370.03PublicBedrock76.226.4950795254.57Detect48.1467.61160.597.6610190.432.447.2260.5862.01PublicBedrock80.162426.4950795916.83Detect0.96332.67163.417.3426.70.594.999.229.0235.93PublicBedrock121.9224.6025738141.77Below Limit0.265.1208.12234.80.531.2018.5929.22PublicBedrock91.4422.7100681716.44Below Limit0.231.7813.847.4418.37.332.26023.6832.55PublicBedrock132.58822.71006814156.63Detect4.34178.2952.888.21238.60.431.34021.4727.16PublicBedrock60.350418.9250568723.89Below Limit0.2132.1844.438.12161.20.491.7711.3532.6432.64PublicBedrock152.418.9250568270.91Below Limit0.239.5914.797.53447.60.322.7218.7940.1340.13PublicBedrock121.9218.925056865.93Detect15.61150.5156.717.4511920.174.3321.3635.8951.75PublicBedrock152.418.9250568142.26Detect32.874.7426.038.31208.50.593.8052.1455.38PublicBedrock91.4411.35503411703.94Below Limit0.2706.51297.056.4152.22.733.2810.9632.7632.76PublicBedrock38.111.3550341539.56Below Limit0.258.3818.367.34522.70.533.9915.2660.160.1PublicBedrock310.8967.570022711292.41Detect10.6479.3282.697.28308.23.252.85045.756.57PublicBedrock68.587.570022713066.18Below Limit0.2306.26103.737.86301.20.371.37022.4248.69PublicBedrock44.8056*1812.88Below Limit0.267.0225.377.37182.50.630.5909.469.46PublicBedrock47.8536*4651.51Below Limit0.23.091.337.39245.41005.335.33PublicBedrock46.0248*5239.42Below Limit0.23.091.338.15194.11.31.63035.5750.02PublicBedrock**1694.76Below Limit0.271.8723.57.35531.45.71.35013.5131.6PublicUnconsoli15.24*2935.85Detect0.7263.7620.58.07272.30.51.64013.5366.28PublicBedrock43.8912*1963.71Below Limit0.212.986.497.62579.62.572.5025.8532.34PublicBedrock45.72*1307.4Detect0.37136.4106.02391.96.073.289.9748.4155.81PublicUnconsoli13.716*1079.9Below Limit0.293.8830.297.6291.82.091.82021.7527.26PublicBedrock**531.89Below Limit0.217.4508.32547.10.351.35016.0316.03PublicBedrock61.8744*3909.57Below Limit0.261.5420.786.0412274.41.941.2820.5920.59PublicBedrock86.868*58.88Detect0.84103.0358.239.03414.60.413.193.6640.6557.37PublicBedrock**3066.65Below Limit0.2230.5781.595.43165.32.532.46019.6319.63PublicUnconsoli**1039.99Detect0.34101.6429.047.35131.883.05041.0341.03PublicUnconsoli**953.94Detect0.2417.717.385.85741.75.293.72052.7956.03PublicUnconsoli9.144*1746.12Detect0.33217.3984.156.6411.57.991.880.8433.5533.55PublicUnconsoli15.24*596.88Below Limit0.292.2433.896.56329.55.121.370.8416.5716.57PublicUnconsoli13.4112*812.91Detect0.8372.6929.477.69400.81.482.5217.6123.1124.88PublicBedrock**418.25Below Limit0.2183.1158.014
7.5264.88.452.9447.552.74PublicBedrock60.96*242.05Below Limit0.2130.8745.367.22369.54.041.39011.4455.1PublicUnconsoli15.24*2770.26Below Limit0.273.0716.247.84335.60.411.55030.0645.99PublicBedrock106.68*1899.85Below Limit0.294.5729.957.75863.70.53.1714.9241.6247.58PublicBedrock45.72*1358.67Below Limit0.2216.7964.026.33431.83.881.712.128.5854.72PublicUnconsoli4.572*2181.43Below Limit0.284.2530.765
GASTURBINEENGINESHAFTSRPMCPRATIOINLET-TEMPEXH-TEMPAIRFLOWPOWERHEATRATETraditional1272459.211346027163014622Traditional11400012.295044615272613196Traditional11738414.8114953720524711948Traditional11108511.8102447827672611289Traditional11404513.2114955329772611964Traditional1621115.711725171765260010526Traditional1621017.411775101935750010387Traditional1360013.511465033158960010592Traditional1300015.1114652437511370010460Traditional1300015117152551416430010086Traditional11800012.7103852511200014628Traditional1111409.1103852325522313396Traditional11663015123257119550011726Traditional2790015.61077482471170011252Traditional15100109634851232655512449Traditional1516012.311355421444217011030Traditional1360012.611135342958665010787Traditional1300012.3112454141012470010603Traditional1300014.2120455351517298510144Traditional11400015.9117752127693011674Traditional1366014.61135526561483811510Traditional1540015.311495141724950010946Traditional1360014.2114152636210937010508Traditional1360011114954435410871910604Traditional1360014.2117752537812050010270Traditional1300014.2111651144813222010529Traditional1300011.1114953750015701010360Traditional1225166.68995127121014796Traditional1149509.791644419351512913Traditional11495010.7105451719460012270Traditional114950121093513225500118421
Traditional11495015112149027752010656Traditional2856816.2106646439928611360Traditional2856817.61104487421068511136Traditional11122015.81121493491350010814Traditional144738.99605171583277613523Traditional1360012.410795153118160011289Traditional1300012.5104149040010050011183Traditional21040015105747926684410951Advanced16600201288546120430009722Advanced1510014.812885902047090510481Advanced1360015.513275994481740009812Advanced1360018.513716264451866009669Advanced1300014.613275996482596709643Advanced1300023.214275666852820009115Advanced1300023.214276216853310009115Advanced1728014.31271556491368011588Advanced1728014.61271556882701010888Advanced136001613436074531854009738Advanced136002014275965672540009295Advanced130001713435866512703009421Advanced130002114275877373340009105Advanced1540016.112885311886230010233Advanced1540016.213105891876800010186Advanced136001612885514251536009918Advanced1360016.913435774401820009209Advanced136001513495904501865009532Advanced130001412605855101890009933Advanced1360019.214275945502530009152Advanced130001713165846422655409295Aeroderiv2330006.9888513348616243Aeroderiv2300008.51004561480614628Aeroderiv2189101410665328184512766Aeroderiv336003512884481525793087142
Aeroderiv3360020116045684256009469Aeroderiv21600010.6123256014381511948Aeroderiv11460013.41077536204942124143
STAT 311
Week 10 Homework Assignment
50 Points
(12 Points) Bus Rapid Transit study. Bus Rapid Transit (BRT) is a rapidly growing trend in the provision of public transportation in America. The Center for Urban Transportation Research (CUTR) at the University of South Florida conducted a survey of BRT customers in Miami (Transportation Research Board Annual Meeting, January 2003). Data on the following variables (all measured on a 5-point scale, where 1 = “very unsatisfied” and 5 = “very satisfied”) were collected for a sample of over 500 bus riders: overall satisfaction with BRT (), safety on bus (), seat availability (), dependability (), travel time (), cost (), information/maps (), convenience of routes (), traffic signals (), safety at bus stops (), hours of service (), and frequency of service (). CUTR analysts used stepwise regression to model overall satisfaction ().
(1 Point) How many models are fit at Step 1 of the stepwise regression?
(1 Point) How many models are fit at Step 2 of the stepwise regression?

(1 Point) How many models are fit at Step 11 of the stepwise regression?
(6 Points) The stepwise regression selected the following eight variables to include in the model (in order of selection): and . Write the equation for that results from stepwise selection.

(1 Point) The model, part d, resulted in Interpret this value.

(2 Points) Explain why the CUTR analysts should be cautious in concluding that the “best” model for has been found.

(28 Points) Cooling method for gas turbines. Refer to the Journal of Engineering for Gas Turbines and Power (January 2005) study of a high-pressure inlet fogging method for a gas turbine engine. A number of independent variables were used to predict the heat rate (kilojoules per kilowatt per hour) for each in a sample of 67 gas turbines augmented with high-pressure inlet fogging. The independent variables available are engine type (traditional, advanced, or aeroderivative), number of shafts, cycle speed (revolutions per minute), cycle pressure ratio, inlet temperature (), exhaust gas temperature (), air mass flow rate (kilograms per second), and horsepower (Hp units). The data are saved in the GASTURBINE file. Engine type is a qualitative independent variable at three levels. Use traditional as the base level and define dummy variables for advanced and aeroderivative.

(3 Points) Use stepwise regression (with stepwise selection) to find the “best” predictors of heat rate. Use 0.05 to enter and 0.05 to remove.
(1 Point) What variable enters at Step 1?
(1 Point) What variable enters at Step 2?
(1 Point) What variable enters at Step 3?

(3 Points) Use stepwise regression (with forward selection) to find the “best” predictors of heat rate. Use 0.05 to enter.
(1 Point) What variable enters at Step 1?
(1 Point) What variable enters at Step 2?
(1 Point) What variable enters at Step 3?
(9 Points) Use stepwise regression (with backward elimination) to find the “best” predictors of heat rate. Use 0.05 to remove.
(1 Point) What variable is removed at Step 1?
(1 Point) What variable is removed at Step 2?
(1 Point) What variable is removed at Step 3?
(1 Point) What variable is removed at Step 4?
(1 Point) What variable is removed at Step 5?
(1 Point) What variable is removed at Step 6?
(3 Points) What are the remaining variables at Step 7?
(8 Points) Use all-possible-regressions-selection to find the “best” predictors of heat rate.
(1 Point) What is the independent variable in the “best” one-variable model?
(2 Points) What are the independent variables in the “best” two-variable model?
(2 Points) What are the independent variables in the “best” three-variable model?
(3 Points) Plot Cp and BIC against number of variables in the model for the ‘best’ models.
(2 Points) Compare the results, parts a – d. Which independent variables consistently are selected as the “best” predictors?
(3 Points) Explain how you would use the results, parts a – d, to develop a model for heat rate.
(10 Points) Groundwater contamination in wells. In New Hampshire, about half the counties mandate the use of reformulated gasoline. This has lead to an increase in the contamination of groundwater with methyl tert-butyl ether (MTBE). Environmental Science and Technology (January 2005) reported on the factors related to MTBE contamination in public and private New Hampshire wells. Data were collected for a sample of 223 wells and saved in the MTBE file. The list of potential predictors of MTBE level (micrograms per liter) include well class (public or private), aquifer (bedrock or unconsolidated), pH level (standard units), well depth (meters), amount of dissolved oxygen (milligrams per liter), distance from well to nearest fuel source (meters), and percentage of adjacent land allocated to industry. Apply the all-possible-regressions-selection method to the data to find a small subset of the independent variables that are the best predictors of MTBE level.
Both well class and aquifer are qualitative independent variables with two levels. For well class, let public be the base level and define a dummy variable (e.g. WC) for the private level. Likewise, let unconsolidated be the base level for aquifer and define a dummy variable (e.g. AQ) for the bedrock level.
MTBE is the response variable and use the following as potential independent variables: WC, AQ, pH, Depth, DissOxy, Distance, and IndPct.
(1 Point) What is the independent variable in the “best” one-variable model?

(6 Points)
(2 Points) What is the largest adjusted value of the listed models?
How many independent variables are in this model?
(2 Points) What is the smallest Cp value of the listed models?
How many independent variables are in this model?
(2 Points) Based on the analysis above, what is the best set of predictor variables? Why?
(3 Points) Fit the model to the data in the MTBE file using the independent variables identified in (b) and give the least squares prediction equation.

Similar Posts

Leave a Reply

Your email address will not be published. Required fields are marked *