Template for Excel Graphing: Please place your name and date in the header ASSIGNMENT: GRAPHING AND DESCRIPTIVE STATISTICS IN EXCEL 2017 Q 1: Clustered bar graph showing employment status and...

How much it would be for having this assignment done?


Template for Excel Graphing: Please place your name and date in the header ASSIGNMENT: GRAPHING AND DESCRIPTIVE STATISTICS IN EXCEL 2017 Q 1: Clustered bar graph showing employment status and education. Interpret this graph based on shape and trend. A 1: INTERPRETATION: Q 2: Stacked bar graph showing education level by gender. Interpret this graph based on shape and trend. A 2: INTERPRETATION: Q 3: Clustered box plot showing annual salary based on education. Annual salary is measured in 1000’s of dollars. A 1: INTERPRETATION: Q 4: Histograms to categorize the Blackberry and Google Stock. How do the histograms compare? Which stock prices seem the most stable? Which stock prices seem the most volatile? Blackberry Stock Price 2015: Google Stock Price 2015: INTERPRETATION: Q 5: Scatterplots comparing: 1) Apple’s Adjusted Closing Price Per Stock to Google’s Adjusted Closing Price Per Stock and 2) Google’s Adjusted Closing Price Per Stock to Blackberry’s Adjusted Closing Price Per. Q 5: Continued INTERPRETATION: a) Which adjusted closing stock price per share (Apple or Google) explains the most variation in Blackberry’s adjusted closing stock price per share? ______ b) Which two stocks display the strongest correlation coefficient? ___________ and ____________. c) Which two stocks display the weakest association between their prices? ___________ and ___________. d) Fifty percent of the time, Apple’s adjusted price per share was less than __________________. e) Apple’s adjusted price per share was more than $ _____20 % of the time. __________ percent of the time, Apple’s adjusted price per share was less than $123.73. __________ percent of the time, Apple’s adjusted price per share was more than $123.73. Q 6: Computer descriptive statistics (the measures of central tendency and dispersion) for the Google’s, Apples’, and Blackberry’s Adjusted Closing Values. Use a formula to compute the coefficient of variation (defined as the ration of the standard deviation over the mean). What can you say about the three stocks? Which stock is more volatile? What stock is the most stable? INTERPRETATION: Apple Closing Price p/Stock ($USD)Google Closing Price p/Stock ($USD)Blackberry Closing Price p/Stock ($USD) Mean120.6754Mean594.2133Mean8.728745 Standard Error0.4761441Standard Error4.86261Standard Error0.087196 Median122Median558.4026Median8.8 Mode126.6Mode629.25Mode10.27 Standard Deviation7.3610093Standard Deviation75.17413Standard Deviation1.348015 Sample Variance54.184459Sample Variance5651.149Sample Variance1.817145 Kurtosis-1.130314Kurtosis-0.53296Kurtosis-1.28042 Skewness-0.286953Skewness0.813684Skewness0.089549 Range29.879997Range274.4878Range6.58 Minimum103.12Minimum492.5522Minimum6.02 Maximum133Maximum767.04Maximum12.6 Sum28841.42Sum142017Sum2086.17 Count239Count239Count239 Confidence Level(95.0%)0.9379951Confidence Level(95.0%)9.579252Confidence Level(95.0%)0.171774 StockMean priceMedian Price Average Price Standard Deviation Coefficient of Variation Apple120.68$ 120.92$ 119.64$ 7.11$ 6% Google594.21$ 558.40$ 594.21$ 75.02$ 13% Blackberry8.73$ 8.80$ 8.73$ 1.35$ 15% Sheet3 Row LabelsCount of EducationLevel College or Greater15 High School15 Some College15 Grand Total45 Employee Educational Levels Total College or GreaterHigh SchoolSome College151515 1 Count of GenderColumn Labels Row LabelsFull-timePart-TimeGrand Total College or Greater8715 High School8715 Some College6915 Grand Total222345 Employee Demographics 2016 Full-timeCollege or GreaterHigh SchoolSome College886Part-TimeCollege or GreaterHigh SchoolSome College779Education Level Number of Employees 2 Count of GenderColumn Labels0.466666666747 Row LabelsFemaleMaleGrand Total College or Greater1515 High School8715 Some College1515 Grand Total232245 Employee Demographics 2016 FemaleCollege or GreaterHigh SchoolSome College158MaleCollege or GreaterHigh SchoolSome College715Education Level Number of Employees 3 AgeGenderEducationLevelEmploymentStatusAnnualSalaryJobSatisfaction 36FemaleCollege or GreaterPart-Time2415 32FemaleCollege or GreaterFull-time3317 34FemaleCollege or GreaterFull-time3714 45FemaleCollege or GreaterPart-Time2919College or GreaterHigh SchoolSome CollegeAnnualSalary 55FemaleCollege or GreaterFull-time4219Average35.333333333333.866666666735.3333333333Average34.8444444444Average34.8444444444 36FemaleCollege or GreaterPart-Time3521Minimum242114Minimum14Minimum14 37FemaleCollege or GreaterFull-time3615Q129.526.521Q128Q128 29FemaleCollege or GreaterPart-Time3017Median353437Median35Median35 28FemaleCollege or GreaterPart-Time3113Q34039.548.5Q343Q343 59FemaleCollege or GreaterFull-time4314Maximum485054Maximum54Maximum54 55FemaleCollege or GreaterFull-time3815 42FemaleCollege or GreaterPart-Time2916Up to Q129.529.529.5Up to Q129.525th pct28 34FemaleCollege or GreaterPart-Time28Q1 to Q25.55.55.5Q1 to Q25.550th Pct7 38FemaleCollege or GreaterFull-time4717Q2 to Q3555Q2 to Q3575th Pct8 34FemaleCollege or GreaterFull-time4813Bottom Whisker5.55.55.5Bottom Whisker5.5 22FemaleHigh SchoolFull-time3014Top Whisker888Top Whisker8Min14 24FemaleHigh SchoolFull-time2113Max11 51FemaleHigh SchoolPart-Time3915 32FemaleHigh SchoolFull-time2621 36FemaleHigh SchoolPart-Time3420 40FemaleHigh SchoolPart-Time3519 46FemaleHigh SchoolPart-Time4021 18FemaleHigh SchoolPart-Time5015Mean34.8444444444 29MaleHigh SchoolFull-time3120Range24 18MaleHigh SchoolFull-time2216 33MaleHigh SchoolPart-Time2621IQR10.5 31MaleHigh SchoolPart-Time271815.75 26MaleHigh SchoolFull-time3622 45MaleHigh SchoolFull-time462513.75 46MaleHigh SchoolFull-time452324.25 18MaleSome CollegePart-Time1919 18MaleSome CollegePart-Time1616 21MaleSome CollegeFull-time1417 19MaleSome CollegeFull-time2318 19MaleSome CollegePart-Time1815 42MaleSome CollegeFull-time3917 44MaleSome CollegePart-Time3714 42MaleSome CollegePart-Time4815College or GreaterHigh SchoolSome College 37MaleSome CollegeFull-time3416 35MaleSome CollegePart-Time3215Mean35.333333333333.866666666735.3333333333 52MaleSome CollegePart-Time4617Standard Error1.85848547322.29049104043.6822181031 51MaleSome CollegeFull-time5013Median353437 60MaleSome CollegeFull-time5114Mode2926ERROR:#N/A 47MaleSome CollegePart-Time4913Standard Deviation7.19788328678.871033654314.2611693904 59MaleSome CollegePart-Time5417Sample Variance51.809523809578.6952380952203.380952381 Kurtosis-0.7578884-0.8533394737-1.5556137301 Skewness0.39496355670.3025518795-0.2574123556 Range242940 Minimum242114 Maximum485054 Sum530508530 Count151515 Confidence Level(95.0%)3.98605490254.91261469237.8975723695 15.5College or Greater29.5College or Greater5.581College or Greater5 Sheet1 AgeGenderEducationLevelEmploymentStatusAnnualSalaryJobSatisfaction 36FemaleCollege or GreaterPart-Time2415 32FemaleCollege or GreaterFull-time3317 34FemaleCollege or GreaterFull-time3714 45FemaleCollege or GreaterPart-Time2919 55FemaleCollege or GreaterFull-time4219 36FemaleCollege or GreaterPart-Time3521 37FemaleCollege or GreaterFull-time3615 29FemaleCollege or GreaterPart-Time3017 28FemaleCollege or GreaterPart-Time3113 59FemaleCollege or GreaterFull-time4314 55FemaleCollege or GreaterFull-time3815 42FemaleCollege or GreaterPart-Time2916 34FemaleCollege or GreaterPart-Time28 38FemaleCollege or GreaterFull-time4717 34FemaleCollege or GreaterFull-time4813 22FemaleHigh SchoolFull-time3014 24FemaleHigh SchoolFull-time2113 51FemaleHigh SchoolPart-Time3915 32FemaleHigh SchoolFull-time2621 36FemaleHigh SchoolPart-Time3420 40FemaleHigh SchoolPart-Time3519 46FemaleHigh SchoolPart-Time4021 18FemaleHigh SchoolPart-Time5015 29MaleHigh SchoolFull-time3120 18MaleHigh SchoolFull-time2216 33MaleHigh SchoolPart-Time2621 31MaleHigh SchoolPart-Time2718 26MaleHigh SchoolFull-time3622 45MaleHigh SchoolFull-time4625 46MaleHigh SchoolFull-time4523 18MaleSome CollegePart-Time1919 18MaleSome CollegePart-Time1616 21MaleSome CollegeFull-time1417 19MaleSome CollegeFull-time2318 19MaleSome CollegePart-Time1815 42MaleSome CollegeFull-time3917 44MaleSome CollegePart-Time3714 42MaleSome CollegePart-Time4815 37MaleSome CollegeFull-time3416 35MaleSome CollegePart-Time3215 52MaleSome CollegePart-Time4617 51MaleSome CollegeFull-time5013 60MaleSome CollegeFull-time5114 47MaleSome CollegePart-Time4913 59MaleSome CollegePart-Time5417 Sheet2 Count of GenderColumn Labels Row LabelsFull-timePart-TimeGrand Total Female111223 Male111122 Grand Total222345 Employee Demographics 2016 Full-timeFemaleMale1111Part-TimeFemaleMale1211Gender Number of Employees Sheet1 BinFrequencyCumulative % $102.6810.42% $104.5942.09% $106.5133.35% $108.4286.69% $110.331412.55% $112.251518.83% $114.161725.94% $116.072134.73% $117.991541.00% $119.901547.28% $121.811453.14% $123.731860.67% $125.643474.90% $127.553288.28% $129.471996.23% More9100.00% BinFrequencyCumulative % $492.5510.42% $510.85115.02% $529.152314.64% $547.456943.51% $565.752353.14% $584.05956.90% $602.35559.00% $620.65962.76% $638.952472.80% $657.241980.75% $675.541185.36% $693.84085.36% $712.14386.61% $730.441191.21% $748.741095.40% More11100.00% BinFrequencyCumulative % $6.0210.42% $6.4642.09% $6.9054.18% $7.342815.90% $7.775739.75% $8.212148.54% $8.65349.79% $9.09752.72% $9.531960.67% $9.973474.90% $10.414091.63% $10.851698.33% $11.28399.58% $11.72099.58% $12.16099.58% More1100.00% Apple Stock Price (2015) Frequency$102.68$104.59$106.51$108.42$110.33$112.25$114.16$116.07$117.99$119.90$121.81$123.73$125.64$127.55$129.47More143814151721151514183432199Cumulative %$102.68$104.59$106.51$108.42$110.33$112.25$114.16$116.07$117.99$119.90$121.81$123.73$125.64$127.55$129.47More4.1841004184100415E-32.0920502092050208E-23.3472803347280332E-26.6945606694560664E-20.125523012552301250.188284518828451870.25941422594142260.347280334728033490.410041841004184120.472803347280334740.531380753138075310.606694560669456040.74895397489539750.882845188284518860.962343096234309581Price per Share ($USD) Number of Days Google Stock Price (2015) Frequency$492.55$510.85$529.15$547.45$565.75$584.05$602.35$620.65$638.95$657.24$675.54$693.84$712.14$730.44$748.74More11123692395924191103111011Cumulative %$492.55$510.85$529.15$547.45$565.75$584.05$602.35$620.65$638.95$657.24$675.54$693.84$712.14$730.44$748.74More4.1841004184100415E-35.0209205020920501E-20.146443514644351460.435146443514644380.531380753138075310.569037656903765730.589958158995815940.627615062761506250.728033472803347290.807531380753138130.853556485355648540.853556485355648540.866108786610878640.912133891213389170.953974895397489591Price per Share ($USD) Number of Days Blackberry Stock Price (2015) Frequency$6.02$6.46$6.90$7.34$7.77$8.21$8.65$9.09$9.53$9.97$10.41$10.85$11.28$11.72$12.16More14528572137193440163001Cumulative %$6.02$6.46$6.90$7.34$7.77$8.21$8.65$9.09$9.53$9.97$10.41$10.85$11.28$11.72$12.16More4.1841004184100415E-32.0920502092050208E-24.1841004184100417E-20.158995815899581590.397489539748953960.485355648535564840.4979079497907950.527196652719665320.606694560669456040.74895397489539750.916317991631799170.983263598326359790.995815899581590.995815899581590.995815899581591Price per Share ($USD) Number of Days Apple DateOpenHighLowCloseVolumeAdj Close ($USD) 12/11/15115.190002115.389999112.849998113.1846640500113.18 12/10/15116.040001116.940002115.510002116.16999829104200116.169998 12/9/15117.639999117.690002115.080002115.62000345017700115.620003 12/8/15117.519997118.599998116.860001118.23000334254500118.230003 12/7/15118.980003119.860001117.809998118.27999931991200118.279999 12/4/15115.290001119.25115.110001119.02999956524700119.029999 12/3/15116.550003116.790001114.220001115.19999741476500115.199997 12/2/15117.339996118.110001116.080002116.27999933199000116.279999 12/1/15118.75118.809998116.860001117.33999634701000117.339996 11/30/15117.989998119.410004117.75118.30000337658700118.300003 11/27/15118.290001118.410004117.599998117.80999813023700117.809998 11/25/15119.209999119.230003117.919998118.02999921388300118.029999 11/24/15117.330002119.349998117.120003118.87999742803200118.879997 11/23/15119.269997119.730003117.339996117.7532482500117.75 11/20/15119.199997119.919998118.849998119.30000334287100119.300003 11/19/15117.639999119.75116.760002118.77999943295800118.779999 11/18/15115.760002117.489998115.5117.29000146674700117.290001 11/17/15114.919998115.050003113.32113.69000227616900113.690002 11/16/15111.379997114.239998111114.1838106700114.18 11/13/15115.199997115.57112.269997112.33999645812400112.339996 11/12/15116.260002116.82115.650002115.72000132525600115.720001 11/11/15116.370003117.419998115.209999116.11000145218000116.110001 11/10/15116.900002118.07116.059998116.76999759127900116.769997 11/9/15120.959999121.809998120.050003120.5733871400120.57 11/6/15121.110001121.809998120.620003121.05999833042300121.059998 11/5/15121.849998122.690002120.18120.91999839552700120.919998 11/4/15123.129997123.82121.62000312244886100121.480003 11/3/15120.790001123.489998120.699997122.5745519000122.047573 11/2/15120.800003121.360001119.610001121.1832203300120.663499 10/30/15120.989998121.220001119.449997119.549365300118.990659 10/29/15118.699997120.690002118.269997120.52999951227300120.016268 10/28/15116.93119.300003116.059998119.26999785551400118.761636 10/27/15115.400002116.540001113.989998114.55000369884400114.06176 10/26/15118.080002118.129997114.919998115.27999966333800114.788644 10/23/15116.699997119.230003116.330002119.08000259366900118.572451 10/22/15114.330002115.5114.099998115.541654100115.007708 10/21/15114115.580002113.699997113.76000241795200113.275126 10/20/15111.339996114.169998110.82113.76999748967800113.285078 10/19/15110.800003111.75110.110001111.73000329759200111.25378 10/16/15111.779999112110.529999111.04000138236300110.566719 10/15/15110.93112.099998110.489998111.86000137673500111.383223 10/14/15111.290001111.519997109.559998110.20999944462400109.740254 10/13/15110.82112.449997110.68111.79000133049300111.313522 10/12/15112.730003112.75111.440002111.59999830467200111.124329 10/9/15110112.279999109.489998112.12000352766100111.642117 10/8/15110.190002110.190002108.209999109.561979600109.033282 10/7/15111.739998111.769997109.410004110.77999946765600110.307825 10/6/15110.629997111.739998109.769997111.30999848857000110.835564 10/5/15109.879997111.370003109.07110.77999952064700110.307825 10/2/15108.010002111.010002107.550003110.37999758019800109.909528 10/1/15109.07109.620003107.309998109.58000263929100109.112942 9/30/15110.169998111.540001108.730003110.30000366473000109.829875 9/29/15112.830002113.510002107.860001109.05999873365400108.595155 9/28/15113.849998114.57112.440002112.44000252109000111.960753 9/25/15116.440002116.690002114.019997114.70999956151900114.221074 9/24/15113.25115.5112.37000311550219500114.509839 9/23/15113.629997114.720001113.300003114.3235756700113.832737 9/22/15113.379997114.18112.519997113.40000250346200112.91666 9/21/15113.669998115.370003113.660004115.20999950222000114.718943 9/18/15112.209999114.300003111.870003113.44999774285300112.966443 9/17/15115.660004116.489998113.720001113.91999864112600113.434441 9/16/15116.25116.540001115.440002116.41000437173500115.913833 9/15/15115.93116.529999114.419998116.27999943341200115.784382 9/14/15116.580002116.889999114.860001115.30999858363400114.818515 9/11/15111.790001114.209999111.760002114.20999949915500113.723205 9/10/15110.269997113.279999109.900002112.5762892800112.090196 9/9/15113.760002114.019997109.769997110.15000285010800109.680513 9/8/15111.75112.559998110.32112.30999854843600111.831302 9/4/15108.970001110.449997108.510002109.26999749996300108.804259 9/3/15112.489998112.779999110.040001110.37000353233900109.899576 9/2/15110.230003112.339996109.129997112.33999661888800111.861173 9/1/15110.150002111.879997107.360001107.72000176845900107.26087 8/31/15112.029999114.529999112112.76000256229300112.279389 8/28/15112.169998113.309998111.540001113.29000153164400112.807129 8/27/15112.230003113.239998110.019997112.91999884616100112.438703 8/26/15107.089996109.889999105.050003109.69000296774600109.222474 8/25/15111.110001111.110001103.5103.739998103601600103.29783 8/24/1594.870003108.80000392103.120003162206300102.680478 8/21/15110.43111.900002105.650002105.760002128275500105.309225 8/20/15114.080002114.349998111.629997112.65000268501600112.169857 8/19/15116.099998116.519997114.68115.01000247445700114.519799 8/18/15116.43117.440002116.010002116.534560700116.003446 8/17/15116.040001117.650002115.5117.16000440884700116.660636 8/14/15114.32116.309998114.010002115.95999942929500115.465746 8/13/15116.040001116.400002114.540001115.15000248535800114.659201 8/12/15112.529999115.419998109.629997115.239998101217500114.748814 8/11/15117.809998118.18113.330002113.48999897082800113.006273 8/10/15116.529999119.989998116.529999119.72000154951600119.209722 8/7/15114.580002116.25114.5115.51999738670400115.027619 8/6/15115.970001116.5114.120003115.12999752903000114.639282 8/5/15112.949997117.440002112.099998115.40000299312600114.390352 8/4/15117.419998117.699997113.25114.639999124138600113.636999 8/3/15121.5122.57117.519997118.44000269976000117.403756 7/31/15122.599998122.639999120.910004121.30000342885000120.238734 7/30/15122.32122.57121.709999122.37000333628300121.299372 7/29/15123.150002123.5122.269997122.98999837011700121.913943 7/28/15123.379997123.910004122.550003123.37999733618100122.30053 7/27/15123.089996123.610001122.120003122.76999744455500121.695866 7/24/15125.32125.739998123.900002124.542162300123.410734 7/23/15126.199997127.089996125.059998125.16000450999500124.064963 7/22/15121.989998125.5121.989998125.220001115450600124.124435 7/21/15132.850006132.919998130.320007130.7576756400129.606052 7/20/15130.970001132.970001130.699997132.07000758900200130.91451 7/17/15129.080002129.619995128.309998129.61999546164700128.485933 7/16/15127.739998128.570007127.349998128.50999536222400127