[Solved] STEYX not available?

Discuss the spreadsheet application
Post Reply
ancblab
Posts: 2
Joined: Wed Dec 28, 2022 11:25 am

[Solved] STEYX not available?

Post by ancblab »

Hello,

I'm trying to use STEYX to calculate standard error on two data columns.
I'm using this formula: ='STEYX'(A600:A605;B600:B605) and I get a #RIF!
Apparently, STEYX is not available in my OO (it's not listed when I open the formula wizard.
I tried to installa Statistical extension but with no results.
I made several searches on the web but could not find where this function is supposed to be found.
Any help is appreciated.

Using OO 4.1.13 on WIn 10

Thanks

Raf
Last edited by MrProgrammer on Thu Dec 29, 2022 5:14 am, edited 1 time in total.
Reason: Tagged ✓ [Solved] -- MrProgrammer, forum moderator
OpenOffice 4.1.13 on Windows 10
Top
User avatar
karolus
Volunteer
Posts: 1252
Joined: Sat Jul 02, 2011 9:47 am

Re: STEYX not available?

Post by karolus »

Hallo

Code: Select all

=STEYX(A600:A605;B600:B605)
should work in Libreoffice, with english-localized-Functionnames
Libreoffice 25.2… on Debian 13 (trixie) (on RaspberryPI5)
Libreoffice 25.8… flatpak on Debian 13 (trixie) (on RaspberryPI5)
Top
cwolan
Posts: 219
Joined: Sun Feb 07, 2021 3:44 pm

Re: STEYX not available?

Post by cwolan »

A shot in the dark...
ancblab wrote: ↑Wed Dec 28, 2022 11:50 am Hello,

I'm trying to use STEYX to calculate standard error on two data columns.
I'm using this formula: ='STEYX'(A600:A605;B600:B605) and I get a #RIF!
Apparently, STEYX is not available in my OO (it's not listed when I open the formula wizard.
I tried to installa Statistical extension but with no results.
(...)
#RIF! and installa

Is it the Italian User Interface?
If so then, the name of the function in 4.1.13 is ERR.STD.YX
OpenOffice 1.1.5 – 4.1.16
LibreOffice 3.3.0.4 – 26.2
Windows 7,10,11 64-bit
Top
User avatar
Zizi64
Volunteer
Posts: 11511
Joined: Wed May 26, 2010 7:55 am
Location: Budapest, Hungary

Re: STEYX not available?

Post by Zizi64 »

The function is present in my LO 6.1.6:
STEYX.png
STEYX.png (33.75 KiB) Viewed 914 times
Tibor Kovacs, Hungary; LO7.5.8/25.8.5.2 /Win7-10-11 x64Prof.
PortableApps: LO3.3.0-25.8.5.2;AOO4.1.14
Please, edit the initial post in the topic: add the word [Solved] at the beginning of the subject line - if your problem has been solved.
Top
ancblab
Posts: 2
Joined: Wed Dec 28, 2022 11:25 am

Re: STEYX not available?

Post by ancblab »

You shot straight.
I have to use the Italian name of the function (ERR.STD.YX).
Now the function works :knock:

Thanks a lot

Raf
cwolan wrote: ↑Wed Dec 28, 2022 12:52 pm A shot in the dark...
ancblab wrote: ↑Wed Dec 28, 2022 11:50 am Hello,

I'm trying to use STEYX to calculate standard error on two data columns.
I'm using this formula: ='STEYX'(A600:A605;B600:B605) and I get a #RIF!
Apparently, STEYX is not available in my OO (it's not listed when I open the formula wizard.
I tried to installa Statistical extension but with no results.
(...)
#RIF! and installa

Is it the Italian User Interface?
If so then, the name of the function in 4.1.13 is ERR.STD.YX
OpenOffice 4.1.13 on Windows 10
Top
Post Reply

Return to “Calc”