Question

I am trying to work a case problem, I have to take a group of numbers and using the data by product line, there is three different products lines, I need to compile a breakdown of sales by product then give a total of all three. then I need to find the expected sales for each product if the total of all 3 is equal to 100,000 total units. Can you give me some advice on where to start?

thanks
Nancy

Answer 1

This does not look like statistics. It looks like extrapolation.

Assume the sales breakdown gives you sales of S1, S2 and S3, with a total T = S1 + S2 + S3.

If you sold 100,000, the new sales amounts of each product would be
S1' = S1*(100,000/T)
S2' = S2*(100,000/T)
S3' = S3*(100,000/T)