# Statistics 101 Lab 2 LAVC Excel Project

Anonymous
account_balance_wallet \$25

### Question 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.

20190131030723lab_3_correlation_data.xls 1/31/2019 SCHOOL ARLETA HS ARLETA HS ARLETA HS ARLETA HS ARLETA HS ARLETA HS ARLETA HS ARLETA HS ARLETA HS ARLETA HS ARLETA HS ARLETA HS ARLETA HS ARLETA HS ARLETA HS ARLETA HS ARLETA HS ARLETA HS ARLETA HS ARLETA HS ARLETA HS ARLETA HS ARLETA HS ARLETA HS ARLETA HS ARLETA HS ARLETA HS ARLETA HS ARLETA HS ARLETA HS ARLETA HS ARLETA HS ARLETA HS ARLETA HS ARLETA HS ARLETA HS LAVC LAVC LAVC LAVC LAVC LAVC LAVC LAVC FINAL 0 0 0 0 31 32 33 37 37 38 39 39 39 40 40 41 43 43 44 46 48 49 49 51 53 53 58 59 62 66 70 71 83 85 89 91 17 18 25 27 28 28 31 32 GRADE F F F F D C F C F C C D F C C C D D C B B A A C B B A A A D A C B B A B F F D F F F D F GPA 2 1.24 2.13 1.72 2.32 2.68 1.39 2.32 1.18 2.89 2.22 2 1.23 2.01 2.02 2.46 2.4 1.84 2.24 2.59 2.35 3.89 3.44 2.52 2.85 2.38 3.44 3.88 3.08 1.8 3.26 2.56 3.13 3.48 3.4 3.25 1.05 1.95 2.74 2.25 2.01 2.2 2.71 1.86 Randomly Selected LAVC Row #s 83 85 146 105 68 115 125 51 108 128 76 112 93 135 39 48 71 120 114 138 84 LAVC Monroe Randomly Selected Monroe Row #s 158 154 177 152 199 159 207 188 163 190 170 175 196 186 166 174 183 176 203 194 165 range: cells 38-146 range: cells 147-211 1 20190131030723lab_3_correlation_data.xls 1/31/2019 LAVC LAVC LAVC LAVC LAVC LAVC LAVC LAVC LAVC LAVC LAVC LAVC LAVC LAVC LAVC LAVC LAVC LAVC LAVC LAVC LAVC LAVC LAVC LAVC LAVC LAVC LAVC LAVC LAVC LAVC LAVC LAVC LAVC LAVC LAVC LAVC LAVC LAVC LAVC LAVC LAVC LAVC LAVC LAVC LAVC LAVC LAVC LAVC 33 34 34 34 35 36 37 37 37 38 39 39 39 40 41 41 42 42 43 44 44 44 45 45 45 46 46 46 46 47 47 48 48 49 50 50 51 51 51 52 53 53 53 53 54 55 55 55 C D D F F F C C D D B F F C C C B F F B B C A D F C C D F A C B B C D D C C D C A A A F A A A A 2.66 2.5 1.76 1.41 2.17 2.16 1.92 2.94 2.36 2.56 3.03 1.49 1.88 2.32 1.93 2.48 2.84 2.11 2.16 2.62 2.36 2.04 3.45 1.92 1.27 2.22 2.54 2.22 1.61 3.47 2.96 2.41 3.3 3.03 2.13 1.99 1.9 2.72 2.49 2.66 3.67 3.27 3.93 1.84 3.85 3.59 3.35 3.41 2 20190131030723lab_3_correlation_data.xls 1/31/2019 LAVC LAVC LAVC LAVC LAVC LAVC LAVC LAVC LAVC LAVC LAVC LAVC LAVC LAVC LAVC LAVC LAVC LAVC LAVC LAVC LAVC LAVC LAVC LAVC LAVC LAVC LAVC LAVC LAVC LAVC LAVC LAVC LAVC LAVC LAVC LAVC LAVC LAVC LAVC LAVC LAVC LAVC LAVC LAVC LAVC LAVC LAVC LAVC 55 56 56 56 58 58 58 58 59 59 59 60 60 62 63 64 64 64 64 67 68 68 69 69 71 71 71 72 72 72 73 73 73 73 73 73 75 75 75 75 77 77 78 78 78 78 80 80 F C D F A A D D A A A B C D A A B B C A A C C C C C C C C C C C C C C C A C C C C C A B B C A C 2.11 3.08 2.51 1.96 3.52 3.16 1.87 2.21 3.09 3.34 4 3.37 2.62 1.67 3.93 3.53 2.4 2.81 2.11 3.34 3.01 2.64 1.98 3.2 2.91 2.6 2.15 2.75 2.25 3.09 1.94 2.66 2.53 2.59 1.96 2.52 3.78 2.17 2.12 2.38 2.26 1.91 3.03 3.46 2.9 2.43 3.65 2.53 3 20190131030723lab_3_correlation_data.xls 1/31/2019 LAVC LAVC LAVC LAVC LAVC MONROE HS MONROE HS MONROE HS MONROE HS MONROE HS MONROE HS MONROE HS MONROE HS MONROE HS MONROE HS MONROE HS MONROE HS MONROE HS MONROE HS MONROE HS MONROE HS MONROE HS MONROE HS MONROE HS MONROE HS MONROE HS MONROE HS MONROE HS MONROE HS MONROE HS MONROE HS MONROE HS MONROE HS MONROE HS MONROE HS MONROE HS MONROE HS MONROE HS MONROE HS MONROE HS MONROE HS MONROE HS MONROE HS MONROE HS MONROE HS MONROE HS MONROE HS MONROE HS 81 82 84 85 87 0 0 20 23 30 30 30 31 31 31 32 32 32 34 34 34 35 36 37 37 37 38 38 38 39 39 40 43 44 44 44 45 45 45 45 47 47 49 49 50 50 50 51 A B B A B F F F F C C F C F F C D F C F F D F C D D C C C C D C C B C F C C D D C C A C A B C B 3.64 3.34 2.34 3.94 2.33 1.59 2.18 1.72 1.43 2.09 3 1.84 2.11 1.09 1.17 2.3 2.59 1.57 2.73 2.23 2.05 2.07 2.1 2.32 2.25 1.77 3.09 2.77 2.45 2.63 2.87 1.94 2.38 2.87 2.48 1.86 2.98 3.15 2.86 1.96 2.61 2.46 3.61 3.13 3.96 2.35 2.17 2.75 4 20190131030723lab_3_correlation_data.xls 1/31/2019 MONROE HS MONROE HS MONROE HS MONROE HS MONROE HS MONROE HS MONROE HS MONROE HS MONROE HS MONROE HS MONROE HS MONROE HS MONROE HS MONROE HS MONROE HS MONROE HS MONROE HS MONROE HS MONROE HS MONROE HS MONROE HS MONROE HS 53 53 53 55 56 56 57 57 57 60 60 61 62 65 65 69 69 72 72 73 78 79 B B F A A F A A B A A A A A A B C C C C C C 2.67 2.58 2.24 3.16 3.34 1.34 3.75 3.68 2.32 3.13 3.46 3.84 3.42 3.64 4 2.88 3.16 2.7 2.65 3.09 2.33 2.22 5

Geontiry
School: Carnegie Mellon University

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

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 ...

flag Report DMCA
Review

Anonymous
Thank you! Reasonably priced given the quality not just of the tutors but the moderators too. They were helpful and accommodating given my needs.

Brown University

1271 Tutors

California Institute of Technology

2131 Tutors

Carnegie Mellon University

982 Tutors

Columbia University

1256 Tutors

Dartmouth University

2113 Tutors

Emory University

2279 Tutors

Harvard University

599 Tutors

Massachusetts Institute of Technology

2319 Tutors

New York University

1645 Tutors

Notre Dam University

1911 Tutors

Oklahoma University

2122 Tutors

Pennsylvania State University

932 Tutors

Princeton University

1211 Tutors

Stanford University

983 Tutors

University of California

1282 Tutors

Oxford University

123 Tutors

Yale University

2325 Tutors