Calibri (Body) 12 A a. Av | | General Paste BIU In $ % ) Conditional Formatting Format as Table Cell Styles 38.99 B17 A x fx % OF WHITE B D 27 3.4 3.4 E G H - F #DIV/0! K M 0 3.4 2 3 4 5 6 7 DIVERISTY 1 1 1 00 LOCATION AL AK AR AS AD AD BE CT FL 9 RANKING SI POPULATION WHITE BLACK HISPANI ASIAN OTHER 10 42232323 12.20% 12.20% 23.00% 12. 20% 12. 20% 3 12323232 13.00% 67.00% 12.00% 23.00% 56.00% 2 12212 24.50% 34.00% 12.00% 34.00% 12.20% 1 343434 4.90% 5.00% 2.00% 23.00% 12.20% 44 123241354 23.20% 32.00% 56.00% 12.00% 7.00% 9 1232321 89.00% 5.00% 54.00% 4.00% 4.00% 89 34343 76.00% 78.00% 43.00% 45.00% 12.20% 12 12323 56.00% 34.00% 34.00% 12.20% 12.20% 13 234341 54.00% 4.00% 2.00% 12.20% 34.00% 56 1 90.00% 5.00% 23.00% 12.20% 23.00% 2 12323 12.00% 4.00% 234.00% 12.20% 23.00% % US POPUL SALES 12.20% 34,534 12.20% 4,534,534 5.00% 1,232,212 12.20% 243,534 56.00% 324,234 5.00% 564 45.00% 67 34.00% 1,232,212 12.20% 3,453,453 5.00% 565 5.00% 456 1 1 4 3 10 2 1 11 12 13 14 15 16 17 HI QT 1 #DIV/01 18 % OF WHITE 0% 55% 70% 80% 1 2 3 4 1 2. 3 1 4 3 #DIV/0! 0 19 20 21 22 23 24 25 26 27 28 Sheet1 + Edit dtv 24 Calculate avg % of US by diversity tier Use % population column and averageif function, and absolute references Calculate avg sales for all locations by diversity tier Use averageif to calculate all diversity tier 1 locations Use absolute references Calibri (Body) 12 A a. Av | | General Paste BIU In $ % ) Conditional Formatting Format as Table Cell Styles 38.99 B17 A x fx % OF WHITE B D 27 3.4 3.4 E G H - F #DIV/0! K M 0 3.4 2 3 4 5 6 7 DIVERISTY 1 1 1 00 LOCATION AL AK AR AS AD AD BE CT FL 9 RANKING SI POPULATION WHITE BLACK HISPANI ASIAN OTHER 10 42232323 12.20% 12.20% 23.00% 12. 20% 12. 20% 3 12323232 13.00% 67.00% 12.00% 23.00% 56.00% 2 12212 24.50% 34.00% 12.00% 34.00% 12.20% 1 343434 4.90% 5.00% 2.00% 23.00% 12.20% 44 123241354 23.20% 32.00% 56.00% 12.00% 7.00% 9 1232321 89.00% 5.00% 54.00% 4.00% 4.00% 89 34343 76.00% 78.00% 43.00% 45.00% 12.20% 12 12323 56.00% 34.00% 34.00% 12.20% 12.20% 13 234341 54.00% 4.00% 2.00% 12.20% 34.00% 56 1 90.00% 5.00% 23.00% 12.20% 23.00% 2 12323 12.00% 4.00% 234.00% 12.20% 23.00% % US POPUL SALES 12.20% 34,534 12.20% 4,534,534 5.00% 1,232,212 12.20% 243,534 56.00% 324,234 5.00% 564 45.00% 67 34.00% 1,232,212 12.20% 3,453,453 5.00% 565 5.00% 456 1 1 4 3 10 2 1 11 12 13 14 15 16 17 HI QT 1 #DIV/01 18 % OF WHITE 0% 55% 70% 80% 1 2 3 4 1 2. 3 1 4 3 #DIV/0! 0 19 20 21 22 23 24 25 26 27 28 Sheet1 + Edit dtv 24 Calculate avg % of US by diversity tier Use % population column and averageif function, and absolute references Calculate avg sales for all locations by diversity tier Use averageif to calculate all diversity tier 1 locations Use absolute references