How to calculate goals from real data ?

[gdeltoro]

Hi,

I want to calculate goals from real data, but i dont know which will the best method, can you help me ?

As example, I want to calculate the goal for the duration of products Family A. This are the duration of the product of the last 3 months:
23, 12, 25, 9, 59, 14, 14, 16, 16, 17, 32, 11, 14, 16, 9, 10, 11, 9, 10, 43

At first I calculate the descriptive statistics and the i calculate the UCL and LCL, but the problem is that the standard deviation is to high that my LCL is negative.

My question will be:
1) This way of calculate goals is correct ?
2) What statistics tool i can use to calculate the goal ?



Thanks...

[yoma819]

Hello gdeltoro

When you say you want to calculate goals do you mean that you want to predict the outcome of a trend?
for example the sales of clothes in my shop have increased by 10% everyday what are they going to be in a years time?
or are you looking to find the targets you should be hitting!
e.g. back in our clothings store your manager wishes to know who many sales of jumpers the shop per day, should be aiming for in a years time?

cheers
--yoma