Applied Data Analytics

profiledoma23
MidtermPortfolioA.xlsx
Home>Mathematics homework help>Applied Data Analytics

Questions

Question 1: (5 marks) Explain in your own words the importance of data analytics in business. Provide at least 5 areas in a business where analytics can be used. (Word Count: Minimum 200 words)
Question 2: (10 marks) a. Explain in your own words what is a 'variable' AND how variables are used in data analysis. b. What are the main differences between a 'sample' and a 'population'. c. Name at least 5 different calculations or graphical representations of how we can summarize a variable to analyze the data. d. Explain the difference between 'qualitative' and 'quantitative' variables. e. List 3 main characteristics about the Normal Distribution.
Question 3: (25 marks) Refer to the Excel Data for Question 3 ("Q3 Data") to answer the following questions: a. Plot the different crime statistics provided in the data set on a line graph. (TIP: You can choose to either create one graph with all crimes or multiple graphs e.g., 1 x per crime). b. Interpret what you see on the graph based on the patterns observed for each crime. (TIP: comment on which crimes have increased, which have decreased, etc.) c. Expand on your analysis in question (2) by concluding on any patterns or trends observed. Include a brief comparison of the trends with the population data included. Does the increase in population play a role? (TIP: Which stocks are higher risk and which stocks are lower in risk). d. As Mayor of the city, what will be your final conclusion after analyzing these data sets of the different crimes and what recommendations will you make to the city?
Question 4: (30 marks) Refer to the Excel Data for Question 4 ("Q4 Data") to answer the following questions: a. Calculate the Measures of Central Tendency for the rainfall data collected. b. Calculate the Measures of Central Tendency for the Kilowatt (KW) data collected. c. Construct a Frequency Table for the rainfall data collected. d. Construct a Frequency Table for the Kilowatt (KW) data collected. e. Draw a Histogram graph for questions (c) and (d). f. Comment and derive a conclusion suitable for business decision making based on the calculations and answers provided in questions (a) to (e)
Question 5: (30 marks) Refer to the Excel Data for Question 5 ("Q5 Data") to answer the following questions: a. Plot each of the stocks in the data set on a line graph. (TIP: You can choose to either create one graph or multiple). b. Interpret what you see on the graph based on the patterns observed for each stock. c. Expand on your analysis in question (b) by concluding on the risk or volatility of the stocks. (TIP: Which stocks are higher risk and which stocks are lower in risk). d. Which stock will you choose for your company to invest in and why.

Q3 Data

