Feature Name Feature Description Record ID - A unique identifier to each row in a dataset. horizon - Stock holding days Amount - Number of Stocks purchased Concatenated Segment - Combination of Company Name, Sector and Number of Stocks purchased Date1 - Stock Buying date Date2 - Stock Selling date BUY - Buying Price SELL - Selling Price expected_return - Yearly expected Return over Investment inf - Inflation during the holding period
Based on the Data, answer the following questions.
(Any assumptions should be mentioned and stated properly with reasons) a) Find the number of record ID’s where the stocks were sold in less than 2 months from the stock buying date combined in the years 2016 – 2017. b) Find the company who works in BANK & RETAIL sector and has made the highest profit in the years 2015 – 2017. c) In the last 10 days of October 2017, average profit of AAPL is more than AMZN. Is this statement TRUE? d) Are there any companies with zero or no profit in the year 2016? If yes, what are the top 2 sectors contributing to major loss? Also, where are these companies headquartered? e) Is Nominal Return Rate following Normal Distribution or Standard Distribution? How is it varying from the Expected Return? (Nominal Rate is computed by dividing the Original Investment Value by the difference of Present Market Value and Original Investment Value) f) Find the 25th, 50th and 75th percentile of profit and loss for all companies in 2017. Categorize your results according to individual sectors. g) Z Score of a feature is defined as = ( – )/ where Xi is the observation/record, μ is the mean of the feature and σ is the standard deviation of the feature. Plot the Z score of profits and losses for all companies from “Tech” sector. Do you find any similarity among companies in their Z Scores? h) Prepare a dashboard using the shared data (PowerBI/Tableau). Note: * Share the workflows/dashboards/calculations used for the above answers, along with the documentation. * Years/Months to be calculated based on the Selling Date.