Skip to content

It is an excel based population analysis project which is created by Injamulhoque_ds.

License

Notifications You must be signed in to change notification settings

InjamulHoque/population-analysis

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

5 Commits
 
 
 
 
 
 

Repository files navigation

Project: Population analysis based on Excel

It is an excel based population analysis project which is created by Injamulhoque_ds. You can fork and clone this project. If you are a beginner in excel you can check out how the basic formulas work through this project.

GitHub license Twitter Follow GitHub forks

Table of contents

Introduction

This is a simple excel data analysis project which is made for practicing purposes. It contained a database of a total of 500 hundred people with some of their basic attributes. The main goal of this project divided into two parts like basic and advanced.

#Basic:

  • Number of men vs women
  • Average Age
  • Number of each profession
  • Number of persons per area
  • Average income
  • Average value of a car
  • Number of persons with debts higher than X
  • Number of persons that have more than x% left on their mortgage

#Advanced:

  • Average income per territory
  • Average income per sector
  • % of people having higher total debts than their yearly income
  • Average age of people having more than X$ of net worth

Installation

Software: Excel 2007, 2013, 2016, 365, web excel.

Usage

A suggested approach for using this project is as follows:

  1. For and clone the the project repo in your local computer using git bash
  2. Open the main project file in excel
  3. You can check out the formulas are used here

Getting help

Here I have given my all social id links. If you face any problem then pls don't feel hesitate to contact me.

Contributing

Anyone can contribute, copy, and clone this project.

License

This project is distributed under the terms of the MIT license. The license applies to this project in the GitHub repository.

Authors and history

The author of this project is Injamul Hoque who is a data science practitioner. He recently made a ds roadmap and this project is a part of his learning according to the roadmap.

Acknowledgments

I have completed this project through the course "MS Excel for data analysis" in the Udemy E-learning platform, conducted by the nice instructor Yassin Marco.

About

It is an excel based population analysis project which is created by Injamulhoque_ds.

Topics

Resources

License

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published