Skip to content

Latest commit

 

History

History
44 lines (30 loc) · 1.95 KB

README.md

File metadata and controls

44 lines (30 loc) · 1.95 KB
Raw

📈 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:

Sample Picture

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

Project Developed by:
Bhushan Gawali 👋