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.