Standard Deviation

[Ken Cole]

Thanks Rick,

this looks like a great start, we really appreciate the help.

Ken

On Fri, 24 Jul 2020 at 01:52, Rick Walsh <marshallscreek at gmail.com> wrote:

> I might be off, this was real quick.
>
> ::r=""; declare datacount ,datasum, meansqu, meancount, std:
> ::datacount="0":
> :':'Generate the mean:
> lcount::lookup set = set  k=r    i=A -ng:
> :not set:goto donec:
> ::datacount=datacount+"1":
> ::datasum=datasum+set(1):
> ::getnext set; goto lcount:
> donec:':'Subtract the mean from the values and square the result:
> ::mu=datasum/datacount:
> ::lookup muset = set  k=r    i=a -ng:
> lmuset:not muset:goto donemu:
> ::meansqu=meansqu+sqrt(set(1)-mu):
> ::meancount=meancount+"1":
> ::getnext muset; goto lmuset:
> donemu:':'Mean of the squared differences:
> ::mu=meansqu/meancount:
> :':'result:
> ::std=sqrt(mu):
> ::msgbox std:
> ::end:
>
>
>
>
> <https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=webmail&utm_term=icon> Virus-free.
> www.avast.com
> <https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=webmail&utm_term=link>
> <#m_700645213611007666_DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2>
>
> On Thu, Jul 23, 2020 at 12:00 AM Ken Cole via Filepro-list <
> filepro-list at lists.celestial.com> wrote:
>
>> Hi everyone,
>>
>> I hope you are all doing well during covid.
>>
>> Not being someone who likes to reinvent the wheel, has anyone
>> implemented a standard deviation function in filePro?
>>
>> We have to implement a very detailed algorithm to calculate reorder
>> points for stock and the algorithm requires the use of the StdDev of
>> certain data sets like lead time and usage over time.
>>
>> We run on RHEL servers so it may be an option to pass the data off to
>> a user function written in say Perl to do this and get it to return
>> the StdDev if we cannot do it within standard filePro.
>>
>> Perl is not foreign to us as we use it liberally and I see we can use
>> a module Statistics::Basic::StdDev.
>>
>> Thanks
>>
>> Ken
>> _______________________________________________
>> Filepro-list mailing list
>> Filepro-list at lists.celestial.com
>> Subscribe/Unsubscribe/Subscription Changes
>> http://mailman.celestial.com/mailman/listinfo/filepro-list
>>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mailman.celestial.com/pipermail/filepro-list/attachments/20200724/04d79631/attachment.html>