Grantham University Complete Research Method Worksheet You will need to use and be familiar with Megastat to complete this assignmentYou must show work and

Grantham University Complete Research Method Worksheet You will need to use and be familiar with Megastat to complete this assignmentYou must show work and answer all questions in detail and correctly You must include the megastat excel worksheet with the word document t worksheet Assignment 4 – Summer 2020 [Due by midnight on 7/14/2020]
Instructions:
(i).
Use the IQdataModified data set.
(ii).
For questions involving test of hypothesis (Questions: 2, 4, 5, 6, 7, 8, and 9a), you must
provide the Null and Alternate hypotheses, the type of test you used, the p-value, and
your conclusion (in context), all in a nicely written paragraph.
(iii).
Organize your output to follow the sequence of the questions. Submit your actual Excel
MegaStat output to Canvas.
(iv).
Answer all the questions in Word and submit to Canvas.
Questions:
[Correct outputs = 32 points; Correct answers = 98; Total = 130 points ]
1.
Construct a 90% confidence interval for the overall mean IQ score and interpret.
[4 points]
2.
Is gender independent of classification? From the crosstab, determine the percentage of
females in each classification. [10 points]
3.
Construct a correlation matrix for the four metric (quantitative) variables: Age, Exam,
Project, and IQ. Comment on the results with respect to direction, magnitude, and
significance. [9 points]
4.
A college administrator believes that the mean exam score is significantly larger than 75.
Does the sample data support this assertion? [10 points]
5.
Can we conclude that, on average, the exam scores for males are better than those for
females? [10 points]
6.
Now we want to compare the exam scores and the project scores. Is there sufficient
evidence to indicate that these two scores are different, on average? [10 points]
7.
It is also of interest for you to check whether significant differences in IQ scores exist
among the four college classifications. If you determine that significant differences
exist, identify the classifications that have significant differences. [14 points]
8.
We would like to explain exam scores (Exam) using Age, Project, IQ, and Gender. In
addition, we would like to predict an exam score for a student using the same four
variables. Note that Gender is a qualitative variable; so create an indicator variable,
Gender2, for Gender with male = 1 and female = 0. Then use Gender2 instead of
Gender.
a.
Is there a significant relationship between Exam and the four variables:
Project, IQ, and Gender2? [10 points]
Age,
b.
Which of the four variables have significant effect on Exam and what is the
nature of the effect? Also, which variable has the greatest effect on Exams.
[7 points]
c.
Comment on the coefficient of determination, R2. [6 points]
d.
Predict an exam score for a 26-year old junior male student who scored 82 on
the project and has an IQ score of 101. [4 points]
e.
Comment on the normality and constancy of variance assumptions for your
regression model. [4 points]
Bonus
9.
Repeat the regression in Question 8 but exclude Project.
Now compare the results for this question with the results for Question 8 (parts a and b).
Also examine the results for Question 3. In a short paragraph, discuss the results in the
context of multicollinearity. [20 points]

Purchase answer to see full
attachment