Need help with part d-i. Thank you! The following is the data:

Cost

Passengers

1

3.7

63

2

6.01

86

3

4.16

73

4

5.7

80

5

5.78

91

6

5.1

68

7

5.01

69

8

4.39

72

9

5.57

83

10

5.03

79

11

1.24

51

12

6.89

96

13

6.91

85

14

2.03

48

15

2.12

64

16

8.72

110

17

5.1

76

18

0.54

59

19

8.15

91

20

3.08

71

21

4.39

65

22

4.67

78

23

6.29

96

24

4.7

70

25

4.55

84

26

3.96

63

27

7.66

83

28

4.25

77

29

4.55

74

30

3.09

75

31

7.66

94

32

9.31

86

33

6.25

84

34

3.05

65

35

6.42

83

36

4.02

78

Transcribed Image Text:(e, v) Find the P-value of your T-test in (e, iv). Use three decimals in your answer. P-value = (f) Using an a of 5%, this data indicates that ? ? be expressed as a linear function of ? (g) Find a 95% confidence interval for the slope term of the model, B1. Lower Bound = (use three decimals in your answer) Upper Bound = (use three decimals in your answer) (h) Choose the correct interpretation of the meaning of your confidence interval for B1, in the the context of the data. A. There is a statistical relationship between the cost of flying a commercial flight using Boeing 737s and the number of passengers. B. As the cost of flying a commercial flight using Boeing 737s increases by 1 unit, the number of passengers increases by an amount that is somewhere between the lower and upper bounds found in (g). C. As the number of passengers increases by 1, the cost of flying a commercial flight using Boeing 737s increases by an amount that is somewhere between the lower and upper bounds found in (g). D. As the cost of flying a commercial flight using Boeing 737s increases by 1 unit, the number of passengers will increase, on average, by an amount that is somewhere between the lower and upper bounds found in (g). E. As the number of passengers increases by 1, the cost of flying a commercial flight using Boeing 737s will increase, on average, by an amount that is between the lower and upper bounds found in (g). F. There is no statistical relationship between the cost of flying a commercial flight using Boeing 737s and the number of passengers. (i) With 95% confidence, find the average cost of flying a commercial flight using Boeing 737s when the number of passengers is 70. Lower Bound = (use three decimals in your answer) Upper Bound (use three decimals in your answer) >
Transcribed Image Text:Can the cost of flying a commercial airliner be predicted using regression analysis? If so, what variables are related to this cost? A few of many variables that can potentially contribute are type of plane, distance, number of passengers, amount of luggage/freight, weather condition, direction of destination, or even pilot skill. Suppose a study is conducted using only Boeing 737s traveling 800 km on comparable routes during the same season of the year. Can the number of passengers predict the cost of flying such routes? It seems logical that more passengers result in more mass and more baggage, which could, in turn, result in increased fuel consumption and other costs. Suppose the data displayed below are the cost and associated number of passengers for thirty-six 800-km commercial airline flights using Boeing 737s during the same season of the year. We will use these data to develop a regression model to predict cost by number of passengers. The data in the .csv file contains the data on the cost and number of passengers of 36 observations. (a) Use software to estimate this model. Use three-decimals in each of your least-squares estimatesyour answer. Cost ; = -5.018 0.130 Number of Passengers; i + ... ... (b) Find the coefficient of determination. Expresses as a percentage, and use two decimal places in your answer. p2 = 71.61 % (c) In the context of the data, interpret the meaning of the coefficient of determination. OA. The percentage found above is the percentage of variation in the number of passengers that can be explained by its linear dependency with the cost of flying a 800-km commercial flight using Boeing 737s. B. There is a strong, positive linear relationship between the cost of flying a 800-km commercial flight using Boeing 737s and the number of passengers. O C. The percentage found above is the percentage of variation in the cost of flying a 800-km commercial flight using Boeing 737s that can be explained by its linear dependency with the number of passengers. D. There is a weak, positive linear relationship between the cost of flying a 800-km commercial flight using Boeing 737s and the number of passengers. (d) Find the standard deviation of the prediction/regression, using three decimals in your answer. Se = %3D (e, i) You wish to test if the data collected supports the statistical model listed above. That is, can the cost of flying a 800-km commercial flight using Boeing 737s be expressed as a linear function of the number of passengers? Select the correct statistical hypotheses which you are to test. OA. Ho : B1 = 0 HA : B1 + 0 O B. Ho : Bo + 0 HẠ : Bo + 0 C. Ho : Bo = 0 HẠ : Bo + 0 O D. Ho : B1 7 0 HA: B1 + 0 OE. Ho : B1 = 0 HẠ : B1 > 0 OF. Ho : B1 = 0 HẠ : B1 < 0 G. Ho : Bo = 0 HẠ : Bo < 0 OH. Ho : Bo = 0 HA : Bo > 0 (e, ii) Use the F-test, test the statistical hypotheses determined in (e, i). Find the value of the test statistic, using two decimals in your answer. Fcalc (e, ii) Find the P-value of your result in (e, ii). Use three decimals in your answer. P-value : (e, iv) Use theT-test, test the statistical hypotheses determined in (e, i). Find the value of the test statistic, using three decimals in your answer. Tcale

Question

Need help with part d-i. Thank you! The following is the data:

Accepted Answer

We have used the excel data analysis tool to run the regression analysis.