3. x5x Difficuity: Level 3 The purpose of this exercise is to analyze a worksheet to identify and correct any integrity flaws. Read the scenario below, then open the Excel workbook related to this exercise. Use the AnswerSheot worksheet for any written responses required for this exercise. SCENARIO You are working as the director of investment research for a small wealth management firm. Your firm holps people make investment decisions and establish plans for key lle events such as saving for college, retirement, and so on. An intern who is working for the firm is evaluating the profit trends for two companies: Big Company and Goode Company. He sends you an Excel workbook and explains the following with respoct to his analysis: - I put a chart together to compare the earnings for the two companies. There is really nothing to look at. Big Company's profits are so much larger than those of Goode Company. Based on this chart, I don't see how we would advise our clients to invest in Goode Company. We should probably stick with Big Company. - Just so you know, the profit numbers on the chart are in thousands. Otherwise, it is a pretty straightferward column chart. I put the profits that each company earned for each quarter on the Y axis and the quarters are shown on the X axts. ASSIGNMENT 1. How many points of data is the analyat using on the chart? Does it make sense to use a column chart for this analysis? If not, what would be a better choice? Place your answer in the Answersheet worksheet. 2. Look at the proft values for the two companies. Does it make sense to compare these values? if not, why and what alternative could you pursue? Place your answer in the Answersheet worksheet. 3. The analyst mentioned that the profit numbers ave in torme of thousands. Would this be apparent by looking at the chart? It not, why? Place your answor in the Anawersheet worksheet. 4. Looking at the X axis of the column chart you wil see that the quarters keep repeating 1 through 4 for each year in column A. Can anything be done to show the year that each set of 4 quarters represents? Place your answer in the ArswurSheet worksheet. 5. Move the chart created by the analyst to a separate chart shoet and label the sheet tab Analyst's Chart. Make any necessary modifications to the Profit Analysis worksheet to create a chart that presents an appropriate comparison betwoen Big Compary and Goode Corripary. Create a now chart comparing the profits of Big Compary and Coode Company. Pay caretu attention to formatting details, 6. De you agre with the Anaysty conclusion that the fim should advise clients to invest in Big Company over Goode Company? Piacs your anawer in the ArawerShoet workaheet. 3. x5x Difficuity: Level 3 The purpose of this exercise is to analyze a worksheet to identify and correct any integrity flaws. Read the scenario below, then open the Excel workbook related to this exercise. Use the AnswerSheot worksheet for any written responses required for this exercise. SCENARIO You are working as the director of investment research for a small wealth management firm. Your firm holps people make investment decisions and establish plans for key lle events such as saving for college, retirement, and so on. An intern who is working for the firm is evaluating the profit trends for two companies: Big Company and Goode Company. He sends you an Excel workbook and explains the following with respoct to his analysis: - I put a chart together to compare the earnings for the two companies. There is really nothing to look at. Big Company's profits are so much larger than those of Goode Company. Based on this chart, I don't see how we would advise our clients to invest in Goode Company. We should probably stick with Big Company. - Just so you know, the profit numbers on the chart are in thousands. Otherwise, it is a pretty straightferward column chart. I put the profits that each company earned for each quarter on the Y axis and the quarters are shown on the X axts. ASSIGNMENT 1. How many points of data is the analyat using on the chart? Does it make sense to use a column chart for this analysis? If not, what would be a better choice? Place your answer in the Answersheet worksheet. 2. Look at the proft values for the two companies. Does it make sense to compare these values? if not, why and what alternative could you pursue? Place your answer in the Answersheet worksheet. 3. The analyst mentioned that the profit numbers ave in torme of thousands. Would this be apparent by looking at the chart? It not, why? Place your answor in the Anawersheet worksheet. 4. Looking at the X axis of the column chart you wil see that the quarters keep repeating 1 through 4 for each year in column A. Can anything be done to show the year that each set of 4 quarters represents? Place your answer in the ArswurSheet worksheet. 5. Move the chart created by the analyst to a separate chart shoet and label the sheet tab Analyst's Chart. Make any necessary modifications to the Profit Analysis worksheet to create a chart that presents an appropriate comparison betwoen Big Compary and Goode Corripary. Create a now chart comparing the profits of Big Compary and Coode Company. Pay caretu attention to formatting details, 6. De you agre with the Anaysty conclusion that the fim should advise clients to invest in Big Company over Goode Company? Piacs your anawer in the ArawerShoet workaheet
