So firstly forgive me for the probable poor explanation.
I am trying to figure out the best way to graph or display a range of data and have myself in quiet a twist. And would love to use some collective minds to help me get to the desired results.
I have a range of Data over 5000 records
First column is Date and time, Its the time stamp of polled every 10 minutes.
On each of these lines I have a numerical value in the range from -3.5 to 19.2
Here is an extract
Aug 24th 05:56:00 9,56
Aug 24th 06:11:00 9,58
Aug 24th 06:41:00 10,15
Aug 24th 06:56:00 8,78
Aug 24th 07:11:00 9,71
Aug 24th 07:26:00 9,55
Aug 24th 07:41:00 9,51
Aug 24th 07:56:00 10,40
Aug 24th 08:11:00 10,51
I can put this onto a line graph and see the trend easily.
What I am trying to find out is between what Numerical values over the given time period of the 5000 records that we see the values change the most with the margin of 3 units.
To give an example, I want to find out that these records jumped between 10 and 13 more then they did between 1 and 4.
I need to either represent this in a graph or table format.
I am trying to figure out the best way to graph or display a range of data and have myself in quiet a twist. And would love to use some collective minds to help me get to the desired results.
I have a range of Data over 5000 records
First column is Date and time, Its the time stamp of polled every 10 minutes.
On each of these lines I have a numerical value in the range from -3.5 to 19.2
Here is an extract
Aug 24th 05:56:00 9,56
Aug 24th 06:11:00 9,58
Aug 24th 06:41:00 10,15
Aug 24th 06:56:00 8,78
Aug 24th 07:11:00 9,71
Aug 24th 07:26:00 9,55
Aug 24th 07:41:00 9,51
Aug 24th 07:56:00 10,40
Aug 24th 08:11:00 10,51
I can put this onto a line graph and see the trend easily.
What I am trying to find out is between what Numerical values over the given time period of the 5000 records that we see the values change the most with the margin of 3 units.
To give an example, I want to find out that these records jumped between 10 and 13 more then they did between 1 and 4.
I need to either represent this in a graph or table format.