Excel Monthly Forecasting Analyst
Budget: ₹100 – ₹400 INR
I have a set of monthly time-series figures and I need clear, defensible forecasts for the periods ahead. Everything must be done in Excel, using its built-in descriptive-statistics and forecasting tools (e.g., Data Analysis ToolPak, FORECAST.ETS, regression functions, or whatever method you judge best).
You will receive a clean worksheet with the historical data; your task is to extend that sheet so it contains:
• Forecasted values for the next 12 months (or another horizon you recommend and justify)
• A concise interpretation of the model’s key statistics—error measures, confidence intervals, and any seasonal factors you uncover
• Well-labeled charts that let a non-technical stakeholder grasp past trends and projected movement at a glance
You will receive a clean worksheet with the historical data; your task is to extend that sheet so it contains:
• Forecasted values for the next 12 months (or another horizon you recommend and justify)
• A concise interpretation of the model’s key statistics—error measures, confidence intervals, and any seasonal factors you uncover
• Well-labeled charts that let a non-technical stakeholder grasp past trends and projected movement at a glance