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 Intelligencebased 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 and using the two methods, we have just discussed:
FORECAST LINEAR
FORECAST SHEET which essentially uses FORECAST.ETS exponential smoothing technique
Please make sure to define the upper and lower limits of your forecasts.
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
