I have 10 teams playing one game in sets of two for a total of 5 games only. I have oragnized an example of what I want but I have done it by hand. There are 5 home teams and 5 away teams. Each team and their opponent is set and can not change. I need an excel formula to determine the possible outcomes for each game. The formula could be hilighting the winning team or the losing team, it could be answering winner or loser in the colum next to the teams. I just need a way to make this process faster than by entering by hand. Attached is a excel sheet that shows more of what I am trying to do for clairity. I only did the most basic selection by hand but need a way to determine every possible win/loss sequence/variation in excel or other formula. (No data in row 22, just skiped it so I can fit in all sets that I made.)
I have 10 teams playing one game in sets of two for a total of 5 games only. I have oragnized an example of what I want but I have done it by hand. There are 5 home teams and 5 away teams. Each team and their opponent is set and can not change. I need an excel formula to determine the possible outcomes for each game. The formula could be hilighting the winning team or the losing team, it could be answering winner or loser in the colum next to the teams. I just need a way to make this process faster than by entering by hand. Attached is a excel sheet that shows more of what I am trying to do for clairity. I only did the most basic selection by hand but need a way to determine every possible win/loss sequence/variation in excel or other formula. (No data in row 22, just skiped it so I can fit in all sets that I made.)
MATLAB: An Introduction with Applications
6th Edition
ISBN:9781119256830
Author:Amos Gilat
Publisher:Amos Gilat
Chapter1: Starting With Matlab
Section: Chapter Questions
Problem 1P
Related questions
Question
I have 10 teams playing one game in sets of two for a total of 5 games only.
I have oragnized an example of what I want but I have done it by hand. There are 5 home teams and 5 away teams. Each team and their opponent is set and can not change. I need an excel formula to determine the possible outcomes for each game. The formula could be hilighting the winning team or the losing team, it could be answering winner or loser in the colum next to the teams. I just need a way to make this process faster than by entering by hand. Attached is a excel sheet that shows more of what I am trying to do for clairity.
I only did the most basic selection by hand but need a way to determine every possible win/loss sequence/variation in excel or other formula. (No data in row 22, just skiped it so I can fit in all sets that I made.)
Transcribed Image Text:23 Fruit
24 Apple
Win
25 Orange
Loss
26 Grape
Win
27 Bananna Win
28 Strawberrie Win
29
30 Fruit
31 Apple
32 Orange
Win
Win
33 Grape
Loss
34 Bananna Win
35 Strawberrie Win
36
37 Fruit
38 Apple
Win
39 Orange
Win
40 Grape
Win
41 Bananna Loss
42 Strawberrie Win
43
44 Fruit
45 Apple
Win
46 Orange Win
47 Grape
Win
48 Bananna Win
49 Strawberrie Loss
Vegetable
Kale
Loss
Carrot
Win
Bean
Loss
Lettice Loss
Squash Loss
Vegetable
Kale
Carrot
Bean
Lettice
Squash
Loss
Loss
Win
Loss
Loss
Vegetable
Kale
Loss
Carrot Loss
Bean
Loss
Lettice Win
Squash
Loss
Vegetable
Kale
Loss
Carrot Loss
Bean
Loss
Lettice Loss
Squash Win
Fruit
Apple Loss
Orange Win
Grape
Loss
Bananna Loss
Strawberri Loss
Fruit
Apple
Loss
Orange Loss
Grape Win
Bananna Loss
Strawberri Loss
Fruit
Apple Loss
Orange Loss
Grape
Loss
Bananna Win
Strawberri Loss
Fruit
Apple Loss
Orange Loss
Grape
Loss
Bananna Loss
Strawberri Win
Vegetable
Kale
Win
Carrot
Loss
Bean
Win
Lettice
Win
Squash Win
Vegetable
Kale
Win
Carrot
Win
Bean
Loss
Lettice Win
Squash Win
Vegetable
Kale
Carrot
Bean
Lettice
Loss
Squash Win
Win
Win
Win
Vegetable
Kale
Win
Carrot
Win
Bean
Win
Lettice
Win
Squash Loss
Transcribed Image Text:1
Fruit
2 Apple
3 Orange
4 Grape
5 Bananna
6 Strawberrie
7
8
9 Fruit
10 Apple
Win
11 Orange
Win
12 Grape
Win
13 Bananna Win
14 Strawberrie Win
15
16 Fruit
17 Apple
Loss
18 Orange
Win
19 Grape
Win
20 Bananna Win
21 Strawberrie Win
5
Vegetable
Kale
Carrot
Bean
Lettice
Squash
5
Vegetable
Kale
Loss
Carrot
Loss
Bean
Loss
Lettice
Loss
Squash Loss
Vegetable
Kale
Carrot
Bean
Lettice
Squash
Win
Loss
Loss
Loss
Loss
Fruit
Apple
Loss
Orange
Loss
Grape
Loss
Bananna Loss
Strawberri Loss
Fruit
Apple
Win
Orange Loss
Grape
Loss
Bananna Loss
Strawberri Loss
Vegetable
Kale
Win
Carrot
Win
Bean
Win
Lettice Win
Squash Win
Vegetable
Kale
Loss
Carrot
Win
Bean
Win
Lettice Win
Squash Win
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by step
Solved in 5 steps with 4 images
Recommended textbooks for you
MATLAB: An Introduction with Applications
Statistics
ISBN:
9781119256830
Author:
Amos Gilat
Publisher:
John Wiley & Sons Inc
Probability and Statistics for Engineering and th…
Statistics
ISBN:
9781305251809
Author:
Jay L. Devore
Publisher:
Cengage Learning
Statistics for The Behavioral Sciences (MindTap C…
Statistics
ISBN:
9781305504912
Author:
Frederick J Gravetter, Larry B. Wallnau
Publisher:
Cengage Learning
MATLAB: An Introduction with Applications
Statistics
ISBN:
9781119256830
Author:
Amos Gilat
Publisher:
John Wiley & Sons Inc
Probability and Statistics for Engineering and th…
Statistics
ISBN:
9781305251809
Author:
Jay L. Devore
Publisher:
Cengage Learning
Statistics for The Behavioral Sciences (MindTap C…
Statistics
ISBN:
9781305504912
Author:
Frederick J Gravetter, Larry B. Wallnau
Publisher:
Cengage Learning
Elementary Statistics: Picturing the World (7th E…
Statistics
ISBN:
9780134683416
Author:
Ron Larson, Betsy Farber
Publisher:
PEARSON
The Basic Practice of Statistics
Statistics
ISBN:
9781319042578
Author:
David S. Moore, William I. Notz, Michael A. Fligner
Publisher:
W. H. Freeman
Introduction to the Practice of Statistics
Statistics
ISBN:
9781319013387
Author:
David S. Moore, George P. McCabe, Bruce A. Craig
Publisher:
W. H. Freeman