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.
   
4. From your pivot table field list, switch to ALL view.
   
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.
   
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.

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

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.

Emoji - History

Emoji were initially used by Japanese mobile operators, NTT DoCoMo, au, 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.

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

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.

WEIRD Problem in data collection

Western, Educated, Industrialized, Rich, And Democratic

The wounds of Honour are self inflicted

Path dependence

Path dependence is the idea that decisions we are faced with depend on past knowledge trajectory and decisions made, and are thus limited by the current competence base.

In other words, history matters for current decision-making situations and has a strong influence on strategic planning. Competences that have been built in the past define the option range for today’s moves. New business opportunities, in particular those based on technological progress, emerge gradually as a consequence of competencies acquired prior to new discoveries and over time.

Example

A well-known example is the QWERTY layout for typewriters. Despite the fact that different keyboard layouts in modern computer keyboards would allow faster typing, the QWERTY layout prevails. Due to the network effect (network externalities) the layout seems immutable.[1]

network effect

A network effect (also known as a network externality) exists when a product’s value to the user increases as the number of users of the product grows. The classic example is the telephone. The more people own telephones, the more valuable the telephone network is to each owner. If there are N owners, each one of them can call the other N - 1 owners: a total of N(N-1) communications can be made. Thus the network’s value grows with the number of possible connections, in the order of N squared. This insight is the basis of Metcalfe’s law that states that the value of a network is proportional to the square of the number of members within the network.

When you buy a DVD player and some DVDs, you encourage an industry, and thus more DVDs are put on the market. In fact, the concept can easily extend: perhaps the most dominant network effect is language. If you write a web page in Inuktitut, not many people can read it. If your only audience is that community, that is fine. But if you want to get attention, you will probably write it in English: scientific journals, for example, are now overwhelmingly in English, especially because the internet amplifies network effects.

Network effects have fundamental importance for business strategy, intellectual property, and technical change in a wide range of industries. For instance, it becomes very important to establish early on in a market. [1]

Example

Amazon lost money for years establishing itself as the main source for online books, in direct competition to Barnes & Noble and eventually driving Borders out of the market.

Over time, positive network effects made the network more valuable and the business more succesful.

Haptic communication

Haptics where you touch a person to add to the emotion of whatever you are saying. A hand over a shoulder, a handshake etc.

Haptic communication refers to the ways in which people and other animals communicate and interact via the sense of touch. As well as providing information about surfaces and textures, touch, or the haptic sense, is a component of communication in interpersonal relationships that is nonverbal and nonvisual. Touch is extremely important for humans and is vital in conveying physical intimacy. Haptics is a branch of nonverbal communication.

Proxemics

Proxemics which is personal space that people have and which varies by culture. See the queue at the bustops in Britain and you will know what I mean. They are all at least a metre from each other while waiting in a queue.  Some  cultures for example have a much smaller personal space.

Boiling the Frog

As the story goes, researchers found that when they put a frog in a pan of boiling water, the frog just quickly jumped out.  On the other hand, when they put a frog in cold water and put the water to boil over time, the frog just boiled to death.  The hypothesis is that the change in temperature is so gradual, the frog does not realize it’s boiling to death. While the results of the experiment are in question it is a good metaphor for organization cultures.

Negotiating 101 - Know Your ZOPA

In life and Sales, there exists the Zone of Possible Agreement.  The Zone of Possible Agreement is considered an area where negotiating parties may find common ground - where parties will often compromise and strike a deal.  In a traditional sales negotiation, it is defined by the highest possible price that the buyer is willing to offer, and the lowest possible price that the seller is willing to accept. (Remember that ZOPA is not necessarily just about price in terms of money. It can include other terms and conditions.)

Suppose that you want to sell a product that costs you $18,000.  You calculate that you can reluctantly let it go at the break-even sell price of $20,000 but would like to sell it for $30,000 to meet target margins.  A buyer wants to buy it for $15,000 but is willing to pay up to a maximum of $25,000.  The ZOPA where both buyer and seller can negotiate within would be between $20,000 to $25,000.  You (the Seller) would not entertain a bid at $15,000 because you would lose money and the Buyer would not consider your asking price of $30,000.

Beware the dangers of not understanding the ZOPA.  If you, the seller, start your offer at $40,000, so far outside the buyer’s ZOPA, the buyer will walk away since he or she may think that any discounting will never reach their buying range. The Seller had demanded too much and shut down negotiations. Likewise, the Buyer may make such a starting bid so low that the Seller might not think that he/she is serious and decides to walk away.

 