Year Population Violent crime total Murder and nonnegligent manslaughter Forcible rape Robbery Aggravated assault Property crime total Burglary Larceny-theft Motor vehicle theft
1960 179,323,175 288,460 9,110 17,190 107,840 154,320 3,095,700 912,100 1,855,400 328,200
1961 182,992,000 289,390 8,740 17,220 106,670 156,760 3,198,600 949,600 1,913,000 336,000
1962 185,771,000 301,510 8,530 17,550 110,860 164,570 3,450,700 994,300 2,089,600 366,800
1963 188,483,000 316,970 8,640 17,650 116,470 174,210 3,792,500 1,086,400 2,297,800 408,300
1964 191,141,000 364,220 9,360 21,420 130,390 203,050 4,200,400 1,213,200 2,514,400 472,800
1965 193,526,000 387,390 9,960 23,410 138,690 215,330 4,352,000 1,282,500 2,572,600 496,900
1966 195,576,000 430,180 11,040 25,820 157,990 235,330 4,793,300 1,410,100 2,822,000 561,200
1967 197,457,000 499,930 12,240 27,620 202,910 257,160 5,403,500 1,632,100 3,111,600 659,800
1968 199,399,000 595,010 13,800 31,670 262,840 286,700 6,125,200 1,858,900 3,482,700 783,600
1969 201,385,000 661,870 14,760 37,170 298,850 311,090 6,749,000 1,981,900 3,888,600 878,500
1970 203,235,298 738,820 16,000 37,990 349,860 334,970 7,359,200 2,205,000 4,225,800 928,400
1971 206,212,000 816,500 17,780 42,260 387,700 368,760 7,771,700 2,399,300 4,424,200 948,200
1972 208,230,000 834,900 18,670 46,850 376,290 393,090 7,413,900 2,375,500 4,151,200 887,200
1973 209,851,000 875,910 19,640 51,400 384,220 420,650 7,842,200 2,565,500 4,347,900 928,800
1974 211,392,000 974,720 20,710 55,400 442,400 456,210 9,278,700 3,039,200 5,262,500 977,100
1975 213,124,000 1,039,710 20,510 56,090 470,500 492,620 10,252,700 3,265,300 5,977,700 1,009,600
1976 214,659,000 1,004,210 18,780 57,080 427,810 500,530 10,345,500 3,108,700 6,270,800 966,000
1977 216,332,000 1,029,580 19,120 63,500 412,610 534,350 9,955,000 3,071,500 5,905,700 977,700
1978 218,059,000 1,085,550 19,560 67,610 426,930 571,460 10,123,400 3,128,300 5,991,000 1,004,100
1979 220,099,000 1,208,030 21,460 76,390 480,700 629,480 11,041,500 3,327,700 6,601,000 1,112,800
1980 225,349,264 1,344,520 23,040 82,990 565,840 672,650 12,063,700 3,795,200 7,136,900 1,131,700
1981 229,146,000 1,361,820 22,520 82,500 592,910 663,900 12,061,900 3,779,700 7,194,400 1,087,800
1982 231,534,000 1,322,390 21,010 78,770 553,130 669,480 11,652,000 3,447,100 7,142,500 1,062,400
1983 233,981,000 1,258,090 19,310 78,920 506,570 653,290 10,850,500 3,129,900 6,712,800 1,007,900
1984 236,158,000 1,273,280 18,690 84,230 485,010 685,350 10,608,500 2,984,400 6,591,900 1,032,200
1985 238,740,000 1,328,800 18,980 88,670 497,870 723,250 11,102,600 3,073,300 6,926,400 1,102,900
1986 241,077,000 1,489,170 20,610 91,460 542,780 834,320 11,722,700 3,241,400 7,257,200 1,224,100
1987 243,400,000 1,484,000 20,100 91,110 517,700 855,090 12,024,700 3,236,200 7,499,900 1,288,700
1988 245,807,000 1,566,220 20,680 92,490 542,970 910,090 12,356,900 3,218,100 7,705,900 1,432,900
1989 248,239,000 1,646,040 21,500 94,500 578,330 951,710 12,605,400 3,168,200 7,872,400 1,564,800
1990 248,709,873 1,820,130 23,440 102,560 639,270 1,054,860 12,655,500 3,073,900 7,945,700 1,635,900
1991 252,153,092 1,911,767 24,703 106,593 687,732 1,092,739 12,961,116 3,157,150 8,142,228 1,661,738
1992 255,029,699 1,932,274 23,760 109,062 672,478 1,126,974 12,505,917 2,979,884 7,915,199 1,610,834
1993 257,782,608 1,926,017 24,526 106,014 659,870 1,135,607 12,218,777 2,834,808 7,820,909 1,563,060
1994 260,327,021 1,857,670 23,326 102,216 618,949 1,113,179 12,131,873 2,712,774 7,879,812 1,539,287
1995 262,803,276 1,798,792 21,606 97,470 580,509 1,099,207 12,063,935 2,593,784 7,997,710 1,472,441
1996 265,228,572 1,688,540 19,645 96,252 535,594 1,037,049 11,805,323 2,506,400 7,904,685 1,394,238
1997 267,783,607 1,636,096 18,208 96,153 498,534 1,023,201 11,558,475 2,460,526 7,743,760 1,354,189
1998 270,248,003 1,533,887 16,974 93,144 447,186 976,583 10,951,827 2,332,735 7,376,311 1,242,781
1999 272,690,813 1,426,044 15,522 89,411 409,371 911,740 10,208,334 2,100,739 6,955,520 1,152,075
2000 281,421,906 1,425,486 15,586 90,178 408,016 911,706 10,182,584 2,050,992 6,971,590 1,160,002
2001 285,317,559 1,439,480 16,037 90,863 423,557 909,023 10,437,189 2,116,531 7,092,267 1,228,391
2002 287,973,924 1,423,677 16,229 95,235 420,806 891,407 10,455,277 2,151,252 7,057,379 1,246,646
2003 290,788,976 1,383,676 16,528 93,883 414,235 859,030 10,442,862 2,154,834 7,026,802 1,261,226
2004 293,656,842 1,360,088 16,148 95,089 401,470 847,381 10,319,386 2,144,446 6,937,089 1,237,851
2005 296,507,061 1,390,745 16,740 94,347 417,438 862,220 10,174,754 2,155,448 6,783,447 1,235,859
2006 299,398,484 1,435,123 17,309 94,472 449,246 874,096 10,019,601 2,194,993 6,626,363 1,198,245
2007 301,621,157 1,422,970 17,128 92,160 447,324 866,358 9,882,212 2,190,198 6,591,542 1,100,472
2008 304,059,724 1,394,461 16,465 90,750 443,563 843,683 9,774,152 2,228,887 6,586,206 959,059
2009 307,006,550 1,325,896 15,399 89,241 408,742 812,514 9,337,060 2,203,313 6,338,095 795,652
2010 308,745,538 1,246,248 14,748 84,767 367,832 778,901 9,082,887 2,159,878 6,185,867 737,142

