Hey i need help immediately
superfunds2018-final-32j522ow.xlsx Sheet1 REGUCLATypeBASELICOWNEROBJECTIVEBOARDSTUAssetsNetINVESTEXPROPEREXPRAONERETTHERETFIVERET 2112212,113,546209.4%0.2%0.2%10.8%9.4%3.9% 2112214,234,21583.6%0.5%0.0%8.2%9.8%4.7% 1311212,240,33685.1%0.5%0.2%8.7%9.4%4.0% 211121690,470195.3%0.0%0.3%9.2%10.0%3.9% 211221265,45253.9%0.1%0.3%8.8%8.0%4.9% 1211121,065124.0%0.0%18.2%0.0%9.3%4.3% 21122111,061,17786.7%0.5%0.2%7.5%8.4%5.4% 22111291,779400.6%0.1%0.8%7.9%8.8%4.3% 221112319,689127.2%0.0%0.4%9.0%8.8%4.4% 21122167,207105.0%0.0%1.0%9.7%9.8%4.8% 211121471,237118.3%0.0%0.4%9.2%13.2%7.0% 211121587,254778.4%0.0%0.4%6.3%8.0%3.9% 2112212,005,20195.3%0.3%0.3%9.8%9.1%4.1% 221112194,672157.5%0.0%0.5%9.1%9.0%4.5% 211121523,65069.7%0.0%0.4%9.0%8.7%4.4% 22111213,626-142600.0%0.5%1.5%9.6%6.3%1.9% 211121635,076124.8%0.0%0.2%7.0%10.3%4.9% 12111222,584,09175.4%0.3%0.2%9.1%8.8%3.7% 2112211,175,47463.6%0.2%0.5%11.4%9.9%4.5% 22111265,315230.1%0.1%0.8%5.1%6.7%3.1% 221112300,445126.4%0.0%0.2%9.4%9.9%4.3% 1211121,499,135220.8%0.6%0.2%7.6%9.2%3.5% 21152183,77368.9%0.4%0.7%5.1%7.8%3.6% 2112217,836,792131.3%0.4%0.2%7.9%7.9%3.6% 2112215,663,533161.1%0.4%0.2%11.0%10.4%5.0% 1211128,479,331106.6%0.0%0.4%8.7%8.8%3.8% 11122119,990,67692.6%0.4%0.3%10.1%9.7%4.5% 211121950,834102.2%0.0%0.3%8.4%9.6%4.5% 221112313,904235.7%0.1%0.4%8.4%8.0%4.9% 122112554,08946.1%0.0%1.3%5.9%6.5%1.8% 1221121,567,940176.5%0.0%0.0%2.8%2.6%2.9% 12211217,427,275101.1%0.0%0.7%6.8%7.5%3.9% 12211255,329,525131.9%0.0%0.3%8.3%8.3%3.1% 12211253,393334.9%0.2%3.7%0.7%3.0%1.1% 1221123,285,910105.3%0.1%1.1%9.6%9.6%3.7% 12211222,437,182116.8%0.6%0.8%7.1%7.6%2.6% 122112718,542561.1%0.0%1.4%3.3%5.7%2.3% 1221121,524,61814.7%1.0%0.6%8.4%10.0%3.7% 142321123,183,65252.1%0.4%0.3%11.7%10.6%5.0% 122112532,378172.5%0.0%2.0%5.3%6.3%2.5% 1221127,760,59861.8%0.0%0.4%6.8%7.3%2.1% 122112412,34776.9%0.0%0.5%7.1%7.7%2.1% 1221121,800,308239.1%0.7%0.3%7.5%8.4%3.0% 1221128,408560.7%0.0%0.2%0.6%1.0%2.0% 122112820,284217.8%0.0%0.0%2.4%4.7%4.7% 1221121,888,39369.3%0.0%0.1%6.6%7.5%3.2% 12211272,074,73996.1%0.0%0.3%7.8%8.1%2.9% 1221122,757,622377.0%0.0%1.1%6.2%9.9%3.0% 1221123,731,411498.4%0.0%0.6%7.5%7.6%3.3% 12211216,381294.1%0.0%1.3%0.7%1.3%2.4% 1221122,764,56317.3%0.0%0.7%7.7%6.9%3.2% 242221510,090104.1%0.0%0.8%10.2%7.6%3.6% 122112158,00620.9%0.0%0.8%1.3%6.7%3.1% 12211273,92276.6%0.0%0.5%4.5%2.9%3.6% 122112141,91271.6%0.0%0.8%4.6%6.1%3.2% 122112165,864164.1%0.0%1.8%7.6%7.9%1.8% 1221121,403,35927.1%0.0%0.2%4.4%6.9%3.0% 1425218,399,476101.4%0.4%0.3%9.9%9.6%4.8% 1221121,156,92456.2%0.1%1.1%8.8%9.6%2.8% 122112244,20415.2%0.1%0.3%-0.8%3.8%3.1% 12211278,200274.9%0.7%3.2%6.8%7.7%3.1% 1221122,895,98017.3%0.2%0.5%4.5%4.7%3.1% 1221122,502,08852.4%0.0%0.2%7.2%7.0%3.2% 12211225,754,519101.2%0.0%0.9%7.9%7.9%2.1% 122112495,591968.4%0.0%1.0%6.6%8.8%4.8% 12211213,79115.9%0.1%0.6%3.0%1.3%3.3% 1425213,652,54477.6%0.1%1.2%9.6%8.6%3.4% 122112464,12289.2%0.7%0.9%6.2%5.7%-1.4% 122112237,184365.7%0.0%0.0%0.6%1.1%2.1% 12211217,594,18674.8%0.0%0.5%7.6%7.9%2.9% 122112476,99166.9%0.0%0.8%6.4%6.4%2.1% 12211295,552167.0%0.1%1.6%7.7%9.8%2.7% 1423215,113,58882.8%0.3%0.5%10.5%9.4%4.2% 1221122,090,05289.4%0.0%0.8%6.6%7.4%3.2% 12211218,681,56386.9%0.0%0.0%7.7%8.1%2.5% 1221122,340,095515.8%0.4%0.2%8.1%6.2%2.1% 142522588,990109.7%0.1%1.4%9.4%6.2%2.1% 1221126,403,86124.4%0.0%1.4%5.7%6.3%1.2% 122112133,926171.4%0.1%0.5%2.3%2.5%3.1% 1221125,134,305221.9%0.0%0.7%6.6%8.0%1.7% 12211236,194,686112.9%0.0%0.2%7.3%7.7%2.7% 1221121,282,31543.5%0.0%1.0%9.1%6.3%2.2% 1221122,037,983213.4%0.3%0.2%9.8%10.1%4.0% 122112283,584192.8%0.6%1.0%7.0%6.6%2.7% 122112282,268145.8%0.1%0.5%5.4%5.6%2.6% 122112683,35510.3%0.8%0.0%4.3%5.6%2.7% 122112416,51682.6%0.0%0.9%6.7%8.2%2.1% 1221121,096,21947.7%0.0%0.7%7.5%7.9%3.1% 12211261,686,36992.0%0.2%1.0%7.4%7.8%2.6% 122112193,722226.4%0.4%1.4%4.6%5.8%1.5% 12211280,8951514.3%0.0%1.8%3.8%5.0%2.6% 122112627,39939.7%0.0%0.5%5.8%7.4%2.5% 1225127,783269.4%0.0%2.6%0.2%1.0%4.1% 12251217,735,35393.8%0.0%1.0%5.3%6.9%3.7% 1422217,553,87669.0%0.3%0.4%9.9%9.6%3.1% 1221126,928,687137.1%0.3%1.0%6.9%8.1%2.9% 14232147,856,43434.0%0.4%0.4%11.2%9.9%4.6% 1221123,504,068213.6%0.0%0.7%8.5%6.7%1.7% 12211221,127257.1%0.0%5.7%0.0%-2.1%-5.7% 1221121,344,259554.2%0.0%2.0%2.7%4.2%3.3% 1221122,159,746192.0%0.0%0.8%6.6%6.6%1.8% 1221121,472,373135.9%0.6%1.8%4.1%7.5%2.9% 1423219,048,9227.7%0.2%0.6%6.3%8.4%4.2% 122112321,64676.2%0.0%0.1%5.9%7.1%4.2% 1221121,133,25927.3%0.0%0.4%5.0%7.1%2.9% 1221121,976,100116.8%0.2%1.0%7.2%8.5%3.3% 1221123,115,815388.0%0.5%0.8%7.9%8.5%2.8% 12211211,798125.3%0.0%1.4%0.5%1.0%2.1% 12211252,355942.5%0.0%1.6%4.0%5.3%3.2% 122112432,48311.5%0.0%2.4%4.2%3.9%3.1% 122112307,61257.1%0.0%0.6%4.6%5.9%2.9% 12211234,870,08757.4%0.0%0.6%8.0%8.1%3.0% 1221125,898,628142.3%0.0%0.3%7.7%7.6%2.8% 122112396,024221.8%0.0%0.3%6.4%7.1%3.1% 1221121,151,444165.6%1.2%0.3%7.0%8.0%3.5% 2335217,786,024230.5%0.2%0.2%6.9%7.1%4.1% 2334212,72773.0%0.0%74.2%-72.1%6.8%3.1% 23342165,239,578115.2%0.0%0.0%8.6%9.0%4.6% 1333213,352,50964.3%0.2%0.4%6.6%7.6%3.7% 2333212,011,969374.9%0.2%0.4%7.1%8.9%3.5% 233421646,19473.8%0.4%0.4%8.4%8.5%4.0% 13352165,919,42859.8%0.4%0.2%11.1%9.6%4.8% 23342111,030,16985.9%0.4%0.2%8.9%8.9%5.1% 1335218,686,01985.4%0.0%0.2%10.4%8.7%4.3% 13332110,547,16883.4%0.1%0.4%9.4%8.9%3.0% 23342143,573,48769.9%0.0%0.0%9.6%9.6%3.7% 23342110,764,62829.1%0.0%0.1%9.1%9.6%4.8% 23342175,734,856128.4%0.0%0.0%9.4%9.8%4.8% 23342195,238,62759.1%0.2%0.2%7.3%9.6%4.3% 13332119,349,50655.1%0.2%0.3%9.9%9.4%4.4% 1333212,847,16872.4%0.3%0.5%7.1%7.9%3.5% 1442218,079,35374.5%0.2%0.3%6.9%7.9%3.2% 1443212,200,31570.1%0.3%0.5%9.9%9.1%4.3% 1443212,524,56571.3%0.4%0.7%10.7%9.8%4.3% 1443214,339,44557.8%0.0%0.4%9.5%10.8%5.2% 14412116,118,64354.0%0.2%0.4%11.0%10.5%5.5% 1442211,315,68155.6%0.5%0.6%7.3%8.5%3.2% 1443212,541,71577.6%0.3%0.6%11.2%8.9%4.3% 244521541,28597.3%0.7%1.3%10.5%9.5%3.5% 244521827,941104.0%0.1%0.4%6.4%9.2%4.2% 14432140,275,27450.8%0.4%0.3%11.5%11.0%5.4% 1444217,058,28386.8%0.4%0.4%10.9%10.0%5.1% 1443212,722,22886.8%0.1%0.5%10.9%9.8%4.4% 1241121,557,01555.1%0.3%0.9%9.5%8.1%3.1% 14432142,064,05154.9%0.4%0.3%10.5%9.8%4.8% 14432125,412,96632.2%0.0%0.5%12.2%10.9%5.0% 1443212,338,20563.5%0.4%0.7%11.9%10.2%4.0% 1443215,827,92377.9%0.8%0.3%9.8%8.7%3.7% 1443213,379,56856.2%0.1%0.4%10.5%9.9%4.1% 1441215,293,702117.4%0.4%0.4%9.7%8.7%4.4% 244321798,166123.4%0.4%0.3%9.2%9.2%4.6% 14432110,769,273112.0%0.4%0.4%8.1%8.5%4.5% 14422110,665,20769.6%0.3%0.4%10.2%9.6%2.4% 1445218,709,72654.0%0.4%0.3%10.5%10.3%5.2% 144321696,15772.6%0.0%0.4%9.4%6.2%2.1% 1441218,249,15172.8%0.3%0.4%10.3%9.3%4.5% 1445214,841,60770.4%0.5%0.5%10.5%10.0%3.3% 2445211,448,94863.6%0.3%0.5%10.9%9.9%4.1% 1443221,509,11876.1%0.0%0.5%8.1%9.4%4.1% 14432147,832,14551.9%0.6%0.4%10.5%10.0%5.5% 244521708,697122.7%0.0%0.3%11.8%9.6%4.2% 1441215,024,18183.4%0.3%0.6%11.1%10.1%4.5% 24442163,096,95851.8%0.4%0.1%8.3%11.4%5.8% 12352222,943,27885.9%0.2%0.3%10.4%10.4%4.9% 14231220,366,18976.4%0.2%0.4%10.2%10.1%4.7% 11442117,602,02775.5%0.2%0.4%10.2%10.0%4.6% 13321131,002,11372.4%0.3%0.3%9.8%10.5%5.0% 22151117,332,35175.0%0.3%0.4%10.1%9.7%4.4% Sheet2 Sheet3 1 2 3 4 A B C D REGUCLA Type BASE LICOWNER 2 1 1 2 2 1 1 2 1 3 1 1 what-is-expected-in-your-analysis-jtckfpd0.pdf What is expected in your analysis? Questions 1 to 3 Statistical output; Histograms and Descriptive statistics output. Remember to calculate CV. Comments Statistical output; Histograms – discuss the shape of the distribution Descriptive statistics output a. Discuss mean across the groups. b. Discuss median across the groups. c. Do you get same conclusions from a and b? d. Use CV to compare the variability across the groups. Questions 4 to 7 1. Set up null and alternative hypothesis using population notation. Do not forget to define population parameters 2. Set up decision rule 3. Hypothesis testing output from EXCEL. Use unequal variance option when you test for two population mean values. 4. Decision H0: µ1 = µ2= µ3 H1: at least one of mu is different mu1=population mean of BMW car buyers. Decision Rule: Reject H0 if Fcal >3.02 Do not reject H0 if Fcal < 3.02="" summary ="" ="" groups ="" count ="" sum ="" average ="" variance ="" age_bmw ="" 130 ="" 5878 ="" 45.22 ="" 18.96 ="" age_lexus ="" 140 ="" 7064 ="" 50.46 ="" 37.20 ="" ="" age_ merc ="" 150 ="" 7798 ="" 51.99 ="" 45.44 ="" ="" anova ="" ="" source of ="" variation ="" ss ="" df ="" ms ="" f ="" p‐value ="" f crit ="" ="" between groups ="" 3436.362 ="" 2 ="" 1718.18 ="" 49.80 ="" 0.00 ="" 3.02 ="" ="" within groups ="" 14386.69 ="" 417 ="" 34.50 ="" ="" total ="" 17823.05 ="" 419 ="" ="" ="" ="" ="" ="" decision:="" reject="" h0="" and="" we="" have="" enough="" evidence="" at="" the="" 5%="" level="" of="" significance="" that="" at="" least="" one="" of="" population="" average="" age="" is="" different.="" h0:="" mum=""><=mubl h1:mum=""> MuBL t‐Test: Two‐Sample Assuming Unequal Variances INC_MERC IN_BMWLEX Mean 184423.9 147005.3 Variance 2217987685.6 1055662620.1 Observations 150 270 Hypothesized Mean Difference 0 df 229 t Stat 8.654 P(T<=t) one‐tail 0.000 ="" ="" t critical one‐tail ="" 1.652 =""><=t) two‐tail 0.000 ="" t critical two‐tail ="" 1.970 ="" ="" ="" decision="" rule="" ;="" reject="" h0="" if="" t=""> 1.652. Do not reject H0 if t < 1.652. calculated t =8.654 reject ho. 809d0fb5-1efe-4c49-a815-f41a6037be14-gkuegbje.jpeg d4603cf3-7b9e-4856-9ea2-efcfa3f840e1-hch1vgeo.jpeg econ940-business-report-marking-guide-moqhbbcz.pdf econ940 statistics for decision making assignment - summary of marking guide trimester 3 2020 student number: section total your mark comments presentation 5 executive summary 13 1.652.="" calculated="" t="8.654" reject="" ho.="" 809d0fb5-1efe-4c49-a815-f41a6037be14-gkuegbje.jpeg="" d4603cf3-7b9e-4856-9ea2-efcfa3f840e1-hch1vgeo.jpeg="" econ940-business-report-marking-guide-moqhbbcz.pdf="" econ940="" statistics="" for="" decision="" making="" assignment="" -="" summary="" of="" marking="" guide="" trimester="" 3="" 2020="" student="" number:="" section="" total="" your="" mark="" comments="" presentation="" 5="" executive="" summary="">