Data Analysis by Excel


Recipe collection of Data Analysis by Excel

About

Data Science for Environment and Quality
Data Analysis by Python
Data Analysis by R


Exploratory data analysis

Visualization of the entire data : line graphs by variables, box plots, heat maps

Pivot table : BI software-like analysis. Convenient for data processing and aggregation

Outlier Analysis of Residuals : Making Hidden Anomalies Visible

Excel Graph Tips

Excel Graph Tips : Histograms, Stratified Graphs

Prediction and simulation

Easy prediction and simulation in Excel : Prediction by exponential smoothing and multiple regression analysis