Statistics lab @mathguru

profilel.udell
mgq_201_lab_1.xlsx
Home>Mathematics homework help>Statistics lab @mathguru

Data

ID Gender Class Level Lectures Watched (%) Attendance (%) Quiz 1 Quiz 2 Quiz 3 Quiz 4 Quiz 5 Midterm Final Final average Final Grade
1 M F 78 70 92 97 96 86 97 87 81 83.12 B-
2 F Jr 72 85 68 72 65 73 65 65 66 70.02 C-
3 M Jr 80 92 88 95 99 90 82 88 100 92.96 A-
4 M So 79 96 83 89 99 80 90 68 82 81.84 B-
5 M So 95 70 98 100 98 99 100 98 100 93.2 A-
6 M So 10 63 76 86 59 84 60 97 59 74 C
7 F Sr 30 79 53 95 26 92 15 54 74 65.44 D
8 F F 72 63 95 95 95 84 91 88 92 85 B
9 F F 91 87 71 91 92 71 76 85 99 88.64 B+
10 M So 46 67 68 71 79 70 94 82 90 80.28 B-
11 M Jr 35 85 65 51 67 88 42 94 29 66.42 D
12 M Jr 45 58 89 87 79 79 86 84 86 79.4 C+
13 F Jr 83 76 97 99 93 91 92 100 95 92.58 A-
14 F So 37 52 86 82 92 95 93 94 85 82.02 B-
15 M Sr 34 70 75 60 71 67 66 71 58 66.26 D
16 F F 80 82 99 89 95 95 94 88 96 90.48 A-
17 F F 55 65 88 100 96 88 98 86 86 83.4 B-
18 M F 5 70 73 75 75 74 73 73 74 72.9 C-
19 F Jr 99 73 96 93 85 97 93 90 82 84.76 B
20 F Jr 74 78 100 99 100 99 99 100 99 95.18 A
21 M F 88 71 76 91 76 72 89 81 85 80.16 B-
22 F F 20 85 85 80 66 84 72 83 72 78.98 C+
23 M So 17 61 0 69 67 71 72 70 71 65.66 D
24 F So 72 65 67 35 26 78 98 97 80 78.26 C+
25 M Sr 91 82 85 99 79 92 91 93 98 91.54 A-
26 F Jr 25 79 73 85 77 82 47 80 96 83.16 B-
27 M Jr 12 90 81 98 48 85 98 62 74 75.2 C
28 M So 61 89 73 69 72 73 70 70 71 74.38 C
29 F So 51 59 77 81 68 70 94 70 94 76.6 C
30 F F 71 76 68 63 74 73 70 61 72 69.02 D+
31 F F 39 55 99 87 95 96 91 92 76 80.12 B-
32 M F 29 52 72 51 29 65 82 85 81 72.16 C-
33 M So 59 54 71 67 66 74 69 74 68 67.28 D
34 F Jr 35 74 96 75 97 99 86 79 99 86.32 B
35 M Jr 55 57 89 34 83 42 70 54 83 65.22 D
36 F So 83 79 95 93 78 85 59 83 86 82.9 B-
37 M Sr 48 55 69 68 55 70 68 56 67 61.1 F
38 M So 37 96 54 67 74 55 68 92 94 87.72 B+
39 M F 100 54 100 98 99 99 98 100 100 90.56 A-
40 F F 100 79 93 95 95 90 98 98 100 94.04 A
41 M Jr 95 55 74 73 95 89 91 99 89 84.28 B
42 M So 39 63 69 76 89 65 55 84 89 78.66 C+
43 F So 100 91 91 89 90 93 99 86 98 91.88 A-
44 F Sr 22 76 89 74 60 86 55 77 95 81.36 B-
45 M F 90 53 98 99 99 91 91 93 96 86.42 B
46 M F 65 82 94 78 91 97 70 82 67 78.3 C+
47 F Sr 29 100 69 53 57 61 62 80 90 83.08 B-
48 M So 37 55 61 87 52 84 89 87 89 78.72 C+
49 F F 64 72 70 59 67 63 75 72 62 67.96 D
50 M Jr 21 83 69 77 71 96 94 61 100 81.18 B-
51 M So 98 98 100 100 100 100 100 100 100 99.6 A
52 F So 75 87 93 92 95 83 83 74 67 77.54 C+
53 M F 34 54 64 76 100 78 99 87 70 74.58 C
54 M F 20 95 93 64 79 84 64 89 28 69.46 D+
55 F Sr 43 92 76 87 85 69 76 84 89 86.02 B
56 M Sr 37 71 95 95 79 93 90 77 97 84.48 B
57 M Jr 84 67 100 87 85 93 83 94 93 87.42 B+
58 M F 70 83 69 73 0 75 75 74 73 72.38 C-
59 M F 18 65 62 58 56 58 68 52 62 59.28 F
60 F So 3 78 51 63 70 60 68 68 57 65.58 D
61 F Sr 53 60 61 71 79 69 61 72 91 74.54 C
62 M So 22 83 74 76 68 71 88 91 83 83.88 B-
63 F Jr 58 93 82 77 75 91 58 73 83 80.72 B-
64 F F 97 77 80 68 54 52 54 68 57 65.22 D
65 M F 29 57 79 92 76 50 58 84 89 77.5 C+
66 M F 62 76 79 87 81 75 92 71 88 79.46 C+
67 F Jr 25 75 53 54 66 74 73 54 58 61.4 F
68 F Jr 100 59 100 99 99 98 100 98 99 90.74 A-
69 M Sr 82 70 99 100 100 99 100 99 100 93.62 A-
70 M So 7 78 89 68 82 71 70 68 56 68 D+
71 F So 87 71 62 100 63 70 66 67 67 68.84 D+
72 F F 74 71 73 69 69 62 66 68 68 68.56 D+
73 M Jr 24 79 97 73 86 74 58 92 54 75.12 C
74 F F 69 91 84 100 54 94 88 95 66 83.3 B-
75 F So 3 51 74 72 72 73 71 73 73 68.48 D+

My Work Lab 1

Lab 1: Summarize qualitative data as well as quantitative data.
1.1 Create a histogram depicting the number of students by class (e.g. freshmen, sophomore, junior, senior). Label the axes.
1.2 Create a bar graph depicting the designation of students by final grade.
1.3 Create a frequency distribution for the midterm exam grade.
1.4 Create a frequency distribution for final exam grade
1.5 Discuss the assumptions of the types of data
1.6 Provide a verbal summary of the information.
Record Answers below. Label according (e.g. 1.1, 1.2, etc.)

Worksheet

PBH43836283-e9a7-4251-8dce-9cf6d8be7a91