GENERAL LIFESTYLE ANALYSIS DASHBOARD
GENERAL LIFESTYLE ANALYSIS DASHBOARD
Overview
This project presents a comprehensive lifestyle survey analysis based on responses from 114 individuals. Using Microsoft Excel, I explored demographics, income, expenses, social media usage, preferences, and digital behavior. The goal was to gain actionable insights into the general lifestyle habits of different age groups.
Objectives: The objectives were to;
Analyze digital presence across age groups.
Understand income, expenses, and lifestyle patterns.
Identify favorite colors, devices, and platforms used.
Present key demographic distributions using clear visuals.
Tools Used:
Microsoft Excel (Charts, PivotTables, Data Labels, Conditional Formatting).
Demographics:
Respondents: 114
Gender: 52% Male, 48% Female
Religion: 89% Christian, 11% Muslim
Demographics
Online & Device Behaviour:
Average online presence is 8 hours daily.
57% use Android while only 43% use iOS.
Most respondents aged 26–35 are the most active online.
Blue is the top favorite color.
WhatsApp is the most used social media platform, followed by Instagram and Twitter.
Phone preference varies by gender but Android dominates overall.
51% spend below ₦100,000, showing cautious spending habits.
However, only 3% spend above ₦500,000.
This Excel dashboard reveals that the 26–35 age group dominates online activity, with most preferring Android phones and WhatsApp as their main app. Despite many earning above ₦100,000, a larger portion spends less, indicating mindful financial behavior. The dominance of the color blue also highlights a strong trend in preference.
PROJECT PRESENTATION