Why Tableau is the leader in visual analytics - Formula Trace Breakdown

Sample Data

Comparison of Tableau and competitors on key visual analytics features rated 1-10.

Cell	Value
A1	Feature
B1	Tableau
C1	Competitor A
D1	Competitor B
A2	Ease of Use
B2	9
C2	6
D2	5
A3	Visualization Options
B3	10
C3	7
D3	6
A4	Data Connectivity
B4	9
C4	8
D4	7
A5	Community Support
B5	10
C5	5
D5	4
A6	Speed
B6	8
C6	7
D6	6

Formula Trace

AVERAGE(B2:B6)

Step 1: B2 + B3 + B4 + B5 + B6

Step 2: 46

Step 3: 46 / 5

Cell Reference Map

    A           B           C           D
1 | Feature   | Tableau   | Competitor A | Competitor B |
2 | Ease of Use | 9       | 6           | 5           |
3 | Visualization Options | 10      | 7           | 6           |
4 | Data Connectivity | 9       | 8           | 7           |
5 | Community Support | 10      | 5           | 4           |
6 | Speed      | 8       | 7           | 6           |

Cells B2 to B6 contain Tableau's feature scores used in the average calculation.

Result

    A           B           
1 | Feature   | Tableau   |
2 | Ease of Use | 9       |
3 | Visualization Options | 10      |
4 | Data Connectivity | 9       |
5 | Community Support | 10      |
6 | Speed      | 8       |
7 | Average Score | 9.2     |

The average score of Tableau's features is 9.2, showing strong performance across key areas.

Sheet Trace Quiz - 3 Questions

What is the sum of Tableau's scores for all features?

A 44

B 45

C 46

D 47

Key Result

AVERAGE(range) calculates the mean by summing values in the range and dividing by count.