**1. Data collection**

Download the salary list for data analysis-related jobs from the Kaggle site.

**2. Data processing**

Only 50 people were selected out of a total of 955.

**3. Data analysis and visualization**

Mean, standard deviation, skewness, and kurtosis for 50 sample salaries

The average is 105.58K. When calculated at the exchange rate of 1$ = 1000 won,

the average annual salary is 105 million won.

Skewness 0.22: judged to have a normal distribution (stable data)

Kurtosis 0.08: judged to have a normal distribution (stable data)

* Overall, concluded with stable data without outliers

* Graphs for average and standard deviation

use vertical bar graphs and error bars

The smaller the standard deviation, the closer it is to the mean.

**Data outliers are**

random values, strange values, and mutations.

**The average** is usually used most often to **set representative values** to **analyze data** . If there are outliers like above, **the data is distorted and cannot be expressed correctly.** (Representative values: average, median, mode, etc.)

*** How to check if there are outliers in your data**

**Standard deviation**: Determines how spread the data is to the left and right from the average value.

Excel function =STDEV.S(Range)

.S(means Sample)

If the standard deviation follows a normal distribution, the range of the data standard deviation is within 95% of the mean.**Skewness**: A measure of how skewed the data is.

**Range of normal distribution: -2 to 2 (sometimes seen as -3 to 3)**

Skewness > 0: Data is skewed to the left.

Skewness < 0: Data is skewed to the right.

Excel function: =SKEW(range)**Kurtosis**: How sharp the data is.

**Range of normal distribution: -8 to 8 (sometimes seen as -10 to 10)**

Excel function: =KURT (range)

*** How to resolve outliers**

Method 1. How to remove distorted data (outlier removal)

Method 2. Using the median (arranging the data in order and the value in the middle)

**Resources**

Kaggle _ CSV file

- After signing up at [Register] in the upper right corner
- Search data in [Datasets] at the top left
- In my case, I searched by just entering the word ‘salary’.
**https://www.kaggle.com/**

- Sales data analysis_Supermarket
- Standard deviation, skewness, kurtosis, outlier analysis_salary data
- Correlation Analysis, Countifs, Date_Bakery Sales
- Correlation, linear regression line, slope_base interest rate and housing sales volume
- Hypothesis test Independent sample T test, F test Analysis of cost of living for male and female college students
- Hypothesis test, paired-sample T test, analysis before and after taking hair loss medication
- Parametric Pearson Correlation Consumer Price Index Sentiment Index Analysis
- Spearman correlation coefficient ranking analysis of credit card usage amount by region
- Korean single-person household income consumption pattern