hiya all i was wndering if anyone could help me i need to work the probability of number using a percentage for expample 50 sales has a probability of occuring 40% and 60 sales has probability of occuring 5% and so on, can any explain how i need to do this im new to excel ,
thank u
It's not very clear from your question what you need to do. Are you trying to work out a percentage of your total sales?
(sales/total sales) *100 = percentage of total sales?
Or are you working on statistical probabilities? Working from values from previous months sales and saying how likely it is that you will gain as many sales again this month? You might need to get in to working out the standard deviation for a months sales and then calculate the number of standard deviations above the mean you want to predict and convert that back in to a probability.. I've not explained that very well but it would be helpful to know exactly what the problem is.
Last edited by eterenal-studen; 10-19-2006 at 07:59 AM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks