00:01
So let's take our data here.
00:04
And in excel, i've installed the data analysis add -on pack.
00:11
And we're going to run an anova two -factor with that replication.
00:16
My input range, it selected it for me.
00:19
And there are labels.
00:22
The alpha value is 0 .05.
00:25
We just hit ok here.
00:29
And then we're going to get these values here.
00:37
So the date, i've got my 9 degrees of freedom.
00:46
City columns, 3 degrees of freedom here for a total of 27 and 39.
00:54
We're going to find the sum, the ss.
01:00
So here's the sum column.
01:01
So here would be, this is the date.
01:05
Because we're talking about rows here...