Bug#588471: openoffice.org-calc: mayer chart (statistique) wrong results
Package: openoffice.org-calc
Version: 1:3.2.0-4~bpo50+1
Severity: normal
I'm start to use statistic in my school, my teacher said me my result are wrong
I show him My result and surprise he confirm OpenOffice Wrong Result for the exercice !
Ms Office works well, and manual resolution confirme Ms office result.
look the array below
0 1 2 4 6 10
76 67 59 46 35 20
Insert diagramme based on that data
Choose the lines one
- 0, 1, 2, 4 on the bottom chart's
- 0 to 80 on the left
right-click on the shape to choose 'Inserez une coube de valeur moyenne' (Yes it's the french version)
(i don't know the english sentense)
and check-in :
- Afficher l'équation
- Aficher le coeficient de détermination (R2)
You'll see :
- f(x)= -11,1142[...]+89,4
- R2=0.989
_BUT_
- f(x) sould be -5.5[....] + 71,80
- the shape does not cross the ordinate (Oy) at ~17,8 or 89,9 but approximatively at 86 !
(i can join en screen-copy or my sheet, i don't know if it's possible here)
-- System Information:
Debian Release: 5.0.4
APT prefers proposed-updates
APT policy: (500, 'proposed-updates'), (500, 'stable'), (90, 'unstable'), (90, 'testing')
Architecture: i386 (i686)
Kernel: Linux 2.6.26-2-686 (SMP w/1 CPU core)
Locale: LANG=fr_FR.UTF-8, LC_CTYPE=fr_FR.UTF-8 (charmap=UTF-8)
Shell: /bin/sh linked to /bin/bash
Versions of packages openoffice.org-calc depends on:
ii libc6 2.10.2-6 Embedded GNU C Library: Shared lib
ii libgcc1 1:4.3.2-1.1 GCC support library
ii libstdc++6 4.3.2-1.1 The GNU Standard C++ Library v3
ii libstlport4.6ld 4.6.2-3.2 STLport C++ class library
ii lp-solve 5.5.0.10-10 Solve (mixed integer) linear progr
ii openoffice.org- 1:3.2.0-4~bpo50+1 full-featured office productivity
ii openoffice.org- 1:3.2.0-4~bpo50+1 full-featured office productivity
ii ure 1.6.0+OOo3.2.0-4~bpo50+1 OpenOffice.org UNO runtime environ
openoffice.org-calc recommends no packages.
openoffice.org-calc suggests no packages.
Versions of packages openoffice.org-core depends on:
ii fontconfig 2.6.0-3 generic font configuration library
ii libc6 2.10.2-6 Embedded GNU C Library: Shared lib
ii libcairo2 1.8.8-2 The Cairo 2D vector graphics libra
ii libcurl3 7.18.2-8lenny4 Multi-protocol file transfer libra
ii libdb4.6 4.6.21-11 Berkeley v4.6 Database Libraries [
ii libexpat1 2.0.1-4+lenny3 XML parsing C library - runtime li
ii libfreetype6 2.3.7-2+lenny1 FreeType 2 font engine, shared lib
ii libgcc1 1:4.3.2-1.1 GCC support library
ii libglib2.0-0 2.24.0-1 The GLib library of C routines
ii libgraphite3 1:2.2.1-2.1 SILGraphite - a "smart font" rende
ii libgstreamer-pl 0.10.26-1~bpo50+1 GStreamer libraries from the "base
ii libgstreamer0.1 0.10.26-1~bpo50+1 Core GStreamer libraries and eleme
ii libgtk2.0-0 2.18.6-1~bpo50+1 The GTK+ graphical user interface
ii libhunspell-1.2 1.2.6-1 spell checker and morphological an
ii libhyphen0 2.4-4 ALTLinux hyphenation library - sha
ii libice6 2:1.0.4-1 X11 Inter-Client Exchange library
ii libjpeg62 6b-14 The Independent JPEG Group's JPEG
ii libneon27-gnutl 0.28.2-6.1 An HTTP and WebDAV client library
ii libnspr4-0d 4.7.1-5 NetScape Portable Runtime Library
ii libnss3-1d 3.12.3.1-0lenny1 Network Security Service libraries
ii libsm6 2:1.0.3-2 X11 Session Management library
ii libssl0.9.8 0.9.8g-15+lenny6 SSL shared libraries
ii libstdc++6 4.3.2-1.1 The GNU Standard C++ Library v3
ii libstlport4.6ld 4.6.2-3.2 STLport C++ class library
ii libx11-6 2:1.1.5-2 X11 client-side library
ii libxaw7 2:1.0.4-2 X11 Athena Widget library
ii libxext6 2:1.0.4-2 X11 miscellaneous extension librar
ii libxinerama1 2:1.0.3-2 X11 Xinerama extension library
ii libxml2 2.7.6.dfsg-2+b1 GNOME XML library
ii libxrandr2 2:1.2.3-1 X11 RandR extension library
ii libxrender1 1:0.9.4-2 X Rendering Extension client libra
ii libxslt1.1 1.1.26-2 XSLT processing library - runtime
ii libxt6 1:1.0.5-3 X11 toolkit intrinsics library
ii libxtst6 2:1.0.3-1 X11 Testing -- Resource extension
ii openoffice.org- 1:3.2.0-4~bpo50+1 full-featured office productivity
ii ttf-opensymbol 1:3.2.0-4~bpo50+1 OpenSymbol TrueType font
ii ure 1.6.0+OOo3.2.0-4~bpo50+1 OpenOffice.org UNO runtime environ
ii zlib1g 1:1.2.3.3.dfsg-12 compression library - runtime
-- no debconf information
Reply to: