Description
Hello? Can you help me do these 21 questions of math please?
You also need to use excel files to finish these questions too.
You may only use Excel and this Word document.
You will put all of your answers and support in THIS Word file. This means do not use the words “look at my Excel file” for the answer. The evaluator will not be looking at your Excel file except in rare circumstances where an answer does not make sense and the Excel file is being used to evaluate partial credit. In other words, “Excel file consulted = less than full points on question.”
When asked to put mathematical equations, you may either put in actual mathematical equations or approximate mathematical equations (e.g., B0 or β0 are acceptable)
Round all answers to 2 decimal places.
Save often. Submitting the correct and completed file is your own responsibility.
When you complete your exam submit your Word and Excel documents within the Canvas quiz
so I will need the excel file too
I attached files
one file is for the paper of questions, the other one is for data
Unformatted Attachment Preview
Purchase answer to see full attachment

Explanation & Answer

Attached. Please let me know if you have any questions or need revisions.
General Comments
Data set contains final exam scores and student information for a single course.
The primary purpose of our model will be to predict final exam scores based on student attributes and behavior.
Students who dropped the course or did not show for the final have been excluded from the data set.
Variable
classes attend
current term GPA
prior GPA
ACT
final exam score
Percent of classes attended
Percent of homework turned in
Missed classes
class
courses
Comment
Number of times the student attended class.
GPA in current term, including this class.
Prior semester's student GPA. Students who have no prior GPA have been excluded from
Score on ACT exam prior to entering into college.
Score on final exam in the class.
Number of classes attend divided by number of classes held.
Number of homeworks submitted divided by number of homeworks required.
Number of times the student missed class
Year in school. Only freshman, sophomore, and juniors take this course.
Number of courses each student is taking. Part-time students have been removed from the
PA have been excluded from the data set (i.e., first semester students and transfer students).
classes attend current term GPA prior GPA
27
1,67
26
2,33
29
2,38
32
2,55
32
3,05
30
2,81
31
2,05
29
2,25
27
2,25
27
1,88
24
2
30
3,21
25
2,14
31
2,86
30
2,92
26
2,15
29
3,3
29
2,73
32
3,54
28
2,25
29
1,38
22
3,04
29
2,96
26
2
27
2,38
32
2,43
26
2,15
28
2,5
30
2,5
27
1,5
18
2,43
29
2,87
23
3,36
24
1,5
31
2,38
28
1,88
32
2
24
3,35
30
2,89
29
3,64
31
2,79
32
2,86
32
3,19
32
2,61
26
2,5
25
2
ACT
2,19
2,2
2
2,57
2,84
1,98
2,5
2,28
2,11
1,74
2,13
2,29
2,12
3,46
2,56
2,96
2,39
2,3
2,94
2,39
1,92
2,48
2,8
1,8
2,02
2,59
1,93
2,38
2,21
1,98
2,6
2,74
1,83
2,1
2,3
2,54
2,45
2,12
2,43
3,08
2,67
2,41
3,13
2,66
2,1
2,27
13
14
15
15
15
15
15
15
15
15
15
16
16
16
16
16
16
16
16
16
16
16
16
16
16
16
16
16
16
16
16
17
17
17
17
17
17
17
17
17
17
17
17
17
17
17
final exam score
15
20
19
20
24
28
16
26
25
27
26
27
22
27
20
20
27
24
22
19
16
24
23
26
21
21
27
28
29
23
29
30
30
24
25
20
29
29
28
31
21
29
23
31
21
22
31
20
26
27
21
17
31
31
31
26
31
28
30
31
27
29
28
32
32
28
27
29
26
32
31
30
30
25
25
25
21
28
27
27
32
29
20
25
19
21
24
25
32
26
29
31
28
2,13
1,75
1,65
2,39
1,83
0,821
3,15
2,16
2,5
3,15
3,28
2,5
1,5
3
2,29
2,21
2,31
2,9
3,07
2,33
1,82
2,43
2,23
2,82
2,25
2,77
2,65
2,63
1
2,12
2,04
2
2,25
2,47
2,55
2,45
1,3
2,29
0,85
0,545
2,64
2,92
4
2,04
2,27
3,04
2,23
2,3
1,98
2,26
2,29
2,03
1,75
3,02
1,98
2,42
2,95
2,46
0,857
2,43
2,98
2,73
2,28
2,42
2,19
2,9
2,36
2,26
1,34
1,83
2,71
2,66
2,78
2,57
2,2
2,31
2,13
2,5
2,17
2,61
2,9
2,46
2,44
1,58
2,36
1,84
1,98
2,09
2,27
3,07
2,75
2,1
3,29
2,67
17
17
17
17
17
17
18
18
18
18
18
18
18
18
18
18
18
18
18
18
18
18
18
18
18
18
18
18
18
18
18
18
18
18
18
18
18
18
18
18
19
19
19
19
19
19
19
20
22
30
30
22
22
25
26
26
27
34
30
32
22
26
26
19
24
23
22
17
21
21
29
25
27
25
25
22
24
23
21
24
27
24
23
21
23
26
23
21
28
35
26
21
32
22
28
30
28
28
30
31
31
26
24
23
29
32
28
25
28
25
26
32
28
32
31
28
32
32
30
29
31
28
25
21
28
31
21
27
28
28
20
29
32
16
14
31
30
28
29
23
31
3,08
1,38
3,19
2,29
2,31
2,79
2,13
2,9
3,19
2
2,38
3,57
3,04
2,25
3,5
2,3
3
2,68
2,5
3
1,93
2,54
3,57
2,69
2,81
2,19
2,96
2,11
1,54
2,36
2,33
3,11
1,5
2,64
1,77
2,5
2,39
2,75
1,65
0,462
1,17
2,04
2,1
1,96
2,76
1,6
2,67
2,59
2,55
2,3
2,46
2,36
2,57
2,63
2,6
2,62
2,15
2,74
2,84
2,94
2,2
2,59
2,04
2,92
1,66
2,43
2,96
2,3
2,39
3,54
2,38
2,41
1,8
3,02
2,69
2,68
2,2
2,42
2,74
2,39
2,56
1,89
2,25
2,61
2,91
2,41
1,95
1,84
2,61
2,33
2,48
2,12
2,18
2,57
19
19
19
19
19
19
19
19
19
19
19
19
19
19
19
19
19
19
19
19
19
19
19
19
19
19
19
19
19
19
19
19
19
19
19
19
19
19
19
19
19
20
20
20
20
20
20
27
17
22
19
30
31
14
24
34
17
25
26
27
24
29
21
24
23
23
26
21
22
26
19
20
19
25
19
22
22
17
24
24
19
17
22
23
22
25
22
28
27
23
21
29
27
20
30
27
25
32
27
31
25
28
27
27
30
29
32
25
30
28
28
28
32
31
21
31
25
31
30
29
32
30
30
32
31
23
29
27
23
28
30
29
22
17
27
28
28
20
24
30
23
2,7
2,71
2,38
2,77
2,38
3
2,94
2,63
2,21
2,11
1,8
2,39
3,43
2,25
2,43
3,46
2,15
3,14
2,85
3
1,93
2,85
2,46
2,8
2,5
2,85
2,9
3,64
3,04
3,75
1,75
2,97
1,77
1,75
1,93
2,13
2,75
3,16
1,71
1,68
2,12
2,5
2,31
2,47
2,88
2,85
2,5
3,02
2,15
2,92
2,53
2,22
2,89
2,94
2,41
2,39
2,14
2,61
2,45
3,29
2,09
1,93
2
2
2,02
1,91
1,5
2,38
2,38
2,58
2,92
2,65
2,75
3,25
2,5
3,36
2,56
2,21
2,62
1,94
2,2
2,45
2,63
2,37
2,84
2,13
2,15
2,21
2,62
1,88
2,06
3,05
3,35
2,36
20
20
20
20
20
20
20
20
20
20
20
20
20
20
20
20
20
20
20
20
20
20
20
20
20
20
20
20
20
20
20
20
20
20
20
20
20
20
20
20
20
20
20
20
20
20
20
28
24
20
29
22
26
30
25
26
23
30
25
22
25
17
35
23
20
27
22
28
29
21
22
24
28
25
32
23
29
23
34
26
26
31
23
24
26
21
24
19
23
24
27
31
28
26
25
30
19
16
19
27
30
28
11
27
25
25
27
16
28
9
18
25
29
31
27
26
28
25
22
32
28
27
28
26
23
29
31
23
27
25
27
24
32
25
27
27
31
29
31
30
30
2,92
1,79
1,79
2,75
3,12
2,63
2,39
2,25
2,05
2,23
0,75
2,13
2,65
1,65
3,5
2
1,14
1,63
3
2,33
2,56
2,86
3,32
2,68
2,68
3,25
2,9
2,13
3,23
2,75
3,4
2,12
3,13
1,79
3,11
2,04
3
2,64
2,9
2,41
1,89
0,692
2,96
2,54
3,34
3,05
3,38
2,68
2,44
1,82
2,06
1,6
2,14
2,5
2,52
2,27
1,96
2,12
2,35
3,26
2,23
3,65
1,95
2,11
2,01
2,73
2,43
2,78
2,34
2,8
2,38
1,74
3,28
2,43
2,58
2,95
2,95
2,35
2,46
2,67
1,68
2,84
2,39
2,81
2,27
2,7
2,75
1,97
1,74
2,68
2,26
3,21
2,83
3
20
20
20
20
20
20
20
20
20
20
20
20
20
20
20
20
20
20
21
21
21
21
21
21
21
21
21
21
21
21
21
21
21
21
21
21
21
21
21
21
21
21
21
21
21
21
21
27
14
25
22
33
21
23
24
22
20
22
30
29
22
29
26
18
27
26
19
26
28
21
23
29
26
22
17
26
25
27
18
30
19
31
22
30
22
23
23
21
19
24
24
28
19
16
31
31
30
32
26
28
31
32
27
27
30
19
28
32
27
28
23
29
28
30
27
19
24
27
28
29
29
9
30
25
19
20
27
10
26
29
25
32
30
30
28
21
29
31
28
31
32
2,9
2,6
3,25
3,04
1,77
2,64
3,18
3,5
2,07
3
2,71
3,29
2,46
2,78
2,32
1,96
2,25
1,07
3,08
1,54
1,77
2,38
1,35
1,36
2,75
2,71
1,62
0,321
3,1
1,6
0,567
1,5
2,86
0,8
2
2,38
3,27
2,71
2,86
2,81
2,04
2,31
3,34
3,55
3,21
2,94
3,5
2,3
2,66
3
3
1,38
2,46
2,48
3,57
2,3
2,3
2,66
2,67
2,74
1,86
2,35
2,04
2,24
1,32
2,17
1,94
2,54
2,17
1,89
1,79
2,22
2,52
2,57
1,79
2,35
2,49
1,74
2,29
3,13
1,8
2,12
2,33
2,93
2,28
2,87
2,55
2,47
2,17
3,42
3,31
2,8
2,4
2,83
21
21
21
21
21
21
21
21
21
21
21
21
21
21
21
21
21
21
21
21
21
21
21
21
21
21
21
21
21
21
21
21
21
21
22
22
22
22
22
22
22
22
22
22
22
22
22
16
25
27
28
21
26
27
32
25
30
23
35
30
34
27
17
24
16
26
10
24
22
22
22
26
22
25
26
19
19
23
21
11
17
34
22
27
28
35
25
23
23
24
28
22
22
27
26
31
24
32
32
24
29
26
28
29
26
30
29
22
29
26
32
27
27
30
28
24
32
24
32
27
28
3
23
23
28
27
28
29
19
31
30
26
28
18
26
20
20
25
21
24
29
2,04
3,12
2,97
2,82
2,75
2,1
3
3,2
2,81
2,81
2
2,5
2,9
2,54
2,1
2,68
3,88
2,31
2,64
3,1
1,18
2,92
3,27
2,73
3,66
2,3
2,68
2,08
2,67
3,14
2,05
2,18
2,13
2,82
2,12
3,27
1,88
2,5
2,74
2,81
2,65
1,27
1,36
3,03
1,85
3
2,43
2,12
2,96
2,37
3,13
2,94
2,08
2,94
2,97
2,35
3,25
2,77
2,43
2,66
2,84
1,95
2,46
3,23
2,23
2,27
2,63
2,16
3,1
2,95
1,96
3,61
1,98
1,67
1,85
2,31
3,21
2,59
2,44
2,03
1,96
2,16
3,05
2,11
2,86
2,95
2,28
2,65
1,98
1,91
2,34
2,85
1,81
2,48
22
22
22
22
22
22
22
22
22
22
22
22
22
22
22
22
22
22
22
22
22
22
22
22
22
22
22
22
22
22
22
22
22
22
22
22
22
22
22
22
22
22
22
22
22
22
22
32
29
31
19
24
30
24
29
22
30
19
19
29
33
30
24
30
22
19
25
29
24
30
22
30
27
31
23
27
24
24
22
19
26
31
32
24
23
26
24
27
22
21
25
21
30
22
17
25
18
18
17
21
19
10
18
12
13
15
16
27
32
25
31
17
31
25
32
23
32
31
26
25
32
31
32
31
29
26
28
31
27
25
27
27
32
32
29
27
19
26
32
31
32
1,68
1,96
2,15
1,75
2,38
2,54
2,65
0,625
2,1
1,14
1,96
0,923
2,2
3,19
3,68
2,33
3,65
2,1
2,31
3,33
2,88
2,62
3,65
2,79
3,36
3,41
3,56
3,14
3,1
2,4
3,12
2,5
3,21
3,46
3
1,89
2,67
2,5
3,68
3,38
2,65
3,63
1,63
2,38
3,09
2,4
3,54
1,98
2
2,19
2,19
2,39
1,88
1,55
2,01
2,51
1,84
2,06
1,48
2
2,64
3,32
2,39
2,63
2,32
2,78
3,05
2,82
1,9
3,49
2,36
1,78
2,92
3,52
3,32
...
