Monday, July 26, 2021

#1 2021-06-15 06:40:52 pm

MitchBVI
Member
Registered: 2006-02-14
Posts: 273

Calculate Standard deviation in Excel

Is there a way to calculate a STDEV in Excel without having to enter the result in an excel cell.

At present the best I can do is

Applescript:

tell application “Microsoft excel”
Set Formula of cell (“G20”) to “=STDEV.S(G3:G12)”
Set CheckF to value of cell (“G20”)
Set value of cell(“G2-“) to “‘
End tell

Thanks

Offline

 

#2 2021-06-15 10:21:28 pm

roosterboy
Member
Registered: 2010-04-19
Posts: 49

Re: Calculate Standard deviation in Excel

Use the evaluate command:

Applescript:


tell application "Microsoft Excel"
   set stdev to evaluate name "=STDEV.S(G3:G12)"
end tell

Last edited by roosterboy (2021-06-15 10:23:07 pm)

Offline

 

#3 2021-06-16 11:56:56 am

MitchBVI
Member
Registered: 2006-02-14
Posts: 273

Re: Calculate Standard deviation in Excel

Brilliant thanks very much, have not been able to find much about " evaluate name" but I assume an AppleScript command that will work with most excel functions.

Peter

Offline

 

Board footer

Powered by FluxBB

RSS (new topics) RSS (active topics)