(upbeat music)
- [Instructor] Okay, I'm in Excel with a new data set
and it's time for another challenge.
So we've switched to a different one now,
it's called Bank Salaries Causality
and I'm going to provide the data set for you.
However, you don't really need the data set
if you choose not to go in there.
Let me orient you to it first,
but I'm going to show you an image
and really all you need is the image
and to take a look at it to do the solution.
But if you want to, you can open the data set.
So what we have is beginning salary, current salary
and a number of other variables.
There is a tab here that gives you a little bit
of information about the variables.
And what we're going to do is determine
whether or not we think we see mediation, moderation
or some third variable issue.
Okay, here's the image.
We've got beginning salary in the Y axis,
we have education level in the X axis
and this is the data that you were just looking at.
Now, the higher of the two lines is the blue line
and that represents the men,
and the lower of the two lines is the green line
and that represents the women.
So you got three variables,
you have a dependent variable, beginning salary,
you have an independent variable, education level,
and you have another independent variable, gender.
So here's the question.
When you look at this, do you see mediation, moderation
or the third variable problem?
And then just spend a couple of minutes on that.
And again, you're welcome to look at the data if you choose.
And after that, if you care to, do you see the potential
for any other issues, maybe not these three variables
but when you look at the dataset,
do you see any other issues?
That's kind of an optional second question.
Okay, so look it over.
Again, you don't have to spend a lot of time
and next we'll do the solution.