Find the range
set of data:
88,76,59,39,20,85,94,20,67
step 1: rearrange from lowest to highest
20,20,39,59,67,76,85,88,94
step 2: highest - lowest = range
94 - 20
Answer = 74
basics:
1.rearrange from lowest to highest
2.highest - lowest = range
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
Takeaway the highest number from the lowest number For example: 2,2,3,4,5,9,11 The range would be 11-2=9
=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.