# Statistics 101 Lab 2 LAVC Excel Project

*label*Mathematics

*timer*Asked: Jan 31st, 2019

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

**Tags:**statistics LAVC Statistics 101 Lab 2 Statistics 101 Lab 2 Aram Nordanyan Robert Lachapelle Los Angeles Valley College Los Angeles Valley College

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

*flag*Report DMCA

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