Data Analysis Using Excel
• Collecting data from newspapers on:
• - Traffic
• - Sports Activities
• - Market Trends
• Using Excel to analyze and predict future
trends
• Prepared by: [Your Name]
Introduction
• This project collects daily data from
newspapers on traffic, sports activities, and
market trends.
• We analyze this data using Excel charts,
conditional formatting, and forecast tools to
predict future trends.
• This helps us learn practical data analysis and
visualization skills.
•
Importance:
- Develops analytical thinking.
Data Collection – Sources
• Newspapers used:
• • The Hindu (Traffic Reports)
• • Times of India (Sports Coverage)
• • Economic Times (Market Trends)
• Collection Period: June 1 - June 30, 2025
•
Reason for using newspapers:
- They provide consistent, reliable daily updates.
- Data is relevant to local and national contexts.
Data Categories
• We focused on three categories for analysis:
• 11️⃣Traffic Data (Congestion, Accidents)
• 2️⃣Sports Activities (Match Results,
Attendance)
• 3️⃣Market Trends (Stock & Commodity Prices)
•
Benefits of categorizing:
- Easy to manage large data.
- Helps analyze each area systematically for clarity.
Traffic Data Collected
• Sample Data:
• Date: 15-June-2025
• Area: MG Road
• Traffic Level: High
• Accidents Reported: 2
• Remarks: Metro work causing congestion
•
Tools used:
- Line graphs for trends.
- Conditional formatting to highlight peak congestion days.
Sports Activities Data Collected
• Sample Data:
• Date: 20-June-2025
• Sport: Cricket
• Match: Local Club A vs Club B
• Result: Club A won by 5 wickets
• Attendance: 2,000
•
We also noted:
- Player of the match details.
- Weather conditions during matches affecting attendance.
Market Trends Data Collected
• Sample Data:
• Date: 25-June-2025
• Sector: Technology
• Stock: ABC Tech Ltd
• Price: ₹780
• Change: +1.5%
•
We tracked:
- Global news impacting markets.
- Inflation effects on commodity prices.
Entering Data in Excel
• Data entered in Excel with columns:
• - Date
• - Category
• - Details (area, match, stock)
• - Numeric Data (congestion, attendance,
prices)
• - Remarks
• Allows sorting, filtering, and analysis.
Traffic Data Analysis
• • Created line charts for congestion trends.
• • Highlighted high congestion days using
conditional formatting.
• • Identified peak traffic areas for planning.
•
Analysis findings:
- Rainy days increased accidents.
- Events near malls spiked traffic significantly.
Sports Data Analysis
• • Used bar charts to track match results and
attendance trends.
• • Found rising attendance during weekends.
• • Analyzed team performances.
•
Also compared:
- Day vs night match attendance.
- Player performance consistency using charts.
Market Trends Analysis
• • Line graphs for stock/commodity prices.
• • Calculated 7-day moving averages to analyze
trends.
• • Identified sectors with growth potential.
•
Included:
- Comparison between tech and agro sectors.
- Impact of global events on local markets.
Using Excel Tools
• Excel Tools Used:
• ✅ Trendlines
• ✅ Forecast Sheet
• ✅ Pivot Tables
• ✅ Conditional Formatting
•
These tools made our analysis systematic and easy to understand with clear
graphs.
Observed Trends
• Traffic: High on weekends near markets.
• Sports: Rising attendance for popular matches.
• Market: Tech sector showing growth trends.
•
Practical application:
- Authorities can plan diversions.
- Players and teams can plan strategies.
- Investors can decide when to buy/sell.
Future Predictions
• Predictions:
• • Traffic: Peak on Fridays.
• • Sports: Club A likely to win next matches.
• • Market: Tech stocks may continue upward.
•
These predictions can help in planning travel, sports events, and investments
effectively.
Conclusion
• ✅ Collected and organized data systematically.
• ✅ Analyzed data using Excel.
• ✅ Predicted trends using real data.
• Thank you!
•
Skills Learned:
- Data entry and cleaning.
- Graphical analysis.
- Using Excel to predict trends.
- Creating meaningful presentations.
