View the step-by-step solution to:

# Report the estimated regression equation. Conduct the F-test for model significance. Interpret your results. Interpret the slope coefficient and...

1.    Report the estimated regression equation.

2.    Conduct the F-test for model significance. Interpret your results.

3.    Interpret the slope coefficient and test for significance using a t test.

4.    a.   Use a t test to determine if the slope coefficient is significantly different

(two-tail test) than the value 1.0 that is, test H0: b = 1 against H1: b ¹ 1.

b.   Of what importance is it to the company to know if this slope coefficient differs

significantly from 1.0?

Be sure to include a copy of your Excel printout.

117.9   47.7   42.2   0.80   2.77   2.62       C

79.6   52.8   42.4   0.83   2.90   2.78       A

70.9   53.1   39.2   0.72   2.98   2.88       B

98.4   52.1   44.0   0.68   2.81   3.10       B

103.8   54.5   40.3   0.75   2.75   2.53       A

69.9   51.3   35.7   0.73   2.89   2.13       B

75.4   49.1   40.8   0.79   3.07   2.14       A

73.7   50.0   37.8   0.71   2.78   2.08       D

142.1   53.2   44.0   0.73   2.76   3.00       C

124.3   54.1   44.7   0.74   2.06   2.91       B

102.3   50.5   43.9   0.70   2.57   2.98       D

83.2   44.2   39.1   0.73   2.74   3.14       D

100.4   53.8   35.3   0.74   2.69   3.03       C

141.4   59.4   42.0   0.78   2.59   3.24       C

80.5   46.4   41.0   0.73   3.00   2.71       D

71.1   50.7   35.2   0.72   2.69   3.10       D

134.1   56.7   41.4   0.74   2.42   2.02       D

110.3   54.1   41.3   0.78   2.29   3.30       B

85.2   50.1   41.3   0.78   2.94   3.42       D

83.7   44.1   41.5   0.73   2.73   2.55       A

62.9   50.5   36.3   0.80   2.96   2.02       B

85.0   47.5   41.7   0.75   2.62   3.30       B

60.5   50.5   37.8   0.81   3.13   2.65       B

113.1   57.0   42.5   0.80   2.56   1.97       D

97.6   46.2   41.2   0.79   2.50   1.74       A

104.7   50.9   37.7   0.76   2.40   2.44       C

61.1   58.0   35.6   0.80   2.97   2.15       A

72.7   60.7   35.3   0.75   2.66   2.87       A

82.5   44.0   44.4   0.74   2.81   2.78       B

129.0   50.5   44.3   0.72   2.27   2.64       C

106.8   44.2   40.6   0.77   2.44   2.10       C

75.3   49.9   39.8   0.72   3.25   1.79       D

101.9   56.5   40.3   0.86   2.68   2.39       A

105.9   50.2   44.9   0.74   2.90   2.35       D

86.1   45.7   37.0   0.69   2.72   1.59       B

103.1   45.8   37.2   0.75   2.63   2.00       C

100.0   44.9   44.1   0.78   2.88   2.28       C

95.8   50.5   35.7   0.70   2.75   3.21       B

90.8   42.3   39.0   0.75   3.02   2.05       C

81.6   52.6   42.4   0.78   2.86   3.49       D

100.1   43.1   44.8   0.75   2.59   2.82       B

92.2   44.9   38.3   0.71   2.55   1.74       B

68.6   50.9   38.2   0.75   2.58   3.13       A

99.5   54.6   39.4   0.72   2.87   3.29       D

112.2   50.1   39.5   0.76   2.69   3.03       C

93.7   51.1   41.7   0.80   2.62   2.01       A

96.0   58.7   38.2   0.77   2.53   2.84       B

119.9   50.2   40.4   0.76   2.68   1.62       C

98.9   55.0   36.7   0.78   2.52   2.81       D

91.9   53.1   39.3   0.75   3.03   2.44       B

99.6   47.6   43.3   0.80   2.71   2.57       D

80.5   49.8   41.0   0.74   3.07   2.95       B

101.2   47.5   36.1   0.77   2.81   2.82       C

80.4   50.2   45.0   0.75   3.04   1.61       A

90.1   58.6   36.3   0.64   3.00   1.53       D

79.6   58.2   38.2   0.77   2.90   2.45       A

77.9   50.6   37.2   0.80   2.80   3.31       B

111.7   50.7   42.7   0.75   2.17   3.25       A

81.2   49.0   38.8   0.67   2.79   2.45       A

82.7   54.7   39.0   0.72   2.91   1.89       D

### Why Join Course Hero?

Course Hero has all the homework and study help you need to succeed! We’ve got course-specific notes, study guides, and practice tests along with expert tutors.

### -

Educational Resources
• ### -

Study Documents

Find the best study resources around, tagged to your specific courses. Share your own to gain free Course Hero access.

Browse Documents