+ +

The following data will be used as example diff --git a/source/text/scalc/01/statistics.xhp b/source/text/scalc/01/statistics.xhp index e48774db3e..a81feab1b9 100644 --- a/source/text/scalc/01/statistics.xhp +++ b/source/text/scalc/01/statistics.xhp @@ -19,1707 +19,31 @@ --> - + Data Statistics in Calc /text/scalc/01/statistics.xhp -Data Statistics in Calc -Use the data statistics in Calc to perform complex data analysis -To work on a complex statistical or engineering analysis, you can save steps and time by using Calc Data Statistics. You provide the data and parameters for each analysis, and the set of tools uses the appropriate statistical or engineering functions to calculate and display the results in an output table. -

- -Analysis toolpack;sampling -sampling;Analysis toolpack -Data statistics;sampling - - - -Sampling -Create a table with data sampled from another table. -

-Choose Data - Statistics - Sampling -

-Sampling allows you to pick data from a source table to fill a target table. The sampling can be random or in a periodic basis. -Sampling is done row-wise. That means, the sampled data will pick the whole line of the source table and copy into a line of the target table.

-Sampling Method -Random: Picks exactly Sample Size lines of the source table in a random way. -Sample size: Number of lines sampled from the source table. -Periodic: Picks lines in a pace defined by Period. -Period: the number of lines to skip periodically when sampling. -

-The following data will be used as example of source data table for sampling: - - - - - -A - - -B - - -C - - - - -1 - - -11 - - -21 - - -31 - - - - -2 - - -12 - - -22 - - -32 - - - - -3 - - -13 - - -23 - - -33 - - - - -4 - - -14 - - -24 - - -34 - - - - -5 - - -15 - - -25 - - -35 - - - - -6 - - -16 - - -26 - - -36 - - - - -7 - - -17 - - -27 - - -37 - - - - -8 - - -18 - - -28 - - -38 - - - - -9 - - -19 - - -29 - - -39 - - -

- -Sampling with a period of 2 will result in the following table: - - - -12 - - -22 - - -32 - - - - -14 - - -24 - - -34 - - - - -16 - - -26 - - -36 - - - - -18 - - -28 - - -38 - - -

- -

- -Analysis toolpack;descriptive statistics -descriptive statistics;Analysis toolpack -Data statistics;descriptive statistics - - - -Descriptive Statistics -Fill a table in the spreadsheet with the main statistical properties of the data set. -

-Choose Data - Statistics - Descriptive Statistics -

-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. -For more information on descriptive statistics, refer to the corresponding Wikipedia article.

-The following table displays the results of the descriptive statistics of the sample data above. - - - - - -Column 1 - - -Column 2 - - -Column 3 - - - - -Mean - - -41.9090909091 - - -59.7 - - -44.7 - - - - -Standard Error - - -3.5610380138 - - -5.3583786934 - - -4.7680650629 - - - - -Mode - - -47 - - -49 - - -60 - - - - -Median - - -40 - - -64.5 - - -43.5 - - - - -Variance - - -139.4909090909 - - -287.1222222222 - - -227.3444444444 - - - - -Standard Deviation - - -11.8106269559 - - -16.944681237 - - -15.0779456308 - - - - -Kurtosis - - --1.4621677981 - - --0.9415988746 - - -1.418052719 - - - - -Skewness - - -0.0152409533 - - --0.2226426904 - - --0.9766803373 - - - - -Range - - -31 - - -51 - - -50 - - - - -Minimum - - -26 - - -33 - - -12 - - - - -Maximum - - -57 - - -84 - - -62 - - - - -Sum - - -461 - - -597 - - -447 - - - - -Count - - -11 - - -10 - - -10 - - -

- -Analysis toolpack;analysis of variance -Analysis toolpack;ANOVA -analysis of variance;Analysis toolpack -ANOVA;Analysis toolpack -Data statistics;analysis of variance -Data statistics;ANOVA - - - -Analysis of Variance (ANOVA) -Produces the analysis of variance (ANOVA) of a given data set -

-Choose Data - Statistics - Analysis of Variance (ANOVA) -

-ANOVA is the acronym for ANalysis Of VAriance. This tool produces the analysis of variance of a given data set -For more information on ANOVA, refer to the corresponding Wikipedia article.

-Type -Select if the analysis is for a single factor or for two factor ANOVA. -Parameters -Alpha: the level of significance of the test. -Rows per sample: Define how many rows a sample has.

