Game Computer Gender Online Study GPA1 GPA2
Yes Windows Female XXXXXXXXXX
Yes Windows Female XXXXXXXXXX
Yes Windows Female XXXXXXXXXX
Yes Windows Female XXXXXXXXXX
Yes Windows Female XXXXXXXXXX
Yes Windows Female XXXXXXXXXX
Yes Windows Female XXXXXXXXXX
Yes Windows Female XXXXXXXXXX
Yes Windows Female XXXXXXXXXX
Yes Windows Female XXXXXXXXXX
Yes Windows Female XXXXXXXXXX
Yes Windows Female XXXXXXXXXX
Yes Windows Female XXXXXXXXXX
Yes Windows Female XXXXXXXXXX
Yes Windows Female XXXXXXXXXX
Yes Windows Female XXXXXXXXXX
Yes Windows Female XXXXXXXXXX
Yes Windows Female XXXXXXXXXX
Yes Windows Female XXXXXXXXXX
Yes Windows Female XXXXXXXXXX
Yes Windows Female XXXXXXXXXX
Yes Windows Female XXXXXXXXXX
Yes Windows Female XXXXXXXXXX
Yes Windows Female XXXXXXXXXX
Yes Windows Female XXXXXXXXXX
Yes Windows Female XXXXXXXXXX
Yes Windows Female XXXXXXXXXX
Yes Windows Female XXXXXXXXXX
Yes Windows Female XXXXXXXXXX
Yes Windows Female XXXXXXXXXX
No Windows Female XXXXXXXXXX
No Windows Female XXXXXXXXXX
No Windows Female XXXXXXXXXX
No Windows Female XXXXXXXXXX
No Windows Female XXXXXXXXXX
No Windows Female XXXXXXXXXX
No Windows Female XXXXXXXXXX
No Windows Female XXXXXXXXXX
No Windows Female XXXXXXXXXX
No Windows Female XXXXXXXXXX
No Windows Female XXXXXXXXXX
No Windows Female XXXXXXXXXX
No Windows Female XXXXXXXXXX
No Windows Female XXXXXXXXXX
No Windows Female XXXXXXXXXX
No Windows Female XXXXXXXXXX
No Windows Female XXXXXXXXXX
No Windows Female XXXXXXXXXX
No Windows Female XXXXXXXXXX
No Windows Female XXXXXXXXXX
No Windows Female XXXXXXXXXX
No Windows Female XXXXXXXXXX
No Windows Female XXXXXXXXXX
No Windows Female XXXXXXXXXX
No Windows Female XXXXXXXXXX
No Windows Female XXXXXXXXXX
No Windows Female XXXXXXXXXX
No Windows Female XXXXXXXXXX
Yes Mac Female XXXXXXXXXX
Yes Mac Female XXXXXXXXXX
Yes Mac Female XXXXXXXXXX
Yes Mac Female XXXXXXXXXX
Yes Mac Female XXXXXXXXXX
Yes Mac Female XXXXXXXXXX
Yes Mac Female XXXXXXXXXX
Yes Mac Female XXXXXXXXXX
Yes Mac Female XXXXXXXXXX
Yes Mac Female XXXXXXXXXX
Yes Mac Female XXXXXXXXXX
Yes Mac Female XXXXXXXXXX
Yes Mac Female XXXXXXXXXX
Yes Mac Female XXXXXXXXXX
Yes Mac Female XXXXXXXXXX
Yes Mac Female XXXXXXXXXX
Yes Mac Female XXXXXXXXXX
Yes Mac Female XXXXXXXXXX
Yes Mac Female XXXXXXXXXX
No Mac Female XXXXXXXXXX
No Mac Female XXXXXXXXXX
No Mac Female XXXXXXXXXX
No Mac Female XXXXXXXXXX
No Mac Female XXXXXXXXXX
No Mac Female XXXXXXXXXX
No Mac Female XXXXXXXXXX
No Mac Female XXXXXXXXXX
No Mac Female XXXXXXXXXX
No Mac Female XXXXXXXXXX
No Mac Female XXXXXXXXXX
No Mac Female XXXXXXXXXX
No Mac Female XXXXXXXXXX
No Mac Female XXXXXXXXXX
No Mac Female XXXXXXXXXX
No Mac Female XXXXXXXXXX
No Mac Female XXXXXXXXXX
No Mac Female XXXXXXXXXX
No Mac Female XXXXXXXXXX
No Mac Female XXXXXXXXXX
No Mac Female XXXXXXXXXX
No Mac Female XXXXXXXXXX
Yes Windows Male XXXXXXXXXX
Yes Windows Male XXXXXXXXXX
Yes Windows Male XXXXXXXXXX
Yes Windows Male XXXXXXXXXX
Yes Windows Male XXXXXXXXXX
Yes Windows Male XXXXXXXXXX
Yes Windows Male XXXXXXXXXX
Yes Windows Male XXXXXXXXXX
Yes Windows Male XXXXXXXXXX
Yes Windows Male XXXXXXXXXX
Yes Windows Male XXXXXXXXXX
Yes Windows Male XXXXXXXXXX
Yes Windows Male XXXXXXXXXX
Yes Windows Male XXXXXXXXXX
Yes Windows Male XXXXXXXXXX
Yes Windows Male XXXXXXXXXX
Yes Windows Male XXXXXXXXXX
Yes Windows Male XXXXXXXXXX
Yes Windows Male XXXXXXXXXX
Yes Windows Male XXXXXXXXXX
Yes Windows Male XXXXXXXXXX
Yes Windows Male XXXXXXXXXX
Yes Windows Male XXXXXXXXXX
Yes Windows Male XXXXXXXXXX
Yes Windows Male XXXXXXXXXX
Yes Windows Male XXXXXXXXXX
Yes Windows Male XXXXXXXXXX
Yes Windows Male XXXXXXXXXX
Yes Windows Male XXXXXXXXXX
Yes Windows Male XXXXXXXXXX
Yes Windows Male XXXXXXXXXX
Yes Windows Male XXXXXXXXXX
Yes Windows Male XXXXXXXXXX
Yes Windows Male XXXXXXXXXX
Yes Windows Male XXXXXXXXXX
Yes Windows Male XXXXXXXXXX
Yes Windows Male XXXXXXXXXX
Yes Windows Male XXXXXXXXXX
Yes Windows Male XXXXXXXXXX
Yes Windows Male XXXXXXXXXX
No Windows Male XXXXXXXXXX
No Windows Male XXXXXXXXXX
No Windows Male XXXXXXXXXX
No Windows Male XXXXXXXXXX
No Windows Male XXXXXXXXXX
No Windows Male XXXXXXXXXX
No Windows Male XXXXXXXXXX
No Windows Male XXXXXXXXXX
No Windows Male XXXXXXXXXX
No Windows Male XXXXXXXXXX
No Windows Male XXXXXXXXXX
Yes Mac Male XXXXXXXXXX
Yes Mac Male XXXXXXXXXX
Yes Mac Male XXXXXXXXXX
Yes Mac Male XXXXXXXXXX
Yes Mac Male XXXXXXXXXX
Yes Mac Male XXXXXXXXXX
Yes Mac Male XXXXXXXXXX
Yes Mac Male XXXXXXXXXX
Yes Mac Male XXXXXXXXXX
Yes Mac Male XXXXXXXXXX
Yes Mac Male XXXXXXXXXX
Yes Mac Male XXXXXXXXXX
Yes Mac Male XXXXXXXXXX
Yes Mac Male XXXXXXXXXX
Yes Mac Male XXXXXXXXXX
Yes Mac Male XXXXXXXXXX
Yes Mac Male XXXXXXXXXX
Yes Mac Male XXXXXXXXXX
Yes Mac Male XXXXXXXXXX
Yes Mac Male XXXXXXXXXX
Yes Mac Male XXXXXXXXXX
Yes Mac Male XXXXXXXXXX
Yes Mac Male XXXXXXXXXX
Yes Mac Male XXXXXXXXXX
Yes Mac Male XXXXXXXXXX
Yes Mac Male XXXXXXXXXX
Yes Mac Male XXXXXXXXXX
Yes Mac Male XXXXXXXXXX
Yes Mac Male XXXXXXXXXX
Yes Mac Male XXXXXXXXXX
Yes Mac Male XXXXXXXXXX
Yes Mac Male XXXXXXXXXX
No Mac Male XXXXXXXXXX
No Mac Male XXXXXXXXXX
No Mac Male XXXXXXXXXX
No Mac Male XXXXXXXXXX
No Mac Male XXXXXXXXXX
No Mac Male XXXXXXXXXX
No Mac Male XXXXXXXXXX
No Mac Male XXXXXXXXXX
1
ACTIVITY 2 WORKSHEET
Activity #2: Co
elation, Regression, and Probability
Please read the instructions carefully and complete the following 38 online questions within
the given time, 60 minutes. You have 3 attempts available in this activity. The highest score
counts.
Problem solving strategies:
1. Download the Activity 2 Worksheet.
2. Locate the saved data file used in the Activity 1.
3. Working on the questions in the activity offline.
4. Round answers to 4 decimal places if possible.
5. After completing the activity questions offline, fill in the question answers online
within the time limit.
6. Check the scores on each question and redo the questions for the second or the third
attempts.
7. REMEMBER! You have to complete the online questions! NOT submitting the
activity question file.
Please notice that if you are using the data file saved from the previous activities, you are
good to go for the questions. However, if you are downloading the original data file (Original
Data.xlsx), you need to clean up the outliers by following the procedures in the previous
activity.
The co
ect data file used in this activity should include 187 observations with 7 variables.
In this activity, you are going to learn about how two variables can be related to each other
and how one variable can be used to predict the outcomes of the other variable. Since
co
elations can be applied only to those numerical variables, you need to transfer those
nominal variables into numbers.
To do this, please use the “Evaluate Formula” function under the “Insert” pull-down menu.
Copy and paste the following formula into the dialogue box and click “Evaluate”.
if([Game]="Yes",1,2)
This function creates a new variable (at the end of the last variable) with 1 as “Yes” and 2 as
“No”.
Copy and paste the following formula into the dialogue box and click “Evaluate”.
if([Computer]="Windows",1,2)
This function creates a new variable (at the end of the last variable) with 1 as “Windows” and
2 as “Mac”.
Copy and paste the following formula into the dialogue box and click “Evaluate”.
if([Gender]="Female",1,2)
2
This function creates a new variable (at the end of the last variable) with 1 as “Female” and 2
as “Male”.
Please “Rename” the variables (under the pull-down menu at each variable name) as
“Game1”, “Computer1”, and “Gender1”, respectively.
The next task is to create Scatterplots among those variables. Scatterplots use Cartesian
coordinates to show the relationship between two numerical variables. Use “Scatterplot”
function under the “Graphics” pull-down menu. Enter proper X (the Independent (or
predictor) variable) and Y (the dependent (or response) variable) and then “Calculate”.
(Since the new variables, “Game1”, “Computer1”, and “Gender1” have only two levels, the
scatterplot using these variables will be almost useless. Therefore, those scatterplots will not
e performed.) The remaining 4 variable can be paired-up to show 6 scatterplots.
Although to show the scatterplot results is not required in this activity, they are very useful to
detect for outliers.
Unfortunately, the scatterplot itself shows very little information as they do not include any
“statistics”. To be able to evaluate the relationship strength and the direction of the variable
pairs, you need to find the co
elation coefficients among those interested variable pairs by
using the “Co
elation” function under the “Statistics” pull-down menu. A total of six
variables will be selected and then “Calculate”. (GPA 2 will not be included because it is
depending on GPA 1.)
Q1: Find the co
elation coefficients (r) of each variable pair. (Round answers to 4
decimal places.) (Includes 15 answers. Next question is Q16.)
Game Computer Gender Online Study
Computer
Gender
Online
Study
GPA1
3
With a sample size between 150 and 300, we need a co
elation coefficient that is greater
than XXXXXXXXXXto claim that the relationship between two variables is significant at an alpha
level of XXXXXXXXXXWe will talk about the alpha level in later chapters.)
Q16: With this standard, please identify those variable pairs which are significant and
positively related.
Q17: With this standard, please identify those variable pairs which are significant and
negative related.
Q18: With this standard, please identify those variable pairs which are not related.
Since there are some significant relationships found. Some Regression models can be used to
describe their relationships. We are going to test two regression models.
In CrunchIt, select Statistics>Regression>Simple Linear and use