statistic homework

profilemixmixjiaojiao
QBUS5001-2017S2-Assignment-Data.xls
Home>Mathematics homework help>Statistics homework help>statistic homework

Q1

Step 1: Type your Name and SID into the fields below
Type your name here: as
Number code Type your SID here: 123123123
23
(Please be aware that you must analyse your assigned stock below. Your SID will be checked by the marker and you will receive 0 marks if you analyse the wrong stock)
Your stock for analysis Stock Code Sector Market Cap
Woolworths Limited WOW Consumer Staples $30,233,200,000
Step 2: View the three stocks below. Your personal stock for analysis is in the final column. You may wish to copy and paste the data below into another spreadsheet. NOTE: you will need to use the "paste values" feature to paste the data from the third column into your new spreadsheet
1 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 Adjusted closing prices
2 Date AGL AMC AMP BHP BXB CSL CTX FMG IAG MQG NAB NCM QBE RHC RIO SCG SUN SYD TCL TLS WBC WES WFD WOW WPL Date CBA ANZ WOW
3 11/1/16 18.69938 14.44993 4.34739 22.8 11.5 98.95737 30.79 5.48 5.48 77.04559 26.4572 22.63343 10.17 72.33 52.37399 4.14 11.51404 6.11446 10.16999 4.92 29.1877 39.17499 8.83 23.47 28.01 11/1/16 70.3531 26.43743 23.47
4 10/3/16 18.74825 14.44011 4.39548 23.07 11.53 99.81139 30.73 5.5 5.51 77.52161 26.56155 22.46415 9.99 73.36 52.35466 4.111 11.55264 6.09499 10.13098 4.98 29.1877 39.60962 8.9 23.65 28.37 10/3/16 70.96226 26.72531 23.65
5 9/1/16 18.62118 14.88215 5.07836 22.38 11.98 106.25629 34.25 4.95 5.47 79.60051 26.43823 22.09572 9.29 79.12 49.87125 4.59 11.68776 6.78628 11.08655 5.18 28.2681 42.59411 9.73 23.27 28.62 9/1/16 70.005 26.5142 23.27
6 8/1/16 18.13243 15.44031 5.05913 20.1654 12.15695 106.3974 33.234 4.7286 5.376 78.39591 25.93546 21.9938 9.92 81.917 45.99634 4.853 12.26684 7.08811 11.17431 5.26 28.22021 40.9908 10.22 23.24659 28.63 8/1/16 69.43452 25.81368 23.24659
7 7/1/16 19.57734 14.49459 5.38847 19.26719 13.27199 116.14147 32.461 4.27504 5.84 72.26607 25.17656 24.77895 10.69304 77.79 47.09037 5.068 12.44813 7.36072 12.24689 5.53731 29.78161 40.19466 10.51779 22.95245 25.95548 7/1/16 71.67027 24.79648 22.95245
8 6/1/16 18.35019 14.40774 4.78563 18.40845 12.22602 110.41314 31.228 3.37757 5.27 66.93282 24.12358 22.79664 10.16667 70.849 43.23269 4.705 11.28952 6.75707 11.6911 5.33578 28.16273 37.54498 10.48825 20.4817 26.25877 6/1/16 68.90909 23.14594 20.4817
9 5/2/16 17.68429 15.71052 5.23081 18.83288 12.67994 113.93675 32.03 2.87576 5.686 72.73237 25.75522 18.90138 12.12592 71.827 42.46305 4.456 12.03103 6.74545 11.5081 5.36457 29.40802 38.04121 10.55718 21.68766 26.80664 5/2/16 71.74439 24.45102 21.68766
10 4/1/16 17.39891 14.8613 5.45339 20.41216 12.31483 103.52339 31.815 3.29072 5.579 59.28094 24.53615 18.80227 10.86849 64.126 48.9812 4.485 11.58613 6.48821 11.05924 5.14384 28.46763 40.04486 9.9466 21.67786 27.72628 4/1/16 68.46433 22.23109 21.67786
11 3/1/16 17.50355 13.84803 5.36992 16.64164 11.9596 99.8423 33.303 2.4608 5.396 61.69885 23.67887 16.81004 10.63455 60.581 40.56271 4.246 11.03926 6.37388 10.83958 5.11505 27.82585 38.80896 9.83827 21.66805 25.39782 3/1/16 69.4187 21.48914 21.66805
12 2/1/16 17.44647 13.51992 4.7541 15.10564 12.17076 99.94473 34.668 1.92976 4.999 59.99044 21.82896 17.34527 9.90673 64.734 38.2728 4.179 10.38117 6.14522 10.83958 4.82578 26.35891 36.59933 9.84812 21.82792 24.80103 2/1/16 64.98969 20.51819 21.82792
13 1/1/16 17.26056 12.59196 4.79878 14.8922 10.84552 101.19016 35.246 1.63651 4.922 66.82409 24.08387 12.76612 10.19728 59.202 35.37202 4.06 10.35838 6.26908 10.29521 5.17507 28.28426 38.21038 9.57237 23.14332 26.51232 1/1/16 70.11829 22.14865 23.14332
14 12/1/15 16.77801 12.72451 5.20985 17.32734 11.27427 102.46476 35.768 1.76895 5.193 77.2706 26.29546 12.85532 11.79998 66.395 40.41612 3.91 10.83124 6.04995 9.99916 5.15669 30.76888 37.70297 9.19527 23.35302 27.24271 12/1/15 76.23258 25.58362 23.35302
15 11/2/15 15.35819 12.80025 5.19198 17.55048 10.61166 97.40525 32.561 1.85408 5.174 76.00096 25.59015 10.81353 11.68751 65.525 41.50088 3.733 11.94648 6.16 9.67604 4.92689 29.47614 34.51348 9.2823 22.56187 28.56122 11/2/15 70.79568 24.86915 22.56187
16 10/1/15 15.52523 12.92333 5.12049 22.33345 10.11469 91.256 29.981 1.97706 5.239 78.18674 24.96537 12.20116 12.41856 60.6 45.78566 3.864 11.69667 6.02 9.70562 4.96366 27.51988 35.70954 9.91078 22.98128 28.08694 10/1/15 68.38918 23.65489 22.98128
17 9/1/15 14.81996 12.46888 4.96857 21.55731 9.49105 86.79001 29.677 1.72165 4.52 69.93928 24.82463 12.58771 12.08115 57.14 43.93253 3.64 10.87585 5.56267 9.24076 5.15669 25.87044 35.53738 9.64005 23.6771 27.44191 9/1/15 64.81508 23.54188 23.6771
18 8/3/15 15.6737 12.71357 5.1464 23.18878 9.43623 88.49587 29.586 1.77896 4.519 69.27328 25.80999 11.10097 12.3717 60.172 45.46023 3.556 11.44686 5.36667 8.99904 5.30376 27.08989 36.84217 9.42733 24.14223 30.60062 8/3/15 66.91854 24.28082 24.14223
19 7/1/15 15.02151 13.35296 5.71726 24.35835 10.43356 95.32548 32.064 1.72773 5.249 74.94798 28.79094 11.17035 13.52998 64.43 45.97176 3.596 12.25032 5.236 9.26865 5.74093 30.36509 36.94118 9.52755 26.15409 32.34334 7/1/15 74.59238 28.41022 26.15409
20 6/1/15 14.00387 12.71357 5.20695 24.91091 10.16505 83.2942 29.558 1.77896 4.973 74.26373 27.58203 12.90488 12.66814 59.218 46.74578 3.406 11.52921 4.648 8.64578 5.43133 28.0045 33.965 8.66314 24.65434 31.05505 6/1/15 72.52219 27.99293 24.65434
21 5/1/15 14.61625 13.43636 5.76051 27.25004 10.97058 90.06601 31.275 2.25397 5.044 74.58304 28.41832 14.00506 13.57632 61.193 50.61589 3.587 11.61505 5.18374 9.24426 5.50209 29.23272 37.99415 9.19509 25.6054 33.23244 5/1/15 72.48818 28.85358 25.6054
22 4/1/15 13.67966 12.53751 5.57022 27.51168 10.38561 87.63857 32.88 2.02112 5.178 69.11555 28.77804 14.32224 12.69594 60.297 49.70272 3.397 11.25879 4.91043 9.01698 5.51094 30.51156 38.03766 8.97661 26.95883 31.79899 4/1/15 75.70834 28.4493 26.95883
23 3/2/15 13.68867 13.0101 5.57022 26.70274 11.0473 88.73669 32.435 1.82553 5.437 67.96318 30.17109 13.25178 12.08431 64.777 49.77229 3.397 11.5893 4.71912 8.66248 5.58171 32.95511 38.25522 9.0716 26.96797 31.31815 3/2/15 79.56745 30.66732 26.96797
24 2/2/15 13.55358 12.65798 5.63713 27.83615 10.49622 88.13908 33.558 2.27925 5.271 64.58585 29.66239 14.26277 11.74939 63.689 54.12748 3.506 12.00136 4.7009 8.31707 5.63478 31.80023 38.15949 9.31857 27.16752 31.91693 2/2/15 78.30666 29.57924 27.16752
25 1/1/15 12.43359 11.64172 4.85466 24.20464 10.02342 84.0398 30.442 2.16025 5.53 55.09211 27.88579 13.4401 9.59669 56.597 48.37103 3.352 12.16869 4.54602 8.37161 5.56281 28.83784 36.90071 9.21381 28.1141 28.85329 1/1/15 73.78479 27.62068 28.1141
26 12/1/14 11.69809 12.37047 4.62749 24.29555 10.05179 82.82627 31.162 2.50809 5.401 51.67046 26.29701 10.79371 10.13939 54.36 48.74078 3.087 11.62309 4.29094 7.79896 5.10923 27.74994 35.31768 8.42886 27.14098 31.99281 12/1/14 70.74524 26.85902 27.14098
27 11/3/14 11.47918 11.07694 4.74528 25.57776 9.19129 78.89899 27.555 2.69116 5.504 51.79456 25.51435 10.24858 9.82282 51.551 49.66518 3.06 11.85456 3.94529 7.37323 4.8696 27.23944 35.06371 7.7467 27.53023 30.09058 11/3/14 66.6731 26.71673 27.53023
28 10/1/14 11.89948 10.67613 4.92197 28.09253 9.01162 76.62481 28.274 3.20376 5.634 52.88828 26.19374 9.23759 10.42883 49.733 50.76604 3.122 12.11083 3.91863 7.21352 4.81825 28.00015 37.70807 7.40095 31.84731 33.77721 10/1/14 66.47487 26.90668 31.84731
29 9/1/14 11.85569 10.32087 4.59384 28.01808 9.00217 70.87245 25.496 3.18546 5.288 49.79298 24.35962 10.45672 10.54641 47.686 50.06855 2.893 11.60655 3.79423 6.84974 4.53583 25.87482 36.01655 6.96175 30.29033 34.1728 9/1/14 62.18806 24.83446 30.29033
30 8/1/14 11.93383 10.19027 4.81002 29.50237 8.83888 69.96227 25.697 3.68629 5.27 50.40685 26.3509 11.21991 10.41978 48.778 52.63164 3.025 11.92896 3.9364 7.15141 4.75834 28.20951 36.99894 7.12061 31.08691 35.94036 8/1/14 67.16872 26.85045 31.08691
31 7/1/14 11.98673 9.30688 4.49099 31.11947 8.77375 64.21337 22.287 4.34929 5.132 50.59706 26.44077 10.80362 9.76243 45.427 54.57166 2.999 11.37088 3.82089 6.90298 4.52303 27.86333 36.2491 6.98979 31.76608 34.412 7/1/14 66.51489 27.28417 31.76608
32 6/2/14 12.55439 9.30688 4.33556 28.8829 8.55045 63.0295 19.455 3.84541 4.757 51.55679 24.53927 10.42698 9.64705 42.714 48.75934 2.822 10.77409 3.7498 6.55694 4.29235 27.27561 34.45399 6.68141 30.27879 33.23849 6/2/14 64.23555 26.77817 30.27879
33 5/1/14 12.48956 9.4675 4.32738 29.77591 8.95053 66.85577 20.159 3.89845 4.847 51.90263 25.07078 9.65388 10.09967 44.45 48.75112 2.726 10.62291 3.79726 6.42529 4.39945 27.7103 35.70562 5.99383 32.26471 34.12874 5/1/14 64.79938 26.89865 32.26471
34 4/1/14 12.7896 9.18195 4.13106 30.37128 8.77375 64.81004 20.087 4.46421 4.676 48.32967 25.28704 10.36751 10.27717 42.066 50.72418 2.726 10.36032 3.65021 6.20205 4.30059 27.23234 35.1704 6.13388 32.08417 33.01998 4/1/14 62.66296 26.71454 32.08417
35 3/3/14 12.31114 9.27119 4.07379 29.34146 8.61558 65.88026 19.924 4.64101 4.537 48.52232 25.40165 9.80255 11.37766 45.183 52.24509 2.547 10.24096 3.62426 6.19353 4.18525 26.79812 33.91869 5.74175 30.70864 31.5794 3/3/14 61.50344 25.62178 30.70864
36 2/3/14 12.32954 9.02134 3.82879 30.0821 8.5808 67.82091 18.709 4.80897 4.423 47.1319 24.8859 11.23973 11.22433 44.833 53.5172 2.658 9.66008 3.51181 6.03144 4.16053 25.95295 35.36802 5.75296 30.21674 30.71344 2/3/14 59.29556 24.90877 30.21674
37 1/1/14 11.97501 9.38191 3.38488 28.66338 8.25112 65.99858 17.229 4.59323 4.324 45.30593 23.81848 9.56468 10.05987 40.754 52.55639 2.496 9.31213 3.40802 5.89494 4.0676 23.9369 33.64349 5.45342 28.54129 28.98396 1/1/14 56.91485 23.35101 28.54129
38 12/2/13 11.84108 9.24175 3.48 29.77636 8.37933 64.77742 17.88 5.01549 4.584 46.04302 24.95036 7.73103 10.07738 40.196 54.59011 2.455 10.01551 3.28692 5.83522 4.15465 25.1077 35.27759 5.39461 28.35699 30.16255 12/2/13 59.65213 24.97852 28.35699
39 11/1/13 11.82537 8.68343 3.69403 29.30614 7.93012 64.56138 16.988 4.89485 4.765 44.62931 24.77129 7.62201 13.70208 35.996 52.89267 2.521 10.08432 3.27265 5.81922 4.00429 25.49546 34.38044 5.56035 28.22295 28.99947 11/1/13 59.66739 24.72277 28.22295
40 10/1/13 12.32172 8.52611 3.75745 29.51777 7.755 65.28468 16.524 4.48982 4.867 41.05239 24.26757 10.20893 12.95788 36.052 51.23528 2.554 10.22958 3.516 5.89393 4.09925 25.49386 34.85269 5.78491 29.2366 30.10052 10/1/13 58.33329 25.21758 29.2366
41 9/2/13 12.14841 8.22723 3.6544 28.01282 7.59657 60.11826 16.488 4.0934 4.623 38.60297 23.58715 11.59655 12.84406 33.646 49.43375 2.455 9.99258 3.29783 5.64489 3.93307 24.33407 33.36028 5.88649 29.32037 29.70507 9/2/13 54.59933 22.93727 29.32037
42 8/1/13 12.02078 8.02406 3.63894 27.24926 7.20088 63.32148 16.657 3.60835 4.304 35.33971 22.30195 13.14276 13.30809 34.16 46.67943 2.414 9.42681 3.17196 5.60338 3.87767 23.33777 32.97905 5.92392 29.02134 29.60427 8/1/13 55.8491 22.125 29.02134
43 7/1/13 11.10489 8.14715 3.47004 26.40314 7.43 61.53332 16.481 3.05001 4.296 35.36388 21.46345 12.12186 14.11028 33.684 45.06994 2.407 9.25619 3.01252 5.62829 3.79403 22.96604 31.75212 5.78281 27.10936 28.13533 7/1/13 54.66962 22.17717 27.10936
44 6/3/13 11.05144 7.80095 3.26276 23.91071 7.64275 57.35162 15.9 2.53334 4.023 33.73631 20.39825 9.78273 12.97527 32.752 41.04178 2.479 8.60638 2.8363 5.61169 3.62676 21.47165 31.00057 5.8962 26.69442 26.20425 6/3/13 50.96408 21.29783 26.69442
45 5/1/13 10.99043 7.6317 3.97673 26.5861 7.49546 55.50758 19.802 2.79168 4.2 34.78373 19.93088 14.3817 13.76634 31.617 43.24395 2.463 9.00348 2.96493 5.59818 3.60395 21.14454 30.71877 5.93743 26.84901 26.93776 5/1/13 49.25496 20.52282 26.84901
46 4/1/13 12.11238 7.60862 4.14563 24.92445 7.13542 58.63686 18.974 2.91668 4.304 30.55415 22.29899 16.66137 11.49631 29.258 43.72984 2.639 9.37171 2.81059 5.51728 3.78643 24.07649 33.95185 6.00443 29.62341 28.11287 4/1/13 54.10975 22.94065 29.62341
47 3/1/13 12.10473 7.13933 3.99976 24.97021 6.93085 55.16298 18.806 3.28335 4.222 28.96368 20.22646 19.87272 11.61669 29.541 44.827 2.415 8.53418 2.66437 5.16132 3.42908 21.91106 31.47025 5.59211 27.49176 26.81052 3/1/13 50.10215 20.55581 27.49176
48 2/1/13 11.82799 7.07778 4.08322 27.60375 7.02398 55.5624 17.297 3.93335 4.208 29.40811 19.80673 22.37385 11.38468 28.992 51.46437 2.543 8.13707 2.57502 4.98334 3.4899 21.91816 32.12 5.7725 27.72104 28.06796 2/1/13 49.55701 20.6927 27.72104
49 1/1/13 11.42732 6.35781 3.964 27.90911 6.51023 50.87664 16.837 3.90002 3.611 30.01617 17.94414 23.1045 10.1424 26.663 50.93476 2.491 7.4244 2.57502 4.93481 3.34643 19.97355 28.64847 5.62025 24.79259 25.90944 1/1/13 45.81104 19.15084 24.79259
50 12/3/12 11.41245 6.10804 3.58399 27.62614 6.02858 49.91356 16.655 3.87502 3.373 27.66947 16.39634 21.89991 9.27451 24.623 50.66611 2.344 7.12322 2.7456 4.92672 3.17911 18.54889 28.07709 5.30858 23.27678 24.748 12/3/12 44.19749 18.04847 23.27678
51 11/1/12 10.663 5.97937 3.42752 25.60812 5.81185 47.87627 15.849 3.25835 3.33 25.54102 15.93724 25.32609 9.30855 23.991 45.09369 2.32 6.78702 2.82699 4.88455 3.13546 18.16427 27.08658 5.2382 23.2371 24.68957 11/1/12 42.42759 17.55133 23.2371
52 10/1/12 10.78915 5.97937 3.42007 25.50389 5.8279 43.9869 14.774 3.40001 3.301 23.84587 15.99524 26.09624 11.2145 21.446 43.70441 2.406 6.5839 2.69958 4.78229 3.01178 17.3247 26.49227 5.35885 23.10575 25.12784 10/1/12 41.04868 17.52546 23.10575
53 9/3/12 11.10827 5.87341 3.22634 24.60285 5.63524 42.59784 14.332 2.90835 3.143 21.2744 15.80917 28.77202 11.0188 21.681 40.95658 2.243 6.47184 2.51642 4.71937 2.85174 16.8765 26.10369 5.10749 22.59506 24.20746 9/3/12 39.64132 17.04342 22.59506
54 8/1/12 11.25665 5.69932 3.20811 23.04506 5.34172 40.83278 13.333 2.95001 2.985 20.07836 15.63548 24.13257 11.08687 22.03 37.79427 2.243 6.43681 2.58809 4.7587 2.80081 16.82214 26.30179 4.98182 22.52721 25.0548 8/1/12 38.90915 17.09162 22.52721
55 7/2/12 11.29138 5.59448 2.88442 23.14653 4.88678 39.24285 12.061 3.3869 2.6 18.67306 15.49283 23.00671 11.56898 20.986 40.12668 2.317 5.81767 2.50846 4.81376 2.76071 15.75589 23.88896 4.88628 21.7286 24.0235 7/2/12 38.87477 16.21018 21.7286
56 6/1/12 10.62249 5.2606 2.76933 22.7986 4.83187 36.2284 11.54 4.01836 2.4 19.43553 14.59976 22.13539 11.02514 20.004 42.61575 2.165 5.54358 2.30938 4.47553 2.54675 14.35008 21.91717 4.64196 20.38246 22.08026 6/1/12 35.8813 15.17036 20.38246
57 5/1/12 10.92459 5.54254 2.79091 23.17554 5.19694 34.60172 11.651 3.78873 2.296 20.16061 13.94231 24.3969 10.20114 19.084 42.88728 2.066 5.31745 2.24869 4.32173 2.45013 13.77962 21.40403 4.44162 20.10865 22.89884 5/1/12 33.38107 14.39222 20.10865
58 4/2/12 10.43027 5.57964 3.07144 25.77074 5.64172 33.69187 11.754 4.62521 2.441 21.25706 14.76007 25.74793 11.40418 17.721 50.04521 2.066 5.57784 2.25644 4.48208 2.44323 14.63538 22.19568 4.51492 19.72836 24.85631 4/2/12 35.11766 15.79352 19.72836
59 3/1/12 10.27011 5.52028 3.10741 25.0893 5.54028 32.98421 11.856 4.76462 2.345 21.16242 14.39151 29.05698 11.6761 17.297 49.32867 1.96 5.756 2.22542 4.27592 2.27068 14.09454 22.00517 4.31458 19.75886 24.77801 3/1/12 33.85406 15.36417 19.75886
60 2/1/12 9.40218 5.26801 2.88442 26.16941 5.52743 29.89966 11.403 4.5206 2.233 19.48137 13.84744 32.69611 9.38271 15.916 50.8749 1.906 5.60525 2.03157 4.27592 2.27759 13.4571 21.33076 4.29504 18.61082 26.50771 2/1/12 33.40132 14.49886 18.61082
61 1/2/12 9.83352 5.12025 2.94682 26.58931 5.55034 28.39464 10.55 4.09857 1.964 18.55712 13.95272 32.92066 9.22969 16.462 51.23785 1.877 5.56352 2.07034 4.19192 2.16349 13.61806 21.48828 4.02307 18.22844 23.88269 1/2/12 32.87659 14.14217 18.22844
62 12/1/11 9.65828 5.24389 2.8088 24.41846 5.46636 29.1882 9.754 3.46553 2.011 17.31275 13.66608 28.89832 10.42971 16.723 44.67384 1.847 5.54367 2.06259 4.29119 2.16349 12.87762 20.92087 3.6965 18.4564 21.37644 12/1/11 31.94211 13.56089 18.4564
63 11/1/11 9.61113 5.28026 2.86401 24.77315 5.39001 28.44937 10.566 3.68466 1.943 16.83967 13.69529 33.7798 10.84046 16.107 46.63712 1.892 5.44444 2.59387 4.15358 2.05304 13.2446 21.62297 3.88108 18.10343 22.89834 11/1/11 30.76098 13.14475 18.10343
AGL AMC AMP BHP BXB CSL CTX FMG IAG MQG NAB NCM QBE RHC RIO SCG SUN SYD TCL TLS WBC WES WFD WOW WPL
AGL Energy Limited Amcor Limited AMP Limited BHP Billiton Limited Brambles Limited CSL Limited Caltex Australia Limited Fortescue Metals Group LTD Insurance Australia Group Limited Macquarie Group Limited National Australia Bank Limited Newcrest Mining Limited QBE Insurance Group Limited Ramsay Health Care Limited RIO Tinto Limited Scentre Group Stapled Suncorp Group Limited Sydney Airport Forus Transurban Group Stapled Telstra Corporation Limited Westpac Banking Corporation Wesfarmers Limited Westfield Corporation Stapled Woolworths Limited Woodside Petroleum Limited
Utilities Materials Financials Materials Industrials Health Care Energy Materials Financials Financials Financials Materials Financials Health Care Materials Real Estate Financials Industrials Industrials Telecommunication Services Financials Consumer Staples Real Estate Consumer Staples Energy
12,907,200,000 17,036,300,000 13,369,000,000 73,226,600,000 18,262,600,000 45,432,500,000 8,030,360,000 17,063,600,000 12,974,000,000 26,992,200,000 74,103,100,000 17,427,900,000 13,949,100,000 14,616,500,000 22,991,200,000 22,575,000,000 15,392,100,000 14,128,900,000 21,305,800,000 58,762,000,000 101,958,000,000 45,780,100,000 18,349,500,000 30,233,200,000 23,596,900,000
0.9455964075 1.7365944101 0.5179381357 -0.0796487326 1.1335767466 2.4783677108 1.9140639788 0.4872471273 1.8203808543 3.5752434579 0.9318466422 -0.3299714622 -0.061847929 3.4905941516 0.123010812 1.1881606765 1.1148253999 1.3572731093 1.4484878105 1.3964462456 1.2037434124 0.8117303035 1.2751399095 0.296439404 0.2232327758

Q2

Brand 1 Brand 2 Brand 3
1 2 1
3 2 2
3 4 4
0 3 2
1 0 3
0 4 4

Q3

Before After
58.27 76.64
68.30 80.18
65.61 80.11
60.61 73.79
65.71 72.49
53.89 76.67
62.91 53.09
69.79 84.05
59.44 78.03
64.31 72.35
88.10 89.80
58.10 77.31
61.28 78.14
40.31 69.09
47.92 61.61
79.67 76.01
54.56 83.89
79.39 83.88
67.90 69.33
59.62 83.35
51.37 81.34
64.11 70.18
73.71 77.42
68.63 77.45
54.84 77.36
58.59 81.48
63.78 81.61
65.46 78.04
62.59 77.63
84.53 67.12

Q5

Sales Sample Quantity
$10,476.62 0
$13,542.58 324
$13,444.85 36
-$184.10 9
-$2,047.04 14
-$7,554.96 17
$195,133.58 454
$288,586.96 333
$10,491.51 27
$4,453.01 3
-$2,008.40 27
$268,511.13 363
-$1,029.85 10
-$1,178.72 28
$100,568.69 288
($158.11) 5
-$1,197.72 19
$75.48 11
$7,454.17 34
$11,048.84 30