Analyze NYSE DataAnalyze NYSE Data Introduction In this project, I analyzed real-life data from the New York Stock Exchange. I drew a subset of a large dataset provided by Kaggle that contains historical financial data from S&P 500 companies. Why this Project? In this project, I went through the process of calculating summary statistics, drawing an inference from the statistics, calculating business metrics and using models to forecast future growth prospects for the companies. The goal is to perform an analysis and also create visual tools to communicate the results in informative ways. I have provided a clean data set for this project. Although in real-life scenarios, data sets often need to be cleaned and processed before analysis can proceed. This project allows me to see what a clean data set should look like. What skills did I use? The main goal of this project is to demonstrate my ability to: • Interpret the measures of central tendency and spread (mean, median, standard deviation, range). • Use a combination of Excel functions (e.g., IF statements, INDEX and MATCH, calculating descriptive statistics with the IF statement, dropdowns, data validation, VLOOKUP). • Analyze and forecast financial business metrics using Excel. • Create visualizations of a business metric and use Excel to create a financial forecast model. Submission What I included in my submission: 1- A presentation file that includes a slide with: • A statement of the question I posed. • Summary statistics and plots to communicate my final results. 2- Excel Workbook with tabs for each of the following: • Dataset • Summary statistics • Profit and Loss statement dashboard • Forecast model for three scenarios • My workbook could include additional tabs I might need for my project (e.g., pivot tables).
Stars
1
Forks
0
Watchers
1
Open Issues
0
Overall repository health assessment
No language data available
No package.json found
This might not be a Node.js project
1
commits