📈 YouTube Views Forecasting Project

🛠 Tools:

• Excel: Utilized Excel functions, graphing tools, and the Forecast Sheet feature for data analysis and forecasting.

📜 Description:

This project involves forecasting YouTube views for the next 7 days using three different methods in Excel: the FORECAST function, a graph trendline, and the Forecast Sheet tool. The aim was to predict future view counts and evaluate the accuracy of each forecasting approach.

🔍 What I Did:

1. Function-based Forecast:

   • Organized historical YouTube views data in Excel.
   • Applied the FORECAST function to estimate views for the upcoming week.

2. Graph Trendline:

   • Added a trendline to the graph and extended it to forecast future views.

3. Forecast Sheet:

   • Used Excel’s Forecast Sheet feature to automatically generate forecasts.
   • Customized settings and analyzed the detailed results.

⭐ Project Highlights:

• Compared different forecasting methods to determine the most effective one.
• Generated both visual and numerical predictions for future YouTube views.
• Explored the strengths and limitations of each forecasting technique.

🏆 Conclusion:

Overall, the Forecast Sheet method proved to be the most accurate and insightful, making it ideal for detailed forecasting tasks. The project demonstrated the effectiveness of each method and provided a clearer understanding of how different forecasting tools can be applied to real-world data.

📥 Download Project File:

Download Project File

🖼️ Sample Picture About Project:

---

"Every challenge unveils a new opportunity for growth. Embrace the journey of discovery and keep pushing forward!"

---

Project Developed by:
Bhushan Gawali 👋

---