summaryrefslogtreecommitdiffstats
diff options
context:
space:
mode:
authorAdolfo Jayme Barrientos <fitojb@ubuntu.com>2016-03-02 13:47:08 -0600
committerAdolfo Jayme Barrientos <fitojb@ubuntu.com>2016-03-02 13:47:08 -0600
commit3ceee913def605d1f2e4c42545b8b4a6d56a13aa (patch)
treec96f142a64606098faac89fdee2872b6066752a3
parentadd warning for case sensitivity and Excel interoperability (diff)
downloadhelp-3ceee913def605d1f2e4c42545b8b4a6d56a13aa.tar.gz
help-3ceee913def605d1f2e4c42545b8b4a6d56a13aa.zip
Minor tweaks to statistics help content
- Use “Choose” rather than “Menu” in menu paths for consistency - Remove the UI-only convention of using an ellipsis - Drop a linkless paragraph of “Refer to Wikipedia”, it’s useless if it doesn’t have a link - Now that we’re on Wikipedia links, refer to them more elegantly and add a dot to end the paragraph Change-Id: I6e3964b8926710cd57ee6750fddb039c2c846c34
-rw-r--r--source/text/scalc/01/02140700.xhp3
-rw-r--r--source/text/scalc/01/statistics.xhp42
2 files changed, 21 insertions, 24 deletions
diff --git a/source/text/scalc/01/02140700.xhp b/source/text/scalc/01/02140700.xhp
index 123bca5650..eee3aa0e3d 100644
--- a/source/text/scalc/01/02140700.xhp
+++ b/source/text/scalc/01/02140700.xhp
@@ -184,8 +184,5 @@
<paragraph id="par_id2308201415431822157" role="paragraph" xml-lang="en-US">Truncate the number to a given number of <emph>Decimal Places</emph>.</paragraph>
<paragraph id="hd_id2308201415431826506" role="heading" xml-lang="en-US" level="3">Decimal places</paragraph>
<paragraph id="par_id2308201415431820502" role="paragraph" xml-lang="en-US">Number of decimal places of the numbers generated.</paragraph>
-<section id="relatedtopics">
-<paragraph id="par_id230820141705438801" role="paragraph" xml-lang="en-US">For more information on the distributions, see the Wikipedia</paragraph>
-</section>
</body>
</helpdocument>
diff --git a/source/text/scalc/01/statistics.xhp b/source/text/scalc/01/statistics.xhp
index 1d143c9c0a..df5db95707 100644
--- a/source/text/scalc/01/statistics.xhp
+++ b/source/text/scalc/01/statistics.xhp
@@ -250,10 +250,10 @@
<paragraph id="hd_id1000050" role="heading" xml-lang="en-US" level="2">Descriptive Statistics</paragraph>
<paragraph id="par_id1000640" role="paragraph" xml-lang="en-US"><ahelp hid="modules/scalc/ui/descriptivestatisticsdialog/DescriptiveStatisticsDialog">Fill a table in the spreadsheet with the main statistical properties of the data set.</ahelp></paragraph>
<section id="howtoget">
-<paragraph id="par_id1000650" role="paragraph" xml-lang="en-US"><variable id="sam01">Menu <emph>Data - Statistics - Descriptive Statistics...</emph></variable></paragraph>
+<paragraph id="par_id1000650" role="paragraph" xml-lang="en-US"><variable id="sam01">Choose <emph>Data - Statistics - Descriptive Statistics</emph></variable></paragraph>
</section>
<paragraph id="par_id1000660" role="paragraph" xml-lang="en-US">The Descriptive Statistics analysis tool generates a report of univariate statistics for data in the input range, providing information about the central tendency and variability of your data.</paragraph>
-<paragraph id="par_id1000670" role="note" xml-lang="en-US">For more information, please visit the Wikipedia: <link href="http://en.wikipedia.org/wiki/Descriptive_statistics">http://en.wikipedia.org/wiki/Descriptive_statistics</link></paragraph><embed href="text/scalc/01/stat_data.xhp#data"/><embed href="text/scalc/01/stat_data.xhp#grouped"/><embed href="text/scalc/01/stat_data.xhp#sampledata01"/>
+<paragraph id="par_id1000670" role="note" xml-lang="en-US">For more information on descriptive statistics, refer to the <link href="http://en.wikipedia.org/wiki/Descriptive_statistics">corresponding Wikipedia article</link>.</paragraph><embed href="text/scalc/01/stat_data.xhp#data"/><embed href="text/scalc/01/stat_data.xhp#grouped"/><embed href="text/scalc/01/stat_data.xhp#sampledata01"/>
<paragraph id="par_id1000680" role="paragraph" xml-lang="en-US">The following table displays the results of the descriptive statistics of the sample data above.</paragraph>
<table id="Tabela4">
<tablerow>
@@ -466,10 +466,10 @@
<paragraph id="hd_id1000060" role="heading" xml-lang="en-US" level="2">Analysis of Variance (ANOVA)</paragraph>
<paragraph id="par_id1001240" role="paragraph" xml-lang="en-US"><ahelp hid="modules/scalc/ui/analysisofvariancedialog/AnalysisOfVarianceDialog">Produces the analysis of variance (ANOVA) of a given data set</ahelp></paragraph>
<section id="howtoget">
-<paragraph id="par_id1001250" role="paragraph" xml-lang="en-US"><variable id="sam01">Menu <emph>Data - Statistics - Analysis of Variance (ANOVA)...</emph></variable></paragraph>
+<paragraph id="par_id1001250" role="paragraph" xml-lang="en-US"><variable id="sam01">Choose <emph>Data - Statistics - Analysis of Variance (ANOVA)</emph></variable></paragraph>
</section>
-<paragraph id="par_id1001260" role="paragraph" xml-lang="en-US">ANOVA is the acronym for <emph>AN</emph>alysis <emph>O</emph>f <emph>VA</emph>riance. Produces the analysis of variance (ANOVA) of a given data set</paragraph>
-<paragraph id="par_id1001270" role="note" xml-lang="en-US">For more information, please visit the Wikipedia: <link href="http://en.wikipedia.org/wiki/ANOVA">http://en.wikipedia.org/wiki/ANOVA</link></paragraph><embed href="text/scalc/01/stat_data.xhp#data"/><embed href="text/scalc/01/stat_data.xhp#grouped"/>
+<paragraph id="par_id1001260" role="paragraph" xml-lang="en-US">ANOVA is the acronym for <emph>AN</emph>alysis <emph>O</emph>f <emph>VA</emph>riance. This tool produces the analysis of variance of a given data set</paragraph>
+<paragraph id="par_id1001270" role="note" xml-lang="en-US">For more information on ANOVA, refer to the <link href="http://en.wikipedia.org/wiki/ANOVA">corresponding Wikipedia article</link>.</paragraph><embed href="text/scalc/01/stat_data.xhp#data"/><embed href="text/scalc/01/stat_data.xhp#grouped"/>
<paragraph id="hd_id1000070" role="heading" xml-lang="en-US" level="3">Type</paragraph>
<paragraph id="par_id1001280" role="paragraph" xml-lang="en-US">Select if the analysis is for a <emph>single factor</emph> or for <emph>two factor</emph> ANOVA.</paragraph>
<paragraph id="hd_id1000080" role="heading" xml-lang="en-US" level="3">Parameters</paragraph>
@@ -700,12 +700,12 @@
<paragraph id="hd_id1000090" role="heading" xml-lang="en-US" level="2">Correlation</paragraph>
<paragraph id="par_id1001740" role="paragraph" xml-lang="en-US"><ahelp hid="modules/scalc/ui/correlationdialog/CorrelationDialog">Calculates the correlation of two sets of numeric data.</ahelp></paragraph>
<section id="howtoget">
-<paragraph id="par_id1001750" role="paragraph" xml-lang="en-US"><variable id="corr01">Menu <emph>Data - Statistics - Correlation...</emph></variable></paragraph>
+<paragraph id="par_id1001750" role="paragraph" xml-lang="en-US"><variable id="corr01">Choose <emph>Data - Statistics - Correlation</emph></variable></paragraph>
</section>
<paragraph id="par_id1001760" role="paragraph" xml-lang="en-US">The correlation coefficient (a value between -1 and +1) means how strongly two variables are related to each other. You can use the CORREL function or the Data Statistics to find the correlation coefficient between two variables.</paragraph>
<paragraph id="par_id1001770" role="paragraph" xml-lang="en-US">A correlation coefficient of +1 indicates a perfect positive correlation. </paragraph>
<paragraph id="par_id1001780" role="paragraph" xml-lang="en-US">A correlation coefficient of -1 indicates a perfect negative correlation</paragraph>
-<paragraph id="par_id1001790" role="note" xml-lang="en-US">For more information on statistical correlation, refer to <link href="http://en.wikipedia.org/wiki/Correlation">http://en.wikipedia.org/wiki/Correlation</link></paragraph><embed href="text/scalc/01/stat_data.xhp#data"/><embed href="text/scalc/01/stat_data.xhp#grouped"/><embed href="text/scalc/01/stat_data.xhp#sampledata01"/>
+<paragraph id="par_id1001790" role="note" xml-lang="en-US">For more information on statistical correlation, refer to the <link href="http://en.wikipedia.org/wiki/Correlation">corresponding Wikipedia article</link>.</paragraph><embed href="text/scalc/01/stat_data.xhp#data"/><embed href="text/scalc/01/stat_data.xhp#grouped"/><embed href="text/scalc/01/stat_data.xhp#sampledata01"/>
<paragraph id="par_id1001800" role="paragraph" xml-lang="en-US">The following table displays the results of the correlation of the sample data above.</paragraph>
<table id="Tabela6">
<tablerow>
@@ -774,10 +774,10 @@
<paragraph id="hd_id1000100" role="heading" xml-lang="en-US" level="2">Covariance</paragraph>
<paragraph id="par_id1001940" role="paragraph" xml-lang="en-US"><ahelp hid="modules/scalc/ui/covariancedialog/CovarianceDialog">Calculates the covariance of two sets of numeric data.</ahelp></paragraph>
<section id="howtoget">
-<paragraph id="par_id1001950" role="paragraph" xml-lang="en-US"><variable id="cov01">Menu <emph>Data - Statistics - Covariance...</emph></variable></paragraph>
+<paragraph id="par_id1001950" role="paragraph" xml-lang="en-US"><variable id="cov01">Choose <emph>Data - Statistics - Covariance</emph></variable></paragraph>
</section>
<paragraph id="par_id1001960" role="paragraph" xml-lang="en-US">The covariance is a measure of how much two random variables change together.</paragraph>
-<paragraph id="par_id1001970" role="note" xml-lang="en-US">For more information on statistical covariance, refer to <link href="http://en.wikipedia.org/wiki/Covariance">http://en.wikipedia.org/wiki/Covariance</link></paragraph><embed href="text/scalc/01/stat_data.xhp#data"/><embed href="text/scalc/01/stat_data.xhp#grouped"/><embed href="text/scalc/01/stat_data.xhp#sampledata01"/>
+<paragraph id="par_id1001970" role="note" xml-lang="en-US">For more information on statistical covariance, refer to the <link href="http://en.wikipedia.org/wiki/Covariance">corresponding Wikipedia article</link>.</paragraph><embed href="text/scalc/01/stat_data.xhp#data"/><embed href="text/scalc/01/stat_data.xhp#grouped"/><embed href="text/scalc/01/stat_data.xhp#sampledata01"/>
<paragraph id="par_id1001980" role="paragraph" xml-lang="en-US">The following table displays the results of the covariance of the sample data above.</paragraph>
<table id="Tabela7">
<tablerow>
@@ -846,10 +846,10 @@
<paragraph id="hd_id1000110" role="heading" xml-lang="en-US" level="2">Exponential Smoothing</paragraph>
<paragraph id="par_id1002120" role="paragraph" xml-lang="en-US"><ahelp hid="modules/scalc/ui/exponentialsmoothingdialog/ExponentialSmoothingDialog">Results in a smoothed data series</ahelp></paragraph>
<section id="howtoget">
-<paragraph id="par_id1002130" role="paragraph" xml-lang="en-US"><variable id="sam01">Menu <emph>Data - Statistics - Exponential Smoothing...</emph></variable></paragraph>
+<paragraph id="par_id1002130" role="paragraph" xml-lang="en-US"><variable id="sam01">Choose <emph>Data - Statistics - Exponential Smoothing</emph></variable></paragraph>
</section>
<paragraph id="par_id1002140" role="paragraph" xml-lang="en-US">Exponential smoothing is a filtering technique that when applied to a data set, produces smoothed results. It is employed in many domains such as stock market, economics and in sampled measurements.</paragraph>
-<paragraph id="par_id1002150" role="note" xml-lang="en-US">For more information on <emph>exponential smoothing</emph>, refer to <link href="http://en.wikipedia.org/wiki/Exponential_smoothing">http://en.wikipedia.org/wiki/Exponential_smoothing</link></paragraph><embed href="text/scalc/01/stat_data.xhp#data"/><embed href="text/scalc/01/stat_data.xhp#grouped"/>
+<paragraph id="par_id1002150" role="note" xml-lang="en-US">For more information on exponential smoothing, refer to the <link href="http://en.wikipedia.org/wiki/Exponential_smoothing">corresponding Wikipedia article</link>.</paragraph><embed href="text/scalc/01/stat_data.xhp#data"/><embed href="text/scalc/01/stat_data.xhp#grouped"/>
<paragraph id="hd_id1000120" role="heading" xml-lang="en-US" level="3">Parameters</paragraph>
<paragraph id="par_id1002160" role="paragraph" xml-lang="en-US"><emph>Smoothing Factor</emph>: A parameter between 0 and 1 that represents the damping factor Alpha in the smoothing equation.</paragraph><embed href="text/scalc/01/stat_data.xhp#timeseries01"/>
<paragraph id="par_id1002170" role="paragraph" xml-lang="en-US">The resulting smoothing is below with smoothing factor as 0.5:</paragraph>
@@ -1001,9 +1001,9 @@
<paragraph id="hd_id1000130" role="heading" xml-lang="en-US" level="2">Moving Average</paragraph>
<paragraph id="par_id1002500" role="paragraph" xml-lang="en-US"><ahelp hid="modules/scalc/ui/movingaveragedialog/MovingAverageDialog">Calculates the moving average of a time series</ahelp></paragraph>
<section id="howtoget">
-<paragraph id="par_id1002510" role="paragraph" xml-lang="en-US"><variable id="sam01">Menu <emph>Data - Statistics - Moving Average...</emph></variable></paragraph>
+<paragraph id="par_id1002510" role="paragraph" xml-lang="en-US"><variable id="sam01">Choose <emph>Data - Statistics - Moving Average</emph></variable></paragraph>
</section>
-<paragraph id="par_id1002520" role="note" xml-lang="en-US">You can get more details about moving average in the Wikipedia: <link href="http://en.wikipedia.org/wiki/Moving_average">http://en.wikipedia.org/wiki/Moving_average</link></paragraph><embed href="text/scalc/01/stat_data.xhp#data"/><embed href="text/scalc/01/stat_data.xhp#grouped"/>
+<paragraph id="par_id1002520" role="note" xml-lang="en-US">For more information on the moving average, refer to the <link href="http://en.wikipedia.org/wiki/Moving_average">corresponding Wikipedia article</link>.</paragraph><embed href="text/scalc/01/stat_data.xhp#data"/><embed href="text/scalc/01/stat_data.xhp#grouped"/>
<paragraph id="hd_id1000140" role="heading" xml-lang="en-US" level="3">Parameters</paragraph>
<paragraph id="par_id1002530" role="paragraph" xml-lang="en-US"><emph>Interval</emph>: The number of samples used in the moving average calculation.</paragraph><embed href="text/scalc/01/stat_data.xhp#timeseries01"/>
<paragraph id="hd_id1000171" role="heading" xml-lang="en-US" level="3">Results of the moving average:</paragraph>
@@ -1133,10 +1133,10 @@
<paragraph id="hd_id1000150" role="heading" xml-lang="en-US" level="2">t-test</paragraph>
<paragraph id="par_id1002820" role="paragraph" xml-lang="en-US"><ahelp hid="modules/scalc/ui/ttestdialog/TTestDialog">Calculates the t-Test of two data samples.</ahelp></paragraph>
<section id="howtoget">
-<paragraph id="par_id1002830" role="paragraph" xml-lang="en-US"><variable id="sam01">Menu <emph>Data - Statistics - t-test...</emph></variable></paragraph>
+<paragraph id="par_id1002830" role="paragraph" xml-lang="en-US"><variable id="sam01">Choose <emph>Data - Statistics - t-test</emph></variable></paragraph>
</section>
<paragraph id="par_id1002840" role="paragraph" xml-lang="en-US">A <emph>t-test</emph> is any statistical hypothesis test that follows a Student's t distribution.</paragraph>
-<paragraph id="par_id1002850" role="note" xml-lang="en-US">For more information on t-tests, see the Wikipedia: <link href="http://en.wikipedia.org/wiki/T-test">http://en.wikipedia.org/wiki/T-test</link></paragraph>
+<paragraph id="par_id1002850" role="note" xml-lang="en-US">For more information on t-tests, refer to the <link href="http://en.wikipedia.org/wiki/T-test">corresponding Wikipedia article</link>.</paragraph>
<paragraph id="hd_id1000160" role="heading" xml-lang="en-US" level="3">Data</paragraph>
<paragraph id="par_id1002860" role="paragraph" xml-lang="en-US"><emph>Variable 1 range</emph>: The reference of the range of the first data series to analyze.</paragraph>
<paragraph id="par_id1002870" role="paragraph" xml-lang="en-US"><emph>Variable 2 range</emph>: The reference of the range of the second data series to analyze.</paragraph>
@@ -1319,10 +1319,10 @@
<paragraph id="hd_id1000180" role="heading" xml-lang="en-US" level="2">F-test</paragraph>
<paragraph id="par_id1003240" role="paragraph" xml-lang="en-US"><ahelp hid="modules/scalc/ui/ttestdialog/TTestDialog">Calculates the F-Test of two data samples.</ahelp></paragraph>
<section id="howtoget">
-<paragraph id="par_id1003250" role="paragraph" xml-lang="en-US"><variable id="sam02">Menu <emph>Data - Statistics - F-test...</emph></variable></paragraph>
+<paragraph id="par_id1003250" role="paragraph" xml-lang="en-US"><variable id="sam02">Choose <emph>Data - Statistics - F-test</emph></variable></paragraph>
</section>
<paragraph id="par_id1003260" role="paragraph" xml-lang="en-US">A <emph>F-test</emph> is any statistical test based on the F-distribution under the null hypothesis.</paragraph>
-<paragraph id="par_id1003270" role="note" xml-lang="en-US">For more information on F-tests, see the Wikipedia: <link href="http://en.wikipedia.org/wiki/F-test">http://en.wikipedia.org/wiki/F-test</link></paragraph>
+<paragraph id="par_id1003270" role="note" xml-lang="en-US">For more information on F-tests, refer to the <link href="http://en.wikipedia.org/wiki/F-test">corresponding Wikipedia article</link>.</paragraph>
<paragraph id="hd_id1000190" role="heading" xml-lang="en-US" level="3">Data</paragraph>
<paragraph id="par_id1003280" role="paragraph" xml-lang="en-US"><emph>Variable 1 range</emph>: The reference of the range of the first data series to analyze.</paragraph>
<paragraph id="par_id1003290" role="paragraph" xml-lang="en-US"><emph>Variable 2 range</emph>: The reference of the range of the second data series to analyze.</paragraph>
@@ -1487,9 +1487,9 @@
<paragraph id="hd_id1000210" role="heading" xml-lang="en-US" level="2">Z-test</paragraph>
<paragraph id="par_id1003640" role="paragraph" xml-lang="en-US"><ahelp hid="modules/scalc/ui/ztestdialog/ZTestDialog">Calculates the z-Test of two data samples.</ahelp></paragraph>
<section id="howtoget">
-<paragraph id="par_id1003650" role="paragraph" xml-lang="en-US"><variable id="sam02">Menu <emph>Data - Statistics - Z-test...</emph></variable></paragraph>
+<paragraph id="par_id1003650" role="paragraph" xml-lang="en-US"><variable id="sam02">Choose <emph>Data - Statistics - Z-test</emph></variable></paragraph>
</section>
-<paragraph id="par_id1003660" role="note" xml-lang="en-US">For more information on Z-tests, see the Wikipedia: <link href="http://en.wikipedia.org/wiki/Z-test">http://en.wikipedia.org/wiki/Z-test</link></paragraph>
+<paragraph id="par_id1003660" role="note" xml-lang="en-US">For more information on Z-tests, refer to the <link href="http://en.wikipedia.org/wiki/Z-test">corresponding Wikipedia article</link>.</paragraph>
<paragraph id="hd_id1000220" role="heading" xml-lang="en-US" level="3">Data</paragraph>
<paragraph id="par_id1003670" role="paragraph" xml-lang="en-US"><emph>Variable 1 range</emph>: The reference of the range of the first data series to analyze.</paragraph>
<paragraph id="par_id1003680" role="paragraph" xml-lang="en-US"><emph>Variable 2 range</emph>: The reference of the range of the second data series to analyze.</paragraph>
@@ -1642,9 +1642,9 @@
<paragraph id="hd_id1000240" role="heading" xml-lang="en-US" level="2">Chi-square test</paragraph>
<paragraph id="par_id1003641" role="paragraph" xml-lang="en-US"><ahelp hid="modules/scalc/ui/chisquaretestdialog/ChiSquareTestDialog">Calculates the Chi-square test of a data sample.</ahelp></paragraph>
<section id="howtoget">
-<paragraph id="par_id1003990" role="paragraph" xml-lang="en-US"><variable id="sam02">Menu <emph>Data - Statistics - Chi-square Test...</emph></variable></paragraph>
+<paragraph id="par_id1003990" role="paragraph" xml-lang="en-US"><variable id="sam02">Choose <emph>Data - Statistics - Chi-square Test</emph></variable></paragraph>
</section>
-<paragraph id="par_id1004000" role="note" xml-lang="en-US">For more information on Chi-square tests, see the Wikipedia: <link href="http://en.wikipedia.org/wiki/Chi-square_test">http://en.wikipedia.org/wiki/Chi-square_test</link></paragraph>
+<paragraph id="par_id1004000" role="note" xml-lang="en-US">For more information on chi-square tests, refer to the <link href="http://en.wikipedia.org/wiki/Chi-square_test">corresponding Wikipedia article</link>.</paragraph>
<paragraph id="hd_id1000250" role="heading" xml-lang="en-US" level="3">Data</paragraph>
<paragraph id="par_id1004010" role="paragraph" xml-lang="en-US"><emph>Input range</emph>: The reference of the range of the data series to analyze.</paragraph>
<paragraph id="par_id1004020" role="paragraph" xml-lang="en-US"><emph>Results to</emph>: The reference of the top left cell of the range where the test will be displayed.</paragraph><embed href="text/scalc/01/stat_data.xhp#grouped"/><embed href="text/scalc/01/stat_data.xhp#datafortests"/>