This is something I have been curious based on observations I have made by analyzing data from the energy industry. The context is you have monthly data for energy used per month and the cost per month.
So for example lets say that we have twelve months of data(I have a spreadsheet attached with sample). For every month we can divide the cost by usage, and we get a pricing or also referred to as a rate. If we average these 12 rates we get one annual rate.
That is method number 1 to create an annual rate. Another way is to add all the energy usage for all 12 months, then add all cost, and divide the two to get another kind of average or rate.![Average Methods formula]
Note in the image: $c$ represents cost data and $m$ is usage data. $$ \left(\sum_i C_i\right) / \left(\sum_i M_i\right) == \frac1N \sum_i(C_i/M_i) $$ So i put a bunch of equal signs in between, I want to find out if there exists an inequality between these 2 averages or rates.
I am not sure how one can prove this,not sure what techniques. Either Induction or using somekind of triangle inequality. I am just wondering if someone can figure out the approach. Also when I do a numerical example, with data, it seems that averaging monthly rates is greater than getting an average of total sum divided by total sum.
Looks like the message I am getting from this app is that I can`t post images until I get up to 10 posts.Also I can't see where I can attach files like spreadsheet. Also I don't know how to make complicated formulas like making summation symbols here.
Hope someone can give me some pointers on how to create mathematical formulas. P