Computes the range between minimum and maximum in each row and column.

Input

 
A
B
C
1
123
2
453
3
55-521
 
A
B
C
 
1
2
3
 

Output

 
A
B
C
D
1
1232.00
2
4532.00
3
55-52160.00
4
54.0010.0018.0060.00
 
A
B
C
D
 
1
2
3
4
 
31 Related tools

Table Statistic?

No suggestion for current input. 👍

3
Total Rows
3
Total Columns
9
Total Cells
0
Blank Values
9
Unique Values
1
Duplicated Values

0
Text Values
9
Numeric Values
0
Date Values
0
Time Values
0
URL Values
0
Percent Values
0
Currency Values
0
Email Values
0
Error Values

9
Word Count
9
Cell without Punctuation
0
Cell with Punctuation

8
Positive Values
1
Negative Values
0
Zero Values
-5
Minimum Value
55
Maximum Value
9.89
Average Value
89
Total Sum
297.21
Variance
17.24
Standard Dev.
2.31
Kurtosis
1.90
Skewness
3.00
Median

93%
Entropy Score
2.95
Data Entropy
3
Most Common Value

Any Questions?

Computes the range between minimum and maximum in each row and column. Range is the difference between the largest and smallest values in a set. Read more about range on Wikipedia https://en.wikipedia.org/wiki/Interval_(mathematics)

4 is the range of the set [2, 4, 6] because 6 (max) - 2 (min) = 4.

Enables an understanding of data dispersion, crucial for identifying data variability and anomalies.

  • Microsoft Excel: RANGE
  • Google Sheets: -
  • Apple Numbers: RANGE
  • Python Pandas: df['column_name'].max() - df['column_name'].min()
  • Related Words: calculate range, find range

This is normal for a web based application. We recommend uploading data up to 6000 columns and rows. If you encounter lag, you can reduce the sheet size.

There is a fullscreen button on the top right side of the input table. You can also download the table offline to edit with excel which has bigger screen sizes.

You can leave a message here.

Why SickSheet?

🌎
Access Anywhere

Compatible with any browser on any systems. No installation needed.

💸
Free to Use

Use over 300+ tools for free. No registration or credit card asked.

🧸
No Code

Complete all process without writing a single line of code.

💡
Intuitive Edit

Editing tables feels like in Excel. No learning curve needed.

💾
Instant Download

Click to download 10+ Spreadsheet formats and continue edit in Excel.

🕵️‍♂️
Super Private

Nothing is sent to the server. All data are operated on the client-side.