2) Use "MS Stock" and "PNC Stock" worksheets.

a. Use Excel or R to create a scatter plot for MS Open Price and PNC Open Price

(Hint: you firstly need to copy both variables to one new worksheet, then start to

work on a scatter plot). What kind of relationship between MS Open Price and

PNC Open Price can be observed? (Hint: One diagram has two variables, "MS

Open Price" and "PNC Open Price". One for X axis, and the other one for Y axis.)

b. Use Excel or R to create a combination chart for MS Open Price and PNC Open

Price. Briefly explain your observation. (Hint: Use different styles for two

variables. For example, one is line, the other is bar.)

c. Use Excel to create sparkelines for Open, High, Low, Close, and Volume for MS

Stock worksheet. Which one shows more volatile? (Hint: Create sparkline for

each column, NOT row.)