Excel statistics - Help?
eraser51
Posts: 63 Member
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/
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/
0
Replies
-
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 HappyScals0 -
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 trendweight0 -
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 )0
This discussion has been closed.
Categories
- All Categories
- 1.4M Health, Wellness and Goals
- 393.6K Introduce Yourself
- 43.8K Getting Started
- 260.3K Health and Weight Loss
- 175.9K Food and Nutrition
- 47.5K Recipes
- 232.5K Fitness and Exercise
- 431 Sleep, Mindfulness and Overall Wellness
- 6.5K Goal: Maintaining Weight
- 8.6K Goal: Gaining Weight and Body Building
- 153K Motivation and Support
- 8K Challenges
- 1.3K Debate Club
- 96.3K Chit-Chat
- 2.5K Fun and Games
- 3.8K MyFitnessPal Information
- 24 News and Announcements
- 1.1K Feature Suggestions and Ideas
- 2.6K MyFitnessPal Tech Support Questions