Data Analysis and Business Intelligence Report: Amazon Stock Trends

This report presents a data analysis of Amazon's stock performance, focusing on the period from 1994 to 2018. It examines the company's growth, stock prices, and trading volume through graphical representations and statistical calculations. The analysis includes an overview of Amazon's business, its market capitalization, and key financial metrics. The report uses histograms to visualize adjusted closing stock prices and stock trading volume, providing insights into market volatility and trends. Descriptive statistics such as mean, median, mode, and standard deviation are calculated to analyze the data. The findings highlight the positive correlation between time and stock value, which helps Amazon to improve the growth of revenue. The conclusion summarizes the key trends and provides recommendations for business management, including improvements in distribution and dividends. References to relevant sources are also included.

Data Analysis and Business
Intelligence On

An Introduction to Amazon
 Jeff Bezos the founder of amazon launched his first
version on 5th of July 1994 (Murninghan, 2018). There
are more than 351000 employees all over the world,
and it is increased 1070% just 16 years that is up to
2017.
This technological company mainly focused on e-
commerce, artificial intelligence, digital streaming etc.
Now a days they offers wide variety product namely
Amazon Prime, Alexa, Amazon Drive, Kindle etc.
 After its three years of launching the estimated worth
was 438 million dollar, now it is 890 billion dollar.
Based on amazon current perch at $1,823.73, up 2.2%
today (Jacaruso, 2018).In 2018, the amazon down
26% from its closing high set and stocked is up 29%.

Graphical Representation
4/10/2018
7/19/2018
10/27/2018
2/4/2019
5/15/2019
8/23/2019
0
500
1000
1500
2000
2500
Scatter Plots on Highest stock Price
Time in Days
Stock Prices in U.S. Dollars
0
500
1000
1500
2000
2500
Scatter Plots on Lowest stock Price
Times in Days
Stock Prices in U.S. Dollars
The highest stock price shows the positive relationship with time 2018. The stock price is maximum at
last week of August 2018. It shows a moderately strong relationship.
 The value of lowest stock prices increases approximately February 2018 to April 2018. It shows a
cyclical relationship. From the lowest stock price, we understand that there is no significant outliners and
this shows the stability of the company.

Histogram on Adjusted closing stock prices of
Amazon
less than 1400 1400-1500 1500-1600 1600-1700 1700-1800 1800-1900 1900-2000 2000-2100
0
20
40
60
80
Histogram
Range of Adjusted closing Stock Prices
Number of Occurrences
The above figure represent that the adjusted closing stock prices which is equally
distributed and it is continuous in range.
 Most of the data fall within the higher ranges of adjusted closing stock price.
 The histogram is skewed to the left. So it is negatively skewed because their
median is greater the mean. It indicates the volatility of the market.

Histogram on Stock trading volume of Amazon
less than 2000000 2000000-4000000 4000000-6000000 6000000-8000000 8000000-10000000 10000000-120000000 120000000-14000000 140000000-
160000000
0
20
40
60
80
100
Histogram
Range of Stock Trading Volume
Frequency
The above figure represent the stock trading volume which is distributed unequally and it is
continuous in range.
 Most of the data points fall within the lower range, it indicates that it is strongly skewed to the
right.
 The histogram is skewed to the right. So it is positively skewed, because their mean is greater the
median.

Descriptive Statistics on
AmazonMean, Median, Mode and Standard deviation on
Adjusted Daily Closing Stock Prices
Descriptive statistics Result
Mean 1776.69
Median 1810.48
Mode 1886.52
Standard deviation 144.74
Mean, Median, Mode and Standard deviation of
Stock Volume on Amazon
Descriptive statistics Result
Mean 5343423.20
Median 4700200
Mode 3460500
Standard deviation 2326336.21
 For adjusted daily closing stock prices
mean <median< mode.
So it is skewed to the left, that is negatively
skewed.
 For stock volume on Amazon
mean >median> mode.
So it is skewed to the right, that is positively
skewed.

Conclusion
 In the above report we show graphical representation and statistical calculation
on Amazon stock during one year period. Which shows some valuable scenario
that could help in the management of Amazon to launch new product.
 From the highest and lowest stock prices shows that in the period of October to
December it is gradually fall down, and it recover from the first month of 2019.
Most of the data point fall within 1800-1900 range, which indicate the high
signal demand.
The daily traded stock volume 46.4%, which indicates the volatility is in the
unpredictable exchange rate ( Talwar & Chengalvarayan, 2015). If it is high, then
we say that the firm or the company earn unexpectedly.

The scatter plot in the figure 1.1 and 1.2 shows positive linear
correlation between time in days and stock value which help Amazon to
improve the growth of revenue in 2019 comparing to the previous year.
 There for we conclude that the trend which is coincide during the
period. Which will improve its distribution and dividends.

References
 Murninghan, M. (2018). Equity Culture and Decent Work: The Case
of Amazon (2017). New England Journal of Public Policy, 30(1), 11.
 Talwar, G., & Chengalvarayan, R. (2015). U.S. Patent No. 9,177,557.
Washington, DC: U.S. Patent and Trademark Office.
 https://www.Finance. Yahoo.com
 https://www.investopedia.com/terms/s/skewness.asp
 https://www.marketwatch.com/investing/stock/amzn