Posted by Nancy on .
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?
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)