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

Recently Asked Questions

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
  • -

    Question & Answers

    Get one-on-one homework help from our expert tutors—available online 24/7. Ask your own questions or browse existing Q&A threads. Satisfaction guaranteed!

    Ask a Question