It is generally believed that there is a relationship between a college’s acceptance rate and its graduation rate. I wanted to know how strong this relationship is within the top universities in the country so I collected the graduation rate and acceptance rate data of a randomly selected sample of universities from all the top U.S. universities (with an acceptance rate at or below 30%). The data set is in Tab Q2 of the Excel data file. a.) Create a scatter plot between the two variables using Excel. Paste the plot here and format it into an APA-styled “figure” (see Assignment Guides for APA format).Be sure to submit the Excel file that you used to create the scatter plot. b) Calculate the mean and standard deviation for the two variables separately. c) Calculate the Z scores for all the scores of the two variables, separately.Tips: It may help to prevent error and to increase clarity if the process and/or the answers (z scores) are listed in a table format. d) Calculate Pearson’s correlation coefficientr. e) Explain the direction and strength of the relationship based on ther. 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 by the variance in the other variable?) g) If the researcher wants to perform a two-tailed hypothesis test using this data set so that she can generalize the relationship between the two variables from the sample to the population, what would be the null and alternative hypothesis? Write the hypotheses in words and in symbol notation.
It is generally believed that there is a relationship between a college’s acceptance rate and its graduation rate. I wanted to know how strong this relationship is within the top universities in the country so I collected the graduation rate and acceptance rate data of a randomly selected sample of universities from all the top U.S. universities (with an acceptance rate at or below 30%). The data set is in Tab Q2 of the Excel data file.
a.) Create a
b) Calculate the mean and standard deviation for the two variables separately.
c) Calculate the Z scores for all the scores of the two variables, separately.Tips: It may help to prevent error and to increase clarity if the process and/or the answers (z scores) are listed in a table format.
d) Calculate Pearson’s
e) Explain the direction and strength of the relationship based on ther.
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 by the variance in the other variable?)
g) If the researcher wants to perform a two-tailed hypothesis test using this data set so that she can generalize the relationship between the two variables from the sample to the population, what would be the null and alternative hypothesis? Write the hypotheses in words and in symbol notation.
![College ID Accept rate (%) Grad rate (%)
1
5
96
2
6
95
3
8
97
4
9
94
5
11
96
13
94
7
15
85
16
93
9
16
84
10
16
92
11
18
87
12
19
96
13
20
90
14
22
89
15
24
85
16
24
78
17
27
87
18
28
82
19
28
78
20
29
72](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2Fd4d41a1b-f39c-4dc2-a825-da1f72fb9e64%2Fd0943787-e1a4-47a1-965b-37dd21f51b73%2Fvahtv0s_processed.jpeg&w=3840&q=75)
![](/static/compass_v2/shared-icons/check-mark.png)
Trending now
This is a popular solution!
Step by step
Solved in 4 steps with 1 images
![Blurred answer](/static/compass_v2/solution-images/blurred-answer.jpg)
![MATLAB: An Introduction with Applications](https://www.bartleby.com/isbn_cover_images/9781119256830/9781119256830_smallCoverImage.gif)
![Probability and Statistics for Engineering and th…](https://www.bartleby.com/isbn_cover_images/9781305251809/9781305251809_smallCoverImage.gif)
![Statistics for The Behavioral Sciences (MindTap C…](https://www.bartleby.com/isbn_cover_images/9781305504912/9781305504912_smallCoverImage.gif)
![MATLAB: An Introduction with Applications](https://www.bartleby.com/isbn_cover_images/9781119256830/9781119256830_smallCoverImage.gif)
![Probability and Statistics for Engineering and th…](https://www.bartleby.com/isbn_cover_images/9781305251809/9781305251809_smallCoverImage.gif)
![Statistics for The Behavioral Sciences (MindTap C…](https://www.bartleby.com/isbn_cover_images/9781305504912/9781305504912_smallCoverImage.gif)
![Elementary Statistics: Picturing the World (7th E…](https://www.bartleby.com/isbn_cover_images/9780134683416/9780134683416_smallCoverImage.gif)
![The Basic Practice of Statistics](https://www.bartleby.com/isbn_cover_images/9781319042578/9781319042578_smallCoverImage.gif)
![Introduction to the Practice of Statistics](https://www.bartleby.com/isbn_cover_images/9781319013387/9781319013387_smallCoverImage.gif)