Excel statistics - Help?
Options
![eraser51](https://d34yn14tavczy0.cloudfront.net/images/no_photo.png)
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'thaha )
0
Categories
- All Categories
- 1.4M Health, Wellness and Goals
- 392.1K Introduce Yourself
- 43.6K Getting Started
- 259.9K Health and Weight Loss
- 175.7K Food and Nutrition
- 47.4K Recipes
- 232.4K Fitness and Exercise
- 403 Sleep, Mindfulness and Overall Wellness
- 6.4K Goal: Maintaining Weight
- 8.5K Goal: Gaining Weight and Body Building
- 152.8K Motivation and Support
- 7.9K Challenges
- 1.3K Debate Club
- 96.3K Chit-Chat
- 2.5K Fun and Games
- 3.4K MyFitnessPal Information
- 23 News and Announcements
- 1K Feature Suggestions and Ideas
- 2.4K MyFitnessPal Tech Support Questions