13) Use the following data to forcast the 2020 prices for Garbs. You can add as...

 

Transcribed Image Text:

13) Use the following data to forcast the 2020 prices for Garbs. You can add as many collumns as needed and graph whatever you find helpful. Your forcast needs to be in red text and entered in cells E241-E252 Obs. Year 1 2017 2 2017 3 2017 4 2017 5 2017 6 2017 7 2017 8 2017 9 2017 Annual-Seasonal Forcast Intercept Slope Average Month Linear Trend Price 31.6 JAN FEB 30.6 MAR 32.2 APR 33.2 Monthly JAN FEB MAR Year 2017 2018 2019 MAY 29.5 JUN 34.9 JUL 30 APR MAY 2020 AUG 32.6 0.72 SEP 31.2 JUN JUL AUG SEP OCT NOV DEC 10 2017 ост 28 11 2017 NOV 27.4 12 2017 DEC 30.2 13 2018 JAN 32.9 14 2018 FEB 35.1 15 2018 MAR 28.7 16 2018 APR 39.4 17 2018 MAY 33.3 18 2018 JUN 28.2 19 2018 JUL 37.4 Price 20 2018 AUG 33.5 40 21 2018 SEP 22.9 22 2018 ост 21.1 30 23 2018 NOV 21 24 2018 DEC 21.1 25 2019 JAN 19.5 20 26 2019 FEB 22 27 2019 MAR 20.8 28 2019 APR 22.5 29 2019 MAY 23.4 30 2019 JUN 20.1 11 13 15 17 19 21 23 25 27 29 1 33 35 31 2019 JUL 20.8 32 2019 AUG 19.9 33 2019 SEP 18.9 34 2019 ост 15 35 2019 NOV 16.5 36 2019 DEC 14.8 37 2020 38 2020 JAN FEB 39 2020 MAR 40 2020 APR 41 2020 MAY 42 2020 JUN 43 2020 JUL 44 2020 AUG 45 2020 SEP 46 2020 ост 47 2020 NOV 48 2020 DEC 13) Use the following data to forcast the 2020 prices for Garbs. You can add as many collumns as needed and graph whatever you find helpful. Your forcast needs to be in red text and entered in cells E241-E252 Obs. Year 1 2017 2 2017 3 2017 4 2017 5 2017 6 2017 7 2017 8 2017 9 2017 Annual-Seasonal Forcast Intercept Slope Average Month Linear Trend Price 31.6 JAN FEB 30.6 MAR 32.2 APR 33.2 Monthly JAN FEB MAR Year 2017 2018 2019 MAY 29.5 JUN 34.9 JUL 30 APR MAY 2020 AUG 32.6 0.72 SEP 31.2 JUN JUL AUG SEP OCT NOV DEC 10 2017 ост 28 11 2017 NOV 27.4 12 2017 DEC 30.2 13 2018 JAN 32.9 14 2018 FEB 35.1 15 2018 MAR 28.7 16 2018 APR 39.4 17 2018 MAY 33.3 18 2018 JUN 28.2 19 2018 JUL 37.4 Price 20 2018 AUG 33.5 40 21 2018 SEP 22.9 22 2018 ост 21.1 30 23 2018 NOV 21 24 2018 DEC 21.1 25 2019 JAN 19.5 20 26 2019 FEB 22 27 2019 MAR 20.8 28 2019 APR 22.5 29 2019 MAY 23.4 30 2019 JUN 20.1 11 13 15 17 19 21 23 25 27 29 1 33 35 31 2019 JUL 20.8 32 2019 AUG 19.9 33 2019 SEP 18.9 34 2019 ост 15 35 2019 NOV 16.5 36 2019 DEC 14.8 37 2020 38 2020 JAN FEB 39 2020 MAR 40 2020 APR 41 2020 MAY 42 2020 JUN 43 2020 JUL 44 2020 AUG 45 2020 SEP 46 2020 ост 47 2020 NOV 48 2020 DEC

Answer rating: 100% (QA)

To forecast the 2020 prices for Garbs using the given data we can use a linear regression model to d... View the full answer