1
00:00:00,660 --> 00:00:05,430
In this video, I'll show you my solution on how to calculate the average of this column.

2
00:00:06,300 --> 00:00:07,800
And that's my solution.

3
00:00:08,010 --> 00:00:15,840
So I am establishing a connection to my Google Sheets account, creating a spreadsheet, creating a

4
00:00:15,840 --> 00:00:19,710
work sheet and then getting the existing column.

5
00:00:19,920 --> 00:00:21,510
So that column?

6
00:00:23,150 --> 00:00:30,860
And, you know, that's the column will come as a list of lists, so we have to flatten that list.

7
00:00:31,160 --> 00:00:33,110
I do that in this part here.

8
00:00:33,470 --> 00:00:40,820
So I extracted the items from each list and convert them into a float or have a plane leaves or floats.

9
00:00:41,270 --> 00:00:47,540
And then I calculate the average finally in here by just putting that existing column as input to the

10
00:00:47,540 --> 00:00:52,650
mean function and then place that final value into the G.

11
00:00:52,670 --> 00:00:54,470
Twenty 26 cell.

12
00:00:54,470 --> 00:01:02,000
So I run this now, I go back here and I see the value placed in this G twenty six column.

13
00:01:02,450 --> 00:01:03,170
That's the average.

14
00:01:04,500 --> 00:01:07,890
Thank you for watching this video, and I'll talk to you in the next one.