Shamima: Hello, students.
So as I mentioned during our examples
as we were going through them
that I was going to show you how to use Excel
to sort our data from smallest to largest.
And that's what I'm doing here using Excel.
So first what I'm gonna do is just enter the data
the way they are.
For example, problem one.
So 185,
225, 240,
196,
175,
180,
194,
147,
and 223.
So what are the numbers here?
The numbers here I like to double check my entries.
180, 225, 240, 196, 175,
180, 194, 147 and 223.
So now all you have to do is highlight them
and then go here.
It says sort and filter.
So you go to sort and filter
and go sort smallest to largest.
Then we are done.
So now you can see it is sorted.
147, 175, 180, 185,
194, 196, 223, 225
and 240.
Right? Great.
So let's do another one because I know we worked
on another problem quite thoroughly, which was problem 20.
So let's enter the data there.
So here again it's 7, 35, 5,
9, 8, 3,
and 12 and 8.
Okay, so let's go through it again.
7, 35, 5, 9, 8,
3, 10, 12, and 8.
Okay, so again, we highlight them here,
we go to the sort and filter, go sort smallest to largest.
And that's it.
It's sorted again.
So this is a really, really quick way to filter
and sort our data to do the descriptive statistics
that we just learned for chapter four.
Now, one thing I want to show you here, and again
no pressure, you do not have to use Excel at all.
A lot of students do not use Excel
and they do great in this class.
But I just want to show you how easy it is to use Excel
to check your work because you still have to show me
all your work and you have to do the calculation by hand
so that I can see that you understood the process.
Like I said, we need to understand the concepts
behind the statistical analysis.
Very important.
So here I'm just showing you the table.
So we have basically X of i,
which is all our values.
Again, these are here entered in the ordered set.
Then we have the middle column
which is the individual value minus our mean
which is the X part, and here we have those values
and then we have the square of the middle column.
So I have done this basically, and you can click on these
and take a look at the form list I have used.
This can really, really help you double check your work
whether it's for the homework problems
or whenever you are taking the test.
Again, this will take a little extra time
so only do it if you have the time.
If you don't have it, please avoid it.
Then what I have done here is I have summarized this column.
As you can see, I used the sum function from Excel
to summarize A2 through A10.
And then I have summarized the middle column again
because as I said, you wanna double check your work.
This middle column should always add up to zero.
It didn't because we had a decimal.
So again, I want you to look at that and see
that here we are 0.1, so very close to zero
but it's not exactly zero because of the decimal.
Again, here the third column
I have used the sum function to calculate
the sum again here.
C2 to C10.
Again, you have to do the calculation,
you have to show me your work
but you can use Excel to double check your work.
Now this one, as you can see the average
it's a function of Excel.
I have used that to calculate my average.
Again, it's A2 through A10.
Keep in mind I did not include A11
in the average calculation
and that is for very good reason.
A11 is not part of our dataset.
A11 is the sum of our dataset.
And again, here the same thing for the standard deviation
I have used A2 through A10.
I did not use or did not include A11 or A12
because they are not part of our dataset.
So again, these are just simple ways
to double check your work by using Excel.
Many of you probably are quite familiar with Excel.
Maybe you are not.
If you are not, if you want to learn it
this might be an easy way to start learning how to use Excel
for simple calculations and also for this class
to kind of double check your work.
But again, if it is too much
you don't want to learn it, that's fine.
No pressure.
So that's about it, okay?
This is all I'm going to cover as far as
chapter four is concerned for basically for our examples.
And again, these examples hopefully will really help you
to work on the homework assignments as well as the test.
And again, please feel free to reach out.
I'm here to help.
Thank you for your time and attention.
I know these were a lot of problems
and a lot of detailed calculation
but I really enjoyed going through them.
So I hope you enjoy learning them too.
Thank you.