If you see the warning NAs introduced by coercion in R, don’t panic. It is not necessarily bad, but you should understand if that is acceptable. This warning message usually appears by converting non-numerical values to numerical values with functions like as.numeric or as.integer. It may also appear by creating plots where the correct data…
Here is how to plot mean by group in R using ggplot2 or try other measures to summarize values. To demonstrate that, I will use a jitter plot. A jitter plot is great if you want to look at all data points by categories, but additional statistics might be useful for evaluation.
Here are 3 ways to create a jitter plot in R, also called a strip chart or a dot plot which is a one-dimensional scatter plot. A jitter plot in R makes it easier to view overlapping data points by categorical or discrete values. In that scenario, the scatter plot groups all data points in…
Different colors in the ggplot2 title might be useful to emphasize part of that or as a substitute for the R plot legend. It is not very easy to do, but worth it if it helps to draw the necessary attention.
When it is necessary to make the plot that is looking cleaner, you might want to remove gridlines in the ggplot2 plot or at least modify them. Mainly gridlines are helpful if there is something to read against the plot axis. If it is not the case, try to remove them to improve your plot.…
If it is necessary to swap the R plot axis, try to do that with the x and y arguments. Package ggplot2 allows you to swap the axis by using coord_flip, but it is mostly unnecessary. Try to fix the problem at the beginning.
A jitter chart in Excel is a beautiful way to use a scatterplot and randomly distribute data points to make them more visible. In other words, if your problem is overlapping data points in Excel, this might be a good solution.
If you are looking for Excel PERSONAL.XLSB location in Windows, I assume you already know why it is helpful. The Personal Macro Workbook file location is in the XLSTART folder. Here is the simplest way how to find that and solve other problems.
Here is an approach that will help you calculate quarter in DAX from the date using various tools like Power BI or Excel data model. The previous post contains a method that is useful not only in Excel but also using Power BI.