Question FourThe dataset in the below table represents the 4-month profits (in million $) of real estate companythat operates in Egypt over the period of time between 2014-2018.I II III2014 15.6 20.4 29.42015 13.8 23.2 352016 17.8 19.4 30.62017 21.4 24.8 33.62018 18.4 27.2 34.2Answer the following questions:1. Find the seasonal indices for the company’s profits and comment on the results.2. Find the deseasonalized values of company’s profits and compare it to the actual valuesgraphically. Comment on the results.3. By using the deseasonalized values obtained in (2), determine the simple linear trend equation.And comment on the results.4. Predict the expected value of company’s profit in summer 2019 which includes the effects of allthe components of time series. And comment on the results Question FourThe dataset in the below table represents the 4-month profits (in million $) of real estate companythat operates in Egypt over the period of time between 2014-2018.IIII201415.620.429.4201513.823.235201617.819.430.6201721.424.833.6201818.427.234.2Answer the following questions:1. Find the seasonal indices for the company's profits and comment on the results.2. Find the deseasonalized values of company's profits and compare it to the actual valuesgraphically. Comment on the results.3. By using the deseasonalized values obtained in (2), determine the simple linear trend equation.And comment on the results.4. Predict the expected value of company's profit in summer 2019 which includes the effects of allthe components of time series. And comment on the results.

Enter the data in EXCEL in the following format and draw a line-chart with it. It will help to…

Answered: The dataset in the below table…

Calculus For The Life Sciences

2nd Edition

ISBN:9780321964038

Author:GREENWELL, Raymond N., RITCHEY, Nathan P., Lial, Margaret L.

Publisher:GREENWELL, Raymond N., RITCHEY, Nathan P., Lial, Margaret L.

Chapter7: Integration

Section7.CR: Chapter 7 Review

Problem 88CR

See similar textbooks

Related questions

Question

Question Four
The dataset in the below table represents the 4-month profits (in million $) of real estate company
that operates in Egypt over the period of time between 2014-2018.
I II III
2014 15.6 20.4 29.4
2015 13.8 23.2 35
2016 17.8 19.4 30.6
2017 21.4 24.8 33.6
2018 18.4 27.2 34.2
Answer the following questions:
1. Find the seasonal indices for the company’s profits and comment on the results.
2. Find the deseasonalized values of company’s profits and compare it to the actual values
graphically. Comment on the results.
3. By using the deseasonalized values obtained in (2), determine the simple linear trend equation.
And comment on the results.
4. Predict the expected value of company’s profit in summer 2019 which includes the effects of all
the components of time series. And comment on the results