forum.xltoolbox.net

xltoolbox.net

Daniel's XL Toolbox - 1-Way Analysis Of Variance (ANOVA)

https://www.xltoolbox.net/anova.html

Source code on GitHub. ANOVA with posthoc analyses. If you want to determine if there are significant differences between groups of data, you can perform an analysis of variance (ANOVA). The XL Toolbox’ ANOVA feature offers several advantages over the ANOVA that comes with Excel’s Analysis Toolpak: It accepts data in a number of different table layouts, and it can compute post-hoc tests. If you are new to ANOVA, the article in Wikipedia. Group data can be arranged in columns. See figure, left side).

xltoolbox.net

Daniel's XL Toolbox - Batch-export charts

https://www.xltoolbox.net/batchexport.html

Source code on GitHub. The batch export of Daniel’s XL Toolbox enables you to export all charts or other graphical objects either on a single spreadsheet or all charts contained in an entire workbook in an automated process. With batch export, you can generate files in screen resolution as well as print resolution (including CMYK color), or export as Windows. EMF) The Toolbox offers various ways to generate file names, including scanning for figure labels. Using the batch export function. My Experiment: ...

xltoolbox.net

Daniel's XL Toolbox - Add/edit watermarks

https://www.xltoolbox.net/watermarks.html

Source code on GitHub. Watermarks are text boxes on charts that can contain any information, e.g. initials or a date. The elements of this form are self-explanatory. A chart with a watermark that was added with the settings as shown looks like the one on the right. The standard font is always used. Site compiled with Nanoc 4. Microsoft, Windows, Office, and Excel are either registered trademarks or trademarks of Microsoft Corporation in the United States and/or other countries.

xltoolbox.net

Daniel's XL Toolbox - Linear Correlation

https://www.xltoolbox.net/correlation.html

Source code on GitHub. Correlation tests if there is a relationship between two variables that do not logically depend on one another. For example, you could count the number of cars in the street and the number of pedestrians on the sidewalk and see if they are correlated. Both numbers (variables) do not logically depend on one another. Variable, you need to perform a linear regression. Rather than a correlation analysis. The Toolbox can also perform a linear regression. Site compiled with Nanoc 4.

xltoolbox.net

Daniel's XL Toolbox - Group allocation (stratification)

https://www.xltoolbox.net/allocate

Source code on GitHub. The Group Allocation function serves to assign study subjects to treatment groups, minimizing differences between the treatment groups. This is also called stratification. The study subjects can have as many properties/characteristics (e.g. body weight, age, etc.) as you like or as is reasonable. How to use the Group Allocator. When you use the Group Allocator, you have to enter a number of parameters:. Indicate how many treatment groups you want to have. When checked, the Allocati...

xltoolbox.net

Daniel's XL Toolbox - Annotate and label charts

https://www.xltoolbox.net/annotate.html

Source code on GitHub. Annotate and label charts. The Annotate Chart function provides a simple way to add comments and color to individual data points in your chart. For example, you can easily highlight specific points in a scatter plot, or you could add asterisks (“stars”, “*”) to a bar graph with a mouse click to denote statistical significance. Annotations (labels) can be read either from the cell comments or from a separate range of cells. The Annotate Chart dialog offers the following options (see.

xltoolbox.net

Daniel's XL Toolbox - Copy chart format

https://www.xltoolbox.net/chartformat.html

Source code on GitHub. The Copy Chart Properties function is a very powerful feature that you can use to copy a number of properties of the selected chart to any other charts in your workbook. In addition to copying the chart format, you can have your chart’s title fully or partially copied to other charts. Use this feature to copy chart sizes, axes, titles, and more. As you can see in the screenshot to the right, the Copy Chart Properties dialog has three panels. In the top panel. And Axes & Grid. Chart...

xltoolbox.net

Daniel's XL Toolbox - Adding many chart series at once

https://www.xltoolbox.net/addseries.html

Source code on GitHub. Adding many chart series at once. The “Select data” (Excel 2007-2013) or “Data source” (Excel 2000-2003) commands can be used to add new data series to a chart, but in some situations, they are not flexible enough. The XL Toolbox offers an alternative and more powerful way to add many chart series add once to a chart. For XY scatter plots, you can have individual X and Y values for each series. Add many data series at once. Add many data series at once. Site compiled with Nanoc 4.

xltoolbox.net

Daniel's XL Toolbox - Linear regression

https://www.xltoolbox.net/regression.html

Source code on GitHub. Regression tests if there is a relationship between two variables where one variable (the dependent. Variable; commonly “Y”) logically depends on the other (the independent. Variable; commonly “X”). Variable, you need to perform a linear regression analysis. However, if you measure two variables with no logical dependency, you need to perform a correlation analysis. 4th edition, chapters 17 and 18. The Toolbox does. Use simplified computational formulas. Also note that my nickname ...

xltoolbox.net

Daniel's XL Toolbox - Formula Builder

https://www.xltoolbox.net/formulabuilder.html

Source code on GitHub. The Formula Builder collects cell references for your data to generate various formulas. The example on the right shows a situation where data for two different experimental groups (“Control” and “Treated”) are written underneath (or horizontally) in the order that they were obtained. Any other formula that can use the pound sign (“#”) as a placeholder for the collected cell references, e.g.:. Using the formula builder. The Formula Builder needs to know four cell ranges:. Group nam...