Recipe collection of Data Analysis by Excel
About
Data Science for Environment and Quality
Data Analysis by Python
Data Analysis by R
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 : Histograms, Stratified Graphs
Easy prediction and simulation in Excel : Prediction by exponential smoothing and multiple regression analysis