Data analysis - Road map

Data analysis - Road map :

1. Data cleaning & pre-processing

. Tidy data( tabular & meaningful data)
. Unique  ID
. Remove duplication 
. Missing data
. Validate data types

2. Statistical analysis
. Data manipulation : Sorting,updating,filter

. Statistical functions in excel
( make box plot chart)
- Sum,average, median, mode
- Min, max, range, IQR
- variance =vrp(range), st. Deviation: =stdvp(range) or =squre root(vrp)
- hypothis test: Z test, T test

Notes,
Variance = measure how far data from mean
St. Deviation: measure of the amount of variation or dispersion of a set of values.
Quartil: quartil =(range data, quarter no.)
2nd quater= median
IQR(inter quartil range): = Q3-Q1
Increase sample vise verse with mean & st. Deviation 
T test: 2 sample with low data, =t.test(range 1,range2,1,paired)
Ztest: for large data


. Conditional functions 
- count if, sumif, average, Vlookup, Hlookup
. Pivot table


3. Data visualisation 
. Comparison: bar, pie, box chart
. Distribution: line, histogram chart
. Correlation: scatter plot, venn diagram
Geographical data

Notes,
Skewness, kurtosis
 

Skewness( الانحياذ) essentially measures the symmetry of the distribution, while kurtosis(التفلطح) determines the heaviness of the distribution tails.”

The understanding shape of data is a crucial action. It helps to understand where the most information is lying and analyze the outliers in a given data. In this article, we’ll learn about the shape of data, the importance of skewness, and kurtosis. The types of skewness and kurtosis and Analyze the shape of data in the given dataset.

. Skewness:=sku(data range) , std= zero
. Kurtosis; =kurt(data range) , std = 3

. Correlation; =corel(data range),  
-1= inverse relation 
0 = no correlation 
1 = direct relation
 

Edit This Article