On May 6, 2010, the stock market showed mind-boggling turbulence for a few minutes, and investigators hypothesize that it was due to a flood of computer-generated trades. This e-project shows how to create charts using Excel, drawing on downloaded stock data from that period so you can see what happened.

Download the Ch01_AAPL Excel file, which contains the high, low, and closing prices for Apple Computers between May 3 and May 14. (AAPL is the ticker symbol for Apple.) Open the file to see how the data is arranged in columns, with the first row showing the column headers.

a. What was the closing price for Apple on May 6?

b. What was the volume of trading for this stock on May 6?