diff options
| author | Daniel Baumann <daniel.baumann@progress-linux.org> | 2024-04-27 16:51:28 +0000 |
|---|---|---|
| committer | Daniel Baumann <daniel.baumann@progress-linux.org> | 2024-04-27 16:51:28 +0000 |
| commit | 940b4d1848e8c70ab7642901a68594e8016caffc (patch) | |
| tree | eb72f344ee6c3d9b80a7ecc079ea79e9fba8676d /helpcontent2/source/text/scalc/01/statistics_regression.xhp | |
| parent | Initial commit. (diff) | |
| download | libreoffice-940b4d1848e8c70ab7642901a68594e8016caffc.tar.xz libreoffice-940b4d1848e8c70ab7642901a68594e8016caffc.zip | |
Adding upstream version 1:7.0.4.upstream/1%7.0.4upstream
Signed-off-by: Daniel Baumann <daniel.baumann@progress-linux.org>
Diffstat (limited to 'helpcontent2/source/text/scalc/01/statistics_regression.xhp')
| -rw-r--r-- | helpcontent2/source/text/scalc/01/statistics_regression.xhp | 321 |
1 files changed, 321 insertions, 0 deletions
diff --git a/helpcontent2/source/text/scalc/01/statistics_regression.xhp b/helpcontent2/source/text/scalc/01/statistics_regression.xhp new file mode 100644 index 000000000..7be159b68 --- /dev/null +++ b/helpcontent2/source/text/scalc/01/statistics_regression.xhp @@ -0,0 +1,321 @@ +<?xml version="1.0" encoding="UTF-8"?> +<helpdocument version="1.0"> +<!-- + * This file is part of the LibreOffice project. + * + * This Source Code Form is subject to the terms of the Mozilla Public + * License, v. 2.0. If a copy of the MPL was not distributed with this + * file, You can obtain one at http://mozilla.org/MPL/2.0/. + * + * This file incorporates work covered by the following license notice: + * + * Licensed to the Apache Software Foundation (ASF) under one or more + * contributor license agreements. See the NOTICE file distributed + * with this work for additional information regarding copyright + * ownership. The ASF licenses this file to you under the Apache + * License, Version 2.0 (the "License"); you may not use this file + * except in compliance with the License. You may obtain a copy of + * the License at http://www.apache.org/licenses/LICENSE-2.0 . +--> + +<meta> + <topic id="regressiontopic" indexer="include" status="PUBLISH"> + <title id="tit" xml-lang="en-US">Regression Analysis</title> + <filename>/text/scalc/01/statistics_regression.xhp</filename> + </topic> +</meta> +<body> +<bookmark xml-lang="en-US" branch="index" id="bm_id2764278"> +<bookmark_value>Analysis toolpack;regression analysis</bookmark_value> +<bookmark_value>regression analysis;Analysis toolpack</bookmark_value> +<bookmark_value>Data statistics;regression analysis</bookmark_value> +</bookmark> + +<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/regressiondialog/RegressionDialog" id="bm_id2745673" localize="false"/> +<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/regressiondialog/@@nowidget@@" id="bm_id2745673" localize="false"/> +<section id="regression"> +<h1 id="hd_id1701201615033510"><variable id="regressionanalysish1"><link href="text/scalc/01/statistics_regression.xhp" name="regression analysis">Regression Analysis</link></variable></h1> +<paragraph id="par_id1001240" role="paragraph" xml-lang="en-US"><ahelp hid="modules/scalc/ui/regressiondialog/RegressionDialog">Produces the regression analysis of a data set</ahelp></paragraph> +</section> + +<section id="howtoget"> +<paragraph id="par_id1000040" role="paragraph" xml-lang="en-US"><variable id="sam01">Choose <menuitem>Data - Statistics - Regression</menuitem></variable></paragraph> +</section> +<paragraph id="par_id1001270" role="note" xml-lang="en-US">For more information on regression analysis, refer to the <link href="https://en.wikipedia.org/wiki/Regression_analysis" name="English Wikipedia: Regression analysis">corresponding Wikipedia article</link>.</paragraph> +<embed href="text/scalc/01/stat_data.xhp#data"/> +<embed href="text/scalc/01/stat_data.xhp#grouped"/> + +<h2 id="hd_id1000070">Output Regression Type</h2> +<paragraph id="par_id1001280" role="paragraph" xml-lang="en-US">Set the regression type. Three types are available: </paragraph> + +<list type="unordered"> + <listitem> + <paragraph id="par_id1701201620334364" role="ul_item" xml-lang="en-US"><emph>Linear Regression</emph>: find a straight line in the form of <item type="literal">y = a.x + b</item>, where <item type="literal">a</item> is the slope and <item type="literal">b</item> is the intercept that best fits the data.</paragraph> + </listitem> + <listitem> + <paragraph id="par_id1701201620340168" role="ul_item" xml-lang="en-US"><emph>Logarithmic regression</emph>: find a logarithmic curve in the form of <item type="literal">y = a.ln(x) + b</item>, where <item type="literal">a</item> is the slope, <item type="literal">b</item> is the intercept and <item type="literal">ln(x)</item> is the natural logarithm of <item type="literal">x</item>, that best fits the data.</paragraph> + </listitem> + <listitem> + <paragraph id="par_id1701201620340139" role="ul_item" xml-lang="en-US"><emph>Power regression</emph>: Find a power curve in the form of <item type="literal">y = a.x^b</item>, where <item type="literal">a</item> is the coefficient, <item type="literal">b</item> is the power that best fits the data.</paragraph> + </listitem></list> +<embed href="text/scalc/01/stat_data.xhp#regressiondata"/> +<paragraph id="par_id1001310" role="paragraph" xml-lang="en-US">The results of the three types of <emph>regression analysis</emph> of the measurements in the table above are shown below.</paragraph> + +<table id="Tabela1"> + <tablerow> + <tablecell> + <paragraph id="par_id1701201618090526" role="tablehead" xml-lang="en-US">Regression</paragraph> + </tablecell> + <tablecell> + </tablecell> + <tablecell> + </tablecell> + <tablecell> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + </tablecell> + <tablecell> + </tablecell> + <tablecell> + </tablecell> + <tablecell> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph id="par_id1701201618090542" role="paragraph" xml-lang="en-US">Regression Model</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id1701201618090596" role="paragraph" xml-lang="en-US">Linear</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id1701201618090586" role="paragraph" xml-lang="en-US">Logarithmic</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id1701201618090555" role="paragraph" xml-lang="en-US">Power</paragraph> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph id="par_id1701201618090553" role="paragraph" xml-lang="en-US">R^2</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id1901201615114385" role="paragraph" localize="false" xml-lang="en-US">0.1243901235</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id1901201615114339" role="paragraph" localize="false" xml-lang="en-US">0.036283506</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id1901201615114321" role="paragraph" localize="false" xml-lang="en-US">0.0884254697</paragraph> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph id="par_id1701201618090595" role="paragraph" xml-lang="en-US">Standard Error</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id1901201615114322" role="paragraph" localize="false" xml-lang="en-US">1.8692568609</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id1901201615114330" role="paragraph" localize="false" xml-lang="en-US">1.9610483597</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id1901201615114373" role="paragraph" localize="false" xml-lang="en-US">0.7746321053</paragraph> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + </tablecell> + <tablecell> + </tablecell> + <tablecell> + </tablecell> + <tablecell> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph id="par_id1701201618090563" role="paragraph" xml-lang="en-US">Slope</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id19012061511466" role="paragraph" localize="false" xml-lang="en-US">-0.2193939394</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id1901201615114648" role="paragraph" localize="false" xml-lang="en-US">-0.4894112008</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id1901201615114619" role="paragraph" localize="false" xml-lang="en-US">4.812672931</paragraph> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph id="par_id1701201618090642" role="paragraph" xml-lang="en-US">Intercept</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id1901201615114679" role="paragraph" localize="false" xml-lang="en-US">4.8666666667</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id190120165114664" role="paragraph" localize="false" xml-lang="en-US">4.3992268695</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id190101615114697" role="paragraph" localize="false" xml-lang="en-US">-0.3103085297</paragraph> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + </tablecell> + <tablecell> + </tablecell> + <tablecell> + </tablecell> + <tablecell> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph id="par_id190120161511461" role="paragraph" localize="false" xml-lang="en-US">1</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id1901201615114631" role="paragraph" localize="false" xml-lang="en-US">4.6472727273</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id1901201615114663" role="paragraph" localize="false" xml-lang="en-US">4.3992268695</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id19012016151142" role="paragraph" localize="false" xml-lang="en-US">4.812672931</paragraph> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph id="par_id1901201615114687" role="paragraph" localize="false" xml-lang="en-US">2</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id1901201615114677" role="paragraph" localize="false" xml-lang="en-US">4.4278787879</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id1901201615114693" role="paragraph" localize="false" xml-lang="en-US">4.0599928755</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id1901201615114630" role="paragraph" localize="false" xml-lang="en-US">3.8812728356</paragraph> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph id="par_id1901201615114697" role="paragraph" localize="false" xml-lang="en-US">3</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id1901201615114659" role="paragraph" localize="false" xml-lang="en-US">4.2084848485</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id1901201615114671" role="paragraph" localize="false" xml-lang="en-US">3.8615537101</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id1901201615114664" role="paragraph" localize="false" xml-lang="en-US">3.4224061924</paragraph> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph id="par_id190120161511463" role="paragraph" localize="false" xml-lang="en-US">4</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id190120161511462" role="paragraph" localize="false" xml-lang="en-US">3.9890909091</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id190120161511466" role="paragraph" localize="false" xml-lang="en-US">3.7207588815</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id1901201615114649" role="paragraph" localize="false" xml-lang="en-US">3.1301272785</paragraph> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph id="par_id1901201615114699" role="paragraph" localize="false" xml-lang="en-US">5</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id1901201615114635" role="paragraph" localize="false" xml-lang="en-US">3.7696969697</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id1901201615114716" role="paragraph" localize="false" xml-lang="en-US">3.6115499281</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id1901201615114792" role="paragraph" localize="false" xml-lang="en-US">2.9207204651</paragraph> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph id="par_id1901201615114711" role="paragraph" localize="false" xml-lang="en-US">6</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id1901201615114718" role="paragraph" localize="false" xml-lang="en-US">3.5503030303</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id1901201615114732" role="paragraph" localize="false" xml-lang="en-US">3.5223197161</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id1901201615114775" role="paragraph" localize="false" xml-lang="en-US">2.7600654308</paragraph> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph id="par_id1901201615114712" role="paragraph" localize="false" xml-lang="en-US">7</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id190120161511476" role="paragraph" localize="false" xml-lang="en-US">3.3309090909</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id1901201615114710" role="paragraph" localize="false" xml-lang="en-US">3.4468766468</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id1901201615117" role="paragraph" localize="false" xml-lang="en-US">2.6311476385</paragraph> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph id="par_id1901201615114767" role="paragraph" localize="false" xml-lang="en-US">8</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id1901201615114753" role="paragraph" localize="false" xml-lang="en-US">3.1115151515</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id19012016151147" role="paragraph" localize="false" xml-lang="en-US">3.3815248876</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id1901201615114720" role="paragraph" localize="false" xml-lang="en-US">2.5243514679</paragraph> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph id="par_id1901201615114746" role="paragraph" localize="false" xml-lang="en-US">9</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id1901201615114725" role="paragraph" localize="false" xml-lang="en-US">2.8921212121</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id1901201615114758" role="paragraph" localize="false" xml-lang="en-US">3.3238805506</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id1901201615114773" role="paragraph" localize="false" xml-lang="en-US">2.4337544465</paragraph> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph id="par_id1901201615114789" role="paragraph" localize="false" xml-lang="en-US">10</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id190120161114720" role="paragraph" localize="false" xml-lang="en-US">2.6727272727</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id1901201615114738" role="paragraph" localize="false" xml-lang="en-US">3.2723159341</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id1901201615114798" role="paragraph" localize="false" xml-lang="en-US">2.3554713075</paragraph> + </tablecell> + </tablerow> +</table> +<section id="relatedtopics"> +<embed href="text/scalc/01/stat_data.xhp#otherstat"/> +</section> +</body> +</helpdocument> |