Question: Please help me develop a step by step guide of which tools to use in excel and how to use them. This question is for

Please help me develop a step by step guide of which tools to use in excel and how to use them. This question is for an accounting expert or a data analyis expert that uses excel. The prompt is, You are working as an analyst for a company, which produces robots and Artificial Intelligence-based products. Forecasting the prices for recycling materials is very critical for the company. You have been tasked with developing forecasts for National Average price of Plastics Commingled ($/Ib) using the data provided below.
The images provided show the beginning and end of the data and how it is currently gathered in excel.
What needs to be solved: Please develop a forecast for the periods 288 and 289 using the two methods, we have just discussed:
1) FORECAST LINEAR()
2) FORECAST SHEET (which essentially uses FORECAST.ETS - exponential smoothing technique-)
Please make sure to define the upper and lower limits of your forecasts.
 Please help me develop a step by step guide of which

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!