please have a look you guys done thisassignment before but my grade was 11/20 so im looking for better marks this term

please have a look you guys done thisassignment before but my grade was 11/20 so im looking for better marks this term


Sheet1 ID numberCustomerCitySeasonProduceQuantity sold (t/day)Price $/kg% of Produce Damage 11111218.704.024.97 21111266.513.246.14 31111235.313.765.36 41111200.054.34.55 51111183.444.544.19 6112142.146.321.72 7112191.065.423.07 8112161.105.982.23 9112129.576.541.39 10112148.906.21.90 111211315.363.885.18 121211290.664.424.37 131211346.043.166.26 141211284.974.544.19 151211354.892.946.59 161221182.104.64.30 171221140.025.443.04 181221121.985.782.53 19122197.786.221.87 201221188.774.464.51 211112146.245.322.12 221112121.985.781.43 231112105.586.080.98 24111281.886.50.35 25111254.906.960.34 261112154.445.162.36 271112104.486.10.95 281112103.366.120.92 291112158.485.082.48 301122346.853.145.29 311122314.483.94.15 321122343.583.225.17 331122323.283.74.45 341122358.052.865.71 351122386.482.16.85 361122383.622.186.73 371122358.052.865.71 381122350.903.045.44 39121211.105.981.13 40121293.484.363.56 41121299.984.223.77 42121211.105.981.13 43121259.495.062.51 44121229.485.641.64 45121249.335.262.21 46121243.145.382.03 47121281.144.623.17 481222337.892.066.91 491222334.342.166.76 501222290.283.35.05 511222322.622.486.28 521222291.103.285.08 531222321.882.56.25 541222275.883.644.54 551222318.862.586.13 561222301.703.025.47 571113356.384.083.38 581113367.143.843.74 591113420.372.545.69 601113385.263.424.37 611113358.204.043.44 621113409.622.825.27 631123337.182.085.88 641123371.901.027.47 651123370.081.087.38 661123326.342.385.43 671123313.502.724.92 681123321.882.55.25 691213393.051.76.95 701213366.052.36.05 711213327.793.044.94 721213389.661.786.83 731213328.903.024.97 741213396.381.627.07 751223494.721.666.51 761223528.760.747.89 771223483.571.926.12 781223515.731.127.32 791223528.110.767.86 801223529.410.727.92 811114461.123.97.15 821114312.383.148.29 831114398.262.029.97 841114498.502.389.43 851124221.744.365.15 86112495.955.762.63 8711249.005.922.34 88112423.004.464.97 891214231.713.47.90 901214357.202.289.58 911214417.011.6810.48 921214443.892.549.19 93122496.424.045.73 94122467.393.46.88 951224107.204.664.61 96122424.923.27.24 972111230.273.845.24 982111257.203.45.90 992111258.383.385.93 1002111276.683.066.41 1012111225.173.925.12 1022111217.394.044.94 1032111191.824.424.37 1042111182.034.564.16 1052111241.523.665.71 106212177.345.682.68 107212193.145.383.13 108212191.065.423.07 109212190.025.443.04 110212175.205.722.62 111212116.766.761.06 112212169.825.822.47 113212181.605.62.80 114212178.415.662.71 1152211297.204.284.58 1162211350.093.066.41 1172211324.143.685.48 1182211334.423.445.84 1192211355.682.926.62 1202211305.484.14.85 1212211290.664.424.37 1222211352.5036.50 1232211293.484.364.46 1242221120.905.82.50 1252221146.245.323.22 1262221142.105.43.10 1272221162.5053.70 1282221145.215.343.19 1292221165.494.943.79 1302221167.484.93.85 1312221115.485.92.35 1322112135.825.521.82 133211272.616.660.11 134211264.406.80.00 1352112121.985.781.43 1362122364.282.75.95 1372122374.122.446.34 1382122354.892.945.59 1392122322.403.724.42 140221235.825.521.82 1412212104.564.123.92 142221264.504.962.66 143221210.0061.10 1442222344.851.867.21 1452222344.161.887.18 1462222310.402.85.80 1472222290.283.35.05 1482113353.654.143.29 1492113404.892.945.09 1502113352.744.163.26 1512113362.693.943.59 1522113400.903.044.94 1532113396.043.164.76 1542113396.853.144.79 1552113351.824.183.23 1562123343.481.96.15 1572123318.862.585.13 1582123344.161.886.18 1592123323.372.465.31 1602123356.881.56.75 1612123371.901.027.47 1622123365.161.247.14 1632123338.602.045.94 1642213390.511.766.86 1652213342.912.765.36 1662213296.423.584.13 1672213334.372.925.12 1682213388.801.86.80 1692213308.383.384.43 1702213394.721.667.01 1712213304.833.444.34 1722223516.451.17.35 1732223520.0017.50 1742223493.051.76.45 1752223520.700.987.53 1762223528.760.747.89 1772223525.470.847.74 1782223502.841.466.81 1792223457.252.485.28 1802114433.902.768.86 1812114435.782.489.28 1822114461.123.38.05 1832114381.382.848.74 1842114428.183.328.02 1852114379.222.289.58 1862114478.023.87.30 1872114324.503.188.23 1882114394.102.189.73 189212491.825.862.45 190212418.005.642.85 19121245.005.083.86 192212443.974.445.01 193212490.435.72.74 19421245.004.564.79 195212482.034.345.19 196212497.325.443.21 197212416.035.243.57 1982214376.682.49.40 1992214411.203.427.87 2002214356.022.19.85 2012214425.453.228.17 2022214367.662.549.19 2032214404.242.169.76 2042214422.672.489.28 2052214407.253.367.96 2062214359.553.587.63 207222486.565.183.68 208222414.004.74.54 209222422.053.846.09 210222480.273.766.23 211222485.314.684.58 212222423.493.925.94 213222475.173.247.17 2142224116.514.385.12 215222444.584.544.83 2163111218.704.024.97 2173111182.034.564.16 2183111177.784.624.07 2193111267.663.226.17 2203111193.204.44.40 2213111210.804.144.79 2223111154.484.943.59 2233121106.465.123.52 2243121106.465.123.52 225312134.176.461.51 226312194.185.363.16 2273121111.505.023.67 228312120.286.71.15 2293121104.445.163.46 2303211360.402.86.80 2313211335.263.425.87 2323211319.783.785.33 2333211284.974.544.19 2343211331.883.55.75 2353211324.143.685.48 2363211361.962.766.86 237322194.406.281.78 2383221128.415.662.71 2393221127.345.682.68 2403221124.135.742.59 2413221170.444.843.94 2423221181.144.624.27 243322195.536.261.81 2443112110.0061.10 2453112106.696.061.01 2463112103.366.120.92 247311297.786.220.77 2483112161.505.022.57 2493112136.885.51.85 250311293.286.30.65 251311263.226.820.00 2523122310.0044.00 2533122329.323.564.66 2543122331.023.524.72 2553122316.253.864.21 2563122324.143.684.48 2573122328.463.584.63 2583122348.483.15.35 2593122318.903.84.30 260321269.454.862.81 261321283.064.583.23 262321298.134.263.71 263321225.205.721.52 264321284.974.543.29 265321288.774.463.41 266321280.184.643.14 267321252.405.22.30 2683222306.482.95.65 2693222342.781.927.12 2703222312.732.745.89 2713222280.173.544.69 2723222331.462.246.64 2733222318.862.586.13 2743222334.342.166.76 2753222270.663.764.36 2763113419.622.565.66 2773113387.783.364.46 2783113370.663.763.86 2793113362.693.943.59 2803113418.102.65.60 2813113379.323.564.16 2823113381.883.54.25 2833123363.281.37.05 2843123314.282.74.95 2853123375.480.97.65 2863123344.851.866.21 2873123336.482.15.85 2883123366.401.27.20 2893123377.240.847.74 2903213363.152.365.96 2913213301.253.54.25 2923213310.723.344.49 2933213358.242.465.81 2943213303.643.464.31 2953213372.672.166.26 2963213306.023.424.37 2973223489.661.786.33 2983223530.050.77.95 2993223517.881.067.41 3003223480.901.986.03 3013223509.051.37.05 3023223456.252.55.25 3033223523.450.97.65 3043114469.703.148.29 3053114398.262.928.62 3063114420.422.489.28 3073114461.122.189.73 3083114486.103.467.81 3093114363.862.848.74 3103114428.183.38.05 3113114381.382.788.83 312312489.044.564.79 313312482.034.15.62 3143124113.454.544.83 315312483.445.023.96 316312448.505.223.60 317312433.265.13.82 318312442.454.94.18 319312457.454.425.04 3203214404.243.188.23 3213214369.941.6410.54 3223214445.553.188.23 3233214369.941.610.60 3243214447.201.8210.27 3253214437.943.028.47 3263214378.903.347.99 3273214360.723.068.41 3283224118.803.27.24 3293224118.804.584.76 330322430.625.023.96 33132241.5045.80 332322470.004.15.62 333322463.453.766.23 334322485.314.145.55 335322460.803.746.27 Generate Sheet2 Generate Sheet3 A health agency is conducting an evaluation of all of the hospitals in the U STATS1900 Business Statistics Major Assignment Date Due: Refer to Course Description Total Marks: 40 Worth: 20% of final assessment This assignment requires a considerable amount of computer work and written comment. You may need to seek guidance from your tutor along the way. Do not leave things until too late. Each question carefully describes what you are required to do, so please follow these carefully. In this assignment, you will again examine data from a fruit and vegetable market that supplies fresh produce to supermarket outlets in NSW and Victoria. The market is conducting an evaluation in Sydney and Melbourne. The fruit and vegetable market wants to examine the Price per kilogram (Price$/kg) at each of the outlets and is particularly interested in the relationship between Price$/kg and the type of produce; the season; and, quantity (sold per day). The data collected is contained in a file called ‘Market.xls’ and the columns of the file contain the following information: Column Name Description A ID Number Order Number B Customer 1= Coles 2= Private 3= Safeway C City 1= Sydney 2= Melbourne D Season 1= summer 2= winter E Produce 1= Apple 2= Orange 3= Potato 4= Tomato F Quantity sold (t/day) Tonnes sold per day G Price$/kg Price in dollars per kilogram H % of produce damage Percentage of produce damaged Use your random sample of 200 customers from the minor assignment. Your answers to the assignment tasks below are to be based on your sample of 200 customers. Make sure you keep a safe copy of your sample, since you cannot use Random Sample Generator to reproduce the first sample. (If necessary, talk to your tutor about generating a new sample.) Assignment Tasks For each task below, you must submit all of the required printouts, graphs, tables and summaries required. NB: Each graph and table should have a heading and each axis should have a label!! 1. Introduction and Variable List: Give a brief introduction to your report, setting out the nature of the data. [1 mark] 2. Data: Provide a printout of the data in your sample, sorted in ascending order based on order (ID) number. [1 mark] 3. Pivot Table: Prepare a contingency table (cross-classification) using the Pivot Table option in Excel that compares types of produce and season