Search This Blog

Tuesday, May 29, 2018

How to generate all combinations from two separate lists [Pivot Table Trick]

https://chandoo.org/wp/generate-all-combinations-from-two-lists-excel/

Time for a quick but very useful tip. Ever wanted to create all combinations from two (or more) lists? a la Cartesian product of both lists.
Here is a ridiculously simple way to do it.

Make Cartesian product of two tables in Excel

Note: You need Excel 2013 or above for this.
  1. Convert two lists to tables, if not already done.
  2. Select any cell in one of the tables and go to Insert > Pivot Table (Use ALT + NV shortcut)
  3. Make sure to check “Add this data to the Data Model” option before clicking ok.
    add-pivot-to-data-model
  4. From your pivot table field list, switch to ALL view.
    see-all-tables-pivot-table-field-list
  5. Add both (or all fields) to row label area.
  6. Now, change the pivot table layout to “Show in tabular form” and check “Repeat all item labels” option.
    pivot-table-layout-settings
  7. Turn off sub totals & grand totals.
  8. Viola, your cross product is ready. All combinations are generated by Excel for you. Use them as you see fit.
join-combinations-of-two-tables-excel

Thursday, May 24, 2018

Uniform Distribution

DEFINITION of 'Uniform Distribution'

In statistics, a type of probability distribution in which all outcomes are equally likely. A deck of cards has a uniform distribution because the likelihood of drawing a heart, a club, a diamond or a spade is equally likely. A coin also has a uniform distribution because the probability of getting either heads or tails in a coin toss is the same.

BREAKING DOWN 'Uniform Distribution'

There are two types of uniform distributions: discrete and continuous. The possible results of rolling a die provide an example of a discrete uniform distribution: it is possible to roll a 1, 2, 3, 4, 5 or 6, but it is not possible to roll a 2.3, 4.7 or 5.5.
Uniform distribution is a statistical probability definition whereby every variable has the same probable outcome. Distributions are simple ways to help statisticians, mathematicians and investors to organize, analyze and display variable probabilities.

Understanding Uniform Distributions

A distribution is a simple way to appear in a set of data, either in a graph or in a list of stating which random variables have lower or higher chances, or probability. There are many different types of probability distributions, yet uniform distributions are the simplest of them all. Many people understand the bell curve distribution, as it is often used in college grading systems. Usually, students in a class organically fall into a bell curve distribution, with most students achieving an average mark, with a few at either end achieving a very poor or a very good grade.
However, a uniform distribution is a set of variables that all have the exact same possibility of happening. This uniform distribution, when displayed as a bar graph, has the exact same height of each bar and a standard number of bars. In this way, it typically looks like a rectangle and therefore is often described as the rectangle distribution. If you think about the possibility of pulling each suit's face card from a deck of playing cards, there is a random yet equal chance of pulling the jack of hearts as there is for pulling the king of spades.

Continuous Uniform Distributions

The other type of uniform distributions is continuous. An idealized random number generator would be considered a continuous uniform distribution. With this type of distribution, every variable has an equal opportunity of appearing, yet there are a continuous or possibly infinite number of possibilities. There are four other important distributions among the infinite possible distributions: binomial distribution, chi-square, normal and Student's t distribution models.

Functions of Distributions

There are also multiple functions associated with distributions to help consider variables and their variance within a data set. These functions include probability density function, cumulative density and moment generating functions.


Read more: Uniform Distribution https://www.investopedia.com/terms/u/uniform-distribution.asp#ixzz5GUOVM8iX
Follow us: Investopedia on Facebook

Tuesday, October 24, 2017

Origins of Machine learning

 a quick trip through time to examine the origins of machine learning as well as the most recent milestones.
