CA\tII-4 Chi-square\ttest\t-\tGoodness-of-fit\ttest Solve\tthe\tfollowing\tproblem: In\tthe\t2010\tU.S.\tCensus,\tthe\tages\tof\tindividuals\tin\ta\tsmall\ttown\twere\tfound\tto\tbe\tthe following: <18 18-35>35 20% 30% 50% in\t2010,\tages\tof\tn=500\tindividuals\tfrom\tthe\tsame\tsmall\ttown\twere\tsample.\tBelow are\tthe\tresults: <18 18-35>35 121 288 91 Using\talpha=.05,\twould\tyou\tconclude\tthat\tthe\tpopulation\tdistribution\tof\tages\thas changed\tin\tthose\t10\tyears? http://www.youtube.com/watch?v=offtAejQm_c&index=7&list=PLfG MkZaH76AkwGs1E1jHL3fZrc78sopeZ Watch\tthe\tabove\tvideo,\tand\tread\tthe\t\"Excel\tGuide\"\tat\tthe\tend\tof\tChapter\t12,\tand solve\tthe\tproblem\ton\ta\tMicrosoft\tExcel\tand\tsubmit\tthe\tfile\ton\tthe\tiLearn,\tprior\tto Midnight\tof\tthe\tdue\tdate. Movie The Devil Inside The Dictator Paranormal Activity 3 The Hunger Games Bridesmaids Red Tails Act of Valor Twitter Activity Receipts 219509 14763 6405 5796 165128 15829 579288 36871 6564 8995 11104 7477 9152 8054 CA II-5 Regression analysis - Solve problem #13.73 http://www.youtube.com/watch?v=HIhdft8IyLU Watch the above video and solve the problem on a Microsoft Excel Please type out response and include excel output with charts and graphs *The data is stored in Twittermovies\" file. CA II-6 Multiple Regression analysis - Solve problem #14.11, P. 484 in eText. Solve the problem on a Microsoft Excel * The data is stored in the \"Business Valuation\" file. Company ABBOTT LABORATORIES ACADIA PHARMACEUTICALS INC ACCELERATE DIAGNOSTICS INC AKORN INC ALERE INC ALEXION PHARMACEUTICALS INC AMAG PHARMACEUTICALS INC AMERICAN BIO MEDICA CORP AMGEN INC ANIKA THERAPEUTICS INC ARIAD PHARMACEUTICALS INC ASTRAZENECA PLC -ADR BALCHEM CORP -CL B BAXTER INTERNATIONAL INC BG MEDICINE INC BIOGEN INC BIOMARIN PHARMACEUTICAL INC BIOTIME INC BRISTOL-MYERS SQUIBB CO CARDIOME PHARMA CORP CELGENE CORP CERUS CORP CHEMBIO DIAGNOSTICS INC EMERGENT BIOSOLUTIONS INC ENDO INTERNATIONAL PLC GENOMIC HEALTH INC GILEAD SCIENCES INC GLAXOSMITHKLINE PLC -ADR HOSPIRA INC IDEXX LABS INC IGI LABORATORIES INC IMMUNOMEDICS INC JUNIPER PHARMACEUTICALS INC LILLY (ELI) & CO MEDICINES CO MERCK & CO MERIDIAN BIOSCIENCE INC MOMENTA PHARMACEUTICALS INC MYLAN NV MYRIAD GENETICS INC NATURAL ALTERNATIVES NEWLINK GENETICS CORP NOVARTIS AG -ADR NOVAVAX INC P/B Ratio 3.149 10.235 12.972 10.093 2.349 11.111 2.345 3.169 4.700 3.318 15.917 4.529 5.228 4.892 28.485 7.416 8.725 9.408 6.593 8.916 13.693 11.763 1.905 1.848 4.673 6.969 9.219 15.651 3.106 60.160 11.870 8.578 1.476 4.997 1.966 3.328 4.566 3.095 6.493 4.050 0.871 5.454 3.543 6.159 ROE 7.995 -29.880 -46.875 9.269 -13.987 19.894 29.528 -50.515 20.009 21.516 -201.238 6.282 13.480 23.966 -1447.756 27.151 -8.768 -110.748 13.493 -106.348 30.651 -93.338 -5.765 6.642 -30.465 -16.900 78.445 64.649 9.986 154.793 13.418 -90.028 8.226 15.550 -3.499 24.503 21.576 -47.779 28.545 24.510 4.699 50.476 15.055 -36.124 SGrowth -8.027 -54.855 -37.409 50.863 6.113 42.007 48.579 -5.616 6.502 21.345 66.242 -3.839 19.795 5.823 -19.971 17.258 18.263 22.188 -3.329 -10.483 23.315 15.157 14.851 13.903 14.518 13.014 28.838 -5.005 2.846 7.930 54.945 -21.337 -1.230 -2.122 12.375 9.018 4.955 20.875 8.684 18.970 0.006 184.011 3.438 148.276 NOVO-NORDISK A/S -ADR ORAGENICS INC OSIRIS THERAPEUTICS INC PERRIGO CO PLC PFIZER INC PHARMATHENE INC POZEN INC PROGENICS PHARMACEUTICAL INC REGENERON PHARMACEUTICALS RIGEL PHARMACEUTICALS INC ROCHE HOLDING LTD -ADR ROSETTA GENOMICS LTD SANOFI -ADR SCICLONE PHARMACEUTICALS INC SEATTLE GENETICS INC SHIRE PLC -ADR SIGMA-ALDRICH CORP SINOVAC BIOTECH LTD SPECTRAL MEDICAL INC TEVA PHARMACEUTICAL INDS-ADR TRINITY BIOTECH PLC -ADR UNITED THERAPEUTICS CORP VANDA PHARMACEUTICALS INC VENAXIS INC VERTEX PHARMACEUTICALS INC VICAL INC XENOPORT INC XOMA CORP 13.653 3.114 6.536 2.244 2.754 6.277 5.490 4.210 16.087 1.554 9.679 1.758 1.782 2.864 18.880 4.825 5.223 2.302 6.879 2.359 1.978 4.952 3.464 2.316 26.580 1.827 5.989 133.766 65.719 -56.018 -0.293 2.362 12.750 -54.476 42.094 3.531 13.691 -70.886 47.646 -96.422 7.823 16.235 -36.114 37.895 15.974 -0.672 -107.615 13.104 8.739 27.373 12.552 -44.091 -68.618 -31.763 -54.129 -1235.915 7.857 7.958 6.096 15.138 -0.132 -18.038 0.128 -1.941 49.364 61.539 0.155 54.652 -1.301 13.232 40.722 14.895 5.335 -5.605 -4.027 7.841 -3.579 28.355 61.623 -12.233 41.619 3.705 6.460 -28.136