Data Analytics and Business Intelligence Report: Amazon Stock Analysis

This report provides a comprehensive analysis of Amazon's stock data, utilizing graphical representations and descriptive statistics to derive meaningful insights. The report begins with an introduction that provides the background of the company and its business context. It then proceeds to present graphical representations, including scatter plots illustrating trends in highest and lowest stock prices, as well as histograms depicting the distribution of adjusted closing stock prices and stock trading volume. The analysis further delves into descriptive statistics, calculating and interpreting the mean, median, mode, and standard deviation for both adjusted daily closing stock prices and stock volume. The findings reveal the volatility of stock prices and the overall stability of the company's financial performance. The report concludes with a list of references used in the analysis.

Running head: Data Analytics And Business Intelligence on Amazon
Data Analytics And Business Intelligence On Amazon
Name of the Student:
Name of the University:
Author Note:

1Running head: Data Analytics And Business Intelligence on Amazon
Table of Contents
Chapter 1: Introduction..............................................................................................................3
1.1 Background of the company........................................................................................3
1.2 Practical Business context Amazon.................................................................................3
Chapter 2: Graphical Representation.........................................................................................4
Chapter 3: Descriptive Statistics................................................................................................8
3.1 Mean, Median, Mode and Standard deviation on Adjusted Daily Closing Stock Prices.8
3.2 Mean, Median, Mode and Standard deviation of Stock Volume on Amazon.................9
Chapter 4: References..............................................................................................................10

2Running head: Data Analytics And Business Intelligence on Amazon
Chapter 1: Introduction
1.1 Background of the company
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( Chaudhary & Kumar, 2016). So it is a
biggest company in the world wide. People beliefs that the first version of this company was
called cadabra.com. Bezos started his company with a list of 20 products, mainly CDs,
computer hardware and software, and books etc. (Lincoln & Andrew, 2018).
1.2 Practical Business context Amazon
Amazon is one of the most popular online multinational company. This technological
company mainly focused on e-commerce, artificial intelligence, digital streaming etc.
Amazon employees have multilevel e-commerce strategy Kantor &Streitfeld, 2015). In
December 2016 the first Amazon store was open (Cooke, Blackwell & Brown, 2016). Now a
days they offers wide variety product namely Amazon Prime, Alexa, Amazon Drive, Kindle
etc.
In day to day life stock prices in U.S. dollar is increases. In my data taking period is
the growing period for Amazon, up to 12th July 2019 its highest and lowest stock prices is
2,016.85 and 2,033.86 U.S. dollars (Investopedia.com).

3Running head: Data Analytics And Business Intelligence on Amazon
Chapter 2: Graphical Representation
0
500
1000
1500
2000
2500
Scatter Plots on Highest stock Price
Time in Days
Stock Prices in U.S. Dollars
Figure 1.1 Scatter Plot on Highest stock prices of Amazon (Yahoo Finance)
The above figure is drawn by secondary data collected from Yahoo finance. This
figure 1.1 shows the trend line of the highest stock prices of Amazon from July 2018 to July
2019. In this figure we show the relationship between two variable, in x- axis we take times
in days, it is independent and in Y-axis stock Prices in U.S. dollars, it is dependent variable.
The scatter plot shows that it is linear. The highest stock price shows the negative relationship
with time 2018.

4Running head: Data Analytics And Business Intelligence on Amazon
0
500
1000
1500
2000
2500
Scatter Plots on Lowest stock Price
Times in Days
Stock Prices in U.S. Dollars
Figure 1.2 Scatter Plot on Lowest stock prices of Amazon
The above figure is drawn by secondary data collected from Yahoo finance. This
figure 1.2 shows the trend line of the highest stock prices of Amazon from July 2018 to July
2019. In this figure we show the relationship between two variable, in x- axis we take the
times in days, it is independent and in Y-axis stock Prices in U.S. dollars, it is dependent
variable. The value of lowest stock prices increases approximately February 2018 to April
2018. It shows a cyclical relationship.

5Running head: Data Analytics And Business Intelligence on Amazon
less than
1400 1400-
1500 1500-
1600 1600-
1700 1700-
1800 1800-
1900 1900-
2000 2000-
2100
0
10
20
30
40
50
60
70
80
Histogram
Range of Adjusted closing Stock Prices
Number of Occurences
Figure 2.1 Histogram on Adjusted closing stock prices of Amazon
The above figure is drawn by secondary data collected from Yahoo finance. The
figure 2.1 represent the adjusted closing stock prices which is equally distributed and its
continuous data range. In the figure 2.1 we show the relationship between two variable, in x-
axis we show the range of the data sheet, and in Y-axis number of occurrences. The
histogram is skewed to the left and it is positively skewed because their median is greater the
mean.

