GORSUCH CORPORATION 80% confidence Annual Rrvenues S thousandX-XM and Minimum Ma
ID: 3323597 • Letter: G
Question
GORSUCH CORPORATION 80% confidence Annual Rrvenues S thousandX-XM and Minimum Maximum 19.97 20.57 18.342.236.00 2.83 13.35 23.32 692 2668 4.00272 20463006 41985 018 14.88 3.82 1986 1987| 2 2263 | 21 80 | 083 | -500| 27 1988, 31 24 89 | 25 26 0 1989 2738 2872 0.37 1.34300 2692399 3345 20 -200 1990 30.12 991 6 33.1335.642.51 266 2749 3687 30.98 40.30 11 1992 7 36.4439.1 2.66 0.00264 34.45 43.75 12 1993840.09 42562.471.00 265 37.90 47.22 1.92 2.00 2.66 41.33 50.70 0.97 13 1994944.0946.02 1905 10 48.50447 3,.00 269447454 21 5 1996 1153.355293042 4.00 272 48.,1457 73 9 12 58 65392295.00 27 17 1998 13 6456 585 4.70 6.00 28354.88 64.83 LINEST OutputModel specification 3.4595 1 14.880 Y=14.880-34595"X 0.1691 1.2936where Y annual revenues, in dolars 0.9721 . 2.5509 and X-number of years since 1985 (ie,x-0 418.41 or 1985, X 1 for 1986, etc.)Explanation / Answer
a)The linear model is a valid one because when we consider the linear equation Y=3.4595X+14.880
and substitite the value of X the value of Y increases.
b)Cell no E16,E17 the error increases,
C) Error from G12 to G16 that is it starts from 2.65
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.