Can anyone assist with the below questions?

B. Apply appropriate data analytic techniques. You are now ready to analyze the data. Required Using Power BI, create new columns in the data table for each ratio component of the DuPont Ratio. Use any combination of columns, measures and/or visualizations to answer the questions below. Again, there are multiple ways to discover the correct answer. Answer the following questions relative to individual companies: 1. Within each of three industries, which companies have the best ROE for 2015 ? 2. Sort the data so you can see the companies listed from highest to lowest ROE using 2015 data. List two observations about differences in ROE between the different companies. 3. Companies that have negative profit margins but are increasing their asset turnover ratio are said to be increasingly efficient at losing money. Which three companies in 2015 performed the worst in that they have a negative profit margin and the highest asset turnover ratio? Answer the following questions relative to individual industries: Note: For measuring performance, use the median industry performance to control for the potentially large effects of outliers. 4. Which industries in 2021 are the highest and lowest performing for each of the following ratios? 5. Which industry has seen the greatest improvement in median ROE from 2015 to 2021 ? 6. What are the best explanations for why the ROE has improved in that industry? Construct your answers referencing the ratios comprising the DuPont ratio. Answer the following questions related to the adoption of ASC 606 The effective date of ASC 606 was December 15, 2017, for public companies. One company from each industry has been identified as an early adopter: CBOE, First Solar, Inc., and General Dynamics, all adopting in Q1 of 2017. 7. Analyze the ROE for each of the three early adopters (CBOE, First Solar, Inc., and General Dynamics) for 2015 to 2021. What is your observation about the impact on ROE year-over-year? Your answer should be in context of ASC 606 . 8. In Project 1, you constructed four questions that you thought would provide relevant insights from the data. For each question you proposed: Identify the type of the analysis needed to answer the question. (Which calculations/visualizations/data inputs will you need?) If your question cannot be answered by the data provided in the dataset, you may edit your question. Please make a note of this change to your question in your submission