I am new in Excel And I need help on creating my statistical report. I need to know how to use the Root Sum Square or the RSS Method in Excel. I need it to get the summary of the square roots of my report. I need links or video tutorials or just please provide some examples so I can study on it. Thanks.
Hi,
The first thing I'll give you is a link to a video that explains how to use the Excel function SUMQ to determine the sum of the square roots of numbers:
The second thing is this tutorial explaining how to find the square root of numbers in Excel (it gives step by step directions):
https://www.thoughtco.com/finding-square-cube-nth-roots-excel-3123674
This link also explains how to use the SUMQ function:
https://itstillworks.com/use-excels-iserror-function-2384504.html
This link is a good one for learning how to do mathematical functions in general:
http://www.excel-examples.com/microsoft-excel-mathematical-functions.htm
