<html>
<body>
<div style="font-family: Verdana, Arial, Helvetica, Sans-Serif;">
<table bgcolor="#f9f3c9" width="100%" cellpadding="8" style="border: 1px #c9c399 solid;">
<tr>
<td>
This is an automatically generated e-mail. To reply, visit:
<a href="http://git.reviewboard.kde.org/r/112123/">http://git.reviewboard.kde.org/r/112123/</a>
</td>
</tr>
</table>
<br />
<blockquote style="margin-left: 1em; border-left: 2px solid #d0d0d0; padding-left: 10px;">
<p style="margin-top: 0;">On August 16th, 2013, 5:41 p.m. UTC, <b>Burkhard Lück</b> wrote:</p>
<blockquote style="margin-left: 1em; border-left: 2px solid #d0d0d0; padding-left: 10px;">
<table width="100%" border="0" bgcolor="white" style="border: 1px solid #C0C0C0; border-collapse: collapse; margin: 2px padding: 2px;">
<thead>
<tr>
<th colspan="4" bgcolor="#F0F0F0" style="border-bottom: 1px solid #C0C0C0; font-size: 9pt; padding: 4px 8px; text-align: left;">
<a href="http://git.reviewboard.kde.org/r/112123/diff/1/?file=181484#file181484line1479" style="color: black; font-weight: bold; text-decoration: underline;">sheets/functions/statistical.xml</a>
<span style="font-weight: normal;">
(Diff revision 1)
</span>
</th>
</tr>
</thead>
<tbody>
<tr>
<th bgcolor="#e9eaa8" style="border-right: 1px solid #C0C0C0;" align="right"><font size="2">1479</font></th>
<td bgcolor="#fdfebc" width="50%"><pre style="font-size: 8pt; line-height: 140%; margin: 0; "> <Text>The TTEST() function calculates the probability of a t-test.</Text></pre></td>
<th bgcolor="#e9eaa8" style="border-left: 1px solid #C0C0C0; border-right: 1px solid #C0C0C0;" align="right"><font size="2">1479</font></th>
<td bgcolor="#fdfebc" width="50%"><pre style="font-size: 8pt; line-height: 140%; margin: 0; "> <Text>The TTEST() function calculates the probability of a t-test given two ranges of data to compare. A t-test compares two sets of data and establishes the likelihood that any difference between the two is down to some variable having an effect, or whether it is simply due to chance variation. For example, given two sets of data, one containing the speed at which 30 tall people can run and the other containing the speed at which 30 short people can run, a t-test can tell you how likely it is that any speed difference between the groups of people is due to their height. Paired tests (type = 1) are only suitable when you have a value in each data set drawn from the same source (i.e. each source of data has provided an item in the first data range and an item in the second data range). In the running speed example, this is impossible as one person cannot be both short and tall: each person can only provide data for one group or the other. In such cases, where the values in each data set are drawn from different sources, an unpaired t-test is appropriate (type = 2 or type = 3). For unpaired t-tests, the two data ranges need not be equally sized; for paired t-tests the two ranges are required to contain the same number of cells. The mode parameter is used to indicate whether you require the difference between the two data sets to be in a specific direction or not. For example, if we are predicting that tall people will be able to run faster than short people, we would use a one-tailed test (mode = 1); however, if we are predicting that one group will be able to run faster than the other but not which one will actually be fastest, we would use a two-tailed test (mode = 2).</Text></pre></td>
</tr>
</tbody>
</table>
<pre style="white-space: pre-wrap; white-space: -moz-pre-wrap; white-space: -pre-wrap; white-space: -o-pre-wrap; word-wrap: break-word;">Using several <Text> blocks (e.g. short summary, then one block for each mode) would imho make it better readable.</pre>
</blockquote>
</blockquote>
<pre style="margin-left: 1em; white-space: pre-wrap; white-space: -moz-pre-wrap; white-space: -pre-wrap; white-space: -o-pre-wrap; word-wrap: break-word;">Thanks, I agree but wasn't sure it was valid. I'll do this and update.</pre>
<br />
<p>- Darren</p>
<br />
<p>On August 16th, 2013, 3:47 p.m. UTC, Darren Edale wrote:</p>
<table bgcolor="#fefadf" width="100%" cellspacing="0" cellpadding="8" style="background-image: url('http://git.reviewboard.kde.org/static/rb/images/review_request_box_top_bg.ab6f3b1072c9.png'); background-position: left top; background-repeat: repeat-x; border: 1px black solid;">
<tr>
<td>
<div>Review request for Calligra.</div>
<div>By Darren Edale.</div>
<p style="color: grey;"><i>Updated Aug. 16, 2013, 3:47 p.m.</i></p>
<h1 style="color: #575012; font-size: 10pt; margin-top: 1.5em;">Description </h1>
<table width="100%" bgcolor="#ffffff" cellspacing="0" cellpadding="10" style="border: 1px solid #b8b5a0">
<tr>
<td>
<pre style="margin: 0; padding: 0; white-space: pre-wrap; white-space: -moz-pre-wrap; white-space: -pre-wrap; white-space: -o-pre-wrap; word-wrap: break-word;">Added a more comprehensive help text for the TTEST() function (for the Sheets function wizard etc.) in sheets/functions/statistical.xml.</pre>
</td>
</tr>
</table>
<h1 style="color: #575012; font-size: 10pt; margin-top: 1.5em;">Diffs</b> </h1>
<ul style="margin-left: 3em; padding-left: 0;">
<li>sheets/functions/statistical.xml <span style="color: grey">(bea7d05a23799ac6aa139f2721602148afea4b93)</span></li>
</ul>
<p><a href="http://git.reviewboard.kde.org/r/112123/diff/" style="margin-left: 3em;">View Diff</a></p>
</td>
</tr>
</table>
</div>
</body>
</html>