Negative ZOPAIn Sales, a negative ZOPA exists when the walkway points of both parties are too far apart with no common area of overlap – a negative ZOPA.  With a negative bargaining zone both parties may (and should) walk away.  

If we study the current North Korea standoff, we see this negative bargaining zone. North Korea’s current walkaway point is that the US and world must drop sanctions before talks.  The US walkaway point is that N. Korea must abandon pursuit of nuclear weapons.

Moving a ZOPACan you move the ZOPA?  Yes, but it requires combining common interests to create a “win/win” for all.  I, as the Seller, might be able to offer a demo or refurbished version of my product at a slightly reduced price which reduces my break-even sell price. The Buyer may be willing to offer me a testimonial for my promotional material or offer to buy in volume to reduce the Seller’s transportation and installation costs.  

Likewise, a Seller or Buyer can shrink a ZOPA by adding terms and conditions during negotiations.  True Story: A couple was getting very serious about marriage.  The woman kept mentioning “little” things which got the man’s spiderman senses tingling (their ZOPA was shrinking).  Finally, she mentioned that she would be in charge of their future finances and ration him $50 per week – their ZOPA went completely negative and he ran for the hills...and is still running.

The STAR (Situation, Task, Action, Result) format - job interview technique

The STAR (Situation, Task, Action, Result) format is a job interview technique used by interviewers to gather all the relevant information about a specific capability that the job requires. This interview format is said^{[by whom?]} to have a higher degree of predictability of future on-the-job performance than the traditional interview. This technique is a behavioral interview technique.

• Situation: The interviewer wants you to present a recent challenge and situation in which you found yourself.
• Task: What did you have to achieve? The interviewer will be looking to see what you were trying to achieve from the situation.
• Action: What did you do? The interviewer will be looking for information on what you did, why you did it and what the alternatives were.
• Results: What was the outcome of your actions? What did you achieve through your actions and did you meet your objectives? What did you learn from this experience and have you used this learning since?

The STAR technique is similar to the SOARA technique.

The SOARA (Situation, Objective, Action, Results, Aftermath) - job interview technique

The SOARA (Situation, Objective, Action, Results, Aftermath) is a job interview technique. The SOARA technique is similar to the Situation, Task, Action, Result technique. In many interviews, the SOARA technique is used as a structure for progressively extracting information relating to a recent challenge.

• Situation: The interviewer wants you to present a recent challenge and situation you found yourself in.
• Objective: What did you have to achieve? The interviewer will be looking to see what you were trying to achieve from the situation.
• Action: What did you do? The interviewer will be looking for information on what you did, why you did it and what were the alternatives.
• Results: What was the outcome of your actions? What did you achieve through your actions and did you meet your objectives.
• Aftermath: What did you learn from this experience and have you used this learning since?

Consumer speech recognition Applications

Ok Google  -- Google
Alexa  -- Amazon
Siri      -- Apple
Cortana -- Microsoft

Forklift Upgrade ( of IT Systems )

Forklift Upgrade

The term is believed to have originated when the individual components of an IT system were much larger, and may have required a forklift to haul old components away and bring new components in. In modern terms, a forklift upgrade usually refers to a software change that requires extensive hardware updates or a hardware update that requires all new software. Forklift upgrades are most common in organizations with many legacy systems that make new implementations trickier as the surrounding systems age. With IT infrastructure, the choice seems to be between regular investments over time or the occasional (and expensive) forklift upgrade when current technology has raced too far ahead.

Vexillology

Vexillology is the scientific study of the history, symbolism and usage of flags or, by extension, any interest in flags in general. The word is a synthesis of the Latin word vexillum ("flag") and the Greek suffix -logia ("study.")

Contra proferentem (Latin: "against [the] offeror"),[1] also known as "interpretation against the draftsman", is a doctrine of contractual interpretation

Contra proferentem (Latin: "against [the] offeror"),^[1] also known as "interpretation against the draftsman", is a doctrine of contractual interpretation providing that, where a promise, agreement or term is ambiguous, the preferred meaning should be the one that works against the interests of the party who provided the wording.^[2] The doctrine is often applied to situations involving standardized contracts or where the parties are of unequal bargaining power, but is applicable to other cases.^[3] The doctrine is not, however, directly applicable to situations where the language at issue is mandated by law, as is often the case with insurance contracts and bills of lading.^[4]

The reasoning behind this rule is to encourage the drafter of a contract to be as clear and explicit as possible and to take into account as many foreseeable situations as it can.