[size=100]The [i]Spreadsheet Tools[/i] are organized in GeoGebra's [i]Spreadsheet View Toolbar[/i]:[/size][br][size=100][br][img]https://wiki.geogebra.org/uploads/thumb/f/f1/Toolbar-Spreadsheet.png/146px-Toolbar-Spreadsheet.png[/img][/size][br][br][size=100]It contains a variety of [i]Spreadsheet Tools[/i] which are organized in [i]Toolboxes [/i]and can be operated with your pointing device.[/size]

Do [icon]/images/ggb/toolbar/mode_onevarstats.png[/icon] [i]One Variable Analysis[/i] and [icon]https://www.geogebra.org/images/ggb/toolbar/mode_twovarstats.png[/icon][i]Two Variable Regression Analysis[/i] with the [i]Spreadsheet Tools[/i] for Data Analysis.

[icon]/images/ggb/toolbar/mode_onevarstats.png[/icon] [b]One Variable Analysis[/b][br]Highlight all cells of column [i]A[/i] that contain data and then activate the tool [i]One Variable Analysis[/i].[br]In the appearing dialog you can display the following information:[br][list][*][img]https://wiki.geogebra.org/uploads/thumb/d/d2/Stylingbar_variable_analysis_2plot.svg/20px-Stylingbar_variable_analysis_2plot.svg.png[/img] Graphs: You can display one or two different graphs (e.g. histogram, boxplot), which you can select from a list.[/*][*][img]https://wiki.geogebra.org/uploads/thumb/8/8a/Stylingbar_variable_analysis_statistics.svg/20px-Stylingbar_variable_analysis_statistics.svg.png[/img] Statistics: The statistical Analysis of the data is displayed in a table.[/*][*][img]https://wiki.geogebra.org/uploads/thumb/e/ee/Stylingbar_variable_analysis_data.svg/20px-Stylingbar_variable_analysis_data.svg.png[/img] Data: The analyzed data is displayed in a table.[/*][/list][b]Note[/b][b]:[/b] [list][*]By default, only one of the graph panels is displayed. You can display the other panels by using the [i]Style Bar[/i] of the dialog.[/*][*][img]https://wiki.geogebra.org/uploads/thumb/3/30/Menu-options.svg/16px-Menu-options.svg.png[/img] Settings: You can modify the settings of the selected graph.[/*][*][img]https://wiki.geogebra.org/uploads/thumb/1/15/Menu-file-export.svg/16px-Menu-file-export.svg.png[/img] Export: You can copy a graph to the [img]https://wiki.geogebra.org/uploads/thumb/c/c8/Menu_view_graphics.svg/16px-Menu_view_graphics.svg.png[/img] [i]Graphics View[/i] or export it as an image file.[/*][/list]

[icon]/images/ggb/toolbar/mode_twovarstats.png[/icon] [b]Two Variable Regression Analysis[/b][br]Highlight two columns with paired number data in the spreadsheet. Then, activate the tool [i]Two Variable Regression Analysis[/i].[br]In the appearing dialog you can display the following information:[br][list][*][img]https://wiki.geogebra.org/uploads/thumb/d/d2/Stylingbar_variable_analysis_2plot.svg/20px-Stylingbar_variable_analysis_2plot.svg.png[/img] Graphs: You can display one or two different graphs (e.g. scatterplot, residual plot), which you can select from a list. Below the graph you can choose between different regression models for the data. When a model is selected, its graph is drawn on the plot and the equation is shown underneath.[/*][*][img]https://wiki.geogebra.org/uploads/thumb/8/8a/Stylingbar_variable_analysis_statistics.svg/20px-Stylingbar_variable_analysis_statistics.svg.png[/img] Statistics: The statistical Analysis of the data is displayed in a table.[/*][*][img]https://wiki.geogebra.org/uploads/thumb/e/ee/Stylingbar_variable_analysis_data.svg/20px-Stylingbar_variable_analysis_data.svg.png[/img] Data: The analyzed data is displayed in a table.[/*][*]You can decide which data column should determine the [i]x[/i]-coordinates and which should be used for the [i]y[/i]-coordinates of the points.[/*][/list][br][b]Note: [/b][list][*]By default, only one of the graph panels is displayed. You can display the other panels by using the [i]Style Bar[/i] of the dialog.[/*][*][img]https://wiki.geogebra.org/uploads/thumb/3/30/Menu-options.svg/16px-Menu-options.svg.png[/img] Settings: You can modify the settings of the selected graph.[/*][*][img]https://wiki.geogebra.org/uploads/thumb/1/15/Menu-file-export.svg/16px-Menu-file-export.svg.png[/img] Export: You can copy a graph to the [img]https://wiki.geogebra.org/uploads/thumb/c/c8/Menu_view_graphics.svg/16px-Menu_view_graphics.svg.png[/img] [i]Graphics View[/i] or export it as an image file.[/*][/list]