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:
. 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/ 2
1
001
1189.01001 9 500
/18
5
.48999
1188.300049 04.199951
1204.199951 1205 5.869995
1209.589966 0015
1229.1 015 1229.140015 6
3.079956
.030029
6.869995
1246.869995 9500
1252.699951 00
24
1254.329956 1254.329956 1276.680054 00
1273.390015 1305.199951 /18
9.939941
1304.859985 .23999
0.880005
1295 6
1293.319946 1312 1294.579956 1327.310059 .089966
1362.540039 00
34
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 0
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 .5
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 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 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 3 7 7 13 23 23 27 28 24 21 14 16 18 14 11 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 20 40 51 33 25 32 11 12 5 6 5 0 3 4 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 1642.285200668 1642.285200668 =
1626.345032 =
1390 1390 =
197.4715064821 1189.01001 2039.51001 250 5643772.4 4948050 5624700 5624700 2555947.14070981 Count 250 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 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. 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 1 1245.71 3 1302.41 7 1359.11 7 1415.81 13 1472.51 23 1529.21 23 1585.91 27 1642.61 28 1699.31 24 1756.01 21 1812.71 14 1869.41 16 1926.11 18 1982.81 14 More 11 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 1 2972147 20 3828693 40 4685240 51 5541787 33 6398333 25 7254880 32 8111427 11 8967973 12 9824520 5 10681067 6 11537613 5 12394160 0 13250707 3 14107253 4 More 2 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. 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 Or 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 Or 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. Britannica. (2019). Amazon. Retrieved from https://www.britannica.com/topic/Amazoncom 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 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 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 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
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
1205.48999
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
1388.160034
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
1458.97998
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
1465.800049
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
1528.699951
3/1/18 1518.48999
3/2/18 1501.050049
3/5/18 1525.380005
3/6/18 1542.130005
3/7/18
1545.900024
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
1596.910034
3/16/18 1589.439941
3/19/18 1561.660034
3/20/18 1587
3/21/18 1590
3/22/18
1573.849976
3/23/18 1549.02002
3/26/18 1556.98999
3/27/18
1575.969971
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
1638.099976
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
1665.680054
6/5/18 1699
6/6/18
1714.5
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
1724.800049
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
1756.959961
7/12/18 1798
7/13/18 1815.300049
7/16/18
1841.949951
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
1880.050049
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
1956.819946
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
1540.98999
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
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
1590.890015
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
1603.439941
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
1673.01001
6/11/18
1680.589966
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
1717.560059
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
1678.060059
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
1795.22998
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
1874.410034
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
1949.810059
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
Q3
Bin
Frequency
1189.01001 1
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
FrequencyQ4
Bin Frequency
2115600 1
2972146.66666667
3828693.33333333
4685240
5541786.66666667
6398333.33333333
7254880
8111426.66666667
8967973.33333333
9824520
10681066.6666667
11537613.3333333
12394160
13250706.6666667
14107253.3333333
More 2
FrequencyQ5
Adj Close
Mean
1642.285200668
Mean=
Standard Error
12.4891946694
Median
1626.345032
Median 1626.345032
Mode
Mode 1390
Standard Deviation
197.4715064821
Standard Deviation 197.4715064821
Sample Variance
38994.9958723108
Kurtosis
-0.7110252515
Skewness
0.0209945136
Range
850.5
Minimum
Maximum
Sum
410571.300167
Count
Q6
Stock Volume
Mean=
5643772.4
Mean 5643772.4
Median=
4948050
Standard Error
161652.290872758
Mode=
Median 4948050
Standard Deviation=
2555947.14070981
Mode 5624700
Standard Deviation 2555947.14070981
Sample Variance
6532865786102.65
Kurtosis
1.8345680918
Skewness
1.3336107842
Range
12848200
Minimum 2115600
Maximum 14963800
Sum
1410943100
Introduction 2
Graphical Representation of Data 2
Descriptive Statistics 2
References 2
Introduction
Graphical Representation of Data
Descriptive Statistics
References
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
Frequency
Frequency