-The following table displays the results of the analysis of variance (ANOVA) of the sample data above. - - - -ANOVA - Single Factor - - - - - - - - - - - - - - -Alpha - - -0.05 - - - - - - - - - - - - - - - - - - - - - - - - - - -Groups - - -Count - - -Sum - - -Mean - - -Variance - - - - - - -Column 1 - - -11 - - -461 - - -41.9090909091 - - -139.4909090909 - - - - - - -Column 2 - - -10 - - -597 - - -59.7 - - -287.1222222222 - - - - - - -Column 3 - - -10 - - -447 - - -44.7 - - -227.3444444444 - - - - - - - - - - - - - - - - - - - - -Source of Variation - - -SS - - -df - - -MS - - -F - - -P-value - - -F-critical - - - - -Between Groups - - -1876.5683284457 - - -2 - - -938.2841642229 - - -4.3604117704 - - -0.0224614952 - - -3.340385558 - - - - -Within Groups - - -6025.1090909091 - - -28 - - -215.1824675325 - - - - - - - - -Total - - -7901.6774193548 - - -30 - - - - - - - - -

- -

- -Analysis toolpack;correlation -correlation;Analysis toolpack -Data statistics;correlation - - - -Correlation -Calculates the correlation of two sets of numeric data. -

-Choose Data - Statistics - Correlation -

-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. -A correlation coefficient of +1 indicates a perfect positive correlation. -A correlation coefficient of -1 indicates a perfect negative correlation -For more information on statistical correlation, refer to the corresponding Wikipedia article.

-The following table displays the results of the correlation of the sample data above. - - - -Correlations - - -Column 1 - - -Column 2 - - -Column 3 - - - - -Column 1 - - -1 - - - - - - - - -Column 2 - - --0.4029254917 - - -1 - - - - - - -Column 3 - - --0.2107642836 - - -0.2309714048 - - -1 - - -

- -

- -Analysis toolpack;covariance -covariance;Analysis toolpack -Data statistics;covariance - - - -Covariance -Calculates the covariance of two sets of numeric data. -

-Choose Data - Statistics - Covariance -

-The covariance is a measure of how much two random variables change together. -For more information on statistical covariance, refer to the corresponding Wikipedia article.

-The following table displays the results of the covariance of the sample data above. - - - -Covariances - - -Column 1 - - -Column 2 - - -Column 3 - - - - -Column 1 - - -126.8099173554 - - - - - - - - -Column 2 - - --61.4444444444 - - -258.41 - - - - - - -Column 3 - - --32 - - -53.11 - - -204.61 - - -

- -

- -Analysis toolpack;exponential smoothing -exponential smoothing;Analysis toolpack -Data statistics;exponential smoothing - - - -Exponential Smoothing -Results in a smoothed data series -

-Choose Data - Statistics - Exponential Smoothing -

-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. -For more information on exponential smoothing, refer to the corresponding Wikipedia article.

-Parameters -Smoothing Factor: A parameter between 0 and 1 that represents the damping factor Alpha in the smoothing equation.

-The resulting smoothing is below with smoothing factor as 0.5: - - - -Alpha - - - - - - -0.5 - - - - - - -Column 1 - - -Column 2 - - - - -1 - - -0 - - - - -1 - - -0 - - - - -0.5 - - -0 - - - - -0.25 - - -0.5 - - - - -0.125 - - -0.25 - - - - -0.0625 - - -0.125 - - - - -0.03125 - - -0.0625 - - - - -0.015625 - - -0.03125 - - - - -0.0078125 - - -0.015625 - - - - -0.00390625 - - -0.0078125 - - - - -0.001953125 - - -0.00390625 - - - - -0.0009765625 - - -0.001953125 - - - - -0.0004882813 - - -0.0009765625 - - - - -0.0002441406 - - -0.0004882813 - - -

Statistics

+Use the data statistics in Calc to perform complex data analysis

- -Analysis toolpack;moving average -moving average;Analysis toolpack -Data statistics;moving average - - - -Moving Average -Calculates the moving average of a time series -

-Choose Data - Statistics - Moving Average -

-For more information on the moving average, refer to the corresponding Wikipedia article.

-Parameters -Interval: The number of samples used in the moving average calculation.

