Write 3 pages [without cover and reference] with that 5 pagesPlease find the attachmentsAssessment 3 Instructions: Applying Analytic Techniques to Business PRINT In the last assessment, you were ask
USING ANALYTIC TECHNIQUES TO ADD MEANING TO DATA 9
Using Analytic Techniques to add Meaning to Data
Student’s Name:
Institution:
Using Analytic Techniques to add Meaning to Data
Introduction
Data analysis is an important tool in business because it models the progress of business activities. It reduces data into meaningful information that can be used to forecast the future of the organization. Data analysis plays a vital role in business but the main ones include projections, boosting customer acquisition, and risk management. The purpose of this paper is to apply data analytics on Tesla Inc., financial data obtained from the Yahoo Finance database.
Tesla Inc. was formally known as Tesla Motors, Inc. is an American e-vehicle and other alternative energy sources. The company is based in Palo Alto, California and its specialty area is the manufacturing of electric vehicles and reachable battery energy. The company was established through acquisition technic by acquiring Solar panels, solar roof tile, and SolarCity manufacturing. It was established in July 2003 by Marc Tarpernning and Martin Eberhard as Tesla Motors. It was named in commemoration of electrical and inventor engineer Nokia Tesla. The first three employees Eon Musk, J. B Straubel, and Ian Wright all who were later named as co-founders of the organization. Musk, who was the former chairman is the current Chief Executive Officer. He envisioned Tesla Motors as a Technological organization and a stand-alone automobile company, whose aim is to produce electric cars at affordable prices to the average consumers. The company shortened its name to Tesla, Inc. in February 2017 (Catarino, 2019).
The quarterly revenue for Tesla Inc. as of 31st March 2020 is US$5,985 Million, which is estimated to be slightly above US$24.58 Billion annually (Catarino, 2019). The total assets as of 2019 were recorded at US$34.309 Billion and the total equity as of 2019 was determined to be US$6.618 Billion. The Largest Shareholder of the company is Elon Musk, who holds 20.8% of the revenue (Catarino, 2019). Moreover, the company employed 48,016 workers as of 2019 with 80% of these are permanent employees. Furthermore, the company has managed to produce several models of electric cars including Model S, Model S, Model 3, and Model Y. Below is the analysis of Tesla's stock and sals between 7/18/2019 and 7/17/2020.
Graphical Representations of Data
Figure 1.
Highest Stock Price between 7/18/2019 and 7/17/2020
To create this graph, copied the data in the columns “Date” and “High” and put them in a new tab “Highest Stock Price and Time” in the same excel worksheet. I then selected the data and clicked on the “Insert” tab on the tabs bar. I chose “Insert Scatter (X, Y)” in the “Charts” group. Finally, chose “Scatter with Smooth Lines” to generate the graph. I then clicked on the “+” in the chart area to insert “Axis Title” (Sarikaya & Gleicher, 2017).
Figure 2.
Lowest Stock Price between 7/18/2019 and 7/17/2020
To create this graph, copied the data in the columns “Date” and “Low” and put them in a new tab “Lowest Stock Price and Time” in the same excel worksheet. I then selected the data and clicked on the “Insert” tab on the tabs bar. I chose “Insert Scatter (X, Y)” in the “Charts” group. Finally, chose “Scatter with Smooth Lines” to generate the graph. I then clicked on the “+” in the chart area to insert “Axis Title” (Sarikaya & Gleicher, 2017).
Figure 3.
Adjusted Daily Closing Stock Price 7/18/2019 and 7/17/2020
To create this graph, I copy the data in the column “Adj Close” and put them in a new tab “Adjusted Daily Stock Price” in the same worksheet. I then establish bin limit and bin count for every range. I then selected the data and clicked on the “Insert” tab on the tabs bar. Finally, chose “Clustered Columns” in the “Charts” group to generate the graph. I then clicked on the “+” in the chart area to insert “Axis Title” (Anderson, Sweeney, Williams, Camm, & Cochran, 2020).
Figure 4.
Stock Trading Volume between 7/18/2019 and 7/17/2020
To create this graph, I copy the data in the column “Volume” and put them in a new tab “Stock Trading Volume” in the same worksheet. I then establish bin limit and bin count for every range. I then selected the data and clicked on the “Insert” tab on the tabs bar. Finally, chose “Clustered Columns” in the “Charts” group to generate the graph. I then clicked on the “+” in the chart area to insert “Axis Title” (Anderson et al., 2020).
Descriptive Statistics
Table 1.
Descriptive Statistics for the Adjusted Daily Closing Stock Price between 7/18/2019 and 7/17/2020
Column1 | |
Mean | 551.8642305 |
Standard Error | 19.81150916 |
Median | 469.059998 |
Mode | #N/A |
Standard Deviation | 315.1213441 |
Sample Variance | 99301.46153 |
Kurtosis | 0.709074562 |
Skewness | 1.021364902 |
Range | 1334.610016 |
Minimum | 211.399994 |
Maximum | 1546.01001 |
Sum | 139621.6503 |
Count | 253 |
Confidence Level (95.0%) | 39.01722924 |
I clicked “Data” in the tabs bar and select “Data Analysis” in the “Analysis Group”. In the Data Analysis wizard, I chose “Descriptive Statistics.” I activated the input range control and selected the data in the “Adj Close” column. I then select a 95% confidence level for mean and click "Ok". The above table with summary statistics was generated.
Table 2.
Descriptive Statistics for the Stock Volume between 7/18/2019 and 7/17/2020
Column1 | |
Mean | 13413402.37 |
Standard Error | 526530.6515 |
Median | 11698100 |
Mode | #N/A |
Standard Deviation | 8374982.707 |
Sample Variance | 7.01403E+13 |
Kurtosis | 5.50164049 |
Skewness | 1.820742724 |
Range | 58473200 |
Minimum | 2465600 |
Maximum | 60938800 |
Sum | 3393590800 |
Count | 253 |
Confidence Level (95.0%) | 1036961.241 |
I clicked "Data" in the tabs bar and select "Data Analysis" in the "Analysis Group". In the Data Analysis wizard, I chose "Descriptive Statistics." I activated the input range control and selected the data in the "Stock Volume" column. I then select a 95% confidence level for mean and click "Ok". The above table with summary statistics was generated (Agabekova, 2019).
Conclusion
Data analysis play important role in business but the main ones include projections, boosting customer acquisition, and risk management. Tesla Inc. was formally known as Tesla Motors, Inc. is an American e-vehicle and other alternative energy source and it was established in July 2003 by Marc Tarpernning and Martin Eberhard as Tesla Motors. From the analysis above, Tesla Inc. is doing well in the automotive industry.
References
Agabekova, N. V. (2019). Business Statistics using Excel: electronic educational-methodical complex for undergraduates in the specialties 1-25 80 10 “Statistics and analysis”.
Anderson, D. R., Sweeney, D. J., Williams, T. A., Camm, J. D., & Cochran, J. J. (2020). Essentials of modern business statistics with Microsoft Excel. Cengage Learning.
Catarino, J. I. M. (2019). Tesla Inc.: an equity valuation (Doctoral dissertation). Retrieved from https://repositorio.ucp.pt/handle/10400.14/29047
Sarikaya, A., & Gleicher, M. (2017). Scatterplots: Tasks, data, and designs. IEEE transactions on visualization and computer graphics, 24(1), 402-412.