From my lecture note at university #12(Modeling with statistics)

Today it was the second session for hypothetical testing.

We focused on testing a gap of two averages, which I believe is the most commonly used in practical business situations.

It was really hard to explain the concept of the statistical hypothesis testing, which is very confusing for beginners.

Concept of “Population” and “Sample” is the first one you have to understand as well as the fact that, in most cases, we are using “sample” data for data analysis.

無題

From such academic topic, we moved to a practical topic, which is the test of two average gap between two groups.

Excel (T.TEST) function helps you to minimize your calculation to reach the conclusion as long as you understand how the testing works.

無題2

For the practical use, my advice was to focus only on the determinations on “one-tailed or two-tailed distribution” and “type of the testing”, which you have to specify in the function.

無題3

Once the class understood the concept and theory, we moved to the practical exercises.

無題4

Apart from those exercises, we tested the gap of average amounts to pay for lunch between “female” and ” male” students, by using sample data of the class.

It was really fun!

Finally this is today’s take-away.

無題5

Thank you again for enjoying my class today!

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s