Find Weighted Average

Originally Posted by Bo_Ry

Please try

=SUMPRODUCT(B2:B42*C2:C42)/SUM(B2:B42)

I want to find the weighted average Sales number given the size of the product. So, just because a product sales is small compared to another product that has more sales, if you compare the size of the products, perhaps one product has better sales when comparing it's size.

I think the weighted average would help with this. Maybe not?

For what you describe, there really isn't enough detail in data....

Since each product is only summarized by size and sales...
You can only calculate individual product's sales per unit weight.... Which is just Sales/Weight.

This really won't help. As there is no data on # of sales etc. But... for analysis of sales data, you'd be more interested in bottom & top line (I.E. Cost vs Profit), rather than weighted avg of sales value. Since profit (net) is usually directly tied to business objective.

Originally Posted by CK76

For what you describe, there really isn't enough detail in data....

Since each product is only summarized by size and sales...
You can only calculate individual product's sales per unit weight.... Which is just Sales/Weight.

This really won't help. As there is no data on # of sales etc. But... for analysis of sales data, you'd be more interested in bottom & top line (I.E. Cost vs Profit), rather than weighted avg of sales value. Since profit (net) is usually directly tied to business objective.

Oh I see - Okay, allow me to add the # of sales.

I'm trying to figure out the method so I can apply it to other areas such as length of stay of particular area given the number of residents. But that might require another thread.

I've attached a new file with # of sales.

Thank you for your help

Originally Posted by FlameRetired

d7882

I tried downloading your attachment and get an "Invalid Attachment" pop up.

Would you try uploading again please?

Thank you.

Try now Dave

Perhaps you're right - I may be needing something else. Thank you for your help in this. I will leave it unsolved for a bit to see if others have any other thoughts/opinions.

Thanks again