Question: Create a line chart below that shows the four data series of SPY Close, GM Close, TSLA Close, and BTC Close. Give the chart a

Create a line chart below that shows the four data series of SPY Close, GM Close, TSLA Close, and BTC Close. Give the chart a title and a legend at the bottom of the chart to label the series. Make sure the x axis provides a clear labeling of the date range.
Below the chart, insert a text box explaining why this is not a very good chart.
In this step, you are going to adjust the data. Back in the Working data, add a 6th column labeled "SPY Close 100." In cell F2, enter a formula to convert the SPY Close on the first date to the value of 100. Your calculation will look like "=(B2B$2)**100." This will convert the value on the first date to 100. You then want to normalize the rest of the values by B2 as well. For instance, the second date will be "=(B3/B$2)*100." To apply this iterative process for all cells in thfy column, put your mouse on the lower right corner of the cel and when your mouse turn into a black cross, double click.
Repeat this process in the next three columns to create "GM Close 100", "TSLA Close 100" and "BTC Close 100."
Create a second line chart to the right of your first chart that shows the four data series of SPY Close 100, GM Close 100, TSLA Close 100, and BTC Close 100. Give the chart a title and a legend at the bottom of the chart to label the series. Make sure the x axis provides a clear labeling of the date range.
Below the chart, insert a text box explaining answering the following questions:
Why this is a better chart?
Which investments (GM, TSLA, or BTC) outperformed SPY over this period?
-Why is that interesting?
 Create a line chart below that shows the four data series

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!