Question: Data Acquisition: Choose four companies from different sectors to diversify the analysis. Access historical stock price data for each company from sources like Yahoo Finance.
Data Acquisition: Choose four companies from different sectors to diversify the analysis. Access historical stock price data for each company from sources like Yahoo Finance. Download six months of daily stock price data. 2. Data Preparation and Analysis: Calculate the daily change in stock value by subtracting the opening price from the closing price for each trading day. Aggregate this data into one dataset with columns for the date and daily changes for each stock. 3. Statistical Analysis: Calculate the mean, standard deviation, and coefficient of variation for the daily changes of each stock. These statistics will help identify which stock has the best daily average change, which one carries the least risk, and other significant data points. 4. Visualization: Create a box plot that displays the distribution of daily changes for all four stocks side-by-side. This visual will help in quick comparison and better visual understanding of the data variance and spread. 5. Communication: Draft an email or report summarizing the findings: Identify the stock with the best average daily change. Point out which stock has the lowest coefficient of variation, indicating the least risk. Highlight other relevant findings from the box plot, such as outliers or any unusual variability.
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
