Overview
The S&P 500 dataset provides a comprehensive view of the largest 500 publicly traded companies in the U.S., serving as a benchmark for market performance and long-term investment analysis. This dataset captures daily stock movements, company details, and index trends, offering insights into sector and individual stock performance.
Project Goal
Our primary objective is to analyze the performance of various sectors in the S&P 500, using the stock prices and revenue growth as key metrics.
Dataset Description
The dataset comprises three primary components:
- Index Data: Daily price of the S&P 500 index, representing overall market performance.
- Stock Data: Daily stock prices for individual companies.
- Company Data: Detailed metrics for each company, including sector, market cap, and financial indicators.
Insights from the Data
Sector Distribution: Technology: 16% Industrials: 14% Financial Services: 13% Healthcare: 12% Consumer Cyclical: 10%
Current Price Statistics:
- Mean: $230.29
- Median: $126.82
- Standard Deviation: $521.99
- Min: $8.56 | Max: $8,946.33
- Interquartile Range: $71.54 (Q1) - $239.19 (Q3)
- Observations Stock prices exhibit high variability, with a positively skewed distribution due to the presence of high-value stocks. The interquartile range provides a more reliable snapshot of typical prices, excluding outliers.
Visual Insights with Tablaeu
To complement the analysis, a comprehensive Tableau dashboard was developed to visualize key trends and insights within the dataset. The dashboard highlights annual returns by sector, revenue growth trends, sector distribution, and stock performance by market capitalization. Key elements include:
- Annual Returns by Sector: A table showcasing sector performance across multiple years, offering a clear view of growth trends.
- Revenue Growth: A bubble chart visualizing revenue growth rates by sector, emphasizing leaders like Financial Services and Technology.
- Sector Distribution: A treemap displaying the composition of the S&P 500 by sector, highlighting dominant sectors such as Technology and Industrials.
- Stock Market Capitalization: A bar chart ranking top companies by market cap, showcasing industry giants like Apple (AAPL) and Nvidia (NVDA).
This visualization provides an intuitive and interactive way to explore the dataset, making complex data accessible and actionable. Go to Talbaeu dashboard Link
Next Steps
- Perform detailed EDA to identify key trends and sector performance.
- Investigate the relationship between sector representation and stock performance.
Data Source
The dataset and additional documentation are available on Kaggle.