-Results of the moving average: - - - -Column 1 - - -Column 2 - - - - -#N/A - - -#N/A - - - - -0.3333333333 - - -0.3333333333 - - - - -0 - - -0.3333333333 - - - - -0 - - -0.3333333333 - - - - -0 - - -0 - - - - -0 - - -0 - - - - -0 - - -0 - - - - -0 - - -0 - - - - -0 - - -0 - - - - -0 - - -0 - - - - -0 - - -0 - - - - -0 - - -0 - - - - -#N/A - - -#N/A - - -

- -

- -Analysis toolpack;t-test -Analysis toolpack;paired t-test -t-test;Analysis toolpack -paired t-test;Analysis toolpack -Data statistics;paired t-test - - - -Paired t-test -Calculates the paired t-Test of two data samples. -

-Choose Data - Statistics - Paired t-test -

-A paired t-test is any statistical hypothesis test that follows a Student's t distribution. -For more information on paired t-tests, refer to the corresponding Wikipedia article. -Data -Variable 1 range: The reference of the range of the first data series to analyze. -Variable 2 range: The reference of the range of the second data series to analyze. -Results to: The reference of the top left cell of the range where the test will be displayed.

-Results for paired t-test: -The following table shows the paired t-test for the data series above: - - - -paired t-test - - - - - - - - -Alpha - - -0.05 - - - - - - -Hypothesized Mean Difference - - -0 - - - - - - - - -Variable 1 - - -Variable 2 - - - - -Mean - - -16.9230769231 - - -20.4615384615 - - - - -Variance - - -125.0769230769 - - -94.4358974359 - - - - -Observations - - -13 - - -13 - - - - -Pearson Correlation - - --0.0617539772 - - - - - - -Observed Mean Difference - - --3.5384615385 - - - - - - -Variance of the Differences - - -232.9358974359 - - - - - - -df - - -12 - - - - - - -t Stat - - --0.8359262137 - - - - - - -P (T<=t) one-tail - - -0.2097651442 - - - - - - -t Critical one-tail - - -1.7822875556 - - - - - - -P (T<=t) two-tail - - -0.4195302884 - - - - - - -t Critical two-tail - - -2.1788128297 - - - - -

- -

- -Analysis toolpack;F-test -F-test;Analysis toolpack -Data statistics;F-test - - - -F-test -Calculates the F-Test of two data samples. -

-Choose Data - Statistics - F-test -

-A F-test is any statistical test based on the F-distribution under the null hypothesis. -For more information on F-tests, refer to the corresponding Wikipedia article. -Data -Variable 1 range: The reference of the range of the first data series to analyze. -Variable 2 range: The reference of the range of the second data series to analyze. -Results to: The reference of the top left cell of the range where the test will be displayed.

-Results for F-Test: -The following table shows the F-Test for the data series above: - - - -Ftest - - - - - - - - -Alpha - - -0.05 - - - - - - - - -Variable 1 - - -Variable 2 - - - - -Mean - - -16.9230769231 - - -20.4615384615 - - - - -Variance - - -125.0769230769 - - -94.4358974359 - - - - -Observations - - -13 - - -13 - - - - -df - - -12 - - -12 - - - - -F - - -1.3244637524 - - - - - - -P (F<=f) right-tail - - -0.3170614146 - - - - - - -F Critical right-tail - - -2.6866371125 - - - - - - -P (F<=f) left-tail - - -0.6829385854 - - - - - - -F Critical left-tail - - -0.3722125312 - - - - - - -P two-tail - - -0.6341228293 - - - - - - -F Critical two-tail - - -0.3051313549 - - -3.277277094 - - -

- -

- -Analysis toolpack;Z-test -Z-test;Analysis toolpack -Data statistics;Z-test - - - -Z-test -Calculates the z-Test of two data samples. -

-Choose Data - Statistics - Z-test -

-For more information on Z-tests, refer to the corresponding Wikipedia article. -Data -Variable 1 range: The reference of the range of the first data series to analyze. -Variable 2 range: The reference of the range of the second data series to analyze. -Results to: The reference of the top left cell of the range where the test will be displayed.

