May 27, 2026 11:36 pm
If you are trying to calculate number of cells/observations in a particular column in your dataset which contains a particular text, then this guide will surely help you. So the below snapshot gives a problem set that we are trying to solve. Column B is the target...
Excel Functions for formatting : TRIM - Removes spaces from textUPPER - Converts Text to UppercaseLOWER - Converts Text to LowercasePROPER - Capitalizes the first letter in each word of a text Excel Functions for Text Extracting : LEFT - Returns the leftmost...
Recently while working on a dataset I had to repeat a particular cell for a specific no of times. For example - suppose I have a name 'Mary' and I need to repeat Mary for 8 times. So we know it is pretty easy to drag the small '+' at the end right corner of the cell...
Correlation measures the relationship between two variables, indicating positive or negative associations. It can be linear or non-linear, computed using Pearson’s correlation coefficient formula. Alternatively, Spearman’s Rank correlation assesses associations among qualitative variables by ranking. Understanding these coefficients helps analyze data patterns accurately, while being cautious of spurious correlations.
In my previous post I described how to run a regression in Excel and generate the output.Here I will focus more into what to look for in the output table and how to derive insights from that. Here is a sample of output table of linear regression generated in MS excel....
As I have listed down all the useful excel functions relevant for data analysis in my previous post, here I will elaborate on the 'Count' functions with examples. Count - This function simply gives us the count of cells containing numeric cells.Interestingly, if we...
MS Excel allows us to run linear regressions pretty easily.Here are the steps to add the 'Data Analysis' toolpack for the version of excel you are using. First go to 'Files' and then select 'Options'.This will open a window similar to the below screenshot. Select...
Excel is still a very powerful tool in the era of advanced analytical software. Here is a list of some very easy and useful excel functions which come very handy to analyze/summarize any large data-set. Count Functions: Count : Returns number of cells that contain...