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+unsubscr...@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