Average

[kaverijaiswal]

Hi,

How to calculate the average of the following data sets in the below column. I tried using text to column tool to separate data into different column but I am not sure whether it's correct way to calculate average. Please advice.

Length of Appointments
51
59,46
46,55,67,49,60
71,62
40,61,65
70,31,61
57,58,41
62,43
67,32
43,46
45
35,45
49
53,27,51
66,69,48
63,50
54
73
36,48
42,70,47
51
65,75,33,53,58
32,56,63
41,34,62
49,74,73
47,36
68,37,58
32

Thanks,

Kaveri Jaiswal

[fmvizcaino · Accepted solution]

Hi @kaverijaiswal ,

I'm attaching an example showing how to do average by line and also for all column.

Best,

Fernando Vizcaino

[ponraj · Accepted solution]

Here is my solution. 

[kaverijaiswal]

@ponraj @fmvizcaino 

Thank you both. Your solution worked seamlessly. 

[Teckydoo2]

This was very helpful. Using the browse tool was the fastest way for me.