Welcome to Debate Club! Please be aware that this is a space for respectful debate, and that your ideas will be challenged here. Please remember to critique the argument, not the author.

Ok smart people! How would you evaluate macro impact on overeating (and possibly satiety)?

EvgeniZyntx
EvgeniZyntx Posts: 24,208 Member
Recently someone wanted to look into their macros and see how it impacted their recent binges.
I wrote a method to do this out of MFP data and will post it below. I'm looking for criticism and input. Does it make sense to you? Who would you do this differently?

General Method: Take the days that are high and look at macro distribution over the prior x days.

First Results: I see a shift where I tend to eat less fat the few days prior to a "large" day. (Note, I don't have a binge issue, so these are just days with a few hundred cals over.)

And this is purely correlation - I'm not saying that at this time that it actually impacts my satiety. I'm not tracking "satiety" in my dairy.

eyzrxnruqgql.png

Detailed Method:

Select only days with calorie data for the prior x days.
For the days with high calories, take average of protein, fat and carb macros for the prior x days.
Normalise these averages against all days with calories.
Look at distribution of these days - do they tend to be the same as general eating or is there a shift towards higher or lower days?

Thoughts? Comments?

Replies

  • MelodyandBarbells
    MelodyandBarbells Posts: 7,724 Member
    That's pretty neat. Does each person's diary in this case equals N, or an entirely separate experiment? I wonder because "high calorie day", for example would have to be determined on an individual basis, and would also likely be randomly selected. Or not. I suppose you Could use a formula like 1.XX TDEE, who knows.

    By analyzing this statistically, you should be able to show if there's significant impact of macro distribution in days preceding an overage day. This should also indicate if there's no link, that is, other factors such as a holiday gathering, emotional eating, lack of planning, I'm in Momma's house so I better eat ALL THE THINGS, ETC have come into play. However, macros seem like an easy one to evaluate given our data

    Oh also the individual would of course need to have been tracking macros properly. Even now, I mostly double check macros on individual food items when one entry throws my pie chart WAY out of whack. This has happened a total of two times
  • lemurcat12
    lemurcat12 Posts: 30,886 Member
    Is there a way to input the number of days before the high cal day that you want to look at so that you can try different options? For example, first look at day before then the 2 days before?

    Also, would the user input what a high cal day is? Days above 2000, say? Or would it take the average calories for a period and look at days that are more than some percentage above the average?

    I don't think it would work for me, though, since I have lots of days that are planned highs -- either an evening out or a big exercise day. But that aside, it seems like a really great tool.
  • EvgeniZyntx
    EvgeniZyntx Posts: 24,208 Member
    JaneiR36 wrote: »
    That's pretty neat. Does each person's diary in this case equals N, or an entirely separate experiment? I wonder because "high calorie day", for example would have to be determined on an individual basis, and would also likely be randomly selected. Or not. I suppose you Could use a formula like 1.XX TDEE, who knows.
    The idea is a personal analysis - not research across the database - 1) because I do not want to look at other people's data without permissions or manage passwords - one just downloads the excel sheet and runs it off their own data 2) it is pretty easy to see high days - just take target cals and identify days that are above that or use a limit that is manually set. Currently, I'm working with a manual set limit because that allows me to play with it.
    By analyzing this statistically, you should be able to show if there's significant impact of macro distribution in days preceding an overage day. This should also indicate if there's no link, that is, other factors such as a holiday gathering, emotional eating, lack of planning, I'm in Momma's house so I better eat ALL THE THINGS, ETC have come into play. However, macros seem like an easy one to evaluate given our data
    Since I can't exclude causes, this is not a causal analysis but a correlative stats. If you can't eat to a target, the solution might be to move out of Momma's but this will tell you if you are eating more carbs or fat on the days before.

    You can see that my protein distribution is bi-modal. That is because I also have high days were I purposefully eat above cals to reach my protein goals. The analysis won't give the context.
    Oh also the individual would of course need to have been tracking macros properly. Even now, I mostly double check macros on individual food items when one entry throws my pie chart WAY out of whack. This has happened a total of two times

    Yes, bad data makes bad analysis.
  • EvgeniZyntx
    EvgeniZyntx Posts: 24,208 Member
    edited February 2016
    lemurcat12 wrote: »
    Is there a way to input the number of days before the high cal day that you want to look at so that you can try different options? For example, first look at day before then the 2 days before?

    Also, would the user input what a high cal day is? Days above 2000, say? Or would it take the average calories for a period and look at days that are more than some percentage above the average?

    I don't think it would work for me, though, since I have lots of days that are planned highs -- either an evening out or a big exercise day. But that aside, it seems like a really great tool.


    Absolutely, the idea is to let the user set the number of consecutive days to consider. It recalculates the curve as one changes the number of day to consider.
  • yarwell
    yarwell Posts: 10,477 Member
    are the binges logged accurately ? If so some form of multivariable regression might be helpful.
  • MelodyandBarbells
    MelodyandBarbells Posts: 7,724 Member
    Ok, I'll be th dumb one. What are the X and Y axes on the graph? I see Y goes up to 16, but can't really tell what unit that is. Being normalized probably means there's no unit, but perhaps there's some context I'm missing
  • EvgeniZyntx
    EvgeniZyntx Posts: 24,208 Member
    yarwell wrote: »
    are the binges logged accurately ? If so some form of multivariable regression might be helpful.

    Let's assume they are. I'll look into that idea. A bit more complicated.
  • EvgeniZyntx
    EvgeniZyntx Posts: 24,208 Member
    edited February 2016
    JaneiR36 wrote: »
    Ok, I'll be th dumb one. What are the X and Y axes on the graph? I see Y goes up to 16, but can't really tell what unit that is. Being normalized probably means there's no unit, but perhaps there's some context I'm missing

    It's a normalised histogram

    y is a count - number of days,
    x is the average of days prior to a high days / the average of all days. It is unit-less.

    So think of it this way - your looking at a sample of days (days before the high cal day). If they are similar to the distribution of all days then the curve should look like a bell curve with a median of 1. If the high days have a tendency to be driven by, say, low fat days prior, then we should see the curve shifted to the left. Like in that sample curve.

    This is a good question. I need to be clear on it.

    Let's say you cut a bunch of strings and you are trying to make them 5 inches long. Some will be little shorter, others a little longer. If you take the length of each, divide by the average, then count all the strings that are between .9 and 1.0 or 1.0 and 1.1, etc you can build a histogram, that is the count for each value (y axis).
  • ClosetBayesian
    ClosetBayesian Posts: 836 Member
    yarwell wrote: »
    are the binges logged accurately ? If so some form of multivariable regression might be helpful.

    Or a time lag analysis in Observation Oriented Modeling.
  • snikkins
    snikkins Posts: 1,282 Member
    My thoughts aren't 100% clear on this so ask for clarification if I am not making sense.

    Are you writing this to pick out certain high calorie days and then look at the day(s) preceeding it? Or will the user select the day that a binge occurs and analysis will happen on the previous day(s)? If it's the latter, then I think there won't be an issue determining which day(s) are being analyzed.
  • EvgeniZyntx
    EvgeniZyntx Posts: 24,208 Member
    yarwell wrote: »
    are the binges logged accurately ? If so some form of multivariable regression might be helpful.

    Or a time lag analysis in Observation Oriented Modeling.

    Let's keep it real, this runs off Excel.
  • EvgeniZyntx
    EvgeniZyntx Posts: 24,208 Member
    edited February 2016
    snikkins wrote: »
    My thoughts aren't 100% clear on this so ask for clarification if I am not making sense.

    Are you writing this to pick out certain high calorie days and then look at the day(s) preceeding it? Or will the user select the day that a binge occurs and analysis will happen on the previous day(s)? If it's the latter, then I think there won't be an issue determining which day(s) are being analyzed.

    Currently written to review all days above a threshold - but in such a manner that you can select one or more specific days.

    So the answer is "yes" to both questions.
  • snikkins
    snikkins Posts: 1,282 Member
    Fascinating. I don't binge, but I think it'd be neat to check out when you're done.

    For the first scenario, are you going with a certain threshold above the daily goal?
  • EvgeniZyntx
    EvgeniZyntx Posts: 24,208 Member
    edited February 2016
    snikkins wrote: »
    Fascinating. I don't binge, but I think it'd be neat to check out when you're done.

    For the first scenario, are you going with a certain threshold above the daily goal?

    Two thresholds - a lower one (say 400) anything under is considered a day that wasn't fully logged. A higher one - user set, above daily goal.

    The current version of the worksheet is here: https://www.dropbox.com/s/10mhbzig1v4v7h2/mfp6v5.xlsm?dl=0
    (to use your own data, go to the "Start" worksheet, press "Reset" and then "Go")




  • snikkins
    snikkins Posts: 1,282 Member
    Thanks!
  • dubird
    dubird Posts: 1,849 Member
    This would be something interesting to see in a larger group sample. Self-reporting data does have it's flaws, but it would be interesting to see the general direction it takes.
  • EvgeniZyntx
    EvgeniZyntx Posts: 24,208 Member
    dubird wrote: »
    This would be something interesting to see in a larger group sample. Self-reporting data does have it's flaws, but it would be interesting to see the general direction it takes.

    Possibly but I also think that would require some cluster classifications - we have people losing, others maintaining, bulking, active, sedentary, athletes, people that binge, people that don't... making inferences from random user data is going to be very difficult. However, if we had two groups - bingers vs non-bingers it might give some interesting results.
  • senecarr
    senecarr Posts: 5,377 Member
    dubird wrote: »
    This would be something interesting to see in a larger group sample. Self-reporting data does have it's flaws, but it would be interesting to see the general direction it takes.

    Possibly but I also think that would require some cluster classifications - we have people losing, others maintaining, bulking, active, sedentary, athletes, people that binge, people that don't... making inferences from random user data is going to be very difficult. However, if we had two groups - bingers vs non-bingers it might give some interesting results.
    I'd find it interesting if exercise calories were an option for comparison as well.
    I believe there is some research that depending on a gene or two some people have different appetite responses to exercise. My own personal feeling lately is that my appetite as a function is almost a normal curve. I could be okay eating nothing all day if I was laying in bed, if I was sitting at work all day and sitting at around 3K steps I'd like to eat 3K kcal of food, but if I'm actually moving 20K+ steps and/ burning an estimate of over 2.5K+, I'd mentally feel okay eating under 1K kcal of food and have to ignore my un-appetite.
  • Sued0nim
    Sued0nim Posts: 17,456 Member
    I think you need overlays of liquid intake, exercise - cardio/ resistance and hormonal shift (specifically in women)
  • robertw486
    robertw486 Posts: 2,401 Member
    Recently someone wanted to look into their macros and see how it impacted their recent binges.
    I wrote a method to do this out of MFP data and will post it below. I'm looking for criticism and input. Does it make sense to you? Who would you do this differently?

    General Method: Take the days that are high and look at macro distribution over the prior x days.

    First Results: I see a shift where I tend to eat less fat the few days prior to a "large" day. (Note, I don't have a binge issue, so these are just days with a few hundred cals over.)

    And this is purely correlation - I'm not saying that at this time that it actually impacts my satiety. I'm not tracking "satiety" in my dairy.

    eyzrxnruqgql.png

    Detailed Method:

    Select only days with calorie data for the prior x days.
    For the days with high calories, take average of protein, fat and carb macros for the prior x days.
    Normalise these averages against all days with calories.
    Look at distribution of these days - do they tend to be the same as general eating or is there a shift towards higher or lower days?

    Thoughts? Comments?

    Seems to make sense to me, but I do think looking at total calorie intake as well as exercise loads might have impact as well. My heaviest eating days tend to follow a period of hard exercise after a trend of lighter days, so really I am just making up for prior excess deficit.
  • EvgeniZyntx
    EvgeniZyntx Posts: 24,208 Member
    Some good points there.

    I see the following:
    - calories in (easy, have the data)
    - exercise/TDEE (requires data from a tracker, manually entered, easy to integrate)

    From these it is possible to look at av. prior cals vs high days or av. prior deficit vs high days.

    - liquids, hormones, stress

    I can see that these non-cal related items would be very impactful to overeating but are more difficult to track and evaluate. I'm going to have to leave them out for now. But, certainly worth thinking about.
  • EvgeniZyntx
    EvgeniZyntx Posts: 24,208 Member
    I've integrated now the ideas behind
    - calories
    - macros
    - exercise / TDEE (either from an estimator, external tracker or a Base + MSF exercise)

    - Sleep might be another item to include, since data is sometimes available.

    The results so far are interesting.
    Here is a screen capture on an analysis off my data (over 6 days prior to overeat days) - It seems that I tend to overeat to catch up on larger deficits - keeping a 25% cut seems fine. 30% not so much. Exercise impacts this.

    r7w3dhccsvkf.png

  • TR0berts
    TR0berts Posts: 7,739 Member
    One additional thing I think might be useful. Or at least interesting. Include the binge day - or have an option to look at that specific day

    It might be useful to see two things: 1) what the person is binging on. Eating a lot more carbs? A lot more fats? A fairly even mixture of the two? Booze involved? and 2) the individual could maybe look at his/her diary and see if he/she is eating more of any particular macro earlier in the day, that may cause him/her to overeat later in the day.

    I suppose that's easy enough to simply look at the individual day's diary, but it might be interesting/helpful to see if there's some sort of pattern between the preceding days and the preceding hours, which would likely be easier to see if the binge day's data is included in the graph(s).
  • psuLemon
    psuLemon Posts: 38,431 MFP Moderator
    edited February 2016
    Following....

    I may have to consider something like this, but in general my macronutrients are fairly consistent. The bigger driver for me is the days after a lifting day, I want to eat a house (especially leg days).
  • robertw486
    robertw486 Posts: 2,401 Member
    psulemon wrote: »
    Following....

    I may have to consider something like this, but in general my macronutrients are fairly consistent. The bigger driver for me is the days after a lifting day, I want to eat a house (especially leg days).

    The same here. I can do 12 miles on the elliptical, long bike rides, be moving stuff, etc... essentially any not too intense cardio or strength and keep eating in line just fine with calorie burn.

    The more I push intensity on anything to the point of high effort, including lifting, the more it seems to make me hungry in the following days.
  • jacklifts
    jacklifts Posts: 396 Member
    holy crap
    i need to learn some stats
    any of you guys trade futures? these skills can come in handy.
  • senecarr
    senecarr Posts: 5,377 Member
    jacklifts wrote: »
    holy crap
    i need to learn some stats
    any of you guys trade futures? these skills can come in handy.

    Most math based stocks and futures trading these days is based on genetics algorithms rather statistical analysis.
  • stealthq
    stealthq Posts: 4,298 Member
    senecarr wrote: »
    jacklifts wrote: »
    holy crap
    i need to learn some stats
    any of you guys trade futures? these skills can come in handy.

    Most math based stocks and futures trading these days is based on genetics algorithms rather statistical analysis.

    +1

    Machine learning and prediction algorithms for 100, Alex.
  • jacklifts
    jacklifts Posts: 396 Member
    senecarr wrote: »
    jacklifts wrote: »
    holy crap
    i need to learn some stats
    any of you guys trade futures? these skills can come in handy.

    Most math based stocks and futures trading these days is based on genetics algorithms rather statistical analysis.
    stealthq wrote: »
    senecarr wrote: »
    jacklifts wrote: »
    holy crap
    i need to learn some stats
    any of you guys trade futures? these skills can come in handy.

    Most math based stocks and futures trading these days is based on genetics algorithms rather statistical analysis.

    +1

    Machine learning and prediction algorithms for 100, Alex.


    So....are you saying you do trade futures?

This discussion has been closed.