Excel with Look up Function
Excel with Look up Function: VLOOKUP:-Vlookup is an excel function to lookup and retrieve data from a specific column. Vlookup support approximate and exact match….
Articles by dyuti
Unconditional Excellence: Conditional Formatting in Excel
What is conditional formatting option? One of the great leaps forward in successive versions of Microsoft Excel has been in clarifying information in immediate and…
Learn Multiple Regression using R
Learn Multiple Regression using R: The term “multiple” in multiple regression means that more than one variable as independent (numerical and categorical) to make predictions…
Pivot Tables For Experts
Now that we know how to create a Pivot table, Let us look into few advanced aspects of it. Let us find out the…
Pivot Tables For Beginner
What is Pivot Table in MS Excel? Ever wondered what we would do when we have chunks of data with thousands of rows and columns…
Demonetization and its Impact on Retail Industry
WHAT IS DEMONETIZATION The term demonetization is not new to the Indian economy. The highest denomination note ever printed by the Reserve Bank of India…
Chisquare Test, Different Types and its Application using R
Chi-Square Test The chi-square statistic is represented by χ2. The tests associated with this particular statistic are used when your variables are at the nominal…
Correlation and its Application using R
Correlation The word correlation is used in everyday life to denote some form of relationships. However, in statistical terms we use correlation to denote association…
Data Science The Ocean of Opportunity
Data is increasingly becoming cheap and important. We are now digitizing analog content that was created over centuries and collecting myriad new types of data…
Analytics: Demand and Supply in India
Analytics: Demand and Supply in India Necessity is the mother of all invention. When we required information we can’t overlook the existence of huge data….
