Month: August 2020

R tutorials for Business Analyst -R Select(), Filter(), Arrange(), Pipeline

(R Tutorials for Business Analyst) In this end-to-end example, you will know how use select, filter, arrange and pipeline function in R and summarise a dataset to get the descriptive statistics. R Select(), Filter(), Arrange(), Pipeline with Example In this tutorial, you will learn select() Filter() Pipeline arrange() The library called dplyr contains valuable verbs …

R tutorials for Business Analyst – R Aggregate Function: Summarise using Group_by()

(R Tutorials for Business Analyst) In this end-to-end example, you will know how we can use aggregate function in R and summarise a dataset to get descriptive statistics. R Aggregate Function: Summarise & Group_by() Summary of a variable is important to have an idea about the data. Although, summarizing a variable by group gives better …

R tutorials for Business Analyst – Correlation in R: Pearson and Spearman

(R Tutorials for Business Analyst) In this end-to-end example, you will know how we can calculate correlation in R, especially Pearson and Spearman correlation coefficient. Correlation in R: Pearson & Spearman with Matrix Example A bivariate relationship describes a relationship -or correlation- between two variables, and . In this tutorial, we discuss the concept of correlation and …

R tutorials for Business Analyst – R Exporting Data to Excel, CSV, SAS, STATA, Text File

(R Tutorials for Business Analyst) In this end-to-end example, you will know how we can export a dataset to excel, csv, SAS, STATA and TEXT file in R. It is important to know this exporting process because we can upload or import these formatted file to their respective software to do further processing as well …

R tutorials for Business Analyst – How to Replace Missing Values(NA) in R

(R Tutorials for Business Analyst) In this end-to-end example, you will find how we can replace missing values i.e. NA in R. NA can be appeared in the dataset when there is no particular value recorded for that particular field. It is important to replace such NA values in the dataset before starting any analysis. …

Excel formula for Beginners – How to Weighted average in Excel

  (Excel examples for Beginners) In this end-to-end excel example, you will learn – Excel formula for Beginners – How to Weighted average in Excel.   Excel formula for Beginners – How to Weighted average in Excel Generic formula =SUMPRODUCT(numbers,weights)/SUM(weights) Explanation To calculated a weighted average, you can use the SUMPRODUCT function together with the …

R tutorials for Business Analyst – Import Data into R: Read CSV, Excel, SPSS, Stata, SAS Files

(R Tutorials for Business Analyst) Import Data into R: Read CSV, Excel, SPSS, Stata, SAS Files Data could exist in various formats. For each format R has a specific function and argument. This tutorial explains how to import data to R. In this tutorial, you will learn Read CSV Read Excel files readxl_example() read_excel() excel_sheets() …

R tutorials for Business Analyst – R apply(), lapply(), sapply(), tapply() Function with Examples

(R Tutorials for Business Analyst)   R apply(), lapply(), sapply(), tapply() Function with Examples This tutorial aims at introducing the apply() function collection. The apply() function is the most basic of all collection. We will also learn sapply(), lapply() and tapply(). The apply collection can be viewed as a substitute to the loop. The apply() …

R tutorials for Business Analyst – R While Loop with Example

(R Tutorials for Business Analyst) While Loop in R with Example A loop is a statement that keeps running until a condition is satisfied. The syntax for a while loop is the following: while (condition) { Exp } While Loop Flow Chart Note: Remember to write a closing condition at some point otherwise the loop …