Averaging Columns with the same Name

[crunyeon]

Hello, I have a list of browsers and bounce rate data from the Google Analytics plugin, and I am trying to average the bounce rates for each browser.  For example, the data comes in as:

Chrome	.26589
Chrome	.24789
Chrome	.21487
FireFox	.35478
Firefox	.98752
Internet Explorer	.21489
Internet Explorer	.24865

And I want it to look like:

Chrrome	.25895
FireFox	.25448
Internet Explorer	.26578

With the bounce rates being averaged for each browser.  Any idea how to do this?  Thank you!

[roadhouse · Accepted solution]

hi crunyeon,

try using the Summarize tool. You'll want to group by the browser and average the bounce rates. 

Example attached.