Re: [da-dansk] Oversættelse af regenarksfunktioner

Programmøren skriver:
"With Excel 2016, 5 new functions have been added:
FORECAST.LINEAR
FORECAST.ETS
FORECAST.ETS.CONFINT
FORECAST.ETS.SEASONALITY
FORECAST.ETS.STAT"

Senere skriver han:
"Further studies of publications and literature about Triple
Exponential Smoothing (AKA Holt-Winters method)
shows that there are 2 methods, depending on the seasonal influences.
If the seasonal influence is absolute (e.g. in July 10 extra icecreams
are sold), the additive method is used,
if the seasonal influence is relative (e.g. in July 10% extra
icecreams are sold), the multiplicative method is used.

For the additive there is a generally accepted method to calculate
prediction intervals, often -but incorrectly- called
confidence intervals. As the interval is calculated for predicted
values, not for actual observations, it is not possible
to calculate a proper confidence interval.
For the multiplicative method I haven't found a method that is recommended yet.

Excel 2016 uses the additive method.
I intend to add both methods to Calc."

Endnu senere skriver han:
"Note that  Excel uses slightly different function names because Excel
only supports 1 method (additive) whereas
Calc supports both additive and multiplicative methods with triple
exponential smoothing. Also, The Excel FORECAST.ETS.SEASONALITY
is not really necessary as a separate function in Calc (though it is
available) because this value can be returned from the
FORECAST.ETS.STAT.ADD/MULT functions in Calc."

Jeg synes ikke det er nemt at se hvad der svarer til hvad, og hvordan skal
det så oversættes? Mine forslag er:

FORECAST.ETS.ADD* -> PROGNOSE.ETS.ADDER
FORECAST.ETS.MULT -> PROGNOSE:ETS:MULT
FORECAST.ETS.SEASONALITY* -> PROGNOSE.ETS.SÆSONBET
FORECAST.ETS.PI.ADD* -> PROGNOSE.ETS.PI:ADDER
FORECAST.ETS.PI.MULT -> PROGNOSE.ETS.PI:MULT
FORECAST.ETS.STAT.ADD* -> PROGNOSE.ETS.STAT:ADDER
FORECAST.ETS.STAT.MULT -> PROGNOSE.ETS.STAT:MULT

Venligst
David Lamhauge

-- 
Send en e-mail til dansk+unsubscribe@da.libreoffice.org for instruktioner om hvordan du ophæver dit 
abonnement
Problemer? http://da.libreoffice.org/kontakt-os/postlister/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
Listens arkiv er tilgængelig på http://listarchives.libreoffice.org/da/dansk/
Alle beskeder du sender til listen bliver publiseret her og kan ikke efterfølgende slettes