Use an Excel conditional statement to find: Whether a show is a Comedy that is still on the air. Do not use an IF statement. No nesting of conditional statements should be used.
Use an Excel conditional statement to find: Whether a show is a Comedy that is still on the air. Do not use an IF statement. No nesting of conditional statements should be used.
Computer Networking: A Top-Down Approach (7th Edition)
7th Edition
ISBN:9780133594140
Author:James Kurose, Keith Ross
Publisher:James Kurose, Keith Ross
Chapter1: Computer Networks And The Internet
Section: Chapter Questions
Problem R1RQ: What is the difference between a host and an end system? List several different types of end...
Related questions
Question
Use an Excel conditional statement to find: Whether a show is a Comedy that is still on the air. Do not use an IF statement. No nesting of conditional statements should be used.
![1
2
3 American Horror Story
4 Archer
5 Arrow
6 Bates Motel
7 Bob's Burgers
8 Bones
9 Breaking Bad
10 DareDevil
11 Death Note
12 Dexter
13 Downton Abbey
14 Family Guy
15 Firefly
16 Friends
17 Futurama
18 Grace and Frankie
19 Grey's Anatomy
20 Haven
21 House
22 House of Cards
23 How I Met Your Mother
24 How To Get Away With Murder
25 It's Always Sunny in Philadelphia
26 Lost Girl
27 Miss Fisher's Murder Mysteries
28 NCIS
29 New Girl
30 Parks and Recreation
31 Psych
32 Red Dwarf
33 Reign
34 Rick and Morty
35 Saved by the Bell
36 Scrubs
37 Supernatural
38 That 70's Show
39 The 100
40 The Blacklist
41 The Flash
42 The L Word
43 The Office
44 The Walking Dead
45 Unbreakable Kimmy Schmidt
46 Workaholics
47
48
49
Name of Show
50
51
52 Average Viewer Rating
53 Earliest Airing Year
54 Greatest Number of Seasons of Any Show:
55 Total Number of Episodes:
56 Total Number of Shows:
64
Name, Unity ID and Section :
Question and Answer Section
Use Excel Functions or Conditional Statements to find:
65
66
RT
57 Number of Shows that have 30 minute Episodes:
58 Time Spent Watching 1 Episode from each Drama:
A ▶
Ready
Data Table
♥ #Season # Episode Year Show Bega Genre of Show Is the show currently on air Average Episode Lengti Average Viewer Rati Comedy that is still airing? onger than 6 Seasons or less than 20 Episodes Is a Show "Too Long", or "Just the Right Length"?
Yes
Yes
2011 Horror
2010 Comedy
2012 Comic Book
2013 Drama
Yes
Yes
2011 Comedy
Yes
2005 Crime/Medical Drama Yes
2008 Drama
No
2015 Comic Book
Yes
2004 A
2006 Anime
No
2006 Crime/Medical Drama No
2011 Drama
Yes
Netflix
+
5
64
75
92
7
30
126
227
62
13
2
IROLAMO 37
KOŃ ANALY 96
6
4
3
6
Accessibility: Good to go
11
5
6
1
10
7
MUH
1
BEMUT 12
5
8
3
9
2
11
THEY
S WEMEE
3
13
6
9
11
8
2
3
2
6
9
6
1
W
1
Answer
4.477272727
1988
14
4575
44
51
257
14
$
7 KINDER 125
8] had
121
101
MELLOR
61
3 FONT 66
2
21
236
140
13
AFT
257
78
177
39
208
30
119
77
34
298
99
99
198
226
200
29
63
35
70
201
76
13
22
W
GIORE
SUP
6
3651
59 Whether a show was a Comedy that is still on the air
Use Column 1 Hint: You should not use an If Statement here
60 Whether a show had more than 6 seasons or had less than 20 (Use Column J.Hint You should not use an If Statement here
61 If a show is
how is 45 minutes or longer, then it is "Too Long" Use Colums
62
63
1999 Comedy
2002 Sci-Fi
1994 Comedy
1999 Sci-Fi
2015 Comedy
No
2005 Crime /Medical Drama Yes
2010 Sci-Fi
Yes
2004 Crime/Medical Drama No
Yes
2013 Drama
2005 Comedy
2014 Drama
2005 Comedy
2010 Sci-F
Yes
2012 Crime/Medical Drama Yes
2006 Comedy
1988 High Camp
2013 Drama
Yes
No
No
No
2003 Crime Medical Drama Yes
2011 Comedy
Yes
2009 Comedy
No
No
No
2013 Comedy
1989 Teen
2001 Comedy
2005 Sci-Fi
1998 Comedy
2014 Sci-Fi
2013 Drama
2014 Action
2004 Drama
2005 Sitcom
2010 Horror
2015 Comedy
2012 Comedy
No
Yes
Yes
Yes
Yes
No
No
Yes
No
Yes
Yes
Yes
IN
No
Yes
Yes
No
Yes
Action
Anime
Comedy
Comic Book
Crime/Medical Drama
Drama
High Camp
Horror
Sci-Fi
45
30
45
30
Sitcom
Teen
=
20
20
45
45
60
30
30
50
50
20
45
20
30
30
45
45
45
50
20
45
20
45
60
45
20
20
45
20
45
20
20
20
45
20
50
50
50
Use the summarized data below to create your graph
Genre of Show
Average Number of Seasons
45
50
30
45
20
20
2
2
6.667
2.5
9.1667
3.875
10
5.5
5.1667
9
6
[8] E](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2F02af43a5-a1ff-44d9-89dd-1e2db9d95d08%2F3902742a-8d94-4d7a-9964-c8f987eb3b40%2Ffzqvouq_processed.jpeg&w=3840&q=75)
Transcribed Image Text:1
2
3 American Horror Story
4 Archer
5 Arrow
6 Bates Motel
7 Bob's Burgers
8 Bones
9 Breaking Bad
10 DareDevil
11 Death Note
12 Dexter
13 Downton Abbey
14 Family Guy
15 Firefly
16 Friends
17 Futurama
18 Grace and Frankie
19 Grey's Anatomy
20 Haven
21 House
22 House of Cards
23 How I Met Your Mother
24 How To Get Away With Murder
25 It's Always Sunny in Philadelphia
26 Lost Girl
27 Miss Fisher's Murder Mysteries
28 NCIS
29 New Girl
30 Parks and Recreation
31 Psych
32 Red Dwarf
33 Reign
34 Rick and Morty
35 Saved by the Bell
36 Scrubs
37 Supernatural
38 That 70's Show
39 The 100
40 The Blacklist
41 The Flash
42 The L Word
43 The Office
44 The Walking Dead
45 Unbreakable Kimmy Schmidt
46 Workaholics
47
48
49
Name of Show
50
51
52 Average Viewer Rating
53 Earliest Airing Year
54 Greatest Number of Seasons of Any Show:
55 Total Number of Episodes:
56 Total Number of Shows:
64
Name, Unity ID and Section :
Question and Answer Section
Use Excel Functions or Conditional Statements to find:
65
66
RT
57 Number of Shows that have 30 minute Episodes:
58 Time Spent Watching 1 Episode from each Drama:
A ▶
Ready
Data Table
♥ #Season # Episode Year Show Bega Genre of Show Is the show currently on air Average Episode Lengti Average Viewer Rati Comedy that is still airing? onger than 6 Seasons or less than 20 Episodes Is a Show "Too Long", or "Just the Right Length"?
Yes
Yes
2011 Horror
2010 Comedy
2012 Comic Book
2013 Drama
Yes
Yes
2011 Comedy
Yes
2005 Crime/Medical Drama Yes
2008 Drama
No
2015 Comic Book
Yes
2004 A
2006 Anime
No
2006 Crime/Medical Drama No
2011 Drama
Yes
Netflix
+
5
64
75
92
7
30
126
227
62
13
2
IROLAMO 37
KOŃ ANALY 96
6
4
3
6
Accessibility: Good to go
11
5
6
1
10
7
MUH
1
BEMUT 12
5
8
3
9
2
11
THEY
S WEMEE
3
13
6
9
11
8
2
3
2
6
9
6
1
W
1
Answer
4.477272727
1988
14
4575
44
51
257
14
$
7 KINDER 125
8] had
121
101
MELLOR
61
3 FONT 66
2
21
236
140
13
AFT
257
78
177
39
208
30
119
77
34
298
99
99
198
226
200
29
63
35
70
201
76
13
22
W
GIORE
SUP
6
3651
59 Whether a show was a Comedy that is still on the air
Use Column 1 Hint: You should not use an If Statement here
60 Whether a show had more than 6 seasons or had less than 20 (Use Column J.Hint You should not use an If Statement here
61 If a show is
how is 45 minutes or longer, then it is "Too Long" Use Colums
62
63
1999 Comedy
2002 Sci-Fi
1994 Comedy
1999 Sci-Fi
2015 Comedy
No
2005 Crime /Medical Drama Yes
2010 Sci-Fi
Yes
2004 Crime/Medical Drama No
Yes
2013 Drama
2005 Comedy
2014 Drama
2005 Comedy
2010 Sci-F
Yes
2012 Crime/Medical Drama Yes
2006 Comedy
1988 High Camp
2013 Drama
Yes
No
No
No
2003 Crime Medical Drama Yes
2011 Comedy
Yes
2009 Comedy
No
No
No
2013 Comedy
1989 Teen
2001 Comedy
2005 Sci-Fi
1998 Comedy
2014 Sci-Fi
2013 Drama
2014 Action
2004 Drama
2005 Sitcom
2010 Horror
2015 Comedy
2012 Comedy
No
Yes
Yes
Yes
Yes
No
No
Yes
No
Yes
Yes
Yes
IN
No
Yes
Yes
No
Yes
Action
Anime
Comedy
Comic Book
Crime/Medical Drama
Drama
High Camp
Horror
Sci-Fi
45
30
45
30
Sitcom
Teen
=
20
20
45
45
60
30
30
50
50
20
45
20
30
30
45
45
45
50
20
45
20
45
60
45
20
20
45
20
45
20
20
20
45
20
50
50
50
Use the summarized data below to create your graph
Genre of Show
Average Number of Seasons
45
50
30
45
20
20
2
2
6.667
2.5
9.1667
3.875
10
5.5
5.1667
9
6
[8] E
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution!
Trending now
This is a popular solution!
Step by step
Solved in 2 steps
Recommended textbooks for you
Computer Networking: A Top-Down Approach (7th Edi…
Computer Engineering
ISBN:
9780133594140
Author:
James Kurose, Keith Ross
Publisher:
PEARSON
Computer Organization and Design MIPS Edition, Fi…
Computer Engineering
ISBN:
9780124077263
Author:
David A. Patterson, John L. Hennessy
Publisher:
Elsevier Science
Network+ Guide to Networks (MindTap Course List)
Computer Engineering
ISBN:
9781337569330
Author:
Jill West, Tamara Dean, Jean Andrews
Publisher:
Cengage Learning
Computer Networking: A Top-Down Approach (7th Edi…
Computer Engineering
ISBN:
9780133594140
Author:
James Kurose, Keith Ross
Publisher:
PEARSON
Computer Organization and Design MIPS Edition, Fi…
Computer Engineering
ISBN:
9780124077263
Author:
David A. Patterson, John L. Hennessy
Publisher:
Elsevier Science
Network+ Guide to Networks (MindTap Course List)
Computer Engineering
ISBN:
9781337569330
Author:
Jill West, Tamara Dean, Jean Andrews
Publisher:
Cengage Learning
Concepts of Database Management
Computer Engineering
ISBN:
9781337093422
Author:
Joy L. Starks, Philip J. Pratt, Mary Z. Last
Publisher:
Cengage Learning
Prelude to Programming
Computer Engineering
ISBN:
9780133750423
Author:
VENIT, Stewart
Publisher:
Pearson Education
Sc Business Data Communications and Networking, T…
Computer Engineering
ISBN:
9781119368830
Author:
FITZGERALD
Publisher:
WILEY