# Difference between revisions of "Calc/ODFF Implementation/Examine functions"

From Apache OpenOffice Wiki

< Calc | ODFF Implementation

(→Statistical Functions) |
(→Statistical Functions) |
||

Line 101: | Line 101: | ||

! QUARTILE | ! QUARTILE | ||

| Example calculates with ''Quart=1.5'' although there is a constraint INT(Quart)=Quart||-||-||-|| | | Example calculates with ''Quart=1.5'' although there is a constraint INT(Quart)=Quart||-||-||-|| | ||

+ | |||

+ | |- | ||

+ | ! RANK | ||

+ | | Description "If not 0, Data is ranked in descending order." has to be "If not 0, Data is ranked in ascending order."||-||-||-|| | ||

|- | |- |

## Revision as of 19:17, 19 October 2008

## Examine Changes in Functions for ODFv1.2

This is a collection of the differences I found and what I know is already done or in progress. I also note, when I found problems in the draft spec itself. You are invited to add your observations. Regina 19:40, 10 October 2008 (CEST)

### Statistical Functions

Function | ODFv1.2 | CALC | Action | Progress | |
---|---|---|---|---|---|

BETADIST | Draft Spec misses faktor 1/(b-a) in densitiy case | not yet implemented | Inform Eike Rathke | - | |

Has density case and optional parameter, to choose between density and cumulative | not yet implemented | expand function to density case and additional parameter | tracked in Issue 91547 , function code is ready, finishing implementation depends on Issue 91602 | ||

BINOMDIST | Parameter C is integer with constraint to 0 and 1. It should be Logical than in other distributions | C=0 is density, all other values of C are treated as cumulative | - | - | |

LEGACY.CHIDIST | Returns 1 for x <0 | x < 0 returns Err:502 | expand domain to x < 0 internal | patch in Issue 94555 | |

CHISQDIST | density function and cumulative left tail of chi-square distribution | not yet implemented | prepare Implementation | patch in Issue 94555 | |

CHISQINV | inverse of CHISQDIST(...TRUE()) | not yet implemented | prepare Implementation | patch in Issue 94555 | |

EXPONDIST | Parameter Cumulative has type Logical and is optional. |
Last Parameter C has type Number and is not optional. C=0 returns denisity, other values for C return cumulative function. | - | - | |

FDIST | density function and cumulative left tail of F-distribution | not yet implemented | prepare for implementation | first draft, depends on BETADIST Issue 91547 | |

Name conflicts with actual FDIST, which calculates right tail. | get new UI-name | have brought problem to dev@sc | |||

FINV | inverse of new FDIST | not yet implemented | - | - | |

Name conflicts with actual FINV, which calculates inverse for right tail. | get new UI-name | - | |||

GAMMA | Parameter is constraint to >= 0 | Gamma is definied for all real numbers, but non-positive integers | Inform Eike Rathke | - | |

not yet implemented | prepare implementation using full domain. Add UI texts. | path in Issue 94555 | |||

is in subgroup Mathematical functions | will go to subgroup Statistical functions | - | - | ||

GAMMALN | is in subgroup Mathematical Functions | is in subgroup Statistical Functions | - | - | |

GAMMADIST | Last Parameter has type Logical | Last Parameter has type Number | Change type internal to bool. Change UI texts. | patch in Issue 94555 | |

Domain for Parameter x includes x < 0 | x < 0 returns Err:502 in OOo2.* | Change implementation | integrated in OOo3.0 | ||

GROWTH | Last parameter has type Logical (in Excel too) | Last parameter has type Number | - | - | |

is in subgroup Statistical Functions (in Excel too) | is in subgroup Array Functions | - | - | ||

HYPGEOMDIST | Optional, logical parameter to calculate "exact" or "at most" | no parameter, calculates always "exact" | - | - | |

INTERCEPT | Current, "Calculates the point at which a line will intersect the y-values by using known x-values and y-values." (BTW: That is literally from Excel help.) Problems:1. It calculates no point but a single value. 2. The line does not intersect the y-values but the y-axis. 3. It does not say, that the line is the linear regression of the known values. | - | - | - | |

NORMDIST | Last Parameter has type Logical and is optional | Last Parameter has type Number and is required | - | - | |

LEGACY.NORMSDIST | "This is exactly NORMDIST(x)." Should be "This is exactly NORMDIST(x;0;1)." because mean parameter and standard deviation parameter are not optional. | - | - | - | |

PERCENTRANK | It has an optional parameter Significance |
not yet implemented | - | - | |

PHI | Description is unclear. PHI(x)=NORMDIST(x;0;1;FALSE()). It is the density function of the standard normal distribution | - | - | - | |

POISSON | Parameter Cumulative has type Logical and is optional. |
Parameter 'C' is required. 'C'=0 is density function, all others are cumulative | - | - | |

QUARTILE | Example calculates with Quart=1.5 although there is a constraint INT(Quart)=Quart |
- | - | - | |

RANK | Description "If not 0, Data is ranked in descending order." has to be "If not 0, Data is ranked in ascending order." | - | - | - | |

TDIST | Draft spec shows the density function. | Calc (and Excel) evaluates the cumulative function. | Inform Eike Rathke | - | |

Functionname | ODF | Calc | Action | Progress |

### Other Functions

Function | ODFv1.2 | CALC | Action | Progress | |
---|---|---|---|---|---|

GCD | "Return the largest value that can be evenly divided (no remainder) into the given numbers." Should be "Return the largest value that can divide the given numbers evenly (no remainder)." | - | - | - | |

Functionname | ODF | Calc | Action | Progress |