Calling all nerds =] Calorie and Weight Data Analysis
Options
alecta337
Posts: 622 Member
For all you math geeks out there... First let me tell you something about myself, I LOVE excel. It is unexplainable my love for this program.
Needless to say I have a huge excel data file filled with weight and calorie information from me. I have only been keeping real track for about 11 weeks now so I only have 11 data points, but I made two very useful scatter plots: Average Weekly Calorie Deficit V. Weight Loss and Average Weekly Net Calories V. Weight Loss. I then fit these data points with a parabola (I chose a parabola because theoretically if your calorie intake is too low or too high you will gain weight). The peak of these two parabolas is the conditions for maximal weight loss!! Approx 350 calorie deficit and 1200 net calories ( Well would ya look at that... my data supports MFP's suggested optimal caloric intake).
I should explain that my calorie deficit (mentioned above) is calculated by my BMR minus the calories I ate that day. I calculate my BMR daily from an equation I found online that takes into account height, weight, sex, and age.
So yeah, bottom line... this is why I am going to be in Biomedical Engineering, because I compuslively do this type of this... maybe I can write a paper about it and get published... I would probably need a larger sample size than just myself.... Hehe =]
I just wanted to share my awesome math project with all of MFP and see if there are any uber nerds out there who think this is the awesomest thing since sliced bread, because I totally do.
The coolest part is that my optimal weekly net calories is 1200...
If you are interested in talking more nerdy math stuff or want to see my data, feel free to message me =D
Needless to say I have a huge excel data file filled with weight and calorie information from me. I have only been keeping real track for about 11 weeks now so I only have 11 data points, but I made two very useful scatter plots: Average Weekly Calorie Deficit V. Weight Loss and Average Weekly Net Calories V. Weight Loss. I then fit these data points with a parabola (I chose a parabola because theoretically if your calorie intake is too low or too high you will gain weight). The peak of these two parabolas is the conditions for maximal weight loss!! Approx 350 calorie deficit and 1200 net calories ( Well would ya look at that... my data supports MFP's suggested optimal caloric intake).
I should explain that my calorie deficit (mentioned above) is calculated by my BMR minus the calories I ate that day. I calculate my BMR daily from an equation I found online that takes into account height, weight, sex, and age.
So yeah, bottom line... this is why I am going to be in Biomedical Engineering, because I compuslively do this type of this... maybe I can write a paper about it and get published... I would probably need a larger sample size than just myself.... Hehe =]
I just wanted to share my awesome math project with all of MFP and see if there are any uber nerds out there who think this is the awesomest thing since sliced bread, because I totally do.
The coolest part is that my optimal weekly net calories is 1200...
If you are interested in talking more nerdy math stuff or want to see my data, feel free to message me =D
0
Replies
-
Ill be a test subject!! LOL0
-
Plug in my numbers girl, and have at it!!!0
-
For all you math geeks out there... First let me tell you something about myself, I LOVE excel. It is unexplainable my love for this program.
Needless to say I have a huge excel data file filled with weight and calorie information from me. I have only been keeping real track for about 11 weeks now so I only have 11 data points, but I made two very useful scatter plots: Average Weekly Calorie Deficit V. Weight Loss and Average Weekly Net Calories V. Weight Loss. I then fit these data points with a parabola (I chose a parabola because theoretically if your calorie intake is too low or too high you will gain weight). The peak of these two parabolas is the conditions for maximal weight loss!! Approx 350 calorie deficit and 1200 net calories ( Well would ya look at that... my data supports MFP's suggested optimal caloric intake).
I should explain that my calorie deficit (mentioned above) is calculated by my BMR minus the calories I ate that day. I calculate my BMR daily from an equation I found online that takes into account height, weight, sex, and age.
So yeah, bottom line... this is why I am going to be in Biomedical Engineering, because I compuslively do this type of this... maybe I can write a paper about it and get published... I would probably need a larger sample size than just myself.... Hehe =]
I just wanted to share my awesome math project with all of MFP and see if there are any uber nerds out there who think this is the awesomest thing since sliced bread, because I totally do.
The coolest part is that my optimal weekly net calories is 1200...
If you are interested in talking more nerdy math stuff or want to see my data, feel free to message me =D
*boregasm*
KIDDING! Really...just joking. I'm impressed, but totally over my head on a thread like this. Hard to believe I was a math major for a while in college. I think smart people are awesome.0 -
feel free to plug in my bloody numbers too!0
-
haha I luv u.0
-
You are too cool. I'm an excel geek too and plug my info into a spreadsheet too to check the trends--I just pull my numbers into a pivot table and look at it every which way (trends for weekends vs. week nights, by month, week, year,etc).....absolutely love it. I have graphed but am more of a numbers gal so tend to look at it this way. I so can't wait until they offer a download of this info (hope it's in the works....) because I can't do all the things I want to do (like with the nutrient information) because typing anything other than net calories in by hand for any length of time would be no fun. Good luck with everything!0
-
Wow that is pretty cool I wouldn't mind if u wanna figure out mine but I don't keep track so well!0
-
I wish I could do the same thing, i am just not that computer savy!! Nice work!0
-
Fairly awesome! I'd love to get info on it. Is it something you've done that can be sent to someone else or can we only send you our info? Glad we're friends, you're twelve kinds of awesome!
0 -
I'm an excel nerd myself and would love to see it if you're open to sharing it0
-
My **exact** optimal stats are
Net Calories: 1145
Daily Deficit: 3540 -
I'll a test subject to the best of my ability
0 -
Hey plug my numbers in! I'm really curious!0
-
Interestingly enough, I found no correlation between how many calories I burned and weight loss. And its more dependent on net calories than deficit calories.... interesting....0
-
Ill be a test subject!0
Categories
- All Categories
- 1.4M Health, Wellness and Goals
- 391.7K Introduce Yourself
- 43.5K Getting Started
- 259.8K Health and Weight Loss
- 175.6K Food and Nutrition
- 47.3K Recipes
- 232.3K Fitness and Exercise
- 395 Sleep, Mindfulness and Overall Wellness
- 6.4K Goal: Maintaining Weight
- 8.5K Goal: Gaining Weight and Body Building
- 152.7K Motivation and Support
- 7.8K Challenges
- 1.3K Debate Club
- 96.3K Chit-Chat
- 2.5K Fun and Games
- 3.3K MyFitnessPal Information
- 23 News and Announcements
- 960 Feature Suggestions and Ideas
- 2.3K MyFitnessPal Tech Support Questions