We are pleased to announce that as of March 4, 2025, an updated Rich Text Editor has been introduced in the MyFitnessPal Community. To learn more about the changes, please click here. We look forward to sharing this new feature with you!

Excel statistics - Help?

eraser51
eraser51 Posts: 63 Member
edited December 2024 in Health and Weight Loss
Hi!

Is anyone proficient with excel statistics?

I tried to get some infos out of my MFP logs and do some statistics but I am clueless, because I really see no pattern.


july2016
https://www.dropbox.com/s/d5vl3vi8qbvvjod/MFP July 2016.xlsm?dl=0

2014-2016
https://www.dropbox.com/s/7jwaybuo9x1xpsk/MFP Statistik 2016-214.xlsx?dl=0


Do I need an moving average? Or a monthly/weekly average? Or a linear progression?
Or something else?



Stats if needed:
32 years
male
130kg
30-32% BF
kcal 2200 right now

my log
http://www.myfitnesspal.com/food/diary/eraser51

o.ld log
http://s270.photobucket.com/user/eraser51/library/

Replies

  • Sued0nim
    Sued0nim Posts: 17,456 Member
    Two ways about it

    1) the inimitable @EvgeniZyntx has written code for export and analysis in Excel

    http://www.myfitnesspal.com/blog/EvgeniZyntx/view/mfp-data-export-tool-the-overview-659927

    2) there are apps and sites designed to do trend analysis on a rolling basis
    -my personal favourite is www.trendweight.com as it synchs seemlessly from my Fitbit, Weightographer.com is similar but I'm not as used to using it
    Also there are apps like Libra and HappyScals
  • eraser51
    eraser51 Posts: 63 Member
    I am using his excel spreadsheet

    I was just thinking about different diagrams to look at. Also my data wasnt imported successfully because it was so much


    the apps wont allow import, wont they?

    I tried libra and trendweight but I can only add manually in libra or import fitbit in trendweight
  • Seffell
    Seffell Posts: 2,246 Member
    edited July 2016
    I use spreadsheets to store my data since Feb this year. I have manually input my data there. I've got lots of graphs but my favourite is of the weekly minima for weight (as datapoints) and a superimposed LINEAR trend. The r^2 value is 0.99 which is pretty amazingly constant for 6 months of dieting. A nice graph to look at. Other graphs I have are for example "weekly average calories eaten and trend", "total average calories eaten", "weight with superimposed accumulated deficit" taken from what I eat which match perfectly too :) etc.

    It is pretty cool to see that Cico works like clockwork (while at the same time reading some posts here that it doesn't :) haha )
This discussion has been closed.

Categories