assignment 1

DS312Fall21Excelassignment1_datasets.xlsx

Data Set Assignment

ACT test scores	GPA	Grade point average. The director of admissions of a small college selected 120 students at
21	3.897	random from the new freshman class in a study to determine whether a student's grade point
14	3.885	average (GPA) at the end of the freshman year can be predicted using the ACT test score.
28	3.778	The results of the study follow.
22	2.54
21	3.028
31	3.865
32	2.962
27	3.961
29	0.5
26	3.178
24	3.31
30	3.538
24	3.083
24	3.013
33	3.245
27	2.963
25	3.522
31	3.013
25	2.947
20	2.118
24	2.563
21	3.357
28	3.731
27	3.925
28	3.556
26	3.101
28	2.42
22	2.579
26	3.871
21	3.06
25	3.927
16	2.375
28	2.929
26	3.375
22	2.857
24	3.072
21	3.381
30	3.29
27	3.549
26	3.646
26	2.978
30	2.654
24	2.54
26	2.25
29	2.069
24	2.617
31	2.183
15	2
19	2.952
18	3.806
27	2.871
16	3.352
27	3.305
26	2.952
24	3.547
30	3.691
21	3.16
20	2.194
30	3.323
29	3.936
25	2.922
23	2.716
25	3.37
23	3.606
30	2.642
21	2.452
24	2.655
32	3.714
18	1.806
23	3.516
20	3.039
23	2.966
18	2.482
18	2.7
29	3.92
20	2.834
23	3.222
26	3.084
28	4
34	3.511
20	3.323
20	3.072
26	2.079
32	3.875
25	3.208
27	2.92
27	3.345
29	3.956
19	3.808
21	2.506
24	3.886
27	2.183
25	3.429
18	3.024
29	3.75
24	3.833
27	3.113
21	2.875
19	2.747
18	2.311
25	1.841
18	1.583
20	2.879
32	3.591
24	2.914
35	3.716
25	2.8
28	3.621
28	3.792
25	2.867
22	3.419
30	3.6
20	2.394
20	2.286
31	1.486
20	3.885
29	3.8
28	3.914
16	1.86
28	2.948

Number of copiers serviced	Total number of minutes spent by the service person	Copier maintenance. The Tri-City Office Equipment Corporation sells an imported copier on
2	20	a franchise basis and performs preventive maintenance and repair service on this copier. The
4	60	data below have been collected from 45 recent calls on users to perform routine preventive
3	46	maintenance service. The company would like to use these data to predict the total
2	41	number of minutes spent by the service person using the number of copiers serviced.
1	12
10	137
5	68
5	89
1	4
2	32
9	144
10	156
6	93
3	36
4	72
8	100
7	105
8	131
10	127
4	57
5	66
7	101
7	109
5	74
9	134
7	112
2	18
5	73
7	111
6	96
8	123
5	90
2	20
2	28
1	3
4	57
5	86
9	132
7	112
1	27
9	131
2	34
2	27
4	61
5	77

Number of times the carton was transferred from one aircraft to another over the shipment route	Number of ampules found to be broken upon arrival	Airfreight breakage. A substance used in biological and medical research is shipped by airfreight
16	1	to users in cartons of 1,000 ampules. The data from shipments were collected.
9	0	The objective is to predect the number of ampules found to be broken upon arrival
17	2	using the number of times the carton was transferred from one aircraft to another overthe shipment route.
12	0
22	3
13	1
8	0
15	1
19	2
11	0
18	2
17	1
17	2
10	0
11	1
18	2
17	1
12	0
14	1
15	1
15	2
14	1
17	1
14	1
12	1
11	0
16	2
12	1
11	0
13	1
18	1
13	0
10	0
15	1
13	1
11	0
14	1
18	2
17	1