Any maths / statistics whizzes here?

[WTFH]

Bored here, opened excel, put 100 into cell A1
in cell B1, I put: =A1-(A1*0.004) (i.e. B1 is the remainder after subtracting 0.4% from A1)
Copy that down and it takes 1150 weeks to get down to 1 person.
And 1323 weeks to get below 0.5
By 3448 weeks you're at 0.000100388

If you want to hit six sigma, it's 3142 weeks.


But that's probably not what you're looking for.

[jamesbrown]

I see pooperscooter has been pruning some posts from this thread without replacement.

[WTFH]

I see pooperscooter has been pruning some posts from this thread without replacement.

But where they have been quoted, they still live on.

[sasguru]

I see pooperscooter has been pruning some posts from this thread without replacement.

Has he?

[jamesbrown]

Has he?

Yeah, all the ones that make him look like a lying moron. Still, he left all the ones that make him look like a regular moron.

[DoctorStrangelove]

But where they have been quoted, they still live on.

To the end of the world or until the oil runs out?

[NotAllThere]

Here's my working out.



Invoice is in the post.

You idiot. You've got phi-minus where there should be a phi-plus.

[ladymuck]

Bored here, opened excel, put 100 into cell A1
in cell B1, I put: =A1-(A1*0.004) (i.e. B1 is the remainder after subtracting 0.4% from A1)
Copy that down and it takes 1150 weeks to get down to 1 person.
And 1323 weeks to get below 0.5
By 3448 weeks you're at 0.000100388

If you want to hit six sigma, it's 3142 weeks.


But that's probably not what you're looking for.

Do it again but this time bearing in mind the original requirement.

0.4% do the thing in a week. How long to reach 100%

[scooterscot]

oh gwd I missed a 0.004 - que ritual ridicule - fair game I suppose.

[OwlHoot]

oh gwd I missed a 0.004 - que ritual ridicule - fair game I suppose.

No, now you've gone too far the other way - Not 0.004, it's 0.04%