Originally Posted by matagi
I just put the stats from my cycling computer into Excel - haven't done any data massaging but Excel has some pretty powerful tools for graphing, linking cells etc. etc. Unfortunately, I am not sufficiently skilled with Excel to take advantage of its more sophisticated features.
Ive just finished doing an econometric and quantitative analysis course at uni so I can do some pretty cool forecasting if you want.
Best thing to find in excel is:
go to tools -> add ins --> data analysis
then tools--> data analysis. then play with those tools summary statistics will give mean, mode, range etc.
If you can be bothered to group the data into groups (like weeks) then run summary stats again it'll give variance etc. Then if you want to you could predict future events, like mileage etc. Or in Matagi's case weightloss
