From df2eefa2ce5e5db43df453ba1c2fb52abb88e08e Mon Sep 17 00:00:00 2001 From: Olivier Hallot Date: Thu, 21 Jan 2016 18:49:23 -0200 Subject: tdf#96868 Help page for data statistics regression Change-Id: I7c0e236c1d19572b682d5b6c120ce604f6e39de8 Reviewed-on: https://gerrit.libreoffice.org/22144 Reviewed-by: Olivier Hallot Tested-by: Olivier Hallot --- source/text/scalc/01/stat_data.xhp | 1184 +++++++++++++----------- source/text/scalc/01/statistics.xhp | 3 + source/text/scalc/01/statistics_regression.xhp | 327 +++++++ 3 files changed, 996 insertions(+), 518 deletions(-) create mode 100644 source/text/scalc/01/statistics_regression.xhp (limited to 'source') diff --git a/source/text/scalc/01/stat_data.xhp b/source/text/scalc/01/stat_data.xhp index 31e5611306..f11b62c861 100644 --- a/source/text/scalc/01/stat_data.xhp +++ b/source/text/scalc/01/stat_data.xhp @@ -1,4 +1,4 @@ - + +--> - -Data -/text/scalc/01/stat_data.xhp - + + Data + /text/scalc/01/stat_data.xhp + + + +
-Data + +Data Input Range: The reference of the range of the data to analyze. Results to: The reference of the top left cell of the range where the results will be displayed.
+
-Grouped By + +Grouped By Select whether the input data has columns or rows layout.
+
-Example + +Example The following data will be used as example + - - - - -A - - -B - - -C - - - - -1 - - -Maths - - -Physics - - -Biology - - - - -2 - - -47 - - -67 - - -33 - - - - -3 - - -36 - - -68 - - -42 - - - - -4 - - -40 - - -65 - - -44 - - - - -5 - - -39 - - -64 - - -60 - - - - -6 - - - - -38 - - -43 - - - - -7 - - -47 - - -84 - - -62 - - - - -8 - - -29 - - -80 - - -51 - - - - -9 - - -27 - - -49 - - -40 - - - - -10 - - -57 - - -49 - - -12 - - - - -11 - - -56 - - -33 - - -60 - - - - -12 - - -57 - - - - - - - - -13 - - -26 - - - - - - + + + + + A + + + B + + + C + + + + + 1 + + + Maths + + + Physics + + + Biology + + + + + 2 + + + 47 + + + 67 + + + 33 + + + + + 3 + + + 36 + + + 68 + + + 42 + + + + + 4 + + + 40 + + + 65 + + + 44 + + + + + 5 + + + 39 + + + 64 + + + 60 + + + + + 6 + + + + + 38 + + + 43 + + + + + 7 + + + 47 + + + 84 + + + 62 + + + + + 8 + + + 29 + + + 80 + + + 51 + + + + + 9 + + + 27 + + + 49 + + + 40 + + + + + 10 + + + 57 + + + 49 + + + 12 + + + + + 11 + + + 56 + + + 33 + + + 60 + + + + + 12 + + + 57 + + + + + + + + + 13 + + + 26 + + + + + +
+
+
-Example + +Example The following table has two time series, one representing an impulse function at time t=0 and the other an impulse function at time t=2. + - - - - -A - - -B - - - - -1 - - -1 - - -0 - - - - -2 - - -0 - - -0 - - - - -3 - - -0 - - -1 - - - - -4 - - -0 - - -0 - - - - -5 - - -0 - - -0 - - - - -6 - - -0 - - -0 - - - - -7 - - -0 - - -0 - - - - -8 - - -0 - - -0 - - - - -9 - - -0 - - -0 - - - - -10 - - -0 - - -0 - - - - -11 - - -0 - - -0 - - - - -12 - - -0 - - -0 - - - - -13 - - -0 - - -0 - - + + + + + A + + + B + + + + + 1 + + + 1 + + + 0 + + + + + 2 + + + 0 + + + 0 + + + + + 3 + + + 0 + + + 1 + + + + + 4 + + + 0 + + + 0 + + + + + 5 + + + 0 + + + 0 + + + + + 6 + + + 0 + + + 0 + + + + + 7 + + + 0 + + + 0 + + + + + 8 + + + 0 + + + 0 + + + + + 9 + + + 0 + + + 0 + + + + + 10 + + + 0 + + + 0 + + + + + 11 + + + 0 + + + 0 + + + + + 12 + + + 0 + + + 0 + + + + + 13 + + + 0 + + + 0 + +
+
-Example + +Example The following table has two data sets. + - - - - -A - - -B - - - - -1 - - -28 - - -19 - - - - -2 - - -26 - - -13 - - - - -3 - - -31 - - -12 - - - - -4 - - -23 - - -5 - - - - -5 - - -20 - - -34 - - - - -6 - - -27 - - -31 - - - - -7 - - -28 - - -31 - - - - -8 - - -14 - - -12 - - - - -9 - - -4 - - -24 - - - - -10 - - -0 - - -23 - - - - -11 - - -2 - - -19 - - - - -12 - - -8 - - -10 - - - - -13 - - -9 - - -33 - - + + + + + A + + + B + + + + + 1 + + + 28 + + + 19 + + + + + 2 + + + 26 + + + 13 + + + + + 3 + + + 31 + + + 12 + + + + + 4 + + + 23 + + + 5 + + + + + 5 + + + 20 + + + 34 + + + + + 6 + + + 27 + + + 31 + + + + + 7 + + + 28 + + + 31 + + + + + 8 + + + 14 + + + 12 + + + + + 9 + + + 4 + + + 24 + + + + + 10 + + + 0 + + + 23 + + + + + 11 + + + 2 + + + 19 + + + + + 12 + + + 8 + + + 10 + + + + + 13 + + + 9 + + + 33 + + +
+ +
+ +
+ +Example +The following table has samples of a physical phenomenon taken in 1 second interval. + + + + + + + A + + + B + + + + + 1 + + + Time + + + Measurement + + + + + 2 + + + 1 + + + 2.7 + + + + + 3 + + + 2 + + + 4.0 + + + + + 4 + + + 3 + + + 4.4 + + + + + 5 + + + 4 + + + 7.1 + + + + + 6 + + + 5 + + + 4.9 + + + + + 7 + + + 6 + + + 3.6 + + + + + 8 + + + 7 + + + 4.0 + + + + + 9 + + + 8 + + + 0.6 + + + + + 10 + + + 9 + + + 1.0 + + + + + 11 + + + 10 + + + 4.3 + +
- + + \ No newline at end of file diff --git a/source/text/scalc/01/statistics.xhp b/source/text/scalc/01/statistics.xhp index 5cdd15940c..bdea8206cc 100644 --- a/source/text/scalc/01/statistics.xhp +++ b/source/text/scalc/01/statistics.xhp @@ -1699,5 +1699,8 @@ +
+Regression Analysis +
diff --git a/source/text/scalc/01/statistics_regression.xhp b/source/text/scalc/01/statistics_regression.xhp new file mode 100644 index 0000000000..b6bf44b6ab --- /dev/null +++ b/source/text/scalc/01/statistics_regression.xhp @@ -0,0 +1,327 @@ + + + + + + + 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 + Data statistics;regression analysis + + + + +
+Menu Data - Statistics - Regression... +
+For more information, please visit the Wikipedia: http://en.wikipedia.org/wiki/Regression_analysis + + + +Output Regression Type +Set the regression type. Three types are available: + + + + Linear Regression: find a strait line in the form of y = a.x + b, where a is the slope and b is the intercept that best fits the data. + + + Logarithmic regression: find a logarithmic curve in the form of y = a.ln(x) + b, where a is the slope, b is the intercept and ln(x) is the natural logarithm of x, that best fits the data. + + + Power regression: Find a power curve in the form of y = a.x^b, where a is the slope, b is the intercept that best fits the data. + + +The results of the three types of regression analysis of the measurements in the table above are shown below. + + + + + Regression + + + + + + + + + + + + + + + + + + + + + Regression Model + + + Linear + + + Logarithmic + + + Power + + + + + R^2 + + + 0.1243901235 + + + 0.036283506 + + + 0.0884254697 + + + + + Standard Error + + + 1.8692568609 + + + 1.9610483597 + + + 0.7746321053 + + + + + + + + + + + + + + + Slope + + + -0.2193939394 + + + -0.4894112008 + + + 4.812672931 + + + + + Intercept + + + 4.8666666667 + + + 4.3992268695 + + + -0.3103085297 + + + + + + + + + + + + + + + 1 + + + 4.6472727273 + + + 4.3992268695 + + + 4.812672931 + + + + + 2 + + + 4.4278787879 + + + 4.0599928755 + + + 3.8812728356 + + + + + 3 + + + 4.2084848485 + + + 3.8615537101 + + + 3.4224061924 + + + + + 4 + + + 3.9890909091 + + + 3.7207588815 + + + 3.1301272785 + + + + + 5 + + + 3.7696969697 + + + 3.6115499281 + + + 2.9207204651 + + + + + 6 + + + 3.5503030303 + + + 3.5223197161 + + + 2.7600654308 + + + + + 7 + + + 3.3309090909 + + + 3.4468766468 + + + 2.6311476385 + + + + + 8 + + + 3.1115151515 + + + 3.3815248876 + + + 2.5243514679 + + + + + 9 + + + 2.8921212121 + + + 3.3238805506 + + + 2.4337544465 + + + + + 10 + + + 2.6727272727 + + + 3.2723159341 + + + 2.3554713075 + + +
+ + +
+ Sampling, Descriptive Statistics, Analysis of Variance (ANOVA), Correlation, Covariance, Exponential Smoothing, Moving Average, t-test, F-test, Z-test, Chi-square test. +
+
+ + + \ No newline at end of file -- cgit