-Results for z-Test: -The following table shows the z-Test for the data series above: - - - -z-test - - - - - - - - -Alpha - - -0.05 - - - - - - -Hypothesized Mean Difference - - -0 - - - - - - - - -Variable 1 - - -Variable 2 - - - - -Known Variance - - -0 - - -0 - - - - -Mean - - -16.9230769231 - - -20.4615384615 - - - - -Observations - - -13 - - -13 - - - - -Observed Mean Difference - - --3.5384615385 - - - - - - -z - - -#DIV/0! - - - - - - -P (Z<=z) one-tail - - -#DIV/0! - - - - - - -z Critical one-tail - - -1.644853627 - - - - - - -P (Z<=z) two-tail - - -#DIV/0! - - - - - - -z Critical two-tail - - -1.9599639845 - - - - -

- -Analysis toolpack;Chi-square test -Chi-square test;Analysis toolpack -Data statistics;Chi-square test - - - -

Chi-square test

-Calculates the Chi-square test of a data sample. -

-Choose Data - Statistics - Chi-square Test -

-For more information on chi-square tests, refer to the corresponding Wikipedia article. -

-Results for Chi-square Test: - - - -Test of Independence (Chi-Square) - - - - - - -Alpha - - -0.05 - - - - -df - - -12 - - - - -P-value - - -2.32567054678584E-014 - - - - -Test Statistic - - -91.6870055842 - - - - -Critical Value - - -21.0260698175 - - -

-Regression Analysis -

+To work on a complex statistical or engineering analysis, you can save steps and time by using Calc Data Statistics. You provide the data and parameters for each analysis, and the set of tools uses the appropriate statistical or engineering functions to calculate and display the results in an output table. +

diff --git a/source/text/scalc/01/statistics_anova.xhp b/source/text/scalc/01/statistics_anova.xhp new file mode 100644 index 0000000000..7f135330f7 --- /dev/null +++ b/source/text/scalc/01/statistics_anova.xhp @@ -0,0 +1,271 @@ + + + + + + +ANOVA +/text/scalc/01/statistics_anova.xhp + + + + +Analysis toolpack;analysis of variance +Analysis toolpack;ANOVA +analysis of variance;Analysis toolpack +ANOVA;Analysis toolpack +Data statistics;analysis of variance +Data statistics;ANOVA + + + +

Analysis of Variance (ANOVA)

+Produces the analysis of variance (ANOVA) of a given data set +

+Choose Data - Statistics - Analysis of Variance (ANOVA) +

+ANOVA is the acronym for ANalysis Of VAriance. This tool produces the analysis of variance of a given data set +For more information on ANOVA, refer to the corresponding Wikipedia article. +

Type

+Select if the analysis is for a single factor or for two factor ANOVA. +

Parameters

+Alpha: the level of significance of the test. +Rows per sample: Define how many rows a sample has. + +

+ +The following table displays the results of the analysis of variance (ANOVA) of the sample data above. + + + +ANOVA - Single Factor + + + + + + + + + + + + + + +Alpha + + +0.05 + + + + + + + + + + + + + + + + + + + + + + + + + + +Groups + + +Count + + +Sum + + +Mean + + +Variance + + + + + + +Column 1 + + +11 + + +461 + + +41.9090909091 + + +139.4909090909 + + + + + + +Column 2 + + +10 + + +597 + + +59.7 + + +287.1222222222 + + + + + + +Column 3 + + +10 + + +447 + + +44.7 + + +227.3444444444 + + + + + + + + + + + + + + + + + + + + +Source of Variation + + +SS + + +df + + +MS + + +F + + +P-value + + +F-critical + + + + +Between Groups + + +1876.5683284457 + + +2 + + +938.2841642229 + + +4.3604117704 + + +0.0224614952 + + +3.340385558 + + + + +Within Groups + + +6025.1090909091 + + +28 + + +215.1824675325 + + + + + + + + +Total + + +7901.6774193548 + + +30 + + + + + + + + +

+ + diff --git a/source/text/scalc/01/statistics_correlation.xhp b/source/text/scalc/01/statistics_correlation.xhp new file mode 100644 index 0000000000..43b1b5d5d1 --- /dev/null +++ b/source/text/scalc/01/statistics_correlation.xhp @@ -0,0 +1,101 @@ + + + + + + +Data Correlation in Calc +/text/scalc/01/statistics_correlation.xhp + + + + + +Analysis toolpack;correlation +correlation;Analysis toolpack +Data statistics;correlation + + + +

Correlation

+Calculates the correlation of two sets of numeric data. +

+Choose Data - Statistics - Correlation +

+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. +A correlation coefficient of +1 indicates a perfect positive correlation. +A correlation coefficient of -1 indicates a perfect negative correlation +For more information on statistical correlation, refer to the corresponding Wikipedia article. +

