Takeaway the highest number from the lowest number
For example:
2,2,3,4,5,9,11
The range would be 11-2=9
Chat with our AI personalities
You calculate the range by subtracting the first and last number in the sequence
Get the biggest number and take away the smaller number
Find the rangeset of data:88,76,59,39,20,85,94,20,67step 1: rearrange from lowest to highest20,20,39,59,67,76,85,88,94step 2: highest - lowest = range94 - 20Answer = 74basics:1.rearrange from lowest to highest2.highest - lowest = range
=max(z1:z10) =min(z1:z10) =average(z1:z10)
See related link. You can use Excel, if you dataset is not too big. Generally, if I have a table of data, with n columns corresponding to n variables with N observations, I can calculate the covariance of columns a and b, using excel covar function, covar(range of first data values, range of second data values) To keep things organized, you may want to name the ranges of your columns and use them as the arguments in the covar.