Google Sheets Descriptive Statistics


This video shows how to use Google
Sheets and the Mann-Whitney test to do a two-group comparison. Let’s begin by accessing the data sheet
and so we’re going to scroll down. This is the data sheet we want to access. It’s on Google Sheets and it represents information obtained from a
questionnaire about midlife crises. We have these variables: dummy coding of male-female, age, social class, religiosity, whether or not someone predicts that a
midlife crisis for himself or herself is very likely, the estimate of the percent
of men today in the US who have midlife crises and the estimate of the
percentage of men in the past (about 50 years ago) who had midlife crises. One of the things we like to do when we begin to look at our data in a spreadsheet, is
to do some error checking with some of the descriptive statistics. So let’s
begin by going over here and getting the COUNT. What we’re going to do is look
at the first column, which is gender, we’re going to look at rows b11 colon b60 because that covers our entire sample. We have a count of 50, no missing data. We then get the AVERAGE for that column: 52% of the column is male. Let’s get the MAXIMUM score, one, and the MINIMUM score, zero. Now, let’s take each of those four descriptive statistics for our
first variable and let’s hold down the mouse and drag it across all the
variables. Now we release and those same four calculations are done for all of the
variables, and we can verify that we have a count of 50 for each variable, in other
words no missing data. We can also verify that all of our data are between the
assigned norms of maximum and minimum for each variable. What we want to do in this example of an abstract is to compare two groups, male and female, on the basis of
some other variable. In this example, we’ll do social class, but you may be
called upon to use one of the other variables. Notice that we have arranged the data so that all the women are together and all of the men are together. The men occupy rows 11 through 36, the women occupy 37 through 60, so we have 26 males and 24 females. Let’s compare the male group and the female group on the variable of social class. So, we go up here and we’ll get another
average but this time it’s in column D and we’re just looking at Row d11 colon
d36 to cover the males. So the average male social class was 2.4. Now let’s get
the average for the females. Again, AVERAGE and it’s going to be d37 colon d60, and as we can see, the female average was a little bit higher: 2.8 vs 2.4. Now,
is that difference going to be a significant one? We will have to use an
inferential statistic and that we will cover in the next video.

Write a Comment

Your email address will not be published. Required fields are marked *