☕ University-Student-Caffeine-Intake-Analysis

Excel-based socio-demographic and psychological data analysis of university students’ caffeine consumption patterns.

---

📖 Table of Contents

• Dataset
• Tools Used
• What I Did
• Key Insights
• Project Structure
• Skills Demonstrated
• Author
• License

---

📊 Dataset

File:
A Socio-Demographic Study of University Students' Perceptions, Psychological Health, and Patterns of Caffeine Intake.xlsx

Contents include:

• Demographic information (Age, Gender, Faculty, Study year, etc.)
• Caffeine consumption habits (Type, Frequency, Quantity, Time of intake)
• Psychological health indicators (Anxiety & Depression scores — GAD, PHQ)
• Students’ attitude and perception toward caffeine use

Data Source:
Survey-based data collected from university students using a structured questionnaire.

---

⚙️ Tools Used

• Microsoft Excel

  • Pivot Tables for summary statistics
  • Charts (Bar, Pie, Line) for visual representation
  • Conditional Formatting for highlighting trends
  • Excel formulas (AVERAGE, STDEV, COUNTIF, IF, etc.)
  • Data Cleaning tools (Remove Duplicates, Filters, Text-to-Columns, etc.)

• Reports & Visualizations

  • Exported PDF dashboards and charts for each section (A–E)
  • Chi-square test results showing statistical associations

---

🧩 What I Did

✅ Data Cleaning & Preparation

• Removed duplicates, blanks, and inconsistent entries
• Fixed category labels (e.g., beverage type, frequency terms)
• Converted qualitative responses into numeric/categorical codes for easier analysis
• Ensured proper formatting for demographic and psychological data

✅ Exploratory Data Analysis (EDA)

• Created Pivot Tables to summarize caffeine intake by demographic groups
• Calculated mean and standard deviation of anxiety & depression scores
• Identified correlations between caffeine intake and psychological health
• Visualized gender-based and faculty-based consumption trends

✅ Statistical Analysis

• Performed Chi-square tests to examine relationships between:
  • Gender and caffeine intake habits
  • Frequency of intake vs. anxiety/depression levels
• Interpreted p-values and highlighted significant associations

✅ Dashboard Development

• Designed interactive Excel dashboard with slicers and dynamic charts to visualize:
  • Overall caffeine consumption distribution
  • Psychological health comparison (high vs. low intake)
  • Attitude and perception variations across demographics

---

📈 Key Insights

• Most university students consume caffeine regularly — mainly tea and coffee.
• Senior-year and male students tend to have higher intake frequency.
• Significant association found between caffeine consumption and anxiety levels (p < 0.05).
• Moderate caffeine users displayed more balanced mental health scores than heavy consumers.

---

📂 Project Structure

university-student-caffeine-intake-analysis/
├── data/
│ └── A Socio-Demographic Study of University Students.xlsx
├── reports/
│ ├── Chi-square of Section A.pdf
│ ├── Section B - Pattern of Caffeine Intake.pdf
│ ├── Section C - Anxiety & Depression.pdf
│ ├── Section D - Attitude Toward Caffeine.pdf
│ └── Section E - Perception Toward Caffeine.pdf
└── README.md

---

🧰 Skills Demonstrated

• Data Cleaning & Validation in Excel
• Exploratory Data Analysis (EDA)
• Statistical Testing (Chi-square)
• Data Visualization & Dashboard Design
• Analytical Interpretation of Socio-Demographic Data

---

👨‍💻 Author

Md. Zahid Hasan
📧 mdzahidhasan096@gmail.com
📍 Data Analyst | Excel Enthusiast | Research-driven Learner

---

📜 License

This project is for educational and analytical purposes only.
All rights reserved © 2025 Md. Zahid Hasan.