Answered step by step
Verified Expert Solution
Link Copied!

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Calculus Early Transcendentals

Authors: James Stewart

8th edition

1285741552, 9781305482463 , 978-1285741550

More Books

Students also viewed these Mathematics questions

Question

Give five examples of items which are liabilities?

Answered: 1 week ago