doing a data
Game Computer Gender Online Study GPA1 GPA2 Yes Windows Female 31 10 2.2 2.6 Yes Windows Female 31 10 2.4 2.8 Yes Windows Female 24 15 2.2 2.9 Yes Windows Female 28 14 2.9 3 Yes Windows Female 24 15 2.7 3.1 Yes Windows Female 19 17 3.1 3.1 Yes Windows Female 30 11 2.9 3.2 Yes Windows Female 24 16 2.9 3.2 Yes Windows Female 26 13 3 3.2 Yes Windows Female 24 15 2.6 3.4 Yes Windows Female 27 21 3 3.4 Yes Windows Female 20 17 3 3.7 Yes Windows Female 27 15 3 3.8 Yes Windows Female 20 17 3.1 3.8 Yes Windows Female 19 17 3.2 4 Yes Windows Female 19 19 3.2 4 Yes Windows Female 18 16 3.4 4 Yes Windows Female 26 16 3.4 4 Yes Windows Female 18 17 3.4 4 Yes Windows Female 18 17 3.4 4 Yes Windows Female 26 16 3.5 4 Yes Windows Female 26 17 3.5 4 Yes Windows Female 18 18 3.5 4 Yes Windows Female 25 13 3.6 4 Yes Windows Female 25 17 3.6 4 Yes Windows Female 25 14 3.7 4 Yes Windows Female 18 18 3.7 4 Yes Windows Female 18 18 3.7 4 Yes Windows Female 18 19 3.8 4 Yes Windows Female 18 22 3.9 4 No Windows Female 22 17 2.6 2.7 No Windows Female 23 16 2.6 3.4 No Windows Female 23 16 3 3.4 No Windows Female 23 16 3.2 3.4 No Windows Female 23 16 3 3.5 No Windows Female 22 18 3.4 3.5 No Windows Female 22 18 3.2 3.8 No Windows Female 23 16 3.3 3.8 No Windows Female 23 17 3.4 3.8 No Windows Female 17 18 3.7 3.8 No Windows Female 23 16 3.3 3.9 No Windows Female 22 18 3.4 3.9 No Windows Female 24 15 3.2 4 No Windows Female 23 16 3.2 4 No Windows Female 17 15 3.3 4 No Windows Female 23 16 3.3 4 No Windows Female 17 16 3.4 4 No Windows Female 22 19 3.4 4 No Windows Female 24 20 3.4 4 No Windows Female 23 17 3.5 4 No Windows Female 22 20 3.5 4 No Windows Female 22 20 3.5 4 No Windows Female 22 22 3.6 4 No Windows Female 22 23 3.6 4 No Windows Female 22 52 3.6 4 No Windows Female 24 17 3.7 4 No Windows Female 17 18 3.7 4 No Windows Female 17 19 3.8 4 Yes Mac Female 18 17 2.3 2.3 Yes Mac Female 18 20 2.6 2.7 Yes Mac Female 18 19 2.3 2.8 Yes Mac Female 19 14 2.5 2.9 Yes Mac Female 19 16 2.6 2.9 Yes Mac Female 18 17 2.3 3 Yes Mac Female 18 19 2.6 3 Yes Mac Female 19 23 3 3 Yes Mac Female 18 19 2.4 3.1 Yes Mac Female 19 16 2.6 3.1 Yes Mac Female 26 10 2.8 3.1 Yes Mac Female 21 12 3 3.1 Yes Mac Female 21 12 2.8 3.3 Yes Mac Female 25 11 2.9 3.4 Yes Mac Female 26 10 2.7 3.5 Yes Mac Female 19 17 2.9 3.5 Yes Mac Female 20 13 2.8 3.6 Yes Mac Female 20 14 3.1 3.8 Yes Mac Female 19 23 3 3.9 No Mac Female 24 10 2.4 2.8 No Mac Female 24 12 2.8 3.2 No Mac Female 23 14 3.1 3.5 No Mac Female 22 15 3.1 3.6 No Mac Female 22 16 3.4 3.7 No Mac Female 22 16 3.3 3.8 No Mac Female 23 12 2.9 3.9 No Mac Female 12 19 0 4 No Mac Female 23 14 3.1 4 No Mac Female 12 12 3.3 4 No Mac Female 22 15 3.3 4 No Mac Female 22 17 3.4 4 No Mac Female 21 17 3.5 4 No Mac Female 17 17 3.6 4 No Mac Female 17 19 3.7 4 No Mac Female 17 19 3.7 4 No Mac Female 16 11 3.8 4 No Mac Female 16 12 3.9 4 No Mac Female 15 14 3.9 4 No Mac Female 16 19 3.9 4 No Mac Female 13 15 4 4 No Mac Female 13 19 4 4 Yes Windows Male 20 16 2.1 2.5 Yes Windows Male 19 11 2.5 2.6 Yes Windows Male 30 10 2.6 2.6 Yes Windows Male 19 9 2.2 2.8 Yes Windows Male 29 9 2 2.9 Yes Windows Male 29 12 2.4 2.9 Yes Windows Male 29 11 2.4 3 Yes Windows Male 29 14 2.5 3 Yes Windows Male 29 14 2.5 3 Yes Windows Male 27 12 2.6 3 Yes Windows Male 19 13 2.7 3 Yes Windows Male 28 11 2.8 3.1 Yes Windows Male 28 11 2.8 3.2 Yes Windows Male 26 13 2.8 3.2 Yes Windows Male 25 15 3 3.2 Yes Windows Male 19 11 2.6 3.3 Yes Windows Male 19 12 2.6 3.3 Yes Windows Male 29 15 2.6 3.3 Yes Windows Male 20 15 3.3 3.3 Yes Windows Male 19 10 2.5 3.4 Yes Windows Male 25 15 2.9 3.4 Yes Windows Male 27 10 3.2 3.4 Yes Windows Male 21 12 3.2 3.4 Yes Windows Male 26 12 2.7 3.6 Yes Windows Male 26 12 2.7 3.6 Yes Windows Male 25 9 2.8 3.7 Yes Windows Male 25 14 2.8 3.7 Yes Windows Male 25 15 3 3.7 Yes Windows Male 25 15 3 3.8 Yes Windows Male 24 12 3.1 3.8 Yes Windows Male 19 14 2.9 3.9 Yes Windows Male 28 14 3.1 4 Yes Windows Male 20 15 3.2 4 Yes Windows Male 19 16 3.2 4 Yes Windows Male 20 14 3.3 4 Yes Windows Male 27 11 3.6 4 Yes Windows Male 27 13 3.6 4 Yes Windows Male 18 15 3.8 4 Yes Windows Male 18 15 3.9 4 Yes Windows Male 17 17 3.9 4 No Windows Male 29 7 2 2.4 No Windows Male 17 15 3.8 4 No Windows Male 17 15 3.8 4 No Windows Male 17 15 3.8 4 No Windows Male 22 9 3.9 4 No Windows Male 22 14 3.9 4 No Windows Male 17 15 3.9 4 No Windows Male 15 17 3.9 4 No Windows Male 12 14 4 4 No Windows Male 22 14 4 4 No Windows Male 21 15 4 4 Yes Mac Male 26 16 2.8 2.9 Yes Mac Male 20 12 2.7 3 Yes Mac Male 28 12 2.8 3 Yes Mac Male 26 16 3 3 Yes Mac Male 20 10 2.7 3.1 Yes Mac Male 28 13 3 3.1 Yes Mac Male 21 13 3.1 3.1 Yes Mac Male 26 16 3 3.2 Yes Mac Male 26 16 3 3.2 Yes Mac Male 32 16 2.7 3.3 Yes Mac Male 28 14 3.1 3.4 Yes Mac Male 21 12 3.2 3.4 Yes Mac Male 26 16 2.9 3.5 Yes Mac Male 27 21 2.7 3.6 Yes Mac Male 26 18 3.1 3.7 Yes Mac Male 25 10 3.4 3.9 Yes Mac Male 29 16 3 4 Yes Mac Male 20 12 3.2 4 Yes Mac Male 25 9 3.3 4 Yes Mac Male 31 10 3.3 4 Yes Mac Male 28 15 3.3 4 Yes Mac Male 30 10 3.5 4 Yes Mac Male 25 14 3.5 4 Yes Mac Male 28 17 3.5 4 Yes Mac Male 35 9 3.6 4 Yes Mac Male 24 11 3.6 4 Yes Mac Male 24 12 3.7 4 Yes Mac Male 21 13 3.8 4 Yes Mac Male 27 18 3.8 4 Yes Mac Male 55 19 3.8 4 Yes Mac Male 21 14 4 4 Yes Mac Male 27 19 4 4 No Mac Male 21 21 3.5 3.5 No Mac Male 22 19 3.5 3.8 No Mac Male 16 21 3.6 3.9 No Mac Male 24 17 3.3 4 No Mac Male 23 18 3.4 4 No Mac Male 22 19 3.5 4 No Mac Male 15 22 3.7 4 No Mac Male 11 22 4 4 1 ACTIVITY 2 WORKSHEET Activity #2: Correlation, 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 correct 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 correlations 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 be 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 correlation coefficients among those interested variable pairs by using the “Correlation” 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 correlation 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 correlation coefficient that is greater than 0.1593 to claim that the relationship between two variables is significant at an alpha level of 0.05. (We 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