[Libreoffice-bugs] [Bug 132983] New: LibreOffice.calc data|statistics|z-test repeated results
bugzilla-daemon at bugs.documentfoundation.org
bugzilla-daemon at bugs.documentfoundation.org
Tue May 12 16:15:08 UTC 2020
https://bugs.documentfoundation.org/show_bug.cgi?id=132983
Bug ID: 132983
Summary: LibreOffice.calc data|statistics|z-test repeated
results
Product: LibreOffice
Version: 6.4.2.2 release
Hardware: x86-64 (AMD64)
OS: Windows (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: libreoffice-bugs at lists.freedesktop.org
Reporter: jfwpublic at gmx.com
Description:
Air Quality data, two sites with identical latitude and longitude. testing data
from 2007 to 2020 by year to compare reported readings. Used t-pair and as
number of readings each year exceeds 30 also using z-test.
Steps to Reproduce:
1.highlight the two columns of data eg all rows where year in 2008
2.select data|statistics|z-test
3.enter destination cell and enter
4. save the file after each year
Actual Results:
z #DIV/0!
z-test
Alpha 0.05
Hypothesised Mean Difference 0
Variable 1 Variable 2
Known Variance 0 0
Mean 17.2256168965517 18.5240762068965
Observations 290 290
Observed Mean Difference -1.29845931034482
differs according to year
P (Z<=z) one-tail #DIV/0!
z Critical one-tail 1.64485362695147
P (Z<=z) two-tail #DIV/0!
z Critical two-tail 1.95996398454005
repeats for all years
Expected Results:
?
Not able to manually calculate. Do not have minitab, matlab, R etc.
Reproducible: Always
User Profile Reset: No
Additional Info:
Version: 6.4.2.2 (x64)
Build ID: 4e471d8c02c9c90f512f7f9ead8875b57fcb1ec3
CPU threads: 2; OS: Windows 10.0 Build 18362; UI render: default; VCL: win;
Locale: en-GB (en_GB); UI-Language: en-GB
Calc: threaded
the *.ods file attached as the data is in the public domain.
raw data in *.csv file as hourly readings extracted from airqualityengland.
loaded into a database, code (object pascal) to determine daily
quartile,mean,stddev, SQL to "select" data for the two sites by date, by
pollutant, copied data into calc
--
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20200512/c45c6a8b/attachment-0001.htm>
More information about the Libreoffice-bugs
mailing list