Question: Step 1: Open the Module Six Activity Template found in the What to Submit section. Step 2: Answer the following questions in the Answer Sheet
Step 1: Open the Module Six Activity Template found in the What to Submit section. Step 2: Answer the following questions in the Answer Sheet worksheet: Question 1: How many points of data is the analyst using on the chart? Does it make sense to use a column chart for this analysis? If not, what would be a better choice? Question 2: Look at the profit values for the two companies. Does it make sense to compare these values? If not, why, and what alternative could you pursue instead? Question 3: The intern mentioned that the profit numbers are in terms of thousands. Would this be apparent by looking at the chart? If not, why? Question 4: Looking at the x axis of the column chart, you will see that the quarters keep repeating one through four for each year in column A. Can anything be done to show the year that each set of four quarters represents? Step 3: Move the chart created by the intern to a separate worksheet and label the worksheet's tab Intern's Chart. Step 4: Modify the Profit Analysis worksheet to create a chart that presents an appropriate comparison between Big Company and Goode
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
