(Excel examples for Beginners) In this end-to-end excel example, you will learn – How to Count cells equal to either x or y. How to Count cells equal to either x or y Generic formula =COUNTIF(rng,value1) + COUNTIF(rng,value2) Explanation To count the number of cells equal to either one value OR another, …
Day: July 19, 2020
(Excel examples for Beginners) In this end-to-end excel example, you will learn – How to Count cells equal to case sensitive. How to Count cells equal to case sensitive Generic formula =SUMPRODUCT((–EXACT(value,range))) Explanation To count cells that contain specific text, taking into account upper and lower case, you can use a formula based on the EXACT …
(Excel examples for Beginners) In this end-to-end excel example, you will learn – How to Count cells equal to something. How to Count cells equal to something Generic formula =COUNTIF(range,value) Explanation To count the number of cells equal to a specific value, you can use the COUNTIF function. In the example shown, G6 contains this …
(Python Data Visualisation Tutorials) Python Data Visualisation for Business Analyst – How to do Seasonal Plot in Python In this data visualisation tutorial, you will learn – How to do Seasonal Plot in Python. The seasonal plot can be used to compare how the time series performed at same day in the previous season (year …
(Python Data Visualisation Tutorials) Python Data Visualisation for Business Analyst – How to Plot Multiple Time Series with different scales using secondary Y axis in Python In this data visualisation tutorial, you will learn – How to Plot Multiple Time Series with different scales using secondary Y axis in Python. If you want to show …
(Python Data Visualisation Tutorials) Python Data Visualisation for Business Analyst – How to Plot Multiple Time Series in Python In this data visualisation tutorial, you will learn – How to Plot Multiple Time Series in Python. You can plot multiple time series that measures the same value on the same chart as shown below. …
(Python Data Visualisation Tutorials) Python Data Visualisation for Business Analyst – How to do Time Series Decomposition Plot in Python In this data visualisation tutorial, you will learn – How to do Time Series Decomposition Plot in Python. Time series decomposition plot shows the break down of the time series into trend, seasonal and residual …
(Python Data Visualisation Tutorials) Python Data Visualisation for Business Analyst – How to do Cross Correlation plot in Python In this data visualisation tutorial, you will learn – How to do Cross Correlation plot in Python. Cross correlation plot shows the lags of two time series with each other. Setup Run this once before …
(Python Data Visualisation Tutorials) Python Data Visualisation for Business Analyst – How to do Autocorrelation (ACF) and Partial Autocorrelation (PACF) Plot in Python In this data visualisation tutorial, How to do Autocorrelation (ACF) and Partial Autocorrelation (PACF) Plot in Python. The ACF plot shows the correlation of the time series with its own lags. Each …
(Python Data Visualisation Tutorials) Python Data Visualisation for Business Analyst – How to Plot Time Series with Peaks and Troughs Annotated in Python In this data visualisation tutorial, How to Plot Time Series with Peaks and Troughs Annotated in Python. Time series plot is used to visualise how a given metric changes over time. Here …