This is my feedback from assignment 5. She want you to use assignment five again with this assignment. I will attach assignment five again for you to get the information that she want you to use. As you know you were to pick a stock, download the stock d

20191115010218week_8_assignment2 x20191115010614week_5_assignment_2.xlsx_bb1.xlsx20191115010646week_5_assignment2 x

This is my feedback from assignment 5. She want you to use assignment five again with this assignment. I will attach assignment five again for you to get the information that she want you to use.

As you know you were to pick a stock, download the stock data and do some analysis.

You were to write a one page introduction, create scatterplots (and include a sentence explaining each process to create. Create a couple of histographs and again explain the process. Calculate central tendency and standard deviation stats for two sets of data and again give us insight into your process to create. And it is always a good idea to add a summary.

So, you picked Amazon – good choice. Good job downloading the data.

Good work on 1 page intro.

Good job on scatterplots – think about labeling x and y axes on all graphs – US Dollars and DATE for example. Let’s your reader understand you results more quickly.

Histograms – well done – see above. Add trendlines for readability and understanding. What else might you add to graphs?

Good job with calculations on mean, median, mode and standard deviation.

I hope you are feeling good about your growing understanding of analytics!

Citations and Reference page – See notes on doc and see Writing Center for quick tutorials. All assignments should meet writing standards, have citations and reference page requirements.

Think about adding summary on all papers.

Good work overall. Questions on next assignment – let me know!

Applying Analytic Techniques to Business

Overview

The first step in creating meaningful information from raw data is to represent the data effectively in a graphical format and calculate any required statistics. The second step is interpreting and explaining those graphs and statistics in order to apply them in the practical business context.

In the last assignment, you were asked to create the first part of your analytics report by developing graphs and calculating some descriptive statistics. In this assignment, you will complete your analytics report by interpreting those graphs and statistics, and explicitly connecting those interpretations to implications in the practical business context.

Scenario

Your supervisor has asked you to prepare a report for the quarterly company meeting. The first part of the task was to download the data and create scatterplots and histograms, and to calculate mean, median, and mode of the stock prices for your report. Now you must analyze and interpret those graphical representations of the company stocks and write the report of your findings for your supervisor.

Your Role

You are an analyst in the same business that you used for the last assignment. Having accessed the company data and placed it in an appropriate graphical format, you must now use descriptive statistics and analysis to develop a report to inform business decisions.

Instructions

After reviewing and integrating your instructor’s feedback on your previous assignment, complete the report as follows:

· For each graph you created, write at least one paragraph interpreting the graph.

. What does that graph represent?

. What does the shape of the graph tell you about how the data have changed over time?

· For each statistic you calculated, include at least one sentence explaining what the statistic represents.

. What does the mean tell you?

. What does it imply if the median is different from the mean?

. What does the standard deviation tell you about the volatility of the data?

· Write a new conclusions section in which you explain how these interpretations can be used in the company:

. What are some trends about which company leaders should be aware?

. How might the information you have provided be used in decision making in the company?

. Explicitly connect those interpretations to implications in the practical business context.

· Create a 6–8 page report containing:

. APA-formatted title page.

. One-page introduction of your chosen company that you created in your previous assignment.

. Section labeled Graphical Representations of Data that includes the four graphs you created as well as your interpretations of the graphs.

. Section labeled Descriptive Statistics, with the statistics you calculated as well as your interpretations of the statistics.

. One-page conclusion in which you describe the potential business applications of the data and interpretations.

. APA-formatted references page (remember to cite the source of your financial data).

Additional Requirements

· Include APA-formatted in-text citations where appropriate.

· Follow the typical double-spaced analytics report format.

· Make sure your written communication is free of errors that detract from the overall message.

>AMZN

/2/

001

1189.01001

500

/18

.48999

1188.300049

04.199951

1204.199951

1205

5.869995

1209.589966

0015

1229.1

015 1229.140015

3.079956

.030029

6.869995

1246.869995

9500

1252.699951

1254.329956 1254.329956

1276.680054

1273.390015

1305.199951

/18

9.939941

1304.859985

.23999

0.880005

1295

1293.319946

1312

1294.579956

1327.310059

.089966

1362.540039

1338

1357.51001

1377.949951

.01001

1402.050049

1417.680054

1392

1437.819946

1450.890015

1390

1429.949951

.97998

1390 1390

000

1442.839966

1416.780029

1350.5

1339.599976

1386.22998

1414.51001

.25

1451.050049

1461.76001

.800049

1448.689941

1446.48999

1468.349976

1482.920044

1485.339966

1500

1500 1500

1521.949951

1511.97998

.699951

1512.449951

1465

1493.449951

.099976

1500.25

1523.609985

1528

1537.640015

.900024

1545 1545

1551.859985

1578.890015

.599976

1598.390015

1588.180054

.890015

1591

.910034

1582.319946

1571.680054

1544.930054

1586.51001

1590

1581.859985

.849976

1544.920044

.01001

1495.359985

1495.560059

1555.859985

.969971

1497.050049

1431.420044

1406

1447.339966

1371.98999

1414

1392.050049

1410.569946

1451.75

1405.22998

1406.079956

1436.219971

1427.050049

1448.5

1430.790039

1445 1447

1441.5

1503.829956

1527.839966

1556.910034

1561.199951

1527.48999

.859985

1517.859985

1460.089966

1458

1460.170044

1517.959961

.099976

1572.619995

1596

.130005

1566.130005

1582.26001

1569.680054

1572.079956

1580.949951

1600.140015

1595

1592.390015

1600

1592 1608 1608

.439941

1609.079956

1602.910034

1601.540039

1587.800049

1576.119995

1587.280029

1573

1581.76001

1574.369995

1585

1575

1585.459961

1589.890015

1581.400024

1601.859985 1601.859985

1603.069946

1603

1610.150024

1612.869995

1624.890015

1629.619995

40039

1641.540039

.680054

1665.27002

.349976

1696.349976

1695.75

1689.300049

.01001

1683.98999

.589966

1689.119995

1693

1698.75

1704.859985

.800049

1723.859985

1714

1715.969971

1723.790039

.780029

1734.780029

1750.079956

.560059

.219971

1730.219971

1715.670044

1663.150024

1691.089966

1660.51001

1701.449951

1717

1699.800049

.060059

1713.780029

1693.959961

1699.72998

1696

1710.630005

1739.02002

1750

1743.069946

.959961

1734

1755

1796.619995

.22998

1813.030029

.949951

1822.48999

1843.930054

1842.920044

1841

1812.969971

1813.699951

1802

1829.23999

1863.609985

1808

.050049

1817.27002

1779.219971

.48999

1777.439941

1797.170044

1786

1834.329956

1841

1823.290039

1847.75

30029

1862.47998

1854.5

1886.52002

2002

1898.52002

.51001

1886.300049

1898.5

1896.199951

1900

1919.650024

1882.619995

1886.52002 1886.52002

1888

1882.219971

1876.709961

1880

.410034

1883.420044

1876.640015

1904.900024

.900024

1902.900024

1001

1905.390015

1927.680054

1932.819946

1998.099976

2002.380005

2012.709961

2039.51001

1994.819946

1958.310059

1952.069946

1939.01001

1987.150024

1994 2000

1990

2000

1989.869995

1970.189941

.819946

1908.030029

1941.050049

1904.900024

1926.420044

1944.300049

1910.5

1915.01001

1934.359985

1974.550049

1974.849976

2012.97998

2003

2004.359985 3460500

1971.310059

.810059

1952.76001

1949 1956

1909.420044

1889.650024

1874 1902

1864.420044

1870.319946

1755.25

1724

1719.359985

1808

1788.609985

1795

1760.949951

1819.959961

1831.72998

1770.719971

1764.030029

1784

1756

1789.300049

1714

1768.699951

1664.199951

1782.170044

1603

1642.810059

1660

1495

1538.880005

.98999

1530.420044

1598.01001

1665.530029

1665.530029 1665.530029

1627.800049 5624700

1665

1642.810059 1642.810059

1673

1755.48999

1755 1784

1754.910034

1712.430054

1636.849976

1631.170044

1673

1599.01001

1619.439941

1593.410034

1512.290039

1495.459961

1550

1516.72998

1517

1502.060059

1539

1581.329956 1581.329956

1581.420044

1677.75

1673.569946

1696

1690.170044

1730

1772.359985

1756

1665

1668.400024

1699.189941

1629.130005

1641.030029

1678

1643.23999

1663.540039

1680

1641.5

1658.380005

1638

1585

1591.910034

1566

1520.910034

1540

1551.47998

1495.079956

1460.829956

1377.449951

1343.959961

1470.900024

1469

1461.640015

1449

1478.02002

										Date	Open		High		Low	Close	Adj Close	Volume
		1	18			11		7		119	0		1170.			5			1189.01001	2	6	4
1/		3			1188.300049		1	20			12	3108800
1/4/18		1	21		1204.660034		1209.589966	3022100
1/5/18	1217.51001				1229.		14		1210	40	3544700
1/8/18	1		23		1	25		12	32		1	24	4	27
1/9/18	1256.900024		1259.329956		1241.76001		1252.699951	366	13
1/10/18	1245.				1500				1254.329956		1237.22998	2686000
1/11/18	1259.73999		1276.77002		1256.459961		1276.680054	31		250
1/12/18			1273.390015		1305.76001		1305.199951	5443700
1/	16	1323		1	33		1292.300049		1304.859985	7220700
1/17/18		1312		1314		1	28		1295	5253800
1/18/18	1293.949951		1304.599976		1284.02002		1293.3	1994	4026900
1/19/18		1313		1292.98999		1294.579956	4578500
1/22/18	1297.170044		1327.449951		1296.660034		1327.310059	4140100
1/23/18			1338		1364.900024		1337.339966		1362.540039	5	1693
1/24/18	1374.819946	1388.	1600		1357.51001	6807500
1/25/18	1368		1378.339966		1357.619995		1377.949951	4753000
1/26/18			1392		1402.530029		1380.910034		1402.050049	4857300
1/29/18	1409.180054		1431.390015		1400.439941		1417.680054	570		1900
1/30/18	1403.170044		1439.25		1437.819946	5871900
1/31/18	1451.300049		1472.579956		1450.040039		1450.890015	6424700
2/1/18		1445		1459.880005		1385.140015							1390	9113800
2/2/18	1477.390015		1498				1414		1429.949951	11125700
2/5/18	1402.619995		1458		1320.719971	1		1495
2/6/18	1361.459961		1443.98999		1351.790039		1442.839966	11066800
2/7/18			1449		1460.98999		1415.150024		1416.780029	7162700
2/8/18	1429.680054		1433.75		1349.939941		1350.5	8578600
2/9/18	1373.48999		1383.5		1265.930054		1339.599976	14141500
2/12/18	1364.670044		1393.810059		1344.01001		1386.22998	6738900
2/13/18	1385.930054		1419.719971		1383.530029		1414.51001	5917900
2/14/18		1406		1452.060059		1403.359985		1451.050049	5959200
2/15/18	1466.890015		1468.939941		1436.839966		1461.76001	5652700
2/16/18	1457.369995			1465		1446.560059		1448.689941	4472600
2/20/18			1446.48999		1488.77002		1468.349976	6499200
2/21/18	1485		1503.48999		1478.920044		1482.920044	6304400
2/22/18			1495.359985		1502.540039		1475.76001		1485.339966	4858100
2/23/18	1495.339966		1486.5	4418100
2/26/18	1509.199951		1522.839966		1507		1521.949951	4955000
2/27/18	1524.5		1526.780029		1507.209961		1511.97998	4808800
2/28/18	1519.51001			1528		1512		1512.449951	4515000
3/1/18	1513.599976		1518.48999		1493.449951	6835200
3/2/18			1469		1501.050049		1455.01001		1500.25	6587600
3/5/18	1494.23999		1525.380005		1481		1523.609985	5233900
3/6/18	1533.199951		1542.130005		1537.640015	4561700
3/7/18	1526.52002			1545		1522.51001	4174100
3/8/18			1550		1554.880005		1545.25		1551.859985	3862600
3/9/18	1563.5		1578.939941		1559.079956		1578.890015	4534300
3/12/18			1592		1605.329956		1586.699951		1598.390015	5174200
3/13/18	1615.959961		1617.540039		1578.01001		1588.180054	6531900
3/14/18	1597		1606.439941			1590		1591	4259400
3/15/18		1595			1596		1578.109985		1582.319946	4069700
3/16/18	1583.449951		1589.439941		1567.5		1571.680054	5425000
3/19/18	1554.530029		1561.660034		1525.349976		1544.930054	6580800
3/20/18	1550.339966		1587		1545.410034		1586.51001	4581600
3/21/18	1586.449951		1563.170044		1581.859985	4750800
3/22/18	1565.469971			1573		1542.400024		1544.920044	6320600
3/23/18		1539		1549.02002		1495.560059	8006000
3/26/18	1530		1556.98999		1499.25		1555.859985					5624700
3/27/18	1572.400024			1575		1482.319946		1497.050049	6999600
3/28/18			1447		1455.900024		1386.170044		1431.420044	13705300
3/29/18		1455.469971		1365.199951		1447.339966	12581100
4/2/18	1417.619995		1421.359985		1355		1371.98999	10463600
4/3/18	1391.380005		1355.329956		1392.050049	10231200
4/4/18	1358.23999		1415.390015		1352.880005		1410.569946	6982300
4/5/18	1441.98999		1459.560059		1427.069946		1451.75	6413500
4/6/18	1429.969971		1452.5		1400.26001		1405.22998	5882300
4/9/18	1425.030029		1438.47998		1402.569946		1406.079956	4208200
4/10/18	1431.98999		1438.380005		1415.699951		1436.219971	4254100
4/11/18	1439.439941		1448.780029		1424.890015		1427.050049	3582500
4/12/18	1439.5		1452.119995		1435.060059		1448.5	3135000
4/13/18	1449.140015		1459.780029		1424.52002		1430.790039	3685300
4/16/18		1427.47998		1441.5	2808600
4/17/18	1462.300049		1507.189941		1457.02002		1503.829956	5114400
4/18/18	1514.650024		1533.800049		1504.109985		1527.839966	5227500
4/19/18	1543.219971		1568.52002		1539.060059		1556.910034	6523700
4/20/18			1561.199951		1516.089966		1527.48999	5541600
4/23/18	1546.689941		1548		1503.410034			1517	4465400
4/24/18	1535.800049		1539.5		1448.449951		1460.089966	7494700
4/25/18		1469.98999		1415.02002		1460.170044	6587300
4/26/18	1485.01001		1529.420044		1478.5		1517.959961	8801100
4/27/18	1634.01001		1638		1567.390015		1572.619995	13053200
4/30/18	1582.5		1560.939941			1566	5464100
5/1/18	1563.219971					1585		1552.180054		1582.26001	4572100
5/2/18	1580.97998		1588.5		1566.359985		1569.680054	4360300
5/3/18	1560.01001		1574.800049		1546.02002		1572.079956	4251900
5/4/18	1562.449951		1584.900024		1562.189941		1580.949951	3443600
5/7/18	1589.339966		1606.949951		1587.829956		1600.140015	3801900
5/8/18		1596.880005		1582.51001		1592.390015	3067900
5/9/18				1608	3637300
5/10/18	1608.47998		1615.599976				1603		1609.079956	28		1750
5/11/18	1610.98999		1611.099976		1597.890015		1602.910034	2263900
5/14/18	1604		1611.180054		1600.050049		1601.540039	2509500
5/15/18			1587.800049		1565.219971		1576.119995	5077500
5/16/18	1577.5		1594.430054		1576.670044		1587.280029	2570600
5/17/18	1580.560059		1594.040039		1581.76001	2147600
5/18/18			1581.329956		1583.589966		1572.099976		1574.369995	2642600
5/21/18		1592.050049		1585.459961	2925200
5/22/18			1589.890015		1575.25		1581.400024			2115600
5/23/18	1571.050049				1601.859985		1566.339966	3361900
5/24/18	1598.030029		1608.23999		1588.380005		1603.069946	3430000
5/25/18		1614.119995		1600.449951		1610.150024	2698400
5/29/18	1600.709961		1621.790039		1600.150024		1612.869995	3846500
5/30/18	1618.099976		1626		1612.930054		1624.890015	2907400
5/31/18	1623		1635		1621.349976		1629.619995	3166300
6/1/18	1637.030029		1646.72998		1635.089966				1641.5	3313400
6/4/18	1648.900024					1665		1645.48999		1665.27002	3187700
6/5/18	1672.98999		1699		1670.060059					1696	4782200
6/6/18	1704.51001				1714		1686.469971		1695.75	5473200
6/7/18	1698.560059		1699.900024		1676.109985		1689.300049	3765700
6/8/18	1681.119995		1689.439941				1673		1683.98999	2955100
6/11/18	1681.51001		1694.23999		1680		1689.119995	2335500
6/12/18		1699.51001		1691.52002		1698.75	2259200
6/13/18	1702.810059		1713.75		1700.119995		1704.859985	3327500
6/14/18	1713.47998		1724		1708.869995		1723.859985	3174400
6/15/18		1720.869995		1708.52002		1715.969971	4777600
6/18/18	1706.26001		1726.73999		1702.560059		1723.790039	3107700
6/19/18	1709.040039		1736.109985		1700.390015				1734	4290100
6/20/18	1742.5		1762.930054		1741.359985		1750.079956	4332600
6/21/18	1760		1763.099976		1717				1730	4941100
6/22/18	1742.619995		1743		1711.900024		1715.670044	4075100
6/25/18	1702.51001		1705		1646.310059		1663.150024	7511200
6/26/18	1672.369995		1701.569946		1663.339966		1691.089966	4386600
6/27/18	1708.109985		1711.949951			1660		1660.51001	4872200
6/28/18	1672.540039		1705.5		1661.170044		1701.449951	4529700
6/29/18		1723.410034		1694.319946		1699.800049	4543500
7/2/18	1682.699951		1713.890015		1678		1713.780029	3185700
7/3/18	1723.959961		1725		1692.47998		1693.959961	2177300
7/5/18	1705.380005		1710.689941		1682.150024		1699.72998	2983100
7/6/18		1715.27002		1691.670044		1710.630005	2650300
7/9/18	1724.050049		1739.560059		1716.22998		1739.02002	301			2000
7/10/18	1738.530029		1731		1743.069946	3002900
7/11/18	1737.98999				1756			1755	3209800
7/12/18	1764.51001		1798		1762.180054		1796.619995	4532700
7/13/18	1803.930054		1815.300049		1795		1813.030029	4383200
7/16/18	1821.949951					1841		1814.449951		1822.48999	5466200
7/17/18	1811.560059		1851.689941		1797.380005		1843.930054	5682900
7/18/18	1848		1858.880005		1831.27002		1842.920044	4861900
7/19/18	1829.459961		1811.27002		1812.969971	4676900
7/20/18	1825.01001		1834.839966		1810.060059		1813.699951	3884400
7/23/18	1812.209961		1819		1769.98999		1802	3888500
7/24/18	1829.01001		1840		1809.380005		1829.23999	4278700
7/25/18	1829.300049		1863.839966		1822.640015		1863.609985	3738200
7/26/18	1839		1844.680054		1804.5			1808	9924400
7/27/18	1876.050049		1880		1806.530029		1817.27002	9681000
7/30/18	1827.329956		1829.5		1766.02002		1779.219971	6562300
7/31/18			1786		1801.829956		1739.319946		1777.439941	5738700
8/1/18				1784		1798.439941		1776.02002		1797.170044	4153100
8/2/18	1788.77002		1836.560059		1834.329956	4354700
8/3/18	1837.73999		1821.5		1823.290039		3460500
8/6/18	1825.810059		1847.77002		1818.920044		1847.75	3391800
8/7/18			1854.5		1869.719971		1846.27002		1862.47998	3377500
8/8/18	1861		1891.51001				1886.52002	3963000
8/9/18	1882		1914.569946		1877.47998			1898.5	4860400
8/10/18			1888		1899.5		1878.209961		1886.300049	3639900
8/13/18		1925		1893.670044		1896.199951	5531500
8/14/18	1919.390015		1921.01001		1919.650024	3986100
8/15/18	1909.550049		1916.209961		1869.790039		1882.619995	7700700
8/16/18	1903.939941		1905		1883.550049	3957100
8/17/18	1885.800049		1855.550049		1882.219971	4104300
8/20/18	1890.569946		1891.75		1866.060059		1876.709961	2862000
8/21/18		1897.75		1874		1883.420044	3105600
8/22/18			1876.640015		1905.800049				1904.900024	3080500
8/23/18	1907.170044		1919.5		1900.76001				1902	3563000
8/24/18			1910.5		1916.01001		1902.540039		1905.390015	2800900
8/27/18	1915		1927.699951		1909.280029		1927.680054	3569000
8/28/18	1937.72998		1941.780029		1928.819946		1932.819946	3100700
8/29/18	1953.449951		1998.689941		1948.939941		1998.099976	6531800
8/30/18	1997.420044		2025.569946		1986.900024		2002.380005	7277300
8/31/18	2007		2022.380005		2004.73999		2012.709961	4204400
9/4/18	2026.5		2050.5		2013			2039.51001	5721100
9/5/18	2038.109985		2040.380005		1989.890015		1994.819946	8220600
9/6/18	2006.51001		2007.5		1935.209961		1958.310059	7488700
9/7/18	1938.709961		1975.199951		1937.349976		1952.069946	4892600
9/10/18	1971		1973.040039		1931.52002		1939.01001	4544800
9/11/18	1928.27002		1988.880005		1917		1987.150024	5033600
9/12/18		1962.439941		1990	4414000
9/13/18		2008.76001		1982.030029		1989.869995	3621500
9/14/18	1992.930054		1993.650024		1959.219971		1970.189941	3642000
9/17/18	1954.72998			1956		1887.410034		1908.030029	7050200
9/18/18	1918.650024		1958.199951		1915.439941		1941.050049	4268700
9/19/18	1940.5		1940.829956		1926.420044	4056800
9/20/18	1938.579956		1955		1932.25		1944.300049	3154900
9/21/18	1954.219971		1957.310059		1915.01001	6855900
9/24/18	1903.790039		1936.880005		1865		1934.359985	4213700
9/25/18	1942.900024		1975.910034		1938.849976		1974.550049	4538400
9/26/18	1968.5		1995.25		1961.52002		1974.849976	4313500
9/27/18	1993.23999		2016.160034		1988.579956		2012.97998	4329400
9/28/18	2004.410034		2026.52002		1996.459961		2003	4085100
10/1/18	2021.98999		2033.189941		2003.599976		2004.359985
10/2/18	1999.98999		2013.390015		1965.77002		1971.310059	5400700
10/3/18	1981.699951		1989.699951		1949		1952.76001	5253100
10/4/18		1896.569946		1909.420044	7257000
10/5/18	1917.98999		1929.079956		1862.829956		1889.650024	6822300
10/8/18		1830.660034		1864.420044	7393200
10/9/18	1859.98999		1896.680054		1852.319946		1870.319946	4772900
10/10/18	1857.890015		1858.560059		1754.410034		1755.25	10988900
10/11/18		1755.400024		1685.099976		1719.359985	13935900
10/12/18		1808.949951		1742.530029		1788.609985	9444600
10/15/18		1795.050049		1734.22998		1760.949951	6437200
10/16/18	1783.5		1823.880005		1761.550049		1819.959961	5859900
10/17/18	1842.790039		1845		1807		1831.72998	5295200
10/18/18	1821.48999		1830.150024		1767.869995		1770.719971	5874000
10/19/18	1785.160034		1809.099976		1753		1764.030029	5907200
10/22/18		1809.5		1789.300049	4500000
10/23/18	1742.23999		1776.339966		1768.699951	6723900
10/24/18	1773.699951		1777.709961		1656.560059		1664.199951	6928400
10/25/18	1703.339966		1794.810059		1692.01001		1782.170044	10285700
10/26/18	1649.589966		1698.459961				1642.810059		14963800
10/29/18		1665.73999		1538.880005	13866100
10/30/18	1486.160034		1540		1476.359985		1530.420044	12460100
10/31/18	1569.98999		1623.910034		1565.089966		1598.01001	9390200
11/1/18	1623.530029		1670.449951		1598.439941				1665.530029	8135500
11/2/18	1678.589966		1697.439941		1651.829956	6955500
11/5/18	1657.569946		1658.089966		1596.359985		1627.800049
11/6/18	1618.349976		1614.550049	4257400
11/7/18		1759.22998		1664.079956		1755.48999	8192200
11/8/18		1725.109985		1754.910034	6534900
11/9/18	1732.5		1743.920044		1701.869995		1712.430054	5902200
11/12/18	1698.23999		1708.550049		1630.01001		1636.849976	6806200
11/13/18	1649.290039		1677.060059		1613.75		1631.170044	5933300
11/14/18	1656.319946		1597.069946		1599.01001	6486900
11/15/18	1581.01001		1624.819946		1546.51001		1619.439941	8427300
11/16/18	1587.5		1614.47998		1573.119995		1593.410034	6066100
11/19/18	1577.01001		1581.189941		1503.359985		1512.290039	7790000
11/20/18	1437.5		1534.75		1420		1495.459961	10878800
11/21/18	1542.98999		1515		1516.72998	5716800
11/23/18		1536.199951		1501.810059		1502.060059	2707600
11/26/18		1584.810059		1524.219971	6257700
11/27/18	1575.98999		1597.650024		1558.01001		1581.420044	5783200
11/28/18	1613.920044		1681.449951		1601.219971		1677.75	8458700
11/29/18	1674.98999		1689.98999		1652.329956		1673.569946	6613200
11/30/18	1679.5		1666.5		1690.170044	5761800
12/3/18	1769.459961		1778.339966		1772.359985	6862300
12/4/18		1770.339966		1668.400024	8694500
12/6/18	1614.869995		1701.050049		1609.849976		1699.189941	8789400
12/7/18	1705.069946		1718.930054		1625.459961		1629.130005	7576100
12/10/18	1623.839966		1657.98999		1590.869995		1641.030029	7494800
12/11/18		1679.469971		1619.599976		1643.23999	6244700
12/12/18	1669		1704.98999		1660.27002		1663.540039	6598000
12/13/18		1692.119995		1658.380005	5271300
12/14/18		1642.569946		1591.910034	6367200
12/17/18		1576.130005		1505.01001		1520.910034	8829800
12/18/18		1567.550049		1523.01001		1551.47998	6523000
12/19/18	1543.050049		1584.530029		1483.180054		1495.079956	8792200
12/20/18	1484		1509.5		1432.689941		1460.829956	9991800
12/21/18	1464.98999		1480		1363.959961		1377.449951	13640300
12/24/18	1346		1396.030029		1307		1343.959961	7220000
12/26/18	1368.890015		1473.160034		1363.01001		1470.900024	10411800
12/27/18	1454.199951		1390.310059		1461.640015	9722000
12/28/18	1473.349976		1513.469971		1478.02002	8829000

Q1

Date High
1/2/18 1190
1/3/18

1/4/18 1215.869995
1/5/18 1229.140015
1/8/18 1253.079956
1/9/18 1259.329956
1/10/18 1254.329956
1/11/18 1276.77002
1/12/18 1305.76001
1/16/18 1339.939941
1/17/18 1314
1/18/18 1304.599976
1/19/18 1313
1/22/18 1327.449951
1/23/18 1364.900024
1/24/18

1/25/18 1378.339966
1/26/18 1402.530029
1/29/18 1431.390015
1/30/18 1439.25
1/31/18 1472.579956
2/1/18 1459.880005
2/2/18 1498
2/5/18

2/6/18 1443.98999
2/7/18 1460.98999
2/8/18 1433.75
2/9/18 1383.5
2/12/18 1393.810059
2/13/18 1419.719971
2/14/18 1452.060059
2/15/18 1468.939941
2/16/18

2/20/18 1488.77002
2/21/18 1503.48999
2/22/18 1502.540039
2/23/18 1500
2/26/18 1522.839966
2/27/18 1526.780029
2/28/18

3/1/18 1518.48999
3/2/18 1501.050049
3/5/18 1525.380005
3/6/18 1542.130005
3/7/18

3/8/18 1554.880005
3/9/18 1578.939941
3/12/18 1605.329956
3/13/18 1617.540039
3/14/18 1606.439941
3/15/18

3/16/18 1589.439941
3/19/18 1561.660034
3/20/18 1587
3/21/18 1590
3/22/18

3/23/18 1549.02002
3/26/18 1556.98999
3/27/18

3/28/18 1455.900024
3/29/18 1455.469971
4/2/18 1421.359985
4/3/18 1414
4/4/18 1415.390015
4/5/18 1459.560059
4/6/18 1452.5
4/9/18 1438.47998
4/10/18 1438.380005
4/11/18 1448.780029
4/12/18 1452.119995
4/13/18 1459.780029
4/16/18 1447
4/17/18 1507.189941
4/18/18 1533.800049
4/19/18 1568.52002
4/20/18 1561.199951
4/23/18 1548
4/24/18 1539.5
4/25/18 1469.98999
4/26/18 1529.420044
4/27/18

4/30/18 1596
5/1/18 1585
5/2/18 1588.5
5/3/18 1574.800049
5/4/18 1584.900024
5/7/18 1606.949951
5/8/18 1596.880005
5/9/18 1608
5/10/18 1615.599976
5/11/18 1611.099976
5/14/18 1611.180054
5/15/18 1587.800049
5/16/18 1594.430054
5/17/18 1594.040039
5/18/18 1583.589966
5/21/18 1592.050049
5/22/18 1589.890015
5/23/18 1601.859985
5/24/18 1608.23999
5/25/18 1614.119995
5/29/18 1621.790039
5/30/18 1626
5/31/18 1635
6/1/18 1646.72998
6/4/18

6/5/18 1699
6/6/18

6/7/18 1699.900024
6/8/18 1689.439941
6/11/18 1694.23999
6/12/18 1699.51001
6/13/18 1713.75
6/14/18

6/15/18 1720.869995
6/18/18 1726.73999
6/19/18 1736.109985
6/20/18 1762.930054
6/21/18 1763.099976
6/22/18 1743
6/25/18 1705
6/26/18 1701.569946
6/27/18 1711.949951
6/28/18 1705.5
6/29/18 1723.410034
7/2/18 1713.890015
7/3/18 1725
7/5/18 1710.689941
7/6/18 1715.27002
7/9/18 1739.560059
7/10/18 1750
7/11/18

7/12/18 1798
7/13/18 1815.300049
7/16/18

7/17/18 1851.689941
7/18/18 1858.880005
7/19/18 1841
7/20/18 1834.839966
7/23/18 1819
7/24/18 1840
7/25/18 1863.839966
7/26/18 1844.680054
7/27/18

7/30/18 1829.5
7/31/18 1801.829956
8/1/18 1798.439941
8/2/18 1836.560059
8/3/18 1841
8/6/18 1847.77002
8/7/18 1869.719971
8/8/18 1891.51001
8/9/18 1914.569946
8/10/18 1899.5
8/13/18 1925
8/14/18 1921.01001
8/15/18 1916.209961
8/16/18 1905
8/17/18 1888
8/20/18 1891.75
8/21/18 1897.75
8/22/18 1905.800049
8/23/18 1919.5
8/24/18 1916.01001
8/27/18 1927.699951
8/28/18 1941.780029
8/29/18 1998.689941
8/30/18 2025.569946
8/31/18 2022.380005
9/4/18 2050.5
9/5/18 2040.380005
9/6/18 2007.5
9/7/18 1975.199951
9/10/18 1973.040039
9/11/18 1988.880005
9/12/18 2000
9/13/18 2008.76001
9/14/18 1993.650024
9/17/18

9/18/18 1958.199951
9/19/18 1940.829956
9/20/18 1955
9/21/18 1957.310059
9/24/18 1936.880005
9/25/18 1975.910034
9/26/18 1995.25
9/27/18 2016.160034
9/28/18 2026.52002
10/1/18 2033.189941
10/2/18 2013.390015
10/3/18 1989.699951
10/4/18 1956
10/5/18 1929.079956
10/8/18 1902
10/9/18 1896.680054
10/10/18 1858.560059
10/11/18 1755.400024
10/12/18 1808.949951
10/15/18 1795.050049
10/16/18 1823.880005
10/17/18 1845
10/18/18 1830.150024
10/19/18 1809.099976
10/22/18 1809.5
10/23/18 1776.339966
10/24/18 1777.709961
10/25/18 1794.810059
10/26/18 1698.459961
10/29/18 1665.73999
10/30/18

10/31/18 1623.910034
11/1/18 1670.449951
11/2/18 1697.439941
11/5/18 1658.089966
11/6/18 1665
11/7/18 1759.22998
11/8/18 1784
11/9/18 1743.920044
11/12/18 1708.550049
11/13/18 1677.060059
11/14/18 1673
11/15/18 1624.819946
11/16/18 1614.47998
11/19/18 1581.189941
11/20/18 1534.75
11/21/18 1550
11/23/18 1536.199951
11/26/18 1584.810059
11/27/18 1597.650024
11/28/18 1681.449951
11/29/18 1689.98999
11/30/18 1696
12/3/18 1778.339966
12/4/18 1770.339966
12/6/18 1701.050049
12/7/18 1718.930054
12/10/18 1657.98999
12/11/18 1679.469971
12/12/18 1704.98999
12/13/18 1692.119995
12/14/18 1642.569946
12/17/18 1576.130005
12/18/18 1567.550049
12/19/18 1584.530029
12/20/18 1509.5
12/21/18 1480
12/24/18 1396.030029
12/26/18 1473.160034
12/27/18 1469
12/28/18 1513.469971

1205.48999
1388.160034
1458.97998
1465.800049
1528.699951
1545.900024
1596.910034
1573.849976
1575.969971
1638.099976
1665.680054
1714.5
1724.800049
1756.959961
1841.949951
1880.050049
1956.819946
1540.98999

Scatter Plot of Highest

Price

High 43102 43103 43104 43105 43108 43109 43110 43111 43112 43116 43117 43118 43119 43122 43123 43124 43125 43126 43129 43130 43131 43132 43133 43136 43137 43138 43139 43140 43143 43144 43145 43146 43147 43151 43152 43153 43154 43157 43158 43159 43160 43161 43164 43165 43166 43167 43168 43171 43172 43173 43174 43175 43178 43179 43180 43181 43182 43185 43186 43187 43188 43192 43193 43194 43195 43196 43199 43200 43201 43202 43203 43206 43207 43208 43209 43210 43213 43214 43215 43216 43217 43220 43221 43222 43223 43224 43227 43228 43229 43230 43231 43234 43235 43236 43237 43238 43241 43242 43243 43244 43245 43249 43250 43251 43252 43255 43256 43257 43258 43259 43262 43263 43264 43265 43266 43269 43270 43271 43272 43273 43276 43277 43278 43279 43280 43283 43284 43286 43287 43290 43291 43292 43293 43294 43297 43298 43299 43300 43301 43304 43305 43306 43307 43308 43311 43312 43313 43314 43315 43318 43319 43320 43321 43322 43325 43326 43327 43328 43329 43332 43333 43334 43335 43336 43339 43340 43341 43342 43343 43347 43348 43349 43350 43353 43354 43355 43356 43357 43360 43361 43362 43363 43364 43367 43368 43369 43370 43371 43374 43375 43376 43377 43378 43381 43382 43383 43384 43385 43388 43389 43390 43391 43392 43395 43396 43397 43398 43399 43402 43403 43404 43405 43406 43409 43410 43411 43412 43413 43416 43417 43418 43419 43420 43423 43424 43425 43427 43430 43431 43432 43433 43434 43437 43438 43440 43441 43444 43445 43446 43447 43448 43451 43452 43453 43454 43455 43458 43460 43461 43462 1190 1205.48999 1215.869995 1229.1400149999999 1253.079956 1259.329956 1254.329956 1276.7700199999999 1305.76001 1339.9399410000001 1314 1304.599976 1313 1327.4499510000001 1364.900024 1388.160034 1378.339966 1402.530029 1431.3900149999999 1439.25 1472.579956 1459.880005 1498 1458.9799800000001 1443.98999 1460.98999 1433.75 1383.5 1393.8100589999999 1419.719971 1452.0600589999999 1468.9399410000001 1465.8000489999999 1488.7700199999999 1503.48999 1502.540039 1500 1522.839966 1526.780029 1528.6999510000001 1518.48999 1501.0500489999999 1525.380005 1542.130005 1545.900024 1554.880005 1578.9399410000001 1605.329956 1617.540039 1606.4399410000001 1596.910034 1589.4399410000001 1561.660034 1587 1590 1573.849976 1549.0200199999999 1556.98999 1575.969971 1455.900024 1455.469971 1421.3599850000001 1414 1415.3900149999999 1459.5600589999999 1452.5 1438.4799800000001 1438.380005 1448.780029 1452.119995 1459.780029 1447 1507.1899410000001 1533.8000489999999 1568.5200199999999 1561.1999510000001 1548 1539.5 1469.98999 1529.420044 1638.099976 1596 1585 1588.5 1574.8000489999999 1584.900024 1606.9499510000001 1596.880005 1608 1615.599976 1611.099976 1611.1800539999999 1587.8000489999999 1594.4300539999999 1594.040039 1583.589966 1592.0500489999999 1589.8900149999999 1601.8599850000001 1608.23999 1614.119995 1621.790039 1626 1635 1646.7299800000001 1665.6800539999999 1699 1714.5 1699.900024 1689.4399410000001 1694.23999 1699.51001 1713.75 1724.8000489999999 1720.869995 1726.73999 1736.1099850000001 1762.9300539999999 1763.099976 1743 1705 1701.5699460000001 1711.9499510000001 1705.5 1723.410034 1713.8900149999999 1725 1710.6899410000001 1715.2700199999999 1739.5600589999999 1750 1756.959961 1798 1815.3000489999999 1841.9499510000001 1851.6899410000001 1858.880005 1841 1834.839966 1819 1840 1863.839966 1844.6800539999999 1880.0500489999999 1829.5 1801.829956 1798.4399410000001 1836.5600589999999 1841 1847.7700199999999 1869.719971 1891.51001 1914.5699460000001 1899.5 1925 1921.01001 1916.209961 1905 1888 1891.75 1897.75 1905.8000489999999 1919.5 1916.01001 1927.6999510000001 1941.780029 1998.6899410000001 2025.5699460000001 2022.380005 2050.5 2040.380005 2007.5 1975.1999510000001 1973.040039 1988.880005 2000 2008.76001 1993.650024 1956.8199460000001 1958.1999510000001 1940.829956 1955 1957.3100589999999 1936.880005 1975.910034 1995.25 2016.160034 2026.5200199999999 2033.1899410000001 2013.3900149999999 1989.6999510000001 1956 1929.079956 1902 1896.6800539999999 1858.5600589999999 1755.400024 1808.9499510000001 1795.0500489999999 1823.880005 1845 1830.150024 1809.099976 1809.5 1776.339966 1777.709961 1794.8100589999999 1698.459961 1665.73999 1540.98999 1623.910034 1670.4499510000001 1697.4399410000001 1658.089966 1665 1759.2299800000001 1784 1743.920044 1708.5500489999999 1677.0600589999999 1673 1624.8199460000001 1614.4799800000001 1581.1899410000001 1534.75 1550 1536.1999510000001 1584.8100589999999 1597.650024 1681.4499510000001 1689.98999 1696 1778.339966 1770.339966 1701.0500489999999 1718.9300539999999 1657.98999 1679.469971 1704.98999 1692.119995 1642.5699460000001 1576.130005 1567.5500489999999 1584.530029 1509.5 1480 1396.030029 1473.160034 1469 1513.469971

Q2

Date Low
1/2/18 1170.51001
1/3/18 1188.300049
1/4/18 1204.660034
1/5/18 1210
1/8/18 1232.030029
1/9/18 1241.76001
1/10/18 1237.22998
1/11/18 1256.459961
1/12/18 1273.390015
1/16/18 1292.300049
1/17/18 1280.880005
1/18/18 1284.02002
1/19/18 1292.98999
1/22/18 1296.660034
1/23/18 1337.339966
1/24/18 1338
1/25/18 1357.619995
1/26/18 1380.910034
1/29/18 1400.439941
1/30/18 1392
1/31/18 1450.040039
2/1/18 1385.140015
2/2/18 1414
2/5/18 1320.719971
2/6/18 1351.790039
2/7/18 1415.150024
2/8/18 1349.939941
2/9/18 1265.930054
2/12/18 1344.01001
2/13/18 1383.530029
2/14/18 1403.359985
2/15/18 1436.839966
2/16/18 1446.560059
2/20/18 1446.48999
2/21/18 1478.920044
2/22/18 1475.76001
2/23/18 1486.5
2/26/18 1507
2/27/18 1507.209961
2/28/18 1512
3/1/18 1465
3/2/18 1455.01001
3/5/18 1481
3/6/18 1528
3/7/18 1522.51001
3/8/18 1545.25
3/9/18 1559.079956
3/12/18 1586.699951
3/13/18 1578.01001
3/14/18

3/15/18 1578.109985
3/16/18 1567.5
3/19/18 1525.349976
3/20/18 1545.410034
3/21/18 1563.170044
3/22/18 1542.400024
3/23/18 1495.359985
3/26/18 1499.25
3/27/18 1482.319946
3/28/18 1386.170044
3/29/18 1365.199951
4/2/18 1355
4/3/18 1355.329956
4/4/18 1352.880005
4/5/18 1427.069946
4/6/18 1400.26001
4/9/18 1402.569946
4/10/18 1415.699951
4/11/18 1424.890015
4/12/18 1435.060059
4/13/18 1424.52002
4/16/18 1427.47998
4/17/18 1457.02002
4/18/18 1504.109985
4/19/18 1539.060059
4/20/18 1516.089966
4/23/18 1503.410034
4/24/18 1448.449951
4/25/18 1415.02002
4/26/18 1478.5
4/27/18 1567.390015
4/30/18 1560.939941
5/1/18 1552.180054
5/2/18 1566.359985
5/3/18 1546.02002
5/4/18 1562.189941
5/7/18 1587.829956
5/8/18 1582.51001
5/9/18 1592
5/10/18

5/11/18 1597.890015
5/14/18 1600.050049
5/15/18 1565.219971
5/16/18 1576.670044
5/17/18 1573
5/18/18 1572.099976
5/21/18 1575
5/22/18 1575.25
5/23/18 1566.339966
5/24/18 1588.380005
5/25/18 1600.449951
5/29/18 1600.150024
5/30/18 1612.930054
5/31/18 1621.349976
6/1/18 1635.089966
6/4/18 1645.48999
6/5/18 1670.060059
6/6/18 1686.469971
6/7/18 1676.109985
6/8/18

6/11/18

6/12/18 1691.52002
6/13/18 1700.119995
6/14/18 1708.869995
6/15/18 1708.52002
6/18/18 1702.560059
6/19/18 1700.390015
6/20/18 1741.359985
6/21/18

6/22/18 1711.900024
6/25/18 1646.310059
6/26/18 1663.339966
6/27/18 1660
6/28/18 1661.170044
6/29/18 1694.319946
7/2/18

7/3/18 1692.47998
7/5/18 1682.150024
7/6/18 1691.670044
7/9/18 1716.22998
7/10/18 1731
7/11/18 1734
7/12/18 1762.180054
7/13/18

7/16/18 1814.449951
7/17/18 1797.380005
7/18/18 1831.27002
7/19/18 1811.27002
7/20/18 1810.060059
7/23/18 1769.98999
7/24/18 1809.380005
7/25/18 1822.640015
7/26/18 1804.5
7/27/18 1806.530029
7/30/18 1766.02002
7/31/18 1739.319946
8/1/18 1776.02002
8/2/18 1786
8/3/18 1821.5
8/6/18 1818.920044
8/7/18 1846.27002
8/8/18 1854.5
8/9/18 1877.47998
8/10/18 1878.209961
8/13/18 1893.670044
8/14/18 1900
8/15/18 1869.790039
8/16/18 1883.550049
8/17/18 1855.550049
8/20/18 1866.060059
8/21/18

8/22/18 1876.640015
8/23/18 1900.76001
8/24/18 1902.540039
8/27/18 1909.280029
8/28/18 1928.819946
8/29/18 1948.939941
8/30/18 1986.900024
8/31/18 2004.73999
9/4/18 2013
9/5/18 1989.890015
9/6/18 1935.209961
9/7/18 1937.349976
9/10/18 1931.52002
9/11/18 1917
9/12/18 1962.439941
9/13/18 1982.030029
9/14/18 1959.219971
9/17/18 1887.410034
9/18/18 1915.439941
9/19/18 1904.900024
9/20/18 1932.25
9/21/18 1910.5
9/24/18 1865
9/25/18 1938.849976
9/26/18 1961.52002
9/27/18 1988.579956
9/28/18 1996.459961
10/1/18 2003.599976
10/2/18 1965.77002
10/3/18

10/4/18 1896.569946
10/5/18 1862.829956
10/8/18 1830.660034
10/9/18 1852.319946
10/10/18 1754.410034
10/11/18 1685.099976
10/12/18 1742.530029
10/15/18 1734.22998
10/16/18 1761.550049
10/17/18 1807
10/18/18 1767.869995
10/19/18 1753
10/22/18 1756
10/23/18 1714
10/24/18 1656.560059
10/25/18 1692.01001
10/26/18 1603
10/29/18 1495
10/30/18 1476.359985
10/31/18 1565.089966
11/1/18 1598.439941
11/2/18 1651.829956
11/5/18 1596.359985
11/6/18 1614.550049
11/7/18 1664.079956
11/8/18 1725.109985
11/9/18 1701.869995
11/12/18 1630.01001
11/13/18 1613.75
11/14/18 1597.069946
11/15/18 1546.51001
11/16/18 1573.119995
11/19/18 1503.359985
11/20/18 1420
11/21/18 1515
11/23/18 1501.810059
11/26/18 1524.219971
11/27/18 1558.01001
11/28/18 1601.219971
11/29/18 1652.329956
11/30/18 1666.5
12/3/18 1730
12/4/18 1665
12/6/18 1609.849976
12/7/18 1625.459961
12/10/18 1590.869995
12/11/18 1619.599976
12/12/18 1660.27002
12/13/18 1641.5
12/14/18 1585
12/17/18 1505.01001
12/18/18 1523.01001
12/19/18 1483.180054
12/20/18 1432.689941
12/21/18 1363.959961
12/24/18 1307
12/26/18 1363.01001
12/27/18 1390.310059
12/28/18 1449

1590.890015
1603.439941
1673.01001
1680.589966
1717.560059
1678.060059
1795.22998
1874.410034
1949.810059

Scatter Plot of Lowest Price

Low 43102 43103 43104 43105 43108 43109 43110 43111 43112 43116 43117 43118 43119 43122 43123 43124 43125 43126 43129 43130 43131 43132 43133 43136 43137 43138 43139 43140 43143 43144 43145 43146 43147 43151 43152 43153 43154 43157 43158 43159 43160 43161 43164 43165 43166 43167 43168 43171 43172 43173 43174 43175 43178 43179 43180 43181 43182 43185 43186 43187 43188 43192 43193 43194 43195 43196 43199 43200 43201 43202 43203 43206 43207 43208 43209 43210 43213 43214 43215 43216 43217 43220 43221 43222 43223 43224 43227 43228 43229 43230 43231 43234 43235 43236 43237 43238 43241 43242 43243 43244 43245 43249 43250 43251 43252 43255 43256 43257 43258 43259 43262 43263 43264 43265 43266 43269 43270 43271 43272 43273 43276 43277 43278 43279 43280 43283 43284 43286 43287 43290 43291 43292 43293 43294 43297 43298 43299 43300 43301 43304 43305 43306 43307 43308 43311 43312 43313 43314 43315 43318 43319 43320 43321 43322 43325 43326 43327 43328 43329 43332 43333 43334 43335 43336 43339 43340 43341 43342 43343 43347 43348 43349 43350 43353 43354 43355 43356 43357 43360 43361 43362 43363 43364 43367 43368 43369 43370 43371 43374 43375 43376 43377 43378 43381 43382 43383 43384 43385 43388 43389 43390 43391 43392 43395 43396 43397 43398 43399 43402 43403 43404 43405 43406 43409 43410 43411 43412 43413 43416 43417 43418 43419 43420 43423 43424 43425 43427 43430 43431 43432 43433 43434 43437 43438 43440 43441 43444 43445 43446 43447 43448 43451 43452 43453 43454 43455 43458 43460 43461 43462 1170.51001 1188.3000489999999 1204.660034 1210 1232.030029 1241.76001 1237.2299800000001 1256.459961 1273.3900149999999 1292.3000489999999 1280.880005 1284.0200199999999 1292.98999 1296.660034 1337.339966 1338 1357.619995 1380.910034 1400.4399410000001 1392 1450.040039 1385.1400149999999 1414 1320.719971 1351.790039 1415.150024 1349.9399410000001 1265.9300539999999 1344.01001 1383.530029 1403.3599850000001 1436.839966 1446.5600589999999 1446.48999 1478.920044 1475.76001 1486.5 1507 1507.209961 1512 1465 1455.01001 1481 1528 1522.51001 1545.25 1559.079956 1586.6999510000001 1578.01001 1590.8900149999999 1578.1099850000001 1567.5 1525.349976 1545.410034 1563.170044 1542.400024 1495.3599850000001 1499.25 1482.3199460000001 1386.170044 1365.1999510000001 1355 1355.329956 1352.880005 1427.0699460000001 1400.26001 1402.5699460000001 1415.6999510000001 1424.8900149999999 1435.0600589999999 1424.5200199999999 1427.4799800000001 1457.0200199999999 1504.1099850000001 1539.0600589999999 1516.089966 1503.410034 1448.4499510000001 1415.0200199999999 1478.5 1567.3900149999999 1560.9399410000001 1552.1800539999999 1566.3599850000001 1546.0200199999999 1562.1899410000001 1587 .829956 1582.51001 1592 1603.4399410000001 1597.8900149999999 1600.0500489999999 1565.219971 1576.670044 1573 1572.099976 1575 1575.25 1566.339966 1588.380005 1600.4499510000001 1600.150024 1612.9300539999999 1621.349976 1635.089966 1645.48999 1670.0600589999999 1686.469971 1676.1099850000001 1673.01001 1680.589966 1691.5200199999999 1700.119995 1708.869995 1708.5200199999999 1702.5600589999999 1700.3900149999999 1741.3599850000001 1717.5600589999999 1711.900024 1646.3100589999999 1663.339966 1660 1661.170044 1694.3199460000001 1678.0600589999999 1692.4799800000001 1682.150024 1691.670044 1716.2299800000001 1731 1734 1762.1800539999999 1795.2299800000001 1814.4499510000001 1797.380005 1831.2700199999999 1811.2700199999999 1810.0600589999999 1769.98999 1809.380005 1822.6400149999999 1804.5 1806.530029 1766.0200199999999 1739.3199460000001 1776.0200199999999 1786 1821.5 1818.920044 1846.2700199999999 1854.5 1877.4799800000001 1878.209961 1893.670044 1900 1869.790039 1883.5500489999999 1855.5500489999999 1866.0600589999999 1874.410034 1876.6400149999999 1900.76001 1902.540039 1909.280029 1928.8199460000001 1948.9399410000001 1986.900024 2004.73999 2013 1989.8900149999999 1935.209961 1937.349976 1931.5200199999999 1917 1962.4399410000001 1982.030029 1959.219971 1887.410034 1915.4399410000001 1904.900024 1932.25 1910.5 1865 1938.849976 1961.5200199999999 1988.579956 1996.459961 2003.599976 1965.7700199999999 1949.8100589999999 1896.5699460000001 1862.829956 1830.660034 1852.3199460000001 1754.410034 1685.099976 1742.530029 1734.2299800000001 1761.5500489999999 1807 1767.869995 1753 1756 1714 1656.5600589999999 1692.01001 1603 1495 1476.3599850000001 1565.089966 1598.4399410000001 1651.829956 1596.3599850000001 1614.5500489999999 1664.079956 1725.1099850000001 1701.869995 163 0.01001 1613.75 1597.0699460000001 1546.51001 1573.119995 1503.3599850000001 1420 1515 1501.8100589999999 1524.219971 1558.01001 1601.219971 1652.329956 1666.5 1730 1665 1609.849976 1625.459961 1590.869995 1619.599976 1660.2700199999999 1641.5 1585 1505.01001 1523.01001 1483.1800539999999 1432.6899410000001 1363.959961 1307 1363.01001 1390.3100589999999 1449

Time in days

Price

Q3

Bin Frequency 1189.01001 1
1245.71001

3
1302.41001

7
1359.11001

7
1415.81001

13
1472.51001

23
1529.21001

23
1585.91001

27
1642.61001

28
1699.31001

24
1756.01001

21
1812.71001

14
1869.41001

16
1926.11001

18
1982.81001

14
More

Histogram adjusted daily closing

Frequency 1189.01001 1245.71001 1302.41001 1359.11001 1415.81001 1472.51001 1529.21001 1585.91001 1642.61001 1699.31001 1756.01001 1812.71001 1869.41001 1926.11001 1982.81001 More 1 3 7 7 13 23 23 27 28 24 21 14 16 18 14 11 Bin
Frequency

Q4

Bin Frequency
2115600 1

More 2

2972146.66666667
3828693.33333333
4685240
5541786.66666667
6398333.33333333
7254880
8111426.66666667
8967973.33333333
9824520
10681066.6666667
11537613.3333333
12394160
13250706.6666667
14107253.3333333

Histogram For Stock Trading Volume

Frequency 2115600 2972146.667 3828693.333 4685240 5541786.667 6398333.333 7254880 8111426.667 8967973.333 9824520 10681066.67 11537613.33 12394160 13250706.67 14107253.33 More 1 20 40 51 33 25 32 11 12 5 6 5 0 3 4 2 Bin
Frequency

Q5

Adj Close

1642.285200668 1642.285200668

1626.345032

Median 1626.345032

1390 1390

Mode 1390

197.4715064821

Standard Deviation 197.4715064821

1189.01001

2039.51001

250

Mean		1642.285200668		Mean=
Standard Error	12.4891946694		Median		1626.345032
	Mode
	Standard Deviation		197.4715064821
Sample Variance	38994.9958723108
Kurtosis	-0.7110252515
Skewness	0.0209945136
Range	850.5
Minimum
Maximum
Sum	410571.300167
Count

Q6

Mean=

5643772.4

Mean 5643772.4

4948050

Standard Error

5624700 5624700

Median 4948050

2555947.14070981

Mode 5624700
Standard Deviation 2555947.14070981
Sample Variance

Kurtosis

Skewness

Range

Minimum 2115600
Maximum 14963800
Sum

Count 250

Stock Volume
		5643772.4
Median=			4948050
161652.290872758	Mode=
Standard Deviation=			2555947.14070981
6532865786102.65
1.8345680918
1.3336107842
12848200
1410943100

Running Head: ANALYSIS OF AMAZON STOCK DATA 2

ANALYSIS OF AMAZON STOCK DATA 2

ANALYSIS OF AMAZON STOCK DATA FOR 2018

Barbara Bradley

MBA5800

Jama Bradley

11/10/2019

Table of Contents
Introduction 2
Graphical Representation of Data 2
Descriptive Statistics 2
References 2

Introduction

Amazon is an online producer and retailer of e-books as well as a provider of web services associated with the web. It is a firm with headquarters in Seattle. The firm is an internet-based retailer of books, music, toys, electronics among many more. (Britannica, 2019). The firm’s director Mr. Jeff Bezos noted in 2002 that the firm qualified as a technological organizational and not just a retailer. Bezos went ahead to establish Amazon Web Services (AWS) that gave data on the internet traffic patterns. Initially, AWS provided data on internet traffic together with other statistics such as website popularity among many more. Moreover, Amazon started selling kindle e-readers that aided in energizing the e-book industry. The firm went ahead to bring on board the low-cost tablets, which were referred to as Kindle Fire in the year 2012. Apart from the company’s general background, what does Amazon’s stock look like in the market? (Campbell, 2018)

In the year 2018, Amazon firm performed well with its share price hitting a maximum of over $2000. As per Yahoo Finance, the firm’s shares are worth $1,658. In September 2018, Amazon stood as the second after Apple as the firm that hit $1 trillion. Both Amazon together with Netflix were the only two FAANG stocks which ended the 2018 year with a positive territory. Facebook and Apple both ended the year in losses. (McKenna, 2019). This paper represents an analysis of the 2018 stock data for Amazon. The analysis is carried out in three main sections, first are the scatterplots representing the highest as well as the lowest stock price, histograms for the stock trading volume together with the adjusted daily closing stock price before finalizing with the descriptive analysis for the data as discussed below.

Graphical Representation of Data

This section discusses Amazon’s scatterplot and the histograms analyzed from the 2018 stock prices data.

1. Scatter plot for the highest stock price.

For the scatter plot involving the date and the highest stock price, data involving the two variables was selected, copied and pasted in a separate worksheet. Copied data was highlighted and then a scatter plot was automatically generated indicating the days and the amount of the highest price for each day.

2. Scatter plot for the lowest stock

Price

A similar procedure was used to create this scatter plot for the lowest price. The data involving the date and the lowest stock price for Amazon company was copied and pasted in a separate sheet. The two columns of values were selected and used when inserting the scatterplot shown above.

3. Histogram for the adjusted daily closing stock price.

Bin

Frequency

1189.01

1245.71

1302.41

1359.11

1415.81

1472.51

1529.21

1585.91

1642.61

1699.31

1756.01

1812.71

1869.41

1926.11

1982.81

Histogram involving adjusted daily closing stock price was created through a small process. First, an analysis tool pack was added to the excel sheet and then data analysis was selected on the Data tab. Within the data analysis, a histogram was clicked which asks the values for the input range as well as the bins. Just using the input data alone gives excel the option of using its own bins as shown below. One has to remember to check the chart output box so that there can be a histogram chart. Clicking okay gives the table as well as the chart output show below.

4. Histogram for the stock trading volume

Bin

Frequency

2115600

2972147

3828693

4685240

5541787

6398333

7254880

8111427

8967973

9824520

10681067

11537613

12394160

13250707

14107253

Go to the data analysis tool, select histogram, select the data and click chart output for the above histogram to be shown once one clicks okay.

Descriptive Statistics

Adj Close

Mean

1642.285

Standard Error

12.48919

Median

1626.345

Mode

1390

Standard Deviation

197.4715

Sample Variance

38995

Kurtosis

-0.71103

Skewness

0.020995

Range

850.5

Minimum

1189.01

Maximum

2039.51

Sum

410571.3

Count

250

Mean=

=AVERAGE(AMZN!F2:F251)

1642.285200668

Median=

=MEDIAN(AMZN!F2:F251)

1626.345032

Mode=

=MODE(AMZN!F2:F251)

1390

Standard Deviation=

=STDEV.S(AMZN!F2:F251)

197.471506482102

The use of the data analysis tool, clicking on descriptive statistics, clicking on the data one wants gives out the above descriptive table for adjusted close daily price. It is amazing that even each of the wanted level is clicked, it is possible to get each value for the mean, mode, median and standard deviation that are same to the ones in the descriptive table.

Stock Volume

Mean

5643772.4

Standard Error

161652.290872758

Median

4948050

Mode

5624700

Standard Deviation

2555947.14070981

Sample Variance

6532865786102.65

Kurtosis

1.83456809177717

Skewness

1.33361078415331

Range

12848200

Minimum

2115600

Maximum

14963800

Sum

1410943100

Count

250

Mean=

=AVERAGE(AMZN!G2:G251)

5643772.4

Median=

=MEDIAN(AMZN!G2:G251)

4948050

Mode=

=MODE(AMZN!G2:G251)

5624700

Standard Deviation=

=STDEV.S(AMZN!G2:G251)

2555947.14070981

In finding this table above, the descriptive table, it was clear that I just had to go to data, then click data analysis before clicking descriptive data. In put range for the data was sheet one of Amazon’s data. Selecting the entire data gave the above output. Using other formulas such as mean=average of the data, median= median(data), mode= mode(data) and standard deviation was equal to= stdev.s(data) just confirmed the values in the table. They were in line with the others.

References

Britannica. (2019). Amazon. Retrieved from https://www.britannica.com/topic/Amazoncom
Campbell. (2018). End of year stock roundup: How did Amazon perform in 2018? Retrieved from https://thenextweb.com/investing-2-0/2018/12/22/end-of-year-stock-roundup-how-did-amazon-perform-in-2018/
McKenna. (2019). Why Amazon Stock Gained 28.4% in 2018? Retrieved from https://www.fool.com/investing/2019/01/07/why-amazon-stock-gained-284-in-2018.aspx

Histogram adjusted daily closing

Histogram For Stock Trading Volume

Scatter Plot of Highest Price

Scatter Plot of Lowest Price

Time in days

Price

Turn in your highest-quality paper
Get a qualified writer to help you with

“ This is my feedback from assignment 5. She want you to use assignment five again with this assignment. I will attach assignment five again for you to get the information that she want you to use. As you know you were to pick a stock, download the stock d ”

Get high-quality paper

NEW! AI matching with writer

Order an Essay Now & Get These Features For Free:

Turnitin Report

Formatting

Title Page

Citation

Outline

Place an Order