When excel files get delivered through e-mail attachments, how can we extract the data and consolidate into a single table? Here I present an automated process to extract the attachments from Outlook emails and consolidate them using R. I use the RD...
Not having enough evidence to reject the null hypothesis doesn't mean the null hypothesis is necessarily true. Here I explain why, using an example. Students in a certain college are more inclined to use drugs than U.S. college students in general. T...
What are my chances of being pregnant if the over-the-counter pregnancy test turns out to be positive? What are my chances of getting cancer if I smoke? Or what are my chances of having cancer if my mammogram is negative? Bayes rule can be used to an...
When you come across an unknown data set, it is important to get to know about it before running into analysis. For instance, knowing the available fields, their data types, count of missing, unique or completed values and their distributions and pre...
Data validation is a critical step to maintain the accuracy of an analysis or reporting. For instance, there could be erroneous or missing values in the input data due to poor quality of the data sources or errors could occur during the stage of the ...
If data manipulation is carried out in R, why not creating the hyperlinks in R as well? Excel files use hyperlinks to navigate to external content, such as, urls or file paths to some other files. Excel uses HYPERLINK() function for this purpose. Bel...
