00:01
For this problem, we are looking at essentially a sort of environmental study about contamination of groundwater with methyl -tertutal ether, or mtbe.
00:11
We have three different qualitative variables, the well class being public or private, the aquifer, bedrock or unconsolidated, and whether or not something exceeds the detectable level of mtbe.
00:24
So for part a, we are asked to use graphical methods to describe each of the qualitative variables.
00:30
For all 223 wells.
00:33
One moment here.
00:35
So i'll note here that i don't have access to the actual data file that is intended to go along with the problem, but i will show you an example here.
00:43
So the first thing that'll do is create a frequency table for well class.
00:49
We have two types, private and public.
00:54
We can see that there are only two private and the rest of the 11, so 9, will be public.
00:58
So one graphical method for this, which would be quite relevant, would be a pie chart.
01:06
I'll say, well class frequency.
01:11
Grab that data, go to insert charts, pie chart.
01:17
Then we'll look at the aquifer type frequency.
01:25
Thankfully only two categories.
01:27
So there's bedrock and unconsolidated, abbreviate as uncons.
01:34
So there are four bedrock, and then there are four bedrock, and then, the remainder of the 11.
01:39
Oh, 11 minus 4, that would be 7.
01:42
So there would be 7 remaining, would be unconsolidated.
01:46
Again, this would be best described with a pie chart.
01:49
So i'll display that here.
01:52
And then we have our detect mtbe frequency.
02:02
There are two or three categories below.
02:05
I'll say below.
02:06
Oh, actually two categories below and detect mtbe or below.
02:11
Limit, might as well write it out fully.
02:14
We can see that there are one, two, three, four, five, six, seven, seven below limit, and that then there are four where we can detect.
02:25
A pie chart for that as well...