Q4 Data

Average power [kW] Average daily rainfall [mm]
1.65 0.69
1.19 17.47
0.85 24.43
0.89 27.13
1.15 25.77
1.43 7.53
1.74 6.74
1.52 1.54
1.51 14.50
1.39 6.34
1.84 2.58
1.33 17.07
0.65 31.97
1.13 13.68
1.58 11.92
1.62 7.50
0.92 31.33
1.81 1.37
1.80 6.32
1.65 2.58
1.69 1.89
1.06 27.57
1.56 0.87
1.41 11.74
1.92 1.56
1.36 5.88
1.29 14.73
1.27 13.58
1.50 3.33
1.60 3.50

Q5 Data

Monthly returns (% changes) for selected stocks
Month AAPL
Chris Albright: Apple 		T
Chris Albright: AT&T 		CSCO
Chris Albright: Cisco 		HPQ
Chris Albright: Hewlett Packard 		INTC
Chris Albright: Intel 		IBM MSFT
Chris Albright: Microsoft 		VZ
Chris Albright: Verizon
Jun-2013 -7.58% 1.17% 0.93% 1.54% 0.72% -7.70% -0.36% 3.86%
Jul-2013 14.12% -0.37% 5.11% 4.86% -3.68% 2.05% -7.82% -1.72%
Aug-2013 7.67% -4.08% -8.26% -12.99% -5.81% -6.55% 4.93% -3.27%
Sep-2013 2.56% -0.03% 0.55% -6.04% 5.27% 2.11% 0.34% -1.50%
Oct-2013 9.64% 7.04% -3.73% 17.78% 6.76% -3.23% 6.37% 8.23%
Nov-2013 6.38% -2.73% -5.12% 12.21% -2.58% 0.26% 7.70% -0.66%
Dec-2013 5.16% -0.14% 5.56% 2.29% 9.91% 4.95% -1.15% -0.97%
Jan-2014 -10.77% -5.23% -2.32% 4.85% -5.47% -5.80% 1.16% -2.28%
Feb-2014 5.12% -4.17% 0.26% 3.11% 0.93% 4.80% 1.24% 0.18%
Mar-2014 6.43% 9.83% 2.85% 8.28% 5.23% 4.52% 7.79% -0.03%
Apr-2014 9.94% 1.80% 3.07% 3.19% 3.40% 2.07% -1.43% -1.76%
May-2014 7.27% -0.64% 7.46% 1.39% 2.36% -6.16% 1.34% 8.09%
Jun-2014 6.92% -0.31% 0.93% 0.53% 14.05% -1.10% 2.56% -2.07%
Jul-2014 2.87% 0.65% 1.51% 6.82% 9.68% 5.74% 3.50% 3.05%
Aug-2014 7.22% -1.77% -0.18% 6.74% 3.06% 0.33% 5.26% -0.12%
Sep-2014 -1.22% 0.80% 0.72% -6.64% 0.35% -0.70% 2.68% 0.33%
Oct-2014 7.20% -1.14% -2.07% 2.06% -2.32% -13.40% 1.27% 0.52%
Nov-2014 10.12% 1.55% 12.98% 8.86% 9.55% -1.36% 1.84% 1.80%
Dec-2014 -6.79% -5.06% 0.65% 2.75% -1.96% -0.39% -2.24% -7.52%
Jan-2015 6.14% -1.99% -5.20% -9.16% -8.96% -4.44% -13.02% -2.29%
Feb-2015 9.64% 4.98% 12.68% -3.57% 0.63% 5.63% 8.53% 9.45%
Mar-2015 -2.75% -5.53% -6.72% -10.53% -5.27% -0.19% -6.63% -1.65%
Apr-2015 0.58% 6.09% 5.54% 6.92% 4.09% 6.72% 19.65% 3.71%
May-2015 4.10% -0.29% 1.65% 1.34% 5.88% -0.96% -3.67% -0.88%
Jun-2015 -3.32% 2.84% -6.30% -10.21% -11.11% -3.40% -5.17% -5.72%
Jul-2015 -3.29% -2.20% 3.46% 2.94% -4.82% -0.41% 5.79% 0.39%
Aug-2015 -6.91% -3.74% -8.21% -8.10% -1.43% -8.70% -6.82% -0.52%
Sep-2015 -1.88% -2.57% 1.40% -8.73% 6.51% -1.16% 2.38% -5.44%
Oct-2015 8.34% 2.85% 9.91% 6.82% 12.33% -3.37% 18.94% 7.76%
Nov-2015 -1.00% 0.48% -4.75% 2.39% 2.70% -0.47% 3.25% -1.79%
Dec-2015 -10.64% 2.20% -0.36% -5.63% -0.25% -0.37% 2.76% 1.68%
Jan-2016 -7.52% 4.80% -12.38% -17.16% -9.93% -9.32% -0.70% 8.14%
Feb-2016 -0.67% 2.47% 10.89% 10.19% -4.62% 5.00% -7.64% 2.76%
Mar-2016 13.33% 6.01% 8.75% 15.18% 10.30% 16.76% 9.33% 6.60%
Apr-2016 -13.99% -0.89% -3.45% 0.70% -6.42% -3.64% -9.69% -5.80%
May-2016 6.53% 0.85% 6.64% 9.10% 4.34% 5.35% 6.26% 0.98%
Jun-2016 -3.68% 10.37% -1.22% -6.20% 4.73% -0.32% -2.77% 9.70%
Jul-2016 9.01% 0.19% 6.42% 12.62% 6.28% 5.82% 10.76% -0.77%
Aug-2016 1.81% -5.57% 3.89% 2.56% 2.95% -1.08% 1.38% -4.61%
Sep-2016 7.13% -0.66% 0.91% 8.14% 5.97% 0.85% 0.87% -0.66%
Oct-2016 0.43% -9.41% -3.28% -5.90% -7.63% -3.25% 4.04% -7.46%
Nov-2016 -2.66% 5.00% -2.00% 6.27% -0.48% 5.55% 0.55% 4.92%
Dec-2016 5.33% 4.53% 1.34% -3.59% 5.32% 3.25% 3.83% 6.97%
Jan-2017 4.77% 4.41% 1.67% 2.25% 1.51% 5.14% 4.03% -8.19%
Feb-2017 12.89% -0.88% 12.19% 15.41% -1.69% 3.04% -1.03% 2.34%
Mar-2017 5.32% -0.57% -1.10% 2.92% 0.34% -2.39% 3.56% -1.78%
Apr-2017 -0.01% -4.62% 0.80% 6.08% 0.23% -7.95% 3.95% -5.82%
May-2017 6.34% -2.78% -6.64% -0.33% -0.11% -4.78% 2.01% 2.80%
Jun-2017 -5.33% -2.08% -0.75% -6.79% -5.86% 1.77% -0.75% -4.25%
Jul-2017 3.27% 3.37% 0.50% 10.05% 5.11% -5.96% 5.48% 8.39%
Aug-2017 10.27% -3.95% 3.35% -0.11% -1.12% -1.13% 2.85% 0.41%
Sep-2017 -5.66% 4.56% 4.42% 4.65% 9.40% 2.50% 0.15% 3.15%
Oct-2017 9.68% -14.09% 1.55% 8.68% 19.47% 6.19% 11.67% -3.27%
Nov-2017 1.66% 8.11% 5.97% -0.42% -1.42% -3.21% 1.19% 7.58%
Dec-2017 -1.17% 6.87% 6.74% -2.08% 3.55% 3.91% 2.14% 4.00%
Jan-2018 -1.06% -3.68% 8.46% 11.71% 4.30% 6.70% 11.08% 2.17%
Feb-2018 6.38% -3.07% 8.61% 0.30% 2.38% -4.81% -1.31% -10.70%
Mar-2018 -5.42% -1.79% -4.21% -6.28% 6.37% -0.57% -2.21% 0.17%
Apr-2018 2.99% -2.33% 3.88% -0.60% 0.27% -3.73% 5.30% 1.27%