Mock Study You are the Director of Institutional Research at a small state university and you have been given the task of gathering information for the Dean of the School of Education regarding the performance of its undergraduate students on the Graduate Record Exam (GRE). Data on six variables were collected: gender, overall grade point average (GPA), major GPA, GRE scores in major area, GRE quantitative, GRE verbal, and type of preparation programs. The university is dedicated to maximizing student success on the GRE. The university has established five different options for students to prepare for the GREs: option 1 = completely online asynchronous prep course, 2 = completely online synchronous prep course, 3 = complete a hybrid prep course with a combination of online and face to face; 4 = complete a traditional instructor led prep course, and 5 = self-paced paper based prep course. The Dean has simply said to you, \"Tell me what works best and for whom?\" You decide to establish a pilot study with 50 randomly selected general science education seniors to determine the details of the methodology as well as to provide some initial data and corresponding results to learn if the research plan meets the Dean's needs. The pilot study needs to contain the following components written in APA format: Q1: What is the relationship of gender and overall GPA on GRE in major? Q2: What is the difference in major GRE scores based on major GPA? Q3: How well do overall GPA, gender, and type of GPA prep course predict GRE success in quantitative section? Ho1: Gender and overall GPA do not have a significant relationship to GRE in major success. Ha1: Gender and overall GPA have a significant relationship to GRE in major success. Ho2: There is no significant relationship in GRE scores based on major GPA. Ha2: There is a significant relationship in GRE scores based on major GPA. Ho3: There is no significant relationship between overall GPA, gender, and type of GRE prep course to GRE success in quantitative section. Ha3: There is a significant relationship between overall GPA, gender, and type of GRE prep course to GRE success in quantitative section. 1. Report appropriate descriptive results. 2. Present the results in a logical fashion, answering the research questions and testing the hypotheses as stated and in an appropriate manner for the type of data collected. 3. Identify the assumptions of statistical tests, explain the conducted tests to determine whether those assumptions were met, and discuss any violations of those assumptions. 4. Make decisions based on the results of the statistical analysis, such as whether the results were statistically significant, and include relevant test statistics and p values. 5. Refer to the APA Manual for guidance on how to present the results in the text, tables, and/or figures. 6. Present sufficient information so the Dean can make independent judgments about the findings. Appendix A Q1 ANOVA Sum of Squares VAR00001 Mean Square F Between Groups 6.020 26 .232 Within Groups 5.500 23 .239 11.520 49 Between Groups 1.012 26 .039 Within Groups 2.482 23 .108 Total 3.494 49 Total VAR00002 df Sig. .968 .535 .361 .993 Q2 One-Sample Statistics N Mean Std. Deviation Std. Error Mean VAR00003 50 3.7778 .19912 .02816 VAR00004 50 652.2000 70.86319 10.02157 One-Sample Test Test Value = 0 t df Sig. (2-tailed) Mean Difference 95% Confidence Interval of the Difference Lower Upper VAR00003 134.153 49 .000 3.77780 3.7212 3.8344 VAR00004 65.080 49 .000 652.20000 632.0609 672.3391 Q3 ANOVA Sum of Squares VAR00002 VAR00001 VAR00007 df Mean Square Between Groups 2.298 23 .100 Within Groups 1.196 26 .046 Total 3.494 49 Between Groups 5.853 23 .254 Within Groups 5.667 26 .218 Total 11.520 49 Between Groups 78.583 23 3.417 Within Groups 21.417 26 .824 100.000 49 Total F Sig. 2.172 .029 1.168 .349 4.148 .000 $FL2@(#) IBM SPSS STATISTICS DATA FILE MS Windows 20.0.0 ################2#########Y@25 Jul 1609:11:08 ###########################GENDER ########################OVERALLG####Overall GPA ########################MAJORGPA ###Major GPA ########################GRE $### Graduate Record Exam (GRE) in major########################GREQUANT####GRE quantitative########################GREVERBA####GRE Verbal ########################PREPARAT####Preparation Approach##############?#Male #######@#Female ########################################################################## ############################################################## ##################################################GENDER=Gender OVERALLG=OveralLGPA MAJORGPA=MajorGPA GRE=GRE GREQUANT=GREquantitative GREVERBA=GREverbal PREPARAT=PreparationApproach########################2######################Gend er:$@Role('0' )/OveralLGPA:$@Role('0' )/MajorGPA:$@Role('0' )/GRE:$@Role('0' )/GREquantitative:$@Role('0' )/GREverbal:$@Role('0' )/PreparationApproach:$@Role('0' )############ ###windows-1252#######fee333333 @#@#####P@#####p@######@ee(\\ @(\\#@######@##### @#####@q= p@ee p= #@#####@######@#####P@#Q @R#Q#@ee#####@#####p@#####`@Gz#@Hz#G#@#####@ef##### @#####@333333@#@#####`@######@ee######@(\\ @(\\#@#####@@#####p@#####@eeeq= p@ p= #@######@##### @######@eee#Q @#Q##@#####@######@#####@@efGz#@#Q @######@#####@#####p@{#Gz @fe#Gz##@#####@######@#####@Q# @Q##@fe#####p@#####@##### @= p= @p= @#####0@ff#####`@#####@)\\(#@(\\#@##### @#####0@ff#####@Q##@Q# @#####@######@#####0@fehf{#Gz#@#####@#####@#####@efeGz##@H z#G@#####@#####`@#####@hfe#Q#@#####@#####@@#####0@q= p#@ffh p= @##### @######@#####@(\\#@ff#####0@#####P@#####@333333#@ @#####p@geh##### @##### @Hz#G#@#####@#####@@ge#####@(\\ @(\\ @######@#####@#####p@gehgQ##@#####@#####@#####@@ege#Q @R#Q @#####@######@#####`@gf @#######@#####@#####P@######@ p= #@gf= p=#@#####@######@#####@(\\ @(\\ @ge#####@#####P@#####@Hz#G#@{#Gz#@#####@ge#####@######@ = p= @q= p @#####P@#####P@gf#####`@Q##@#Q#@#####@######@######@hfh ###### @333333 @#####P@#####@#####`@ehe(\\#@(\\#@#####@@#####@#####P@hf (\\ @(\\ @#####@#####`@######@#Gz# @he{#Gz#@#####@#####@@#####@Q# @#Q @hf#####`@######@#####p@R#Q @Q##@#####@he#####@#####@Hz#G @{#Gz @######@######@he##### @(\\ @(\\#@#####0@#####@#####@@hfh p= @= p= @######@#####p@#####@fhie @#####@#####0@#####@ie#@###### @#####p@#####@#####@ p= @hieg#####@#####@@#####@333333#@ieh##### @#####0@#####0@Gz# @#####p@if#####@#####@333333#@ffffff @#####@##### @ifh#####@{#Gz#@######@#####@#####@ieiffffff#@ @#####@#####@#####`}@ehifHz#G#@######@#####@##### @hi##z#G#@#####@@######@#####~@ WEEK 7: Creating Mock Data Thus far in the course, a provided data file has been used to complete the SPSS related assignments. This assignment will provide the opportunity to learn how to create an SPSS data file using the data below. The newly created data file in this activity will be used in the Signature Assignment in Activity 12. Creating this new data file now will allow any adjustments to be made based on mentor suggestions prior to completing the Signature Assignment in Activity 12. George and Mallery (2014) Chapter 3 will be useful in creating this new SPSS data file. In this mock data file there are 50 participants and 6 variables: Variable column 1: Gender 1=male, 2=female Variable column 2: overall grade point average (gpa) based on a 4 point system Variable column 3: major gpa based on a 4 point system Variable column 4; Graduate Record Exam (GRE) in major Variable column 5; GRE quantitative Variable column 6: GRE verbal Variable column 7: Preparation Approach ********************************************************************************** 2 3.65 3.85 650 750 640 1 1 3.62 3.82 640 740 630 1 1 3.68 3.88 660 760 650 1 1 3.59 3.79 630 750 620 1 1 3.71 3.91 670 740 660 1 2 3.65 3.85 620 760 610 1 1 3.62 3.82 680 750 670 1 1 3.68 3.88 610 740 600 1 1 3.59 3.89 690 760 680 1 1 3.71 3.59 600 720 590 1 2 3.56 3.76 700 770 690 2 1 3.74 3.94 590 720 580 2 1 3.53 3.73 710 780 700 2 2 3.77 3.97 580 710 570 2 2 3.49 3.69 720 770 710 2 1 3.81 4.00 570 700 560 2 1 3.46 3.66 730 780 720 2 1 3.84 4.00 560 680 550 2 1 3.43 3.63 740 770 730 2 2 3.87 4.00 550 650 540 2 2 3.40 3.60 750 740 740 3 1 1 1 1 1 2 2 1 1 2 2 1 1 2 1 2 1 1 2 2 1 1 1 1 2 2 1 1 2 3.91 3.37 3.94 3.34 3.35 3.38 3.32 3.41 3.28 3.44 3.25 3.47 3.22 3.51 3.19 3.54 3.16 3.57 3.13 3.60 3.10 3.63 3.00 3.71 2.90 3.81 2.80 3.91 3.86 4.00 3.57 4.00 3.54 3.75 3.78 3.72 3.81 3.68 3.84 3.65 3.87 3.62 3.81 3.59 3.94 3.56 3.97 3.53 4.00 3.50 4.00 3.40 4.00 3.30 4.00 3.20 4.00 4.00 540 760 530 790 630 660 660 670 650 670 650 680 630 690 620 700 610 710 600 720 590 730 580 750 560 760 530 770 520 680 720 730 640 650 640 650 660 650 640 630 670 620 680 610 690 600 700 590 710 570 680 550 730 580 630 670 560 600 530 750 520 780 600 630 630 640 620 640 620 650 600 660 590 670 580 680 570 690 560 700 550 720 530 730 470 740 490 3 3 3 3 3 3 3 3 3 4 4 4 4 4 4 4 4 4 4 5 5 5 5 5 5 5 5 5 5 Once the data have been entered into a SPSS file, save the file with the following file name: Your last name, initial of your first name, Mock Data.sav For example: AdamsHMockData.sav Upload the new SPSS data file for mentor feedback. WEEK 7: Creating Mock Data Thus far in the course, a provided data file has been used to complete the SPSS related assignments. This assignment will provide the opportunity to learn how to create an SPSS data file using the data below. The newly created data file in this activity will be used in the Signature Assignment in Activity 12. Creating this new data file now will allow any adjustments to be made based on mentor suggestions prior to completing the Signature Assignment in Activity 12. George and Mallery (2014) Chapter 3 will be useful in creating this new SPSS data file. In this mock data file there are 50 participants and 6 variables: Variable column 1: Gender 1=male, 2=female Variable column 2: overall grade point average (gpa) based on a 4 point system Variable column 3: major gpa based on a 4 point system Variable column 4; Graduate Record Exam (GRE) in major Variable column 5; GRE quantitative Variable column 6: GRE verbal Variable column 7: Preparation Approach ********************************************************************************** 2 3.65 3.85 650 750 640 1 1 3.62 3.82 640 740 630 1 1 3.68 3.88 660 760 650 1 1 3.59 3.79 630 750 620 1 1 3.71 3.91 670 740 660 1 2 3.65 3.85 620 760 610 1 1 3.62 3.82 680 750 670 1 1 3.68 3.88 610 740 600 1 1 3.59 3.89 690 760 680 1 1 3.71 3.59 600 720 590 1 2 3.56 3.76 700 770 690 2 1 3.74 3.94 590 720 580 2 1 3.53 3.73 710 780 700 2 2 3.77 3.97 580 710 570 2 2 3.49 3.69 720 770 710 2 1 3.81 4.00 570 700 560 2 1 3.46 3.66 730 780 720 2 1 3.84 4.00 560 680 550 2 1 3.43 3.63 740 770 730 2 2 3.87 4.00 550 650 540 2 2 3.40 3.60 750 740 740 3 1 1 1 1 1 2 2 1 1 2 2 1 1 2 1 2 1 1 2 2 1 1 1 1 2 2 1 1 2 3.91 3.37 3.94 3.34 3.35 3.38 3.32 3.41 3.28 3.44 3.25 3.47 3.22 3.51 3.19 3.54 3.16 3.57 3.13 3.60 3.10 3.63 3.00 3.71 2.90 3.81 2.80 3.91 3.86 4.00 3.57 4.00 3.54 3.75 3.78 3.72 3.81 3.68 3.84 3.65 3.87 3.62 3.81 3.59 3.94 3.56 3.97 3.53 4.00 3.50 4.00 3.40 4.00 3.30 4.00 3.20 4.00 4.00 540 760 530 790 630 660 660 670 650 670 650 680 630 690 620 700 610 710 600 720 590 730 580 750 560 760 530 770 520 680 720 730 640 650 640 650 660 650 640 630 670 620 680 610 690 600 700 590 710 570 680 550 730 580 630 670 560 600 530 750 520 780 600 630 630 640 620 640 620 650 600 660 590 670 580 680 570 690 560 700 550 720 530 730 470 740 490 3 3 3 3 3 3 3 3 3 4 4 4 4 4 4 4 4 4 4 5 5 5 5 5 5 5 5 5 5 Once the data have been entered into a SPSS file, save the file with the following file name: Your last name, initial of your first name, Mock Data.sav For example: AdamsHMockData.sav Upload the new SPSS data file for mentor feedback