In Exercise 3.1 you calculated summary statistics for the sample of 50 student GPAs in the file Studentsl.xls. Return to those data (depicted in figure 1 below) Can you conclude that more than 50% of...

In Exercise 3.1 you calculated summary statistics for the sample of 50 student GPAs in the file Studentsl.xls. Return to those data (depicted in figure 1 below)

1. Can you conclude that more than 50% of all students at this school are female? Use α= 0.05. What is the p-value of this test?


2. Can you conclude that the mean GPA of all students at this school is less than 3.000? Use α= 0.05. What is the p-value of this test?

Figure 1)

ID    Female    Major    GPA
1    1    4    2.537
2    0    2    3.648
3    1    3    2.981
4    0    2    2.683
5    1    2    3.234
6    1    3    2.467
7    1    1    3.384
8    1    3    3.555
9    0    2    3.263
10    1    1    3.711
11    1    5    1.970
12    1    4    3.406
13    0    1    2.523
14    0    3    1.750
15    1    6    3.191
16    1    2    2.795
17    0    1    2.606
18    0    5    2.397
19    1    6    3.791
20    0    4    3.490
21    0    3    2.421
22    0    5    3.937
23    0    5    2.890
24    1    6    2.246
25    1    2    3.371
26    1    5    3.114
27    0    1    3.084
28    0    5    2.703
29    1    3    3.045
30    0    1    1.948
31    1    1    2.717
32    1    6    1.996
33    1    3    2.870
34    0    5    2.986
35    0    1    3.393
36    1    2    2.740
37    1    6    2.499
38    1    4    3.695
39    1    4    2.664
40    1    5    2.306
41    1    3    3.022
42    1    6    2.776
43    1    5    2.175
44    0    2    3.828
45    0    6    3.410
46    0    4    2.330
47    0    5    3.978
48    1    3    3.503
49    1    4    3.253
50    1    2    2.215