View the step-by-step solution to:

# ME Assignment - Part: II General Instruction: Complete Part I of this ass'gnment rst, ifyou have not done so. Check out the "Assignment Guides" in...

Any help with any of this would be greatly appreciated.

ME Assignment - Part: II General Instruction: 1. Complete Part I of this ass'gnment ﬁrst, ifyou have not done so. It will help you become proﬁcient in
answerirgthe questions here in Part II. 2. Check out the “Assignment Guides” in the Navigation menu in Blackboard to see how to properly show
your math work, instruction on essential procedures in Ill'luford and Excel, and APA formatting examples. 3. Use this document to ﬁll in the answers to the questions. ‘t‘ou must type out a clear answer to each
question, even rj'tne answer is also contained in the Exceiﬂe submitted to show work. Additional Instruction for this aslgnment:
1. Download the Excel data ﬁle in Blackboard for this assign merit. There is a tab for {11 and another tab for
Q2.
2. ‘I'ou will be required to organize [sort] the data and create some graphs in Excel so the Excel ﬁle must be
submitted along with this Wﬂrd document. t11. Pearson's Correlation [10' points] The data set for this question set [Tab 0.1 in the Excel data ﬁle] comes from a geriatric research project
that tracks the elderly residents In a oommunity to monitor their cognitive function and general health.
Based on the literature, education is considered a protective factor against dementia, and memory
decline is usually the ﬁrst sign of dementia. E the researchers would like to know whether education
level [measured in number of years of formal schooling] is correlated with memory function [a
standardized memory test score] In their sample of elderly residents. a. Create a scatter plot between the two varia bles using Excel. Paste the plot here and format it into an
APE-styled &quot;ﬁgure” [see Assignment Guides for APA format}. — .5 for correct scatter graph typel — .5 for the two axis labels {deduct .5 even if only one label is missing] — .5 for APA ﬁgure label and number — .5 for ﬁgure caption — 1 for correct data from the two variables on the it and 'f axes b. Calculate the mean and standard deviation for the two variables separately. [4 points total: 1 point for
each mean and 1 point for each SD, deduct .5 if an answer is inoorrect but the calculation process was
correct] c. Calculate the 2 scores for all the scores of the two variables, separately. {4 points total: 2 for the 2
scores for each variable, deduct .5 for each error in the 2 scores up to a total of 2 per variable} Tips: itrnoy help to prevent error and to increase clarity h'the process ond'for the answers ['1 scores]I
ore listed in o toﬂe format. d. Calculate Pearson’s correlation coefﬁcient r. {2 points total: 1 if the process is correct but the answer
is wro rig] e. Explain the direction and strength ofthe relationship based on the r. [2 points total: 1 for strength, 1 Fr&quot;- el :mrI-i-lnn'l

is wro rig] e. Explain the direction and strength ofthe relatIonshIp based on the r. [2 points total: 1 for strength. 1
for direction] PSYZSU SummerBEUIE f. What is the proportion of variance shared between the two variables? [That Is, how much of the
variance in one variable can be predicted bv the variance In the other varia ble?] {2 points total: 1 if the
prooess is correct but the answer is wrong] g. If the researcher wants to perform. a two-tailed hvpothesls test using this data set so that she can
generallte the relationship between the two variables from the sample to the population, what would
be the null and altemative hvpothesis'i Write the hvpolheses In words and In svmbol notation. {2 point:
total: 1 for each hypothesis. .5 for written, .5 for svmbol notation} h. Using SPSS to analvze the same dataset vlelds a p value of .341 Based on c: = .G5, what would be the
conclusion of the hvpothesls test {use wording of &quot;reject the null hvpothesis&quot; or &quot;fail to reject the null
hvpothesis&quot;? How do vou know? [1 point total: .5 for oonclusion. .5 for rationale] I12. Pearson's Correlation [10' points] It is generallv believed that there Is a relationship behveen a college’s acceptance rate and Its
graduation rate. I wanted to know how strong thIs relationship is within the top universities in the
countrv so I oollected the graduation rate and acceptance rate data of 2|] randomhiI selected universities
from all the top U.S. universities [with an aoceptanoe rate at or below 3056]. The data set Is In Tab Ci: of
the Excel data ﬁle. a. Create a scatter plot between the two variables using Excel. Paste the plot here and format it Into an
APA~stvled ”ﬁgure” [see Assignment Guides for APA format}. — .5 for oorrect scatter graph tvpe — .5 for the two axis labels {deduct .5 even if only one label is missing] — .5 for AM ﬁgure label and number — .5 for ﬁgure caption — 1 for correct data from the two variables on the x and Y axes

- 1 for correct data from the twd variables on the x and Y axes b. Calculate the mean and standard deviation for the two variables sepa ratelv. [4 points total: 1 point for
each mean and 1 point for each SD, deduct .5 if an answer is in correct but the calculation process was
correct] c. Calculate the 2 scores for all the scores of the two variables, separately. [4 points total: 2 for the 2
scores for each variable, deduct .5 for each error in the 2 scores up to a total of 2 per variable} iTps: timely heir: to prevent error ondmincreose clarity tithe process earlier the answers {2 semsj
are Esteem o table foam. d. Calculate Pearson’s correlation coefficient r. {2 points total: 1 it the process is correct but the answer
is wro ng] e. Explain the direction and strength ofthe relationship based on the r. :2 points total: 1 for strength, 1
for direction] f. What is the proportion of variance shared between the two variables? [That Is, how much of the
variance in one variable can be predicted bv the variance In the other variable?) [2 points total: 1 if the
process is correct but the answer is wrong} W230 SummerBZDlE a. If the researcher wants to perlomt a mtailed hvpothesls test using this data set so that she can
generalixe the relationship between the two variables from the sample to the population, what would
be the null and altemative hypothesis? Write the hypotheses In words and In svntbol notation. {2 points
total: 1 for each hypothesis, .5 for written, .5 for symbol notation} h. Using SPSS to analvze the same dataset 1.rlelds a p value of .01. Based on o = .05, what would be the
conclusion of the hypothesis test [use wording of &quot;reject the null hypothesis&quot; or &quot;fail to reject the null
hypothesis&quot;? How do vou know? {1 point total: .5 for conclusion, .5 for rationale] Extra Credit Question 11 pointj
Explain the meaning of p = .01 In Q2h above, In your own words. Explain whv the p value allows us to
determine the signiﬁcance of a hypothesis test. [.5 for each answer]

### Why Join Course Hero?

Course Hero has all the homework and study help you need to succeed! We’ve got course-specific notes, study guides, and practice tests along with expert tutors.

### -

Educational Resources
• ### -

Study Documents

Find the best study resources around, tagged to your specific courses. Share your own to gain free Course Hero access.

Browse Documents