Excel statistics - Help?

eraser51
eraser51 Posts: 63 Member
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,244 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 )

Categories