Displaying change via 'slope'?

  • Context: High School 
  • Thread starter Thread starter hexa
  • Start date Start date
  • Tags Tags
    Change Slope
Click For Summary
SUMMARY

The discussion focuses on analyzing running performance data using slope calculations to determine improvement in speed, distance, and duration. The user has a dataset in Excel and is calculating the slope with time as the x-axis and performance metrics as the y-axis. It is confirmed that calculating the average slope between data points provides a reasonable estimate of performance trends, although the accuracy may be limited due to the small dataset size. The conversation emphasizes the importance of understanding the context of the data for more precise conclusions.

PREREQUISITES
  • Basic knowledge of Excel for data manipulation
  • Understanding of slope calculations in statistics
  • Familiarity with performance metrics in running
  • Concept of data trends and averages
NEXT STEPS
  • Research "Excel functions for statistical analysis" to enhance data evaluation skills
  • Learn about "linear regression analysis" for more robust trend analysis
  • Explore "data visualization techniques" to better present performance metrics
  • Investigate "running performance tracking apps" for automated data collection and analysis
USEFUL FOR

Athletes, fitness enthusiasts, data analysts, and anyone interested in tracking and improving running performance through data analysis.

hexa
Messages
32
Reaction score
0
I started running a few weeks back and I want to know if I'm improving speed-, distance- and duration-wise.

I have a set of data like these (this is bogus data), currently in Excel:
  1. 15
  2. 13
  3. 16
  4. 17
  5. 15
  6. 15
  7. 14
  8. 17
  9. 17

and I want to know if these numbers get larger with time. How would I do that. I calculated the slope with ongoing number on the x-axis and the changing value on the y-axis. If this is a correct way, what does that number actually tell me regarding the grade of improvement? Is there a much better way to do so?
 
Last edited:
Physics news on Phys.org
Without knowing what generated these numbers it's impossible to know for sure whether or not they are getting larger, but you can still make a decent guess using slopes.

The way I would do it would be to calculate the slope between each point and take the average, you should get a good idea as to how the number set is behaving. Given how close your actual values are, though, and how few of them you have, it may not be terribly accureate, however.
 

Similar threads

  • · Replies 5 ·
Replies
5
Views
4K
  • · Replies 2 ·
Replies
2
Views
2K
  • · Replies 19 ·
Replies
19
Views
4K
Replies
7
Views
2K
  • · Replies 3 ·
Replies
3
Views
4K
  • · Replies 4 ·
Replies
4
Views
5K
  • · Replies 7 ·
Replies
7
Views
3K
  • · Replies 9 ·
Replies
9
Views
3K
  • · Replies 3 ·
Replies
3
Views
2K
  • · Replies 5 ·
Replies
5
Views
2K