Do you need this or any other assignment done for you from scratch?
We assure you a quality paper that is 100% free from plagiarism and AI.
You can choose either format of your choice ( Apa, Mla, Havard, Chicago, or any other)
NB: We do not resell your papers. Upon ordering, we do an original paper exclusively for you.
NB: All your data is kept safe from the public.
Teslas Stock Prices Review on Yahoos Finance Service
For this weeks assignment, the stock prices of Tesla are reviewed using Yahoos Finance service. Tesla is a United States-based company that works in the industry of electric car manufacturing construction and is of the companies owned by Elon Musk. Tesla is a great company, both because it entered a challenging industry of auto manufacturing and because of its CEO. Musk has other successful projects, such as SpaceX, which partners with NASA and has built and launched several successful rockets that use new technology, allowing these rockets to return to earth. From a business perspective, Tesla is a risky investment because the company is unique to the industry that has a set of established players ( Tesla, Inc, n.d.). However, based on the stock prices, which are showing a steady increase over the past year, Tesla is worth investing in since, in the long-term, the company can generate a substantial profit for the stockholders. This paper will analyze Teslas stock prices over the past year using visual methods and descriptive statistics and will provide an explanation of how the analysis was conducted.
Tesla is a relatively new company, which was established to create efficient electric cars, which would be comfortable and offer decent miles per charge ratio since the market did not have an electric vehicle that could compete with petrol or diesel before Tesla. Created in 2003 by two entrepreneurs from the United States, and in 2008 Musk became the CEO ( Tesla, Inc, n.d.). In the same year, the company presented its first sports car, the Roadster. Since then, Teslas engineering developed several fully electric vehicles that are available to consumers. Hence, this is a potentially prospective business, since Tesla offers innovative solutions and has caused a disruption in the market of vehicles.
Graphical Representation of Data
The data on Teslas daily stock prices within the last year was obtained from Yahoo Finances website ( Tesla, Inc. (TSLA), n.d.). The information about the stock prices within the last year was selected using the filters and downloaded as an Excel spreadsheet. Next, the author of this paper used Exels built-in functions to create graphs and analyze the data. Figures 1-4 depict the visual representations of Teslas stock price analysis. The scatterplot shown in Figure 1 was made by selecting the columns Date and High and clicking the Scatter button in Excel. Similarly, Figure 2 or the scatterplot of the lowest prices was created by selecting the columns Low and Date and choosing the scatterplot option. Hence, both scatterplots were created using the same function and selecting different data sets as the base for the graph. The histogram in figure 3 was created using Excels option Insert choosing insert statistics chart and selecting a histogram as a type of a chart. A similar process was used to create figure 4 was made, and in both cases, the bin size was adjusted automatically.
Descriptive Statistics
Next, the author used the same data set to apply built-in functions and determine some of the characteristics of the data set using descriptive statistics. Descriptive statistics allow summarising the data sets by describing its core characteristics ( Descriptive statistics, n.d.). The mean, median, and standard deviation for the adjusted daily stock price were created using the following formulas: AVERAGE, MEDIAN, and STDEV. For the adjusted closing price, the data range of F2 to F254 was selected, and to calculate these values for stock volume, G2 and G254 fields were chosen, as presented in Tables 1 and 2. The author typed in the name of the function that allows performing the calculations, followed by (), where the data range was cited. The standard deviation allows determining the dispersion of this data range, the median can be used to describe the middle number from the given data set, and calculations of the mean allow determining the central tendency ( Descriptive statistics, n.d.). In comparison, the first data set is far less dispersed when compared to the second, since its standard deviation is seven as opposed to 40051531.
Overall, this paper is an analysis of Teslas stock prices over the last year. This essay presents graphical representations of the stock prices using scatterplots and histograms, as well as calculations of the descriptive statistics. Graphs 1 and 2 re scatterplots of the highest and lowest stock prices for each day. Graphs 3 and 4 are histograms representing volume and adjusted closing prices. Based on the graphs, one can conclude that Teslas stock price has been steadily increasing over time. In addition, descriptive statistical methods were used to calculate the the averedges and dispersion for this data set.
References
Descriptive statistics. (n.d.). Web.
Tesla, Inc. (TSLA). (n.d.). Web.
Tesla, Inc. (n.d.). Web.
Do you need this or any other assignment done for you from scratch?
We assure you a quality paper that is 100% free from plagiarism and AI.
You can choose either format of your choice ( Apa, Mla, Havard, Chicago, or any other)
NB: We do not resell your papers. Upon ordering, we do an original paper exclusively for you.
NB: All your data is kept safe from the public.