Introduction

In this report, we analyse the stock data of Alphabet Inc, S&P500 and Dow Jones indexes. Our goal is to compare the performance of these indexes and identify any statistically significant differences. The group used an Excel spreadsheet to compare the performance of the data sets for the S&P 500, Dow Jones, and Alphabet Inc. which were selected in phase 1. The S&P 500 and the Dow Jones Industrial Average are better market benchmarks, says the new analysis. Both track the stocks of significant US firms and serve as the foundation for a number of investment products published by S&P Dow Jones Indices (The S&P 500 and The Dow | S&P Dow Jones Indices, n.d.). Both offer a broad perspective of the current state of stock market activity. As a result, the project's primary metric was based on these indicators.

We then calculated the highest returns and volatilities and performed hypothesis tests to identify any significant differences.

As stated in the hypothesis framework, the functions T and F-test were used to compute and compare the means and coefficient of variance between the three data sets for various time periods. Finally, we present our conclusions and discuss how the mainmarket events affected the behaviour of the studied indexes.

Figure 1: Time Series Graph of SP500