1950 — Alan Turing creates the “Turing Test” to determine if a computer has real intelligence. To pass the test, a computer must be able to fool a human into believing it is also human.
1952 — Arthur Samuel wrote the first computer learning program. The program was the game of checkers, and the IBM computer improved at the game the more it played, studying which moves made up winning strategies and incorporating those moves into its program.
1957 — Frank Rosenblatt designed the first neural network for computers (the perceptron), which simulate the thought processes of the human brain.
1967 — The “nearest neighbor” algorithm was written, allowing computers to begin using very basic pattern recognition. This could be used to map a route for traveling salesmen, starting at a random city but ensuring they visit all cities during a short tour. 
1979 — Students at Standford University invent the “Standford Cart” which can navigate obstacles in a room on its own.
1981 — Gerald Dejong introduces the concept of Explanation Based Learning (EBL), in which a computer analyses training data and creates a general rule it can follow by discarding unimportant data.
1985 — Terry Sejnowski invents NetTalk, which learns to pronounce words the same way a baby does.
1990s — Work on machine learning shifts from a knowledge-driven approach to a data-driven approach.  Scientists begin creating programs for computers to analyze large amounts of data and draw conclusions — or “learn” — from the results.
1997 — IBM’s Deep Blue beats the world champion at chess.
2006 — Geoffrey Hinton coins the term “deep learning” to explain new algorithms that let computers “see” and distinguish objects and text in images and videos.
2010 — The Microsoft Kinect can track 20 human features at a rate of 30 times per second, allowing people to interact with the computer via movements and gestures.
2011 — IBM’s Watson beats its human competitors at Jeopardy.
2011 — Google Brain is developed, and its deep neural network can learn to discover and categorize objects much the way a cat does.
2012 – Google’s X Lab develops a machine learning algorithm that is able to autonomously browse YouTube videos to identify the videos that contain cats.
2014 – Facebook develops DeepFace, a software algorithm that is able to recognize or verify individuals on photos to the same level as humans can.
2015 – Amazon launches its own machine learning platform.
2015 – Microsoft creates the Distributed Machine Learning Toolkit, which enables the efficient distribution of machine learning problems across multiple computers.
2015 – Over 3,000 AI and Robotics researchers, endorsed by Stephen Hawking, Elon Musk and Steve Wozniak (among many others), sign an open letter warning of the danger of autonomous weapons which select and engage targets without human intervention.
2016 – Google’s artificial intelligence algorithm beats a professional player at the Chinese bioard game Go, which is considered the world’s most complex board game and is many times harder than chess. The AlphaGo algorithm developed by Google DeepMind managed to win five games out of five in the Go competition.

Saturday, June 3, 2017

Emoji - History

Emoji were initially used by Japanese mobile operators, NTT DoCoMoau, and SoftBank Mobile (formerly Vodafone). These companies each defined their own variants of emoji using proprietary standards. The first emoji was created in 1998 or 1999 in Japan by Shigetaka Kurita,[12] who was part of the team working on NTT DoCoMo's i-mode mobile Internet platform. Kurita took inspiration from weather forecasts that used symbols to show weather, Chinese characters and street signs, and from manga that used stock symbols to express emotions, such as lightbulbs signifying inspiration.[13][14][15] The first set of 176 12×12 pixel emoji was created as part of i-mode's messaging features to help facilitate electronic communication, and to serve as a distinguishing feature from other services.[5] Kurita created the first 180 emoji based on the expressions that he observed people making and other things in the city.[16]

Originally meaning pictograph, the word emoji comes from Japanese e (絵, "picture") + moji (文字, "character"). 

Gantt chart

WHAT IS A GANTT CHART? ADVANTAGES, LIMITATIONS OF GANTT CHART

What is project management all about?

The answer to above question has evolved over the period. Initially it was merely considered as a process to manage time, resources and cost. A project manager would be rated good if s/he was able to complete project on time, within budget and of a desired quality. A seasoned project managers would apply their skills to optimise resource allocation, better stakeholder management and reduce the project cost.
Project management these days is expected to become part of the strategic initiatives for a sustainable business. Project management has moved up in the value chain with project management office (PMO), strategic project management, active customer engagement, etc. The underlying principles of project management have remained the same: it is still about defining project objectives, having a clear project charter, scope documents, planning a project timeline, identifying and assigning resources, optimising costs, managing issues, risks and change requests.
Even today when someone mentions project management, it is perceived as if he is talking about project planning and specifically about project timeline. By far the most popular and commonly used project timeline tool is Gantt chart. Let’s look at what is Gantt chart and why it is still popular.

What Is a Gantt Chart?

A Gantt chart is a visual presentation used in project management to show overview of timeline for project activities and their inter-dependence. Each project task or activity is represented with a bar chart clearly displaying start and end date. Thus the length of the bar shows the duration required for a task to complete. This way multiple tasks when displayed as bar charts, shows work breakdown structure on a timeline. Essentially Gantt chart shows when an activity starts, completes, how long it will take to complete an activities and also overall project, which is a project schedule.
What is a Gantt chart, advantages, disadvantages

