Browse by category:
Data analysis (16) Excel (6) Extension (1) Market Research (21) Power BI (6) Probability (10) Projects (10) Python (6) SQL (2) Statistics (33) Visualization (11)
Excel basics for beginners
Excel basics for beginners 1. Introduction to excel 2. Getting started with excel 3. Working with cells 4. Basic formulas and functions 5. Formatting your spreadsheet 6. Sorting and filtering data 7. Basic data visualization…
EDA on Euro Mart (Using Python and MYSQL)
Exploratory Data Analysis (EDA) Exploratory Data Analysis (EDA) is an approach to analyzing data sets to summarize the data, using statistical analysis and data visualization methods. It is a crucial step in any data analysis…
Chebychev’s Theorem
For any distribution regardless of shape the portion of data lying within k standard deviations (k > 1) of the mean is at least 1 – 1/(K^2) Eg: mean = 6, Standard deviation = 3.84…
What is AI? Artificial Intelligence
Introduction to Artificial Intelligence Artificial Intelligence (AI) refers to the capability of machines to perform tasks that typically require human intelligence. In computer science, AI is defined as the development of systems that can perceive…
Pandas (Panel Data)
Pandas Series is like a column (has only one dimension), and a DataFrame (has two dimensions) is like a table or a spreadsheet with rows and columns Create panda series Method Syntax Description Example From…
Numpy Examples
Here i like to show some examples using NumPy, Please copy and paste the codes in your environement to practice Note: The below examples are made for practice purpose, so not much details are given.…
NumPy
Numpy Library in Python for numerical computations, data manipulation & mathematical functions Feature Python List NumPy Array Data type Any data type Same data type Mutability Mutable Partially mutable (elements can modified, size and shape…
Python Basics
Python Basics I was programming when I found interest in data science, earlier for nearly 5 years I was using MS Excel for data analysis and data handling until I touched the limits of excel.…
Student’s T test
When Student’s T test should be used? Typically we usually don’t get population standard deviation in real life examples, such that we cannot calculate the standard deviation of population (σ_population) and Z score. So we…
Hypothesis test examples
Example 1 A store believes that new product has 100 sales per day compared to their old product. We want to test this claim statistically Sample size = 10 stores = n, sample mean =…
Confidence Interval and Margin of Error
Confidence Interval (CI): Range of values that is to contain the true population parameter (mean, proportion) with certain level of confidence Margin of Error (ME): Amount of uncertainty/ potential error our estimate or Confidence Interval…
Hypothesis?
Hypothesis is an educated guess or a tentative statement about the relationship between two or more variables Types of Hypothesis: Note: We are collecting enough evidence to say that hypothesis to accept or reject the…
The Forge Insights
Data Forged into Insights
Hub for Knowledge Sharing…
