Statistic analysis of our data
The final stage of our journey. Lets interpret our findings. The Data Analysis ToolPak has a histogram function. This will display frequency and cumulative percent in both tabular form and graphic chart. Perfect for our needs.
The data we are interested in is what time the high/low formed by. Column L. Use the filter button and filter out times except hour 23:00 again as this is the rows that contain our data. Select column L by the rick click and select copy from the dropdown menu
Open a new worksheet and in cell A1 paste our data. Next select cell B2 and type in Bin. This will represent each value excel will work with. Then from cell B3 to B26 type the values 1….24. Your worksheet should look like this
Now left click on the Data Analysis pane in the data tab. A dropdown menu will appear. Highlight Histogram and click OK
The histogram data window will now appear. We need to input the variables. Input range. Select the input pane, a sub window will pop up. Scroll to cell A2, left click , hold and scroll down to the last row of data and release. The sub window will copy the range. Deselect the sub window.
Select the bin range. Again a sub window will open. Select cells C3 to C26. Deselect the sub window.
In the output options select Output Range and click on the select button. Click on cell G2. This is where our results will be displayed. Finally select Cumulative Percentage and Chart Output for our visual display. Click OK when complete
The end result should look like this