Description
Need help with an excel project, One of my labs. I absolutely don't understand how to do this. I need every little detail very organized on my files. Please let me know you have any questions.
Unformatted Attachment Preview
Purchase answer to see full attachment
Explanation & Answer
Hello buddy! I have attached the answer in a word document for you. :) Let me know if you have any edits or have any questions.
Title
EXCEL PROJECT
Name
Institutional Affiliations
Date
For this project, we were interested to determine whether the final grade scored
and the student grade point average (GPA) are related using alpha=0.05 in two different
schools. We obtained a random sample of 21 students in each of the two schools i.e. 21
students from LAVC and 21 students from MONROE HS. The scale of measurement used in
the two data sets for the two variables is interval scale evidenced by the variability of the
values of final score from a scale of 0 – 100 and ratio in the GPA variable. From the random
sampling, we obtained the following datasheet:
LAVC
Randomly
Selected Row #s
39
48
51
68
71
76
83
84
85
93
105
108
112
114
115
120
125
128
135
138
146
MONROE HS
FINAL GPA
18
34
36
45
46
47
51
51
52
55
60
63
64
68
68
71
73
73
77
78
87
1.95
1.76
2.16
3.45
2.22
2.96
2.72
2.49
2.66
3.41
3.37
3.93
2.11
3.01
2.64
2.15
2.66
1.96
1.91
2.9
2.33
Randomly
Selected Row #s
152
154
158
159
163
165
166
170
174
175
176
177
183
186
188
190
194
196
199
203
207
FINAL GPA
30
31
32
32
35
37
37
38
43
44
44
44
47
50
50
53
56
57
60
65
72
3
2.11
2.59
1.57
2.07
2.32
2.25
2.45
2.38
2.87
2.48
1.86
2.46
3.96
2.17
2.67
3.34
3.75
3.13
3.64
2.7
Running Head: LAB PROJECT REPORT
1
We then proceed with the hypothesis test using Pearson’s r as per the following four
steps:
Step 1 – Creating a Scatterplot of the Data
Then we obtained scatterplots using Excel in order to visually determine the
correlation between the variable (i.e. Final grade and GPA) for each date set (i.e. LAVC data
and MONROE HS data).
The scatter plot for LAVC is shown in the figure below:
FINAL
X-Y Scatter Plot for LAVC
100
90
80
70
60
50
40
30
20
10
0
0
0.5
1
1.5
2
2.5
3
3.5
4
4.5
GPA
Figure 1: Scatter plot for LAVC
Based on this scatter plot in figure one above, we could tell at a glance that there
was a weaker positive relation between the final grade and the GPA.
Also, the scatter plot for MONROE HS is shown in the figure below:
LAB PROJECT REPORT
4
X-Y Scatter Plot for MONROE HS
80
70
y = 10.71x + 17.128
R² = 0.3262
60
FINAL
50
40
30
20
10
0
0
0.5
1
1.5
2
2.5
3
3.5
4
4.5
GPA
Figure 2: scatter plot for MONROE ...