6Running head: Data Analytics And Business Intelligence on 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
Figure 2.2 Histogram on Stock trading volume of Amazon
The above figure is drawn by secondary data collected from Yahoo finance. The
figure 2.2 represent the stock trading volume which is equally distributed and its continuous
data range. In the figure 2.2 we show the relationship between two variable, in x- axis we
show the range of the data sheet, and in Y-axis frequency that is the number of occurrences.
The histogram is skewed to the right and it is negatively skewed because their mean is greater
the median.

7Running head: Data Analytics And Business Intelligence on Amazon
Chapter 3: Descriptive Statistics
3.1 Mean, Median, Mode and Standard deviation on Adjusted Daily Closing Stock
Prices
The mean, median, mode and standard deviation of the adjusted daily closing stock
prices are given bellow in the table.
Result
Mean 1776.69
Median 1810.48
Mode 1886.52
Standard deviation 144.74
From the above calculation of descriptive statistics is calculated using Ms-Excel. The mean
or average value of the adjusted daily closing stock prices is 1776.69 U.S. dollars, it indicate
the healthy stock price. That means the company is stable and it is growing throughout the
year.
The median that is the middle part of the value of adjusted daily closing stock price of
Amazon is 1810.48 U.S. dollars. While median is greater than mean it indicate the lower side
of the stock prices.
The most frequently occurring data in the data sheet is mode. Here the Mode of the
adjusted daily closing stock price is 1886.52 U.S. dollars. Since mean is less than mode that
means it is negatively skewed.
The standard deviation of adjusted daily closing stock price is 144.74 U.S. dollars. It
represent the volatility of the stock price. That means volatility is 144.7%.

8Running head: Data Analytics And Business Intelligence on Amazon
3.2 Mean, Median, Mode and Standard deviation of Stock Volume on Amazon
The mean, median, mode and standard deviation of the stock volume on Amazon are
given bellow in the table.
Result
Mean 5343423.20
Median 4700200
Mode 3460500
Standard deviation 2326336.21
From the above calculation of descriptive statistics is calculated using Ms-Excel. The mean
or average value of the adjusted daily closing stock prices is 5343423.20 U.S. dollars, it
indicate the healthy or good stock price. That means the company is stable and it is growing
throughout the year.
The median that is the middle part of the value of adjusted daily closing stock price of
Amazon is 4700200 U.S. dollars. While mean is greater than median it indicate the higher
side of the stock prices.(Mondal &Mondal, 2016).
The most frequently occurring data in the data sheet is mode. Here the Mode of the
adjusted daily closing stock price is 3460500 U.S. dollars. Since mode is less than mean that
means it is positively skewed.
The standard deviation of adjusted daily closing stock price is 2326336.21 U.S.
dollars. It represent the volatility of the stock price. That means volatility is 2326336.2%.

9Running head: Data Analytics And Business Intelligence on Amazon
Chapter 4: References
Chaudhary, K., & Kumar, S. (2016). Customer Satisfaction Towards Flipkart and Amazon: A
Comparative Study. International Journal of Academic Research & Development
JAR&D, 35.
Cooke, D. G., Blackwell, L. F., & Brown, S. (2016). A graphical trap for unwary users of
Excel 2010. International Journal of Open Information Technologies, 4(2).
https://www.Finance. Yahoo.com
https://www.investopedia.com/terms/s/skewness.asp
https://www.marketwatch.com/investing/stock/amzn
Kantor, J., & Streitfeld, D. (2015). Inside Amazon: Wrestling big ideas in a bruising
workplace. New York Times, 15, 74-80.
Lincoln, I. V., & Andrew, C. E. (2018). Porter Analysis: A Business Strategy of Amazon.
Com Through a Value Chain and Comparative Advantage Analysis of Amazon’s
Trademarks and Intangibles. Com Through a Value Chain and Comparative
Advantage Analysis of Amazon’s Trademarks and Intangibles (November 27, 2018).
Practical Guide to US Transfer Pricing.
Mondal, H., & Mondal, S. (2016). Sample size calculation to data analysis of a correlation
study in Microsoft Excel®: A hands-on guide with example. International Journal of
Clinical and Experimental Physiology, 3(4), 180-189
Murninghan, M. (2018). Equity Culture and Decent Work: The Case of Amazon (2017). New
England Journal of Public Policy, 30(1), 11.
Woo, S. E., Keith, M., & Thornton, M. A. (2015). Amazon Mechanical Turk for industrial
and organizational psychology: Advantages, challenges, and practical
recommendations. Industrial and Organizational Psychology, 8(2), 171-179.