Chapter 3, Problem 1PE

Create a line chart for the closing prices for all years, and a stock chart for the high/low/close prices for August 2013 in the Excel file S&P 500.

To determine

To create a line chart and stock chart.

Explanation of Solution

Given:

The data shows values of open/high/low/close of stocks for years between 2007 to 2013.

  

Closing price from 2007 to 2008 is decreasing, but it increases from 2009.

  

There is very good opening in the initial of August’13 but there is decreasing trend of Open/high/low/close value. There is lowest opening as well as closing value on the end of the month.