[Libreoffice-bugs] [Bug 132983] New: LibreOffice.calc data|statistics|z-test repeated results

[bugzilla-daemon at bugs.documentfoundation.org]

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>