51, the maximum bound was set to 55 for both charts. This process was repeated on the low side for both charts. Finally, the charts were titled, and the axis were labeled by clicking those designated sections on the chart and renaming them. Figure 3: Histogram of Daily Stock Closing PriceFigure 4: Histogram of Stock Trading Volume DailyThe histogram graphs above were created by selecting the “Adj Close” category for the first graph and the “Volume” column. Once the respective column was highlighted, the histogram button was pressed in the chart section, under the insert category. The bin numbers, or blue columns on the chart, were both set to 7 to better compare the two values in axis settings.
Using Analytic Techniques to Add Meaning to Data5Titles were added at the top of the chart and both horizontal and vertical axis were placed on the chart. Finally, figure captions were added to the document.Descriptive StatisticsClosing PriceVolumeMean46.163305576053Median45.996925252700Mode42.876886728400Standard Deviation2.5468241567592Figure 5: Table of Descriptive StatisticsTo calculate the values summarized in the table above, it was important to note whatcolumn the closing price and volume were and how many data point were in each column. In thisspreadsheet, closing price was in column “F” and ran from data points in row 2 to 252. Once theabove table was set up, the cell under closing price and next to mean was selected. In that cell,“=AVERAGE(F2:F252)” was entered to tell excel to calculate the average value of all of theclosing price data points. To do this manually, all the numbers would be added up and then