Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

13) Use the following data to forcast the 2020 prices for Garbs. You can add as many collumns as needed and graph whatever you

 

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

Step by Step Solution

3.38 Rating (157 Votes )

There are 3 Steps involved in it

Step: 1

To forecast the 2020 prices for Garbs using the given data we can use a linear regression model to d... blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Principles of Economics

Authors: Fred M. Gottheil

7th edition

978-1133962069, 9781285064444, 1133962068, 1285064445, 978-1285064437

More Books

Students also viewed these Accounting questions

Question

Why is the specific-factors model referred to as a short-run model?

Answered: 1 week ago

Question

Compare and contrast skills, knowledge, and interests.

Answered: 1 week ago

Question

What are the principal 1996 changes made to our welfare program?

Answered: 1 week ago