Brief History

Gantt chart is a legacy left behind by Henry Laurence Gantt in 1910. Henry Gantt was a mechanical engineer, management consultant and industry expert. He introduced Gantt chart to visualise schedule and actual progress of projects. Its first major implementation or usage was well known – World War One (WW1) when US army used Gantt charts to manage arms production and logistic projects.
Henry Gantt experimented with Gantt chart and presented variations of it. The Gantt chart we see and use today (along with task dependencies) was introduced by Wallace Clark. Interestingly Wallace Clark used to work in Henry Gantt’s company and was considered as Henry Gantt’s disciple.

Gantt Chart Importance

here have been few tools or techniques used to identify and manage project activities before Gantt chart came into existence such as
  • Message board
  • Post-It boards
  • To Do lists/Task lists
However these tools and techniques could not give a better picture about a project schedule. And this is where Gantt chart stands out.
  • It shows breakdown structure
  • It shows dependencies
  • It shows expected timeline
  • It shows current progress
  • It shows schedule baseline
  • It shows resources assigned
  • It shows task priority
  • It shows critical path
  • It shows smallest as well as longest task

Advantages of Gantt Chart

There are distinct advantages of a Gantt chart, primarily from project manager, project stakeholderperspective. It is easy for stakeholder’s to understand the timeline, it brings clarity to everyone: when a project is going to start and expected to complete, team can manage its time accordingly, it also establishes accountability among stakeholders, it enables team to better coordinate project activities thereby enabling team to improving overall efficiency.
  • It is easy to understand
  • It gives clarity of dates
  • It enables time management
  • It brings efficiency
  • It ensures accountability in terms of timeline
  • It expects coordination among stakeholders in order to deliver things as per Gantt timeline

Disadvantage of Gantt Chart

However Gantt chart has its own limitations. Let’s look at those briefly.
  • Tedious if one need to keep it updating regularly
  • Can become for detailed project plan
  • Unclear amount of work expected
  • Not easy to view everything on a single paper

Steps to Create a Gantt Chart

In order to create Gantt chart, first project manager needs to identify high level tasks, then break those down into smaller actionable subtasks. Further he can identify efforts and duration required for those smaller set of tasks, link, sequence project tasks. And now it’s a time to plot bar chart against each of the task. Fortunately we don’t have to use pen and paper to draw Gantt chart, neither we have to use spreadsheet for the same. Project management tools like ZilicusPM make it easier for project manager to create Gantt chart easily. Interactive Gantt chart makes it even simpler

Should You Use Gantt Chart? Why?

There are reasons to use Gantt chart for a project manager to consider
  • Better Visibility
  • Greater Clarity
  • Ease of Understanding
  • Better Time Management
  • Better Coordination

Sunday, May 28, 2017

Lady Justice statue - Origin & Symbolism

Origins of the Lady Justice Statue
Some of the first images similar to the Lady of Justice date back to the Egyptian goddess Maat, who signified truth and order in that ancient society. Later, the ancient Greeks worshipped the goddess Themis, the personification of divine law and custom, and her daughter, Dike, whose name means “justice.” Dike was always depicted carrying a pair of balance scales, and it was believed that she ruled over human law.
The ancient Romans revered Justitia or lustitia, who most closely resembles the Lady of Justice statues formed in more modern times. She represented the morality of the justice system.
The Symbols of Justice
Balance Scales: These represent impartiality and the obligation of the law (through its representatives) to weigh the evidence presented to the court. Each side of a legal case needs to be looked at and comparisons made as justice is done.
Sword: This item symbolizes enforcement and respect, and means that justice stands by its decision and ruling, and is able to take action. The fact that the sword is unsheathed and very visible is a sign that justice is transparent and is not an implement of fear. A double-edged blade signifies that justice can rule against either of the parties once the evidence has been perused, and it is bound to enforce the ruling as well as protect or defend the innocent party.
Blindfold: This first appeared on a Lady Justice statue in the 16th century, and has been used intermittently since then. Apparently its original significance was that the judicial system was tolerating abuse or ignorance of aspects of the law. However, in modern times, the blindfold represents the impartiality and objectivity of the law and that it doesn’t let outside factors, such as politics, wealth or fame, influence its decisions.