I posted this question on Software Recommendations. As it is getting no response, I think that I might try to make a meaningful chart for my friend, in Excel .

Actually, I would prefer someone else to post an Excel formula to do so, but that is certainly off-topic here :-)

What I am hoping is not off topic is asking for a mathematical formula which will produce meaningful results.

From that question:

Basically my friend weighs daily and has historical data in CSV format. They would like a gratis app that takes that data and overlays it in some form of weekly chart. E.g shows only Monday to Sunday (start day preferably selectable), not several months or years.

We are unsure what format the display should take, but the objective is to see if there is a pattern to weight loss/gain on certain days of the week.

My friend has been steadily losing weight for months now, but against that background, there are days when weight is gained and my friend is looking for an identifiable pattern. A very obvious example would be weight gain on Monday after a weekend binge, but this is not the case, just an example.

The idea is that if certain days can be identified as problematic then the cause can be identified and behavio(u)r changed.

So, could I somehow phrase that to be an on-topic question here? I am looking for a pattern in data (and how best to represent it visually).

closed as off-topic by Henrik, achille hui, José Carlos Santos, Delta-u, hardmath Oct 18 at 14:03

This question appears to be off-topic. The users who voted to close gave this specific reason:

  • "This question does not appear to be about Mathematics Stack Exchange or the software that powers the Stack Exchange network within the scope defined in the help center." – Henrik, achille hui, José Carlos Santos, Delta-u, hardmath
If this question can be reworded to fit the rules in the help center, please edit the question.

  • Thank you! I was not aware of the stats site, which definitely seems to be a better fit. Would you like to post an answer, which I will accept, to help others in future. Alternatively, I could just delete this question, as I will be duplicating it on stats (meta). – Mawg Oct 18 at 10:30
  • 2
    Sure! Good luck! – davidlowryduda Oct 18 at 10:32
up vote 5 down vote accepted

Good luck with your idea! Unfortunately, I do not see an on topic question here. I think the real underlying question is "I have some data. How do I detect patterns in it?" And that is overwhelmingly broad. Of course, I may be wrong, and perhaps there is an on-topic question here.

You might also consider reading some questions on stats.SE, as perhaps there is something of interest there.

Not the answer you're looking for? Browse other questions tagged .