Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Columns A and B contain the team # (found in column F) of each NBA team, for example Team #2 is Boston. Column A is
Columns A and B contain the team # (found in column F) of each NBA team, for example Team #2 is Boston. | |||||||||
Column A is the home team and Column B is the away team for every NBA team. | |||||||||
Column C is the home score and Column D is the away team score. | |||||||||
Use COUNT functions toFIND NUMBER OF GAMES TEAM SCORED OVER ONE HUNDRED POINTS | |||||||||
max 10 points | |||||||||
A=away games, H=homegames | |||||||||
HS = home score, AS = away score | # Games team | ||||||||
H | A | HS | AS | Team # | Team | # of Games Played | scored > 100 points | ||
5 | 2 | 89 | 108 | 1 | Atl | 82 | #VALUE! | ||
18 | 11 | 103 | 97 | 2 | Bos | 98 | |||
20 | 27 | 114 | 85 | 3 | Charlotte | 91 | |||
19 | 29 | 93 | 91 | 4 | Chicago | 82 | |||
17 | 21 | 83 | 74 | 5 | Cleveland | 82 | |||
6 | 8 | 94 | 87 | 6 | Dallas | 90 | |||
10 | 1 | 89 | 84 | 7 | Denver | 82 | |||
25 | 12 | 109 | 98 | 8 | Detroit | 92 | |||
28 | 16 | 112 | 119 | 9 | Golden | 82 | |||
22 | 7 | 96 | 99 | 10 | Houston | 82 | |||
24 | 26 | 101 | 95 | 11 | Indiana | 87 | |||
13 | 23 | 98 | 87 | 12 | LAC | 82 | |||
3 | 5 | 100 | 94 | 13 | LAL | 101 | |||
2 | 18 | 92 | 95 | 14 | Memphis | 82 | |||
15 | 27 | 97 | 92 | 15 | Miami | 82 | |||
4 | 11 | 73 | 98 | 16 | Milwaukee | 82 | |||
23 | 9 | 92 | 87 | 17 | Minnesota | 85 | |||
1 | 29 | 88 | 98 | 18 | NJN | 102 | |||
21 | 6 | 92 | 99 | 19 | NYK | 82 | |||
14 | 8 | 80 | 90 | 20 | Orlando | 86 | |||
10 | 12 | 98 | 92 | 21 | Philadelphia | 87 | |||
28 | 13 | 101 | 105 | 22 | Phoenix | 82 | |||
7 | 16 | 101 | 102 | 23 | Portland | 85 | |||
26 | 25 | 114 | 108 | 24 | Sacramento | 98 | |||
9 | 22 | 101 | 107 | 25 | SAN | 92 | |||
11 | 20 | 117 | 107 | 26 | Seattle | 87 | |||
27 | 6 | 109 | 92 | 27 | Toronto | 87 | |||
3 | 19 | 97 | 93 | 28 | Utah | 86 | |||
15 | 5 | 83 | 90 | 29 | Washington | 82 | |||
2 | 4 | 96 | 82 | ||||||
8 | 18 | 102 | 88 | ||||||
17 | 14 | 111 | 102 | ||||||
13 | 22 | 117 | 94 | ||||||
29 | 21 | 90 | 76 | ||||||
1 | 15 | 90 | 83 | ||||||
5 | 20 | 69 | 99 | ||||||
18 | 3 | 95 | 85 | ||||||
4 | 19 | 84 | 79 | ||||||
10 | 17 | 88 | 90 | ||||||
16 | 2 | 105 | 99 | ||||||
7 | 24 | 94 | 106 | ||||||
26 | 28 | 74 | 91 | ||||||
23 | 25 | 90 | 106 | ||||||
12 | 9 | 108 | 110 | ||||||
27 | 11 | 113 | 100 | ||||||
8 | 29 | 100 | 78 | ||||||
14 | 6 | 85 | 94 |
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started