+The following table displays the results of the correlation of the sample data above. + + + +Correlations + + +Column 1 + + +Column 2 + + +Column 3 + + + + +Column 1 + + +1 + + + + + + + + +Column 2 + + +-0.4029254917 + + +1 + + + + + + +Column 3 + + +-0.2107642836 + + +0.2309714048 + + +1 + + +

+ + diff --git a/source/text/scalc/01/statistics_covariance.xhp b/source/text/scalc/01/statistics_covariance.xhp new file mode 100644 index 0000000000..b2b4d1d96c --- /dev/null +++ b/source/text/scalc/01/statistics_covariance.xhp @@ -0,0 +1,97 @@ + + + + + + +Data Covariance in Calc +/text/scalc/01/statistics_covariance.xhp + + + + +Analysis toolpack;covariance +covariance;Analysis toolpack +Data statistics;covariance + + + +

Covariance

+Calculates the covariance of two sets of numeric data. +

+Choose Data - Statistics - Covariance +

+The covariance is a measure of how much two random variables change together. +For more information on statistical covariance, refer to the corresponding Wikipedia article. +

+The following table displays the results of the covariance of the sample data above. + + + +Covariances + + +Column 1 + + +Column 2 + + +Column 3 + + + + +Column 1 + + +126.8099173554 + + + + + + + + +Column 2 + + +-61.4444444444 + + +258.41 + + + + + + +Column 3 + + +-32 + + +53.11 + + +204.61 + + +

+ + diff --git a/source/text/scalc/01/statistics_descriptive.xhp b/source/text/scalc/01/statistics_descriptive.xhp new file mode 100644 index 0000000000..ac0c94da04 --- /dev/null +++ b/source/text/scalc/01/statistics_descriptive.xhp @@ -0,0 +1,240 @@ + + + + + + +Descriptive Statistics in Calc +/text/scalc/01/statistics_descriptive.xhp + + + + + +Analysis toolpack;descriptive statistics +descriptive statistics;Analysis toolpack +Data statistics;descriptive statistics + + + +

Descriptive Statistics

+Fill a table in the spreadsheet with the main statistical properties of the data set. +

+Choose Data - Statistics - Descriptive Statistics +

+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. +For more information on descriptive statistics, refer to the corresponding Wikipedia article. +

+The following table displays the results of the descriptive statistics of the sample data above. + + + + + +Column 1 + + +Column 2 + + +Column 3 + + + + +Mean + + +41.9090909091 + + +59.7 + + +44.7 + + + + +Standard Error + + +3.5610380138 + + +5.3583786934 + + +4.7680650629 + + + + +Mode + + +47 + + +49 + + +60 + + + + +Median + + +40 + + +64.5 + + +43.5 + + + + +Variance + + +139.4909090909 + + +287.1222222222 + + +227.3444444444 + + + + +Standard Deviation + + +11.8106269559 + + +16.944681237 + + +15.0779456308 + + + + +Kurtosis + + +-1.4621677981 + + +-0.9415988746 + + +1.418052719 + + + + +Skewness + + +0.0152409533 + + +-0.2226426904 + + +-0.9766803373 + + + + +Range + + +31 + + +51 + + +50 + + + + +Minimum + + +26 + + +33 + + +12 + + + + +Maximum + + +57 + + +84 + + +62 + + + + +Sum + + +461 + + +597 + + +447 + + + + +Count + + +11 + + +10 + + +10 + + +

+ + diff --git a/source/text/scalc/01/statistics_exposmooth.xhp b/source/text/scalc/01/statistics_exposmooth.xhp new file mode 100644 index 0000000000..4ff6a3e1fe --- /dev/null +++ b/source/text/scalc/01/statistics_exposmooth.xhp @@ -0,0 +1,177 @@ + + + + + + +Exponential Smoothing in Calc +/text/scalc/01/statistics_exposmooth.xhp + + + + +Analysis toolpack;exponential smoothing +exponential smoothing;Analysis toolpack +Data statistics;exponential smoothing + + + +

Exponential Smoothing

+Results in a smoothed data series +

+Choose Data - Statistics - Exponential Smoothing +

+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. +For more information on exponential smoothing, refer to the corresponding Wikipedia article.

Parameters

+Smoothing Factor: A parameter between 0 and 1 that represents the damping factor Alpha in the smoothing equation.

