I sell goods on eBay UK.
I sell various 'product lines' in several different 'categories'.
For each product line I have a set of numbers which are sales values as a percentage of the amount I aim to sell for. Naturally enough I call it 'sell-as-%-of-aim'. I then have an average 'sell-as-%-of-aim' for each product line. I also have an overall average 'sell-as-%-of-aim' for each category.
To estimate future sales values for each product line, I need to know what weighting I should give to the average 'sell-as-%-of-aim' of that product line, and what weighting to give to the average 'sell-as-%-of-aim' of that category.
Also, the more history I have for each line, presumably the more reliable the 'sell-as-%-of-aim' is for that line and the less relevant the 'sell-as-%-of-aim' is for that category. I therefore need to know how to weight between 'sell-as-%-of-aim' of that product line, 'sell-as-%-of-aim' of that category as history builds up.
The resulting equation needs to be 'straight line' simple enough to be programmed into MS Excel, and also simple enough to be easily understood.
All my sales data is in MS Excel and is laid out in a clear and easy to understand way.
9 freelancer đang chào giá trung bình $176 cho công việc này
Hi. I am a professional in applied mathematics. I have many experiences in statistical analysis. We can discuss details via chat. I wait for you now. Thanks.