00:01
In problem 37, we're going to be comparing the committing times in various locations.
00:07
And here we have six different cities in the united states.
00:12
And the first part of the question a will be constructing a box plot showing the six cities side by side.
00:21
And what we need to do first is to select the data.
00:24
And then you go to insert, then you press this bar here, and then you press this bar here, and then you press the box and whisker.
00:33
So this is the box plot for the data and each of these box plots represents the different cities.
00:41
Okay so in part b we're going to tell whether the box plot shows visual evidence suggesting that the city has an effect on the average morning or much time.
00:54
Now as you can see this box plot seem very similar and one of them shows any significant differences according to the graphical display.
01:07
So here we can make a conclusion that no, the graphs do not show visual evidence suggesting that the city has an effect on the average morning commute time.
01:19
Because each box plot looks about the same as the others.
01:24
And then we now move on to part b of the question, now part c of the question, where i'm supposed to use the analysis of variance technique to tell whether this data show sufficient evidence to claim that the city has an effect on the average morning commute time.
01:47
And here the level of significance alpha will be 0 .05.
01:56
So first we're going to move this chart aside and then we're going to use the analysis of variance tool on data and data analysis options.
02:09
So you press the analysis of variance single factor, then you select the data and then you make sure that it's grouped by the columns and the labels are in the first row and the alpha should be 0 .05.
02:32
Then for the output you can select a cell and you press okay and here are the results for the single factor analysis of variance.
02:49
Keep in mind that alpha level of significance is 0 .05...