<html>
<head>
<base href="https://bugs.documentfoundation.org/">
</head>
<body><table border="1" cellspacing="0" cellpadding="8">
<tr>
<th>Bug ID</th>
<td><a class="bz_bug_link
bz_status_UNCONFIRMED "
title="UNCONFIRMED - LibreOffice.calc data|statistics|z-test repeated results"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=132983">132983</a>
</td>
</tr>
<tr>
<th>Summary</th>
<td>LibreOffice.calc data|statistics|z-test repeated results
</td>
</tr>
<tr>
<th>Product</th>
<td>LibreOffice
</td>
</tr>
<tr>
<th>Version</th>
<td>6.4.2.2 release
</td>
</tr>
<tr>
<th>Hardware</th>
<td>x86-64 (AMD64)
</td>
</tr>
<tr>
<th>OS</th>
<td>Windows (All)
</td>
</tr>
<tr>
<th>Status</th>
<td>UNCONFIRMED
</td>
</tr>
<tr>
<th>Severity</th>
<td>normal
</td>
</tr>
<tr>
<th>Priority</th>
<td>medium
</td>
</tr>
<tr>
<th>Component</th>
<td>Calc
</td>
</tr>
<tr>
<th>Assignee</th>
<td>libreoffice-bugs@lists.freedesktop.org
</td>
</tr>
<tr>
<th>Reporter</th>
<td>jfwpublic@gmx.com
</td>
</tr></table>
<p>
<div>
<pre>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</pre>
</div>
</p>
<hr>
<span>You are receiving this mail because:</span>
<ul>
<li>You are the assignee for the bug.</li>
</ul>
</body>
</html>