预测模型构建器
在Excel中打开历史数据,替换[METRIC]和时间范围,Copilot会构建预测模型并进行敏感性分析。
提示词
Build a forecasting model for [METRIC] based on this historical data. Include:
1) Trend analysis and seasonality detection
2) Forecast for next [3/6/12] months with confidence intervals
3) Key assumptions underlying the forecast
4) Factors that could change the forecast
5) Sensitivity analysis (best case, worst case, most likely)
6) Recommended model formula and methodology
7) Visualization of historical data vs. forecast
Explain model in business terms.示例输出
输出:趋势分析+季节性检测、带置信区间的预测、关键假设、敏感性分析(最佳/最差/最可能)、推荐模型公式、历史vs预测可视化。
评论 0
更多
登录后可点赞、收藏、评论和举报。
还没有评论,先发起一个具体问题。