my assigned data set is #3 (Airfreight Breakage) .
Data Set Assignment
DS 312 Fall 2021 Student ID Data Set #
916422265 2
916629498 1
916980524 2
917000063 1
917529475 3
917666625 3
917804555 1
917808572 3
917881632 2
917910752 3
918213483 1
918224468 3
918377556 2
918429400 2
918628729 1
918634228 1
918822728 3
920020761 3
920446589 2
920494403 1
920868218 1
921178268 2
921251588 1
921426711 2
922115724 2
data set #1
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
data set #2
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
data set #3
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
DS 312 Fall21 Excel Assignment# 1
Posted on Monday 9/27/2021 at 9:00 am
Due: Friday 10/1/2021 at 11:59 pm
INSTRUCTIONS:
· This assignment accounts for 7% of the final grade. It consists of data analysis and software exercises. Use Excel to analyze the data.
· Type all your answers in a single MS word document. Copy and paste relevant Excel output reports, graphs, and/or tables in the same document. You need not retype the questions, but label your answers with the question numbers, e.g., 1.1)_____
· When done, upload and submit the word file via iLearn assignment. Please name your file “DS312 Excel assignment#1-LastnameFirstname.”
· Please keep the Excel file containing all of your analyses and results. You may be asked to submit it later.
· You can not collaborate, consult, or receive help from anyone. If you have any question, please ask me, not a classmate. Late or missed submission will be counted as a zero.
· You will be graded based on the completeness and correctness of your answers. Simply submitting the Excel output and/or plot without any explanation will not be sufficient.
QUESTIONS & TASKS:
Question 1:
1.1. Determine which variable should be the independent variable (X) and the dependent variable (Y).
1.2. Develop a scatter plot between X and Y and comment on the type of relationship between the two variables.
Question 2:
2.1 Perform the simple regression analysis using Excel’s regression function. What is the regression equation for the problem? Submit the summary output report.
2.2 Comment on the strength of the relationships between X and Y. Is X a good predictor of Y? Explain.
Question 3: Conduct residual analysis to determine whether there is any violation of the main assumptions of the regression model. Comment on the results of the analysis. Submit all the graphs used to test the assumptions.
Questions 4 -6 will be in the context of the data set assigned to you. Please see the questions below.
Don’t just provide the final answers. You must show intermediate calculations leading up to the final answers.
For data set #1 (GPA)
The director of admissions of a small college selected 120 students at random from the new freshman class in a study to determine whether a student’s grade point average (GPA) at the end of the freshman year can be predicted using the ACT test score.
Question 4: Obtain a point estimate of the mean freshman GPA for students with ACT test score of 30. Question 5: Construct a 98% confidence interval for the mean freshman GPA for students whose ACT test score is 30.
Question 6: Mary Jones obtained a score of 28 on the entrance test. Construct a 90% prediction interval of her freshman GPA.
For data set #2: (Copier Maintenance)
The Tri-City Office Equipment Corporation sells an imported copier on a franchise basis and performs preventive maintenance and repair service on this copier. The data have been collected from 45 recent calls on users to perform routine preventive maintenance service. The company would like to use these data to predict the total number of minutes spent by the service person using the number of copiers serviced.
Question 4: Obtain a point estimate of the mean service time on calls in which 80 copiers are serviced.
Question 5: Construct a 98% confidence interval for the mean service time on calls in which 80 copiers are serviced
Question 6: The store receives a call to repair 75 copiers today. Construct a 90% prediction interval for the service time on this call.
For data set #3: (Airfreight Breakage)
A substance used in biological and medical research is shipped by airfreight to users in cartons of 1,000 ampules. The data below, involving 10 shipments, were collected. The objective is to predict the number of ampules found to be broken upon arrival using the number of times the carton was transferred from one aircraft to another over the shipment route.
Question 4: Obtain a point estimate of the mean number of ampules broken in 16 transfers.
Question 5: Construct a 98% confidence interval for the mean number of ampules broken in 16 transfers.
Question 6: The next shipment will entail 20 transfers. Construct a 90% prediction interval for the number of broken ampules for this shipment.
1
Why Choose Us
- 100% non-plagiarized Papers
- 24/7 /365 Service Available
- Affordable Prices
- Any Paper, Urgency, and Subject
- Will complete your papers in 6 hours
- On-time Delivery
- Money-back and Privacy guarantees
- Unlimited Amendments upon request
- Satisfaction guarantee
How it Works
- Click on the “Place Order” tab at the top menu or “Order Now” icon at the bottom and a new page will appear with an order form to be filled.
- Fill in your paper’s requirements in the "PAPER DETAILS" section.
- Fill in your paper’s academic level, deadline, and the required number of pages from the drop-down menus.
- Click “CREATE ACCOUNT & SIGN IN” to enter your registration details and get an account with us for record-keeping and then, click on “PROCEED TO CHECKOUT” at the bottom of the page.
- From there, the payment sections will show, follow the guided payment process and your order will be available for our writing team to work on it.