00:01
All right, so we're given a scenario where we want to compare how groceries cost across different areas in the country.
00:10
So using a market basket of 10 items including meat, milk, bread, eggs, coffee, potato, cereal, orange juice, a magazine company calculated the cost of the market basket in six cities and six retirement areas across the country.
00:26
For both of these two different areas, the retirement area and the different cities, we want to compute the mean variance in standard deviation for the sample of cities and the sample of retirement areas.
00:41
And then based on that, what observations can be made based on the two different samples.
00:47
So to do this in excel, if we want to get the mean in excel language, we call that average.
00:54
So we'll just average the cost right there, right? if we want to get the variance, we can do bar .s, which estimates the variance based on a sample.
01:08
So we'll do that like this.
01:12
And then to get the standard deviation, we'll do sddev .s again for the sample.
01:18
Just like so...