https://neowiki.neooffice.org/index.php?title=Computing_and_Graphing_a_Regression_Line&action=history&feed=atom
Computing and Graphing a Regression Line - Revision history
2024-03-29T00:51:03Z
Revision history for this page on the wiki
MediaWiki 1.10.1
https://neowiki.neooffice.org/index.php?title=Computing_and_Graphing_a_Regression_Line&diff=10971&oldid=prev
Lorinda: /* Graphing the linear regression line */ Remove NeoOfficeFr category
2007-06-18T01:13:46Z
<p><span class="autocomment">Graphing the linear regression line -</span> Remove NeoOfficeFr category</p>
<table border='0' width='98%' cellpadding='0' cellspacing='4' style="background-color: white;">
<tr>
<td colspan='2' width='50%' align='center' style="background-color: white;">←Older revision</td>
<td colspan='2' width='50%' align='center' style="background-color: white;">Revision as of 01:13, 18 June 2007</td>
</tr>
<tr><td colspan="2" align="left"><strong>Line 36:</strong></td>
<td colspan="2" align="left"><strong>Line 36:</strong></td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">{{botlangbarEN|[[Fr:Droite de Régression|Français]] [[It:Lavorare_con_la_Regressione_Lineare|Italiano]] [[Es:C%c3%b3mo_usar_la_funci%c3%b3n_estimaci%c3%b3n_lineal|Español]]}} </td><td> </td><td style="background: #eee; font-size: smaller;">{{botlangbarEN|[[Fr:Droite de Régression|Français]] [[It:Lavorare_con_la_Regressione_Lineare|Italiano]] [[Es:C%c3%b3mo_usar_la_funci%c3%b3n_estimaci%c3%b3n_lineal|Español]]}} </td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;"></td><td> </td><td style="background: #eee; font-size: smaller;"></td></tr>
<tr><td>-</td><td style="background: #ffa; font-size: smaller;">[[Category:NeoOffice]][[Category:Tips and Hints<del style="color: red; font-weight: bold; text-decoration: none;">]][[Category:NeoWikiFR</del>]]</td><td>+</td><td style="background: #cfc; font-size: smaller;">[[Category:NeoOffice]][[Category:Tips and Hints]]</td></tr>
</table>
Lorinda
https://neowiki.neooffice.org/index.php?title=Computing_and_Graphing_a_Regression_Line&diff=10349&oldid=prev
Lorinda: remove fixme template
2007-04-12T02:03:35Z
<p>remove fixme template</p>
<table border='0' width='98%' cellpadding='0' cellspacing='4' style="background-color: white;">
<tr>
<td colspan='2' width='50%' align='center' style="background-color: white;">←Older revision</td>
<td colspan='2' width='50%' align='center' style="background-color: white;">Revision as of 02:03, 12 April 2007</td>
</tr>
<tr><td colspan="2" align="left"><strong>Line 1:</strong></td>
<td colspan="2" align="left"><strong>Line 1:</strong></td></tr>
<tr><td>-</td><td style="background: #ffa; font-size: smaller;">{{Fixme}}</td><td colspan="2"> </td></tr>
<tr><td>-</td><td style="background: #ffa; font-size: smaller;"></td><td colspan="2"> </td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">In NeoOffice Calc, it is possible to calculate the slope and the Y-intercept of a linear regression line, starting from a set of statistical data. Furthermore, you can get the set of data points and the regression line on the same chart.</td><td> </td><td style="background: #eee; font-size: smaller;">In NeoOffice Calc, it is possible to calculate the slope and the Y-intercept of a linear regression line, starting from a set of statistical data. Furthermore, you can get the set of data points and the regression line on the same chart.</td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;"></td><td> </td><td style="background: #eee; font-size: smaller;"></td></tr>
</table>
Lorinda
https://neowiki.neooffice.org/index.php?title=Computing_and_Graphing_a_Regression_Line&diff=10348&oldid=prev
Lorinda: /* Graphing the linear regression line */ just a little polish
2007-04-12T01:57:37Z
<p><span class="autocomment">Graphing the linear regression line -</span> just a little polish</p>
<table border='0' width='98%' cellpadding='0' cellspacing='4' style="background-color: white;">
<tr>
<td colspan='2' width='50%' align='center' style="background-color: white;">←Older revision</td>
<td colspan='2' width='50%' align='center' style="background-color: white;">Revision as of 01:57, 12 April 2007</td>
</tr>
<tr><td colspan="2" align="left"><strong>Line 14:</strong></td>
<td colspan="2" align="left"><strong>Line 14:</strong></td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">==Graphing the linear regression line==</td><td> </td><td style="background: #eee; font-size: smaller;">==Graphing the linear regression line==</td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;"></td><td> </td><td style="background: #eee; font-size: smaller;"></td></tr>
<tr><td>-</td><td style="background: #ffa; font-size: smaller;">'''valterb''' provided in <del style="color: red; font-weight: bold; text-decoration: none;">this </del>[http://trinity.neooffice.org/modules.php?name=Forums&file=viewtopic&t=3420 trinity <del style="color: red; font-weight: bold; text-decoration: none;">forum</del>] <del style="color: red; font-weight: bold; text-decoration: none;"> indications for graphing a linear regression line</del>.</td><td>+</td><td style="background: #cfc; font-size: smaller;">'''valterb''' provided <ins style="color: red; font-weight: bold; text-decoration: none;">these instructions for graphing a linear regression line </ins>in [http://trinity.neooffice.org/modules.php?name=Forums&file=viewtopic&t=3420 <ins style="color: red; font-weight: bold; text-decoration: none;">this post at </ins>trinity].</td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;"></td><td> </td><td style="background: #eee; font-size: smaller;"></td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">*Enter your data in a spreadsheet, in two columns, e.g. A and B, with headers X and Y. Thus the matrix of Y values is (B2:Bn) and the matrix of X values is (A2:An), if you have a set of n-1 data (X,Y).</td><td> </td><td style="background: #eee; font-size: smaller;">*Enter your data in a spreadsheet, in two columns, e.g. A and B, with headers X and Y. Thus the matrix of Y values is (B2:Bn) and the matrix of X values is (A2:An), if you have a set of n-1 data (X,Y).</td></tr>
<tr><td colspan="2" align="left"><strong>Line 31:</strong></td>
<td colspan="2" align="left"><strong>Line 31:</strong></td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;"></td><td> </td><td style="background: #eee; font-size: smaller;"></td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">'''Note 2''' : You can graph several regression lines on the same chart. For instance, in order to graph three straight lines, enter all the values of X in column A, then enter the values of Y in three columns, B, C, D, with headers Y1, Y2, Y3. The corresponding values of X and Y must be on the same line. So you get three couples of matrices, for example (A2:A6) (B2:B6), (A7:A12) (C7:C12) and (A13:A17) (D13:D17). Select the whole set of data and insert a chart. Complete as indicated in the "Graphing the linear regression line" section. The three straight lines are of different color on the chart.</td><td> </td><td style="background: #eee; font-size: smaller;">'''Note 2''' : You can graph several regression lines on the same chart. For instance, in order to graph three straight lines, enter all the values of X in column A, then enter the values of Y in three columns, B, C, D, with headers Y1, Y2, Y3. The corresponding values of X and Y must be on the same line. So you get three couples of matrices, for example (A2:A6) (B2:B6), (A7:A12) (C7:C12) and (A13:A17) (D13:D17). Select the whole set of data and insert a chart. Complete as indicated in the "Graphing the linear regression line" section. The three straight lines are of different color on the chart.</td></tr>
<tr><td>-</td><td style="background: #ffa; font-size: smaller;">Thanks to '''valterb''' for this <del style="color: red; font-weight: bold; text-decoration: none;"> </del>additional information.</td><td>+</td><td style="background: #cfc; font-size: smaller;">Thanks to '''valterb''' for this additional information.</td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;"></td><td> </td><td style="background: #eee; font-size: smaller;"></td></tr>
<tr><td>-</td><td style="background: #ffa; font-size: smaller;">'''Note 3''' : Remember to include the first line of the table, which contains the values x, y1, y2, y3 or whatever values you want, in the selected data. Otherwise the <del style="color: red; font-weight: bold; text-decoration: none;">legende </del>will display Column A, Column B, Column C, etc. Don't insert numbers in the first line.</td><td>+</td><td style="background: #cfc; font-size: smaller;">'''Note 3''' : Remember to include the first line of the table, which contains the values x, y1, y2, y3 or whatever values you want, in the selected data. Otherwise the <ins style="color: red; font-weight: bold; text-decoration: none;">legend </ins>will display Column A, Column B, Column C, etc. Don't insert numbers in the first line.</td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;"></td><td> </td><td style="background: #eee; font-size: smaller;"></td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;"></td><td> </td><td style="background: #eee; font-size: smaller;"></td></tr>
</table>
Lorinda
https://neowiki.neooffice.org/index.php?title=Computing_and_Graphing_a_Regression_Line&diff=10347&oldid=prev
Lorinda: /* Calculating parameters of the linear regression */ polishing the text a bit
2007-04-12T01:47:31Z
<p><span class="autocomment">Calculating parameters of the linear regression -</span> polishing the text a bit</p>
<table border='0' width='98%' cellpadding='0' cellspacing='4' style="background-color: white;">
<tr>
<td colspan='2' width='50%' align='center' style="background-color: white;">←Older revision</td>
<td colspan='2' width='50%' align='center' style="background-color: white;">Revision as of 01:47, 12 April 2007</td>
</tr>
<tr><td colspan="2" align="left"><strong>Line 5:</strong></td>
<td colspan="2" align="left"><strong>Line 5:</strong></td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">==Calculating parameters of the linear regression==</td><td> </td><td style="background: #eee; font-size: smaller;">==Calculating parameters of the linear regression==</td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;"></td><td> </td><td style="background: #eee; font-size: smaller;"></td></tr>
<tr><td>-</td><td style="background: #ffa; font-size: smaller;">*Enter your data in a spreadsheet, <del style="color: red; font-weight: bold; text-decoration: none;">in two columns, </del>e.g. A and B, with headers X and Y. Thus the matrix of Y values is (B2:Bn) and the matrix of X values is (A2:An), if you have a set of n-1 data (X,Y).</td><td>+</td><td style="background: #cfc; font-size: smaller;">*Enter your data in <ins style="color: red; font-weight: bold; text-decoration: none;">two columns of </ins>a spreadsheet, <ins style="color: red; font-weight: bold; text-decoration: none;"> </ins>e.g. A and B, with headers X and Y. Thus the matrix of Y values is (B2:Bn) and the matrix of X values is (A2:An), if you have a set of n-1 data (X,Y).</td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">*Click in an empty cell to select it.</td><td> </td><td style="background: #eee; font-size: smaller;">*Click in an empty cell to select it.</td></tr>
<tr><td>-</td><td style="background: #ffa; font-size: smaller;">*Click the {{prefName|Function Wizard}} icon (<del style="color: red; font-weight: bold; text-decoration: none;">on </del>the left of the sign Σ). <del style="color: red; font-weight: bold; text-decoration: none;">In the </del>{{window|Function Wizard}} window <del style="color: red; font-weight: bold; text-decoration: none;">then in </del>the {{prefName|Category}} drop down menu, choose {{prefName|Array}} then '''LINEST''' and click {{button|Next}}.</td><td>+</td><td style="background: #cfc; font-size: smaller;">*Click the {{prefName|Function Wizard}} icon (<ins style="color: red; font-weight: bold; text-decoration: none;">to </ins>the left of the sign Σ). <ins style="color: red; font-weight: bold; text-decoration: none;">The </ins>{{window|Function Wizard}} window <ins style="color: red; font-weight: bold; text-decoration: none;">opens. In </ins>the {{prefName|Category}} drop down menu, choose {{prefName|Array}}<ins style="color: red; font-weight: bold; text-decoration: none;">; </ins>then <ins style="color: red; font-weight: bold; text-decoration: none;">choose </ins>'''LINEST''' <ins style="color: red; font-weight: bold; text-decoration: none;">in the box below the drop down </ins>and click {{button|Next}}.</td></tr>
<tr><td>-</td><td style="background: #ffa; font-size: smaller;">*In the {{prefName|data_Y}} field enter B2:Bn, in the {{prefName|data_X}} field enter A2:An (you can use the keyboard or click the corresponding cells to select them), you can <del style="color: red; font-weight: bold; text-decoration: none;">let </del>the {{prefName|Linear_type}} field empty.</td><td>+</td><td style="background: #cfc; font-size: smaller;">*In the {{prefName|data_Y}} field enter B2:Bn, in the {{prefName|data_X}} field enter A2:An (you can use the keyboard or click the corresponding cells to select them), you can <ins style="color: red; font-weight: bold; text-decoration: none;">leave </ins>the {{prefName|Linear_type}} field empty.</td></tr>
<tr><td>-</td><td style="background: #ffa; font-size: smaller;">*If you don't fill the {{prefName|stats}} field, you will get the slope of the regression line and its intercept with the Y axis. If you fill that field, you will get some additional values (click {{button|Help}} in the {{window|Function Wizard}} window for more <del style="color: red; font-weight: bold; text-decoration: none;">informations </del>and <del style="color: red; font-weight: bold; text-decoration: none;">for seeing </del>an example which explains in <del style="color: red; font-weight: bold; text-decoration: none;">details </del>how to use the '''LINEST''' function).</td><td>+</td><td style="background: #cfc; font-size: smaller;">*If you don't fill the {{prefName|stats}} field, you will get the slope of the regression line and its intercept with the Y axis. If you fill that field, you will get some additional values (click {{button|Help}} in the {{window|Function Wizard}} window for more <ins style="color: red; font-weight: bold; text-decoration: none;">information </ins>and <ins style="color: red; font-weight: bold; text-decoration: none;">to see </ins>an example which explains in <ins style="color: red; font-weight: bold; text-decoration: none;">detail </ins>how to use the '''LINEST''' function).</td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">*If you need only the slope of the linear regression line, you can use the '''SLOPE'''(data_Y;data_X) function, if you need only the point at which the line intercepts the Y axis, you can use the '''INTERCEPT'''(data_Y;data_X). Those two functions are available in the {{prefName|Category> Statistical}} drop down menu in the {{window|Function Wizard}} window.</td><td> </td><td style="background: #eee; font-size: smaller;">*If you need only the slope of the linear regression line, you can use the '''SLOPE'''(data_Y;data_X) function, if you need only the point at which the line intercepts the Y axis, you can use the '''INTERCEPT'''(data_Y;data_X). Those two functions are available in the {{prefName|Category> Statistical}} drop down menu in the {{window|Function Wizard}} window.</td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;"></td><td> </td><td style="background: #eee; font-size: smaller;"></td></tr>
</table>
Lorinda
https://neowiki.neooffice.org/index.php?title=Computing_and_Graphing_a_Regression_Line&diff=10346&oldid=prev
Lorinda: just a little polish
2007-04-12T01:38:26Z
<p>just a little polish</p>
<table border='0' width='98%' cellpadding='0' cellspacing='4' style="background-color: white;">
<tr>
<td colspan='2' width='50%' align='center' style="background-color: white;">←Older revision</td>
<td colspan='2' width='50%' align='center' style="background-color: white;">Revision as of 01:38, 12 April 2007</td>
</tr>
<tr><td colspan="2" align="left"><strong>Line 1:</strong></td>
<td colspan="2" align="left"><strong>Line 1:</strong></td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">{{Fixme}}</td><td> </td><td style="background: #eee; font-size: smaller;">{{Fixme}}</td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;"></td><td> </td><td style="background: #eee; font-size: smaller;"></td></tr>
<tr><td>-</td><td style="background: #ffa; font-size: smaller;">In NeoOffice Calc, it is possible to calculate the slope and the Y-intercept <del style="color: red; font-weight: bold; text-decoration: none;"> </del>of <del style="color: red; font-weight: bold; text-decoration: none;">the </del>linear regression line, starting from a set of statistical data. Furthermore, you can get the set of data points and the regression line on the same chart.</td><td>+</td><td style="background: #cfc; font-size: smaller;">In NeoOffice Calc, it is possible to calculate the slope and the Y-intercept of <ins style="color: red; font-weight: bold; text-decoration: none;">a </ins>linear regression line, starting from a set of statistical data. Furthermore, you can get the set of data points and the regression line on the same chart.</td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;"></td><td> </td><td style="background: #eee; font-size: smaller;"></td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">==Calculating parameters of the linear regression==</td><td> </td><td style="background: #eee; font-size: smaller;">==Calculating parameters of the linear regression==</td></tr>
</table>
Lorinda
https://neowiki.neooffice.org/index.php?title=Computing_and_Graphing_a_Regression_Line&diff=10326&oldid=prev
Jgd at 09:21, 9 April 2007
2007-04-09T09:21:15Z
<p></p>
<p><b>New page</b></p><div>{{Fixme}}<br />
<br />
In NeoOffice Calc, it is possible to calculate the slope and the Y-intercept of the linear regression line, starting from a set of statistical data. Furthermore, you can get the set of data points and the regression line on the same chart.<br />
<br />
==Calculating parameters of the linear regression==<br />
<br />
*Enter your data in a spreadsheet, in two columns, e.g. A and B, with headers X and Y. Thus the matrix of Y values is (B2:Bn) and the matrix of X values is (A2:An), if you have a set of n-1 data (X,Y).<br />
*Click in an empty cell to select it.<br />
*Click the {{prefName|Function Wizard}} icon (on the left of the sign Σ). In the {{window|Function Wizard}} window then in the {{prefName|Category}} drop down menu, choose {{prefName|Array}} then '''LINEST''' and click {{button|Next}}.<br />
*In the {{prefName|data_Y}} field enter B2:Bn, in the {{prefName|data_X}} field enter A2:An (you can use the keyboard or click the corresponding cells to select them), you can let the {{prefName|Linear_type}} field empty.<br />
*If you don't fill the {{prefName|stats}} field, you will get the slope of the regression line and its intercept with the Y axis. If you fill that field, you will get some additional values (click {{button|Help}} in the {{window|Function Wizard}} window for more informations and for seeing an example which explains in details how to use the '''LINEST''' function).<br />
*If you need only the slope of the linear regression line, you can use the '''SLOPE'''(data_Y;data_X) function, if you need only the point at which the line intercepts the Y axis, you can use the '''INTERCEPT'''(data_Y;data_X). Those two functions are available in the {{prefName|Category> Statistical}} drop down menu in the {{window|Function Wizard}} window.<br />
<br />
==Graphing the linear regression line==<br />
<br />
'''valterb''' provided in this [http://trinity.neooffice.org/modules.php?name=Forums&file=viewtopic&t=3420 trinity forum] indications for graphing a linear regression line.<br />
<br />
*Enter your data in a spreadsheet, in two columns, e.g. A and B, with headers X and Y. Thus the matrix of Y values is (B2:Bn) and the matrix of X values is (A2:An), if you have a set of n-1 data (X,Y).<br />
*Select the whole set of data then choose {{menu|Insert > Chart}}.<br />
*Be sure that the selected cells contain the desired data.<br />
*Click the {{button|Next}} button, choose the chart type called "XY chart" then click {{button|Next}}.<br />
*Choose the variant you prefer (symbols only, lines with symbols, etc) then click {{button|Next}} and choose the chart title, legend, etc.<br />
*Click {{button|Create}}. A chart appears in the spreadsheet.<br />
*Select it and go to the {{menu|Insert > Statistics}} menu.<br />
*In the {{prefName|Regression curves}} section on the right, click the {{prefName|Linear regression}} icon and the {{button|OK}} button.<br />
You can choose another regression type, display an error category (Variance, Standard deviation …) and display an error indicator on the chart.<br />
<br />
[[image:regressione.png|320px|center|Regression line ]]<br />
<br />
'''Note 1''': If the origin of the axes does not belong to the interval of your data, you can increase the X axis by clicking on the chart and choosing the {{menu|Format > Axis > X Axis > Scale}} menu, then in the {{prefName|Minimum}} section deselect the {{prefName|Automatic}} option and type the value you wish. Repeat those operations with the Y axis.<br />
<br />
'''Note 2''' : You can graph several regression lines on the same chart. For instance, in order to graph three straight lines, enter all the values of X in column A, then enter the values of Y in three columns, B, C, D, with headers Y1, Y2, Y3. The corresponding values of X and Y must be on the same line. So you get three couples of matrices, for example (A2:A6) (B2:B6), (A7:A12) (C7:C12) and (A13:A17) (D13:D17). Select the whole set of data and insert a chart. Complete as indicated in the "Graphing the linear regression line" section. The three straight lines are of different color on the chart.<br />
Thanks to '''valterb''' for this additional information.<br />
<br />
'''Note 3''' : Remember to include the first line of the table, which contains the values x, y1, y2, y3 or whatever values you want, in the selected data. Otherwise the legende will display Column A, Column B, Column C, etc. Don't insert numbers in the first line.<br />
<br />
<br />
{{botlangbarEN|[[Fr:Droite de Régression|Français]] [[It:Lavorare_con_la_Regressione_Lineare|Italiano]] [[Es:C%c3%b3mo_usar_la_funci%c3%b3n_estimaci%c3%b3n_lineal|Español]]}} <br />
<br />
[[Category:NeoOffice]][[Category:Tips and Hints]][[Category:NeoWikiFR]]</div>
Jgd