+The resulting smoothing is below with smoothing factor as 0.5: + + + +Alpha + + + + + + +0.5 + + + + + + +Column 1 + + +Column 2 + + + + +1 + + +0 + + + + +1 + + +0 + + + + +0.5 + + +0 + + + + +0.25 + + +0.5 + + + + +0.125 + + +0.25 + + + + +0.0625 + + +0.125 + + + + +0.03125 + + +0.0625 + + + + +0.015625 + + +0.03125 + + + + +0.0078125 + + +0.015625 + + + + +0.00390625 + + +0.0078125 + + + + +0.001953125 + + +0.00390625 + + + + +0.0009765625 + + +0.001953125 + + + + +0.0004882813 + + +0.0009765625 + + + + +0.0002441406 + + +0.0004882813 + + +

+ + diff --git a/source/text/scalc/01/statistics_fourier.xhp b/source/text/scalc/01/statistics_fourier.xhp index 383cb88576..34d0b635d6 100644 --- a/source/text/scalc/01/statistics_fourier.xhp +++ b/source/text/scalc/01/statistics_fourier.xhp @@ -19,18 +19,18 @@ - -

Fourier Analysis

- Produces the Fourier analysis of a data set by computing the Discrete Fourier Transform (DFT) of an input array of complex numbers using a couple of Fast Fourier Transform (FFT) algorithms. - -

Analysis toolpack;Fourier analysis Fourier analysis;Analysis toolpack Data statistics;Fourier analysis + +

Fourier Analysis

+ Produces the Fourier analysis of a data set by computing the Discrete Fourier Transform (DFT) of an input array of complex numbers using a couple of Fast Fourier Transform (FFT) algorithms. +

- Choose Data - Statistics - Fourier Analysis + Choose Data - Statistics - Fourier Analysis

For more information on Fourier analysis, refer to the corresponding Wikipedia article. @@ -645,12 +645,8 @@ - -

- Sampling, Descriptive Statistics, Analysis of Variance (ANOVA), Correlation, Covariance, Exponential Smoothing, Moving Average, Paired t-test, F-test, Z-test, Chi-square test. -

diff --git a/source/text/scalc/01/statistics_movingavg.xhp b/source/text/scalc/01/statistics_movingavg.xhp new file mode 100644 index 0000000000..1a9faf27e3 --- /dev/null +++ b/source/text/scalc/01/statistics_movingavg.xhp @@ -0,0 +1,155 @@ + + + + + + +Moving Average in Calc +/text/scalc/01/statistics_movingavg.xhp + + + + + +Analysis toolpack;moving average +moving average;Analysis toolpack +Data statistics;moving average + + + +

Moving Average

+Calculates the moving average of a time series +

+Choose Data - Statistics - Moving Average +

+For more information on the moving average, refer to the corresponding Wikipedia article.

Parameters

+Interval: The number of samples used in the moving average calculation.

Results of the moving average:

+ + + +Column 1 + + +Column 2 + + + + +#N/A + + +#N/A + + + + +0.3333333333 + + +0.3333333333 + + + + +0 + + +0.3333333333 + + + + +0 + + +0.3333333333 + + + + +0 + + +0 + + + + +0 + + +0 + + + + +0 + + +0 + + + + +0 + + +0 + + + + +0 + + +0 + + + + +0 + + +0 + + + + +0 + + +0 + + + + +0 + + +0 + + + + +#N/A + + +#N/A + + +

+ + diff --git a/source/text/scalc/01/statistics_regression.xhp b/source/text/scalc/01/statistics_regression.xhp index 456dad892d..7be159b68a 100644 --- a/source/text/scalc/01/statistics_regression.xhp +++ b/source/text/scalc/01/statistics_regression.xhp @@ -19,17 +19,12 @@ --> - + Regression Analysis /text/scalc/01/statistics_regression.xhp - - -

Regression Analysis

-Produces the regression analysis of a data set - Analysis toolpack;regression analysis regression analysis;Analysis toolpack @@ -38,15 +33,19 @@ +

Regression Analysis

+Produces the regression analysis of a data set +

-Choose Data - Statistics - Regression +Choose Data - Statistics - Regression

For more information on regression analysis, refer to the corresponding Wikipedia article.

-Output Regression Type +

Output Regression Type

Set the regression type. Three types are available: @@ -315,10 +314,8 @@ -

- Sampling, Descriptive Statistics, Analysis of Variance (ANOVA), Correlation, Covariance, Exponential Smoothing, Moving Average, Paired t-test, F-test, Z-test, Chi-square test. +

diff --git a/source/text/scalc/01/statistics_sampling.xhp b/source/text/scalc/01/statistics_sampling.xhp new file mode 100644 index 0000000000..219efe1844 --- /dev/null +++ b/source/text/scalc/01/statistics_sampling.xhp @@ -0,0 +1,234 @@ + + + + + + +Data Sampling in Calc +/text/scalc/01/statistics_sampling.xhp + + + + +Analysis toolpack;sampling +sampling;Analysis toolpack +Data statistics;sampling + + + +

Sampling

+Create a table with data sampled from another table. +

+Choose Data - Statistics - Sampling +

+Sampling allows you to pick data from a source table to fill a target table. The sampling can be random or in a periodic basis. +Sampling is done row-wise. That means, the sampled data will pick the whole line of the source table and copy into a line of the target table.

Sampling Method

+Random: Picks exactly Sample Size lines of the source table in a random way. +Sample size: Number of lines sampled from the source table. +Periodic: Picks lines in a pace defined by Period. +Period: the number of lines to skip periodically when sampling. +

+The following data will be used as example of source data table for sampling: + + + + + +A + + +B + + +C + + + + +1 + + +11 + + +21 + + +31 + + + + +2 + + +12 + + +22 + + +32 + + + + +3 + + +13 + + +23 + + +33 + + + + +4 + + +14 + + +24 + + +34 + + + + +5 + + +15 + + +25 + + +35 + + + + +6 + + +16 + + +26 + + +36 + + + + +7 + + +17 + + +27 + + +37 + + + + +8 + + +18 + + +28 + + +38 + + + + +9 + + +19 + + +29 + + +39 + + +

+ +Sampling with a period of 2 will result in the following table: + + + +12 + + +22 + + +32 + + + + +14 + + +24 + + +34 + + + + +16 + + +26 + + +36 + + + + +18 + + +28 + + +38 + + +

+ + diff --git a/source/text/scalc/01/statistics_test_chisqr.xhp b/source/text/scalc/01/statistics_test_chisqr.xhp new file mode 100644 index 0000000000..04052f5470 --- /dev/null +++ b/source/text/scalc/01/statistics_test_chisqr.xhp @@ -0,0 +1,91 @@ + + + + + + +Chi Square Statistics in Calc +/text/scalc/01/statistics_test_chisqr.xhp + + + + +Analysis toolpack;Chi-square test +Chi-square test;Analysis toolpack +Data statistics;Chi-square test + + + +

Chi-square test

+Calculates the Chi-square test of a data sample. +

+Choose Data - Statistics - Chi-square Test +

+For more information on chi-square tests, refer to the corresponding Wikipedia article. +

Results for Chi-square Test:

+ + + +Test of Independence (Chi-Square) + + + + + + +Alpha + + +0.05 + + + + +df + + +12 + + + + +P-value + + +2.32567054678584E-014 + + + + +Test Statistic + + +91.6870055842 + + + + +Critical Value + + +21.0260698175 + + +

+ + diff --git a/source/text/scalc/01/statistics_test_f.xhp b/source/text/scalc/01/statistics_test_f.xhp new file mode 100644 index 0000000000..1fdc54d469 --- /dev/null +++ b/source/text/scalc/01/statistics_test_f.xhp @@ -0,0 +1,191 @@ + + + + + + +F Test Statistics in Calc +/text/scalc/01/statistics_test_f.xhp + + + + + +Analysis toolpack;F-test +F-test;Analysis toolpack +Data statistics;F-test + + + +

F-test

+Calculates the F-Test of two data samples. +

+Choose Data - Statistics - F-test +

+A F-test is any statistical test based on the F-distribution under the null hypothesis. +For more information on F-tests, refer to the corresponding Wikipedia article. +

Data

+Variable 1 range: The reference of the range of the first data series to analyze. +Variable 2 range: The reference of the range of the second data series to analyze. +Results to: The reference of the top left cell of the range where the test will be displayed.

Results for F-Test:

+The following table shows the F-Test for the data series above: + + + +Ftest + + + + + + + + +Alpha + + +0.05 + + + + + + + + +Variable 1 + + +Variable 2 + + + + +Mean + + +16.9230769231 + + +20.4615384615 + + + + +Variance + + +125.0769230769 + + +94.4358974359 + + + + +Observations + + +13 + + +13 + + + + +df + + +12 + + +12 + + + + +F + + +1.3244637524 + + + + + + +P (F<=f) right-tail + + +0.3170614146 + + + + + + +F Critical right-tail + + +2.6866371125 + + + + + + +P (F<=f) left-tail + + +0.6829385854 + + + + + + +F Critical left-tail + + +0.3722125312 + + + + + + +P two-tail + + +0.6341228293 + + + + + + +F Critical two-tail + + +0.3051313549 + + +3.277277094 + + +

+ + diff --git a/source/text/scalc/01/statistics_test_t.xhp b/source/text/scalc/01/statistics_test_t.xhp new file mode 100644 index 0000000000..6a013e6a5d --- /dev/null +++ b/source/text/scalc/01/statistics_test_t.xhp @@ -0,0 +1,211 @@ + + + + + + +T Test Statistics in Calc +/text/scalc/01/statistics_test_t.xhp + + + + + +Analysis toolpack;t-test +Analysis toolpack;paired t-test +t-test;Analysis toolpack +paired t-test;Analysis toolpack +Data statistics;paired t-test + + + +

Paired t-test

+Calculates the paired t-Test of two data samples. +

+Choose Data - Statistics - Paired t-test +

+A paired t-test is any statistical hypothesis test that follows a Student's t distribution. +For more information on paired t-tests, refer to the corresponding Wikipedia article. +

Data

Results for paired t-test:

+The following table shows the paired t-test for the data series above: + + + +paired t-test + + + + + + + + +Alpha + + +0.05 + + + + + + +Hypothesized Mean Difference + + +0 + + + + + + + + +Variable 1 + + +Variable 2 + + + + +Mean + + +16.9230769231 + + +20.4615384615 + + + + +Variance + + +125.0769230769 + + +94.4358974359 + + + + +Observations + + +13 + + +13 + + + + +Pearson Correlation + + +-0.0617539772 + + + + + + +Observed Mean Difference + + +-3.5384615385 + + + + + + +Variance of the Differences + + +232.9358974359 + + + + + + +df + + +12 + + + + + + +t Stat + + +-0.8359262137 + + + + + + +P (T<=t) one-tail + + +0.2097651442 + + + + + + +t Critical one-tail + + +1.7822875556 + + + + + + +P (T<=t) two-tail + + +0.4195302884 + + + + + + +t Critical two-tail + + +2.1788128297 + + + + +

+ + diff --git a/source/text/scalc/01/statistics_test_z.xhp b/source/text/scalc/01/statistics_test_z.xhp new file mode 100644 index 0000000000..b54ba44fd5 --- /dev/null +++ b/source/text/scalc/01/statistics_test_z.xhp @@ -0,0 +1,188 @@ + + + + + + +Z Test Statistics in Calc +/text/scalc/01/statistics_test_z.xhp + + + + + +Analysis toolpack;Z-test +Z-test;Analysis toolpack +Data statistics;Z-test + + + +

Z-test

+Calculates the z-Test of two data samples. +

+Choose Data - Statistics - Z-test +

+For more information on Z-tests, refer to the corresponding Wikipedia article. +

Data

Results for z-Test:

+The following table shows the z-Test for the data series above: + + + +z-test + + + + + + + + +Alpha + + +0.05 + + + + + + +Hypothesized Mean Difference + + +0 + + + + + + + + +Variable 1 + + +Variable 2 + + + + +Known Variance + + +0 + + +0 + + + + +Mean + + +16.9230769231 + + +20.4615384615 + + + + +Observations + + +13 + + +13 + + + + +Observed Mean Difference + + +-3.5384615385 + + + + + + +z + + +#DIV/0! + + + + + + +P (Z<=z) one-tail + + +#DIV/0! + + + + + + +z Critical one-tail + + +1.644853627 + + + + + + +P (Z<=z) two-tail + + +#DIV/0! + + + + + + +z Critical two-tail + + +1.9599639845 + + + + +

+ + diff --git a/source/text/scalc/main0112.xhp b/source/text/scalc/main0112.xhp index 77725a3257..c46aab32cf 100644 --- a/source/text/scalc/main0112.xhp +++ b/source/text/scalc/main0112.xhp @@ -48,6 +48,7 @@

-- cgit