I was wondering if you could guide me a little so that I can head off and do some analysis..

I'm looking to calculate

1. the time it takes for my team to close a business deal and

2. what our closing rate is. i.e rate of success

The information I will need is :

1 - the start date of all my previous deals and

2 - the close date of the deals.

To get my closing rate do I need to create a separate column to put the closing dates of deals we have closed?

Once I have the successful closing dates in days I can calculate the time it takes to close a deal.

Can I get both information in one go or would I have to do two different regressions?

In the formula y = a + bx + e

Where y = time to close a deal?

what is a?

How do I get the error i.e. e ?

Would b be the slope i.e my closing success rate?

How do I get the line of regression so that it can help me forecast how long we should spend on a deal and then give up?

Any tips?

Your guidance will be very helpful

Thanks a lot..

- Lost -