Question

3. Weekly closing prices of Hewlett-Packard stock from October 1995 to February 1996 are listed below, given in sequential order and rounded to the nearest dollar: 93, 94, 95, 89, 85, 82, 87, 85, 84, 80, 78, 78, 84, 87, 90. (a) Using time as the horizontal axis and closing price as the vertical axis, construct a trend graph showing how the price moved during this period. (b) Calculate the mean and median closing price.

Answer 1

(a) The procedure to create trend graph in Excel is as written below: 1. Enter the data in Excel as shown below: A B 1 Time Closing Price 16 2. Select the data->Click on Insert->Select first line chart->Click on plus sing on the right upper side of the graph and click on Axis Titles to add the titles "Closing Price” and "Time(Weeks)", also change the chart title.

3. The output will be: Trend Graph Closing Price 1 2 3 4 5 6 10 11 12 13 14 15 7 8 9 Time(Weeks)

(b) The mean and median are calculated as: А 1 Time Closing Price 93 2 = OVU WN 87 10 9 11 10 12 11 13 12 14 13 15 14 16 15 17 Mean 18 Median The output is: 17 Mean 18 Median 90 =AVERAGE(B2:B16) =MEDIAN(B2:B16) 86.1 85 Hence the mean and median are 86.1 and 85 respectively.