Great Deal! Get Instant $10 FREE in Account on First Order + 10% Cashback on Every Order Order Now

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...

1 answer below »
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
Answered 3 days After Feb 23, 2023

Solution

Monica answered on Feb 27 2023
43 Votes
Data cleaning
1. Remove the outlier points from the dataset using the below formula,
Q1 +1.5*IQR and Q3 – 1.5*IQR
2. The points which are below and above from the above points are considered outlier.
    outlier
    29.5
    19.125
    4
    4.4
    Outlier
    8.5
    6.375
    1.6
    2
Co
elation Analysis Results –
    Var1
    Var2
    Var3
    Var4
    Var5
    Var6
    Var7
     
    Game
    Compute
    Gende
    Online
    Study
    GPA1
    Game
    1
    0.01118
    0.3468
    -0.2838
    0.1813
    0.2973
    Compute
    0.01118
    1
    -0.03083
    -0.1179
    -0.1028
    -0.1132
    Gende
    0.3468
    -0.03083
    1
    -0.3437
    0.04906
    0.1127
    Online
    -0.2838
    -0.1179
    -0.3437
    1
    0.01866
    -0.2078
    Study
    0.1813
    -0.1028
    0.04906
    0.01866
    1
    0.3733
    GPA1
    0.2973
    -0.1132
    0.1127
    -0.2078
    0.3733
    1
16)
Based on the given standard of a co
elation coefficient greater than 0.1593, the variable pairs that are significant and positively related are:
Game and GPA1 (co
elation coefficient = 0.2973, which is greater than 0.1593)
Study and GPA1 (co
elation coefficient = 0.3733, which is greater than 0.1593)
Based on the given co
elation coefficients and the significance level of 0.05, the variable pairs that are significant and positively related are:
17: Based on the given standard, there are no variable pairs that are significant and negatively related in the co
elation matrix. None of the co
elation coefficients in the matrix have a value less than -0.1593.
18: Based on the given standard, the variable pairs that are not related (or have a very weak relationship) are:
Game and Computer (co
elation coefficient = 0.01118, which is less than 0.1593)
Computer and Gender (co
elation coefficient = -0.03083, which is less than 0.1593)
Gender and Online (co
elation coefficient = -0.3437, which is less than 0.1593)
Online and Study (co
elation coefficient = 0.01866, which is less than 0.1593)
Results of first model
    Var1
    Var2
    Var3
    Var4
    Var5
    ['Fitted Equation: ', 'GPA1 = 2.211 + 0.06620...
SOLUTION.PDF

Answer To This Question Is Available To Download

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here