Project 1 uses actual research data collected from a random sample ofN= 340 certified flight instructors (CFIs). This dataset is given as the Excel file"Week9-ResearchProject 2A Data."

As a reminder, the initialdata set consists of the following 10 independent variables (IVs) and one dependentvariable (DV):

X₁=Participants'gender

X₂ = Participants' age in yearsX₃ =Participants' race/ethnicityX₄=Participants'maritalstatus

X₅=Participants' highest level of education

X₆=Totalyears participants haveheld a CFIcertificate

X₇=Participants'total hoursdualgiven

X₈=Participants'totalhoursdualgiveninprevious90days

X₉=Participants'totalflighttime(inhours)

X₁₀=Typesofcertificatesparticipantscurrenthold

Y= Complacency scores, which weremeasured on a 7-?item Likert scale ranging from 1 = Strongly Disagree to 5 = Strongly Agree. Thus, scores could rangefrom 7 to 35, with higher scores indicating a greater likelihood towardcomplacencyasaflight instructor.

Project 1 Questions 1. Create a new categorical variable, Yil, which represents the partitioning of X6 into two groups: Group 1 = CFIs who have held a CFI certificate for less than 20 years and Group 2 = CFIs who have held a CFI certificate for 20 years or more. 2. What is the overall RQ? 3. What research methodology do you think is appropriate for this study? Explain. 4. Summarize the descriptive statistics for Complacency scores using the following APA compliant table. (Round to two decimal places.) Group N M SD Range (L-H) Less than 20 years 20 or more years Overall 5. Perform an a priori power analysis to determine the minimum sample size needed. Is the given data set sufficient relative to this minimum sample size? In what way do you think the size of the given sample will impact the results? 6. Conduct a corresponding hypothesis test as follows: a. Formulate the null and alternative hypotheses in symbols and words. b. Determine the test criteria c. Test for the assumptions of independent samples { test and indicate if you will use the pooled variance t, separate variances t, or Welch's t, and why. d. Run the analysis and record the results. e. Make a decision to reject or fail to reject the null hypothesis and write a concluding statement. 7. Determine and interpret the estimated effect size, d. 8. Determine and interpret the power of the study. 9. Determine and interpret the 95% confidence interval. 10. Present at least three plausible explanations for the results