What are the formulas for Q#(A) to (k). there is the correct answers for reference below.
What are the formulas for Q#(A) to (k). there is the correct answers for reference below.
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
What are the formulas for Q#(A) to (k).
there is the correct answers for reference below.
![AutoSave OFF
Home
Paste
G20
A
Insert
20 March
21 March
22 April
23 April
24 April
25 April
26 May
27 May
28 May
29 May
30 June
31 June
32 June
33 June
34 July
35 July
36 July
37 July
38 Aug
39 Aug
40 Aug
41 Aug
42 Sep
43 Sep
44 Sep
45 Sep
46 Oct
47 Oct
48 Oct
49 Oct
50 Nov
51 Nov
52 Nov
53 Nov
54 Dec
55 Dec
56 Dec
57 Dec
58
59
60
61
19 March Owen Smith
V
A B C
Page Layout
X Calibri
B
Draw
BIUV H
Bailey Cunningham
Meredith Palmer
Brenden Calderon
Owen Smith
Bailey Cunningham
Meredith Palmer
Brenden Calderon
Owen Smith
Bailey Cunningham
Meredith Palmer
Brenden Calderon
Owen Smith
Bailey Cunningham
Meredith Palmer
Brenden Calderon
Owen Smith
Bailey Cunningham
Meredith Palmer
Brenden Calderon
Owen Smith
Bailey Cunningham
Meredith Palmer
Brenden Calderon
Owen Smith
Yes
C
Yes
Yes
Yes
Yes
No
No
Yes
Yes
No
Yes
Yes
Yes
No
Yes
Yes
No
Yes
Yes
Yes
Yes
Yes
No
Yes
Yes
Yes
Bailey Cunningham Yes
Meredith Palmer
Brenden Calderon
Owen Smith
No
Yes
Bailey Cunningham Yes
Meredith Palmer Yes
Brenden Calderon Yes
Owen Smith
No
Yes
Yes
Yes
Bailey Cunningham
Meredith Palmer
Brenden Calderon
Owen Smith
Bailey Cunningham
Meredith Palmer
Yes
Yes
Yes
D
Open recovered workbooks? Your recent changes were saved. Do you want to continue working
X ✓ fx
Compute the Minimum monthly sales generated by Owen Smith when
91
138
123
119
V 11
133
134
113
124
93
100
109
134
135
91
91
132
91
107
113
115
136
103
127
120
99
139
129
120
93
117
118
102
121
102
123
103
131
97
138
V
E F
(J)
Q#
Formulas
V
✓ A A
А.
(J)
Data Review View Te
(K)
=
20
==
= = = = =
V
ab
v
(K) Compute the Minimum monthly sales generated by Owen Smith when the tar
Correct Answer
M
G
H
1
J
K
L
Compute the Maximum monthly sales generated by Brenden Calderon when
met
Questions asked by Sales Manager
(A) Compute the total number of times the target was met across all salespe
Compute the total Sales generated in the month of March
(B)
(C) Compute the total Sales generated by Owen Smith
(D) Compute the average Sales generated by Meredith Palmer
(E)
Compute the total number of times the target was met by Brenden Calder
(F) Compute the total sales generated by Bailey Cunrt tham when the target
(G) Compute the average Sales generated by Owen Smith when the target wa
(H) Compute the Maximum monthly sales generated by Brenden Calderon
(1) Compute the Minimum monthly sales generated in the month of April
Compute the Maximum monthly sales generated by Brenden Calderon whe
target was met
Compute the Minimum monthly sales generated by Owen Smith when the
NOT met](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2F6c35fbc2-14ed-48bd-8ad4-e0369aa46c47%2F3e4fe6b3-d2f9-4de4-8cfd-5e60f4f384a1%2Fkerph49_processed.jpeg&w=3840&q=75)
Transcribed Image Text:AutoSave OFF
Home
Paste
G20
A
Insert
20 March
21 March
22 April
23 April
24 April
25 April
26 May
27 May
28 May
29 May
30 June
31 June
32 June
33 June
34 July
35 July
36 July
37 July
38 Aug
39 Aug
40 Aug
41 Aug
42 Sep
43 Sep
44 Sep
45 Sep
46 Oct
47 Oct
48 Oct
49 Oct
50 Nov
51 Nov
52 Nov
53 Nov
54 Dec
55 Dec
56 Dec
57 Dec
58
59
60
61
19 March Owen Smith
V
A B C
Page Layout
X Calibri
B
Draw
BIUV H
Bailey Cunningham
Meredith Palmer
Brenden Calderon
Owen Smith
Bailey Cunningham
Meredith Palmer
Brenden Calderon
Owen Smith
Bailey Cunningham
Meredith Palmer
Brenden Calderon
Owen Smith
Bailey Cunningham
Meredith Palmer
Brenden Calderon
Owen Smith
Bailey Cunningham
Meredith Palmer
Brenden Calderon
Owen Smith
Bailey Cunningham
Meredith Palmer
Brenden Calderon
Owen Smith
Yes
C
Yes
Yes
Yes
Yes
No
No
Yes
Yes
No
Yes
Yes
Yes
No
Yes
Yes
No
Yes
Yes
Yes
Yes
Yes
No
Yes
Yes
Yes
Bailey Cunningham Yes
Meredith Palmer
Brenden Calderon
Owen Smith
No
Yes
Bailey Cunningham Yes
Meredith Palmer Yes
Brenden Calderon Yes
Owen Smith
No
Yes
Yes
Yes
Bailey Cunningham
Meredith Palmer
Brenden Calderon
Owen Smith
Bailey Cunningham
Meredith Palmer
Yes
Yes
Yes
D
Open recovered workbooks? Your recent changes were saved. Do you want to continue working
X ✓ fx
Compute the Minimum monthly sales generated by Owen Smith when
91
138
123
119
V 11
133
134
113
124
93
100
109
134
135
91
91
132
91
107
113
115
136
103
127
120
99
139
129
120
93
117
118
102
121
102
123
103
131
97
138
V
E F
(J)
Q#
Formulas
V
✓ A A
А.
(J)
Data Review View Te
(K)
=
20
==
= = = = =
V
ab
v
(K) Compute the Minimum monthly sales generated by Owen Smith when the tar
Correct Answer
M
G
H
1
J
K
L
Compute the Maximum monthly sales generated by Brenden Calderon when
met
Questions asked by Sales Manager
(A) Compute the total number of times the target was met across all salespe
Compute the total Sales generated in the month of March
(B)
(C) Compute the total Sales generated by Owen Smith
(D) Compute the average Sales generated by Meredith Palmer
(E)
Compute the total number of times the target was met by Brenden Calder
(F) Compute the total sales generated by Bailey Cunrt tham when the target
(G) Compute the average Sales generated by Owen Smith when the target wa
(H) Compute the Maximum monthly sales generated by Brenden Calderon
(1) Compute the Minimum monthly sales generated in the month of April
Compute the Maximum monthly sales generated by Brenden Calderon whe
target was met
Compute the Minimum monthly sales generated by Owen Smith when the
NOT met
![Home Insert
2
3
AutoSave OFF
4
G20
5
Paste
Month Salesperson
9
10 Jan
11 Jan
12 Jan
13 Jan
14 Feb
15 Feb
16 Feb
17 Feb
18 March
19 March
20 March
21 March
22 April
23 April
24 April
25 April
26 May
27 May
28 May
29 May
30 June
31 June
32 June
33 June
34 July
35 July
36 July
37 July
38 Aug
39 Aug
40 Aug
41 Aug
42 Sep
A B C
Page Layout
Ready
Draw
Calibri
BI U v
Owen Smith
A
B
с
E F
G
H
He has asked you some questions, you need to construct Excel Formula to answer his queries.
Most of his questions can be answered by creating formula using Countl F, SumIF, Averagel F, CountIFS, SumIFS, AveragelFS,
MAXIFS, MINIFS functions
Questions asked by the manager is mentioned in the G10 to G20. Your answers should be in N10 to N20.
Brenden Calderon
Owen Smith
Bailey Cunningham
Meredith Palmer
Brenden Calderon
Owen Smith
Bailey Cunningham
Meredith Palmer
Brenden Calderon
Open recovered workbooks? Your recent changes were saved. Do you want to continue working where you left off?
X вести fx Compute the Minimum monthly sales generated by Owen Smith when the target was NOT met
Target
Met
Yes
Yes
Yes
Yes
No
No
Yes
Yes
Yes
Yes
D
Yes
Yes
Yes
Bailey Cunningham Yes
Meredith Palmer
Brenden Calderon
Owen Smith
Bailey Cunningham No
Meredith Palmer No
Brenden Calderon
Yes
Owen Smith
Yes
Bailey Cunningham No
Meredith Palmer
Brenden Calderon
Owen Smith
Yes
Yes
Yes
Yes
Yes
No
Yes
Yes
Bailey Cunningham No
Meredith Palmer
Brenden Calderon
Owen Smith
Bailey Cunningham
Meredith Palmer
Brenden Calderon
Owen Smith
Bailey Cunningham Yes
Meredith Palmer No
Brenden Calderon Yes
Yes
Yes
Instructions
Sales
Amount
($ '000)
120
128
114
132
140
109
92
104
130
91
✓
138
123
119
133
134
113
124
93
100
109
134
135
91
91
132
91
107
113
115
136
103
127
120
11
P1
Accessibility: Investigate
Q#
(G)
(H)
(1)
(5)
***
Q#
Formulas Data Review View Tell me
Α' Α΄
A
V
(J)
=
(K)
=
三三三
P2
1
J
(A) Compute the total number of times the target was met across all salesperson
(B) Compute the total Sales generated in the month of March
(C)
Compute the total Sales generated by Owen Smith
(D) Compute the average Sales generated by Meredith Palmer
(E) Compute the total number of times the target was met by Brenden Calderon
(F) Compute the total sales generated by Bailey Cunningham when the target was met
Questions asked by Sales Manager
K
(K) Compute the Minimum monthly sales generated by Owen Smith when the target was NOT met
Correct Answer
ab Wrap Text v
L
Merge & Center v
Questions asked by Sales Manager
Compute the average Sales generated by Owen Smith when the target was met
Compute the Maximum monthly sales generated by Breen Calderon
Compute the Minimum monthly sales generated in the month of April
Compute the Maximum monthly sales generated by Brenden Calderon when the target was
met
(A) Compute the total number of times the target was met across all salesperson
(B) Compute the total Sales generated in the month of March
(C) Compute the total Sales generated by Owen Smith
(D) Compute the average Sales generated by Meredith Palmer
(F)
(E) Compute the total number of times the target was met by Brenden Calderon
Compute the total sales generated by Bailey Cunningham when the target was met
(G) Compute the average Sales generated by Owen Smith when the target was met
(H) Compute the Maximum monthly sales generated by Brenden Calderon
(1)
Compute the Minimum monthly sales generated in the month of April
SampleAnswer +
M
Compute the Maximum monthly sales generated by Brenden Calderon when the
target was met
NOT met
Compute the Minimum monthly sales generated by Owen Smith when the target was
MiniCase9_144
Your
Answer
N
Your
Answer
General
10
1009
115.44
140.00
$ % 9
38
482
1360
118.33
113
134
91
482
0
O](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2F6c35fbc2-14ed-48bd-8ad4-e0369aa46c47%2F3e4fe6b3-d2f9-4de4-8cfd-5e60f4f384a1%2F7r8yjr6_processed.jpeg&w=3840&q=75)
Transcribed Image Text:Home Insert
2
3
AutoSave OFF
4
G20
5
Paste
Month Salesperson
9
10 Jan
11 Jan
12 Jan
13 Jan
14 Feb
15 Feb
16 Feb
17 Feb
18 March
19 March
20 March
21 March
22 April
23 April
24 April
25 April
26 May
27 May
28 May
29 May
30 June
31 June
32 June
33 June
34 July
35 July
36 July
37 July
38 Aug
39 Aug
40 Aug
41 Aug
42 Sep
A B C
Page Layout
Ready
Draw
Calibri
BI U v
Owen Smith
A
B
с
E F
G
H
He has asked you some questions, you need to construct Excel Formula to answer his queries.
Most of his questions can be answered by creating formula using Countl F, SumIF, Averagel F, CountIFS, SumIFS, AveragelFS,
MAXIFS, MINIFS functions
Questions asked by the manager is mentioned in the G10 to G20. Your answers should be in N10 to N20.
Brenden Calderon
Owen Smith
Bailey Cunningham
Meredith Palmer
Brenden Calderon
Owen Smith
Bailey Cunningham
Meredith Palmer
Brenden Calderon
Open recovered workbooks? Your recent changes were saved. Do you want to continue working where you left off?
X вести fx Compute the Minimum monthly sales generated by Owen Smith when the target was NOT met
Target
Met
Yes
Yes
Yes
Yes
No
No
Yes
Yes
Yes
Yes
D
Yes
Yes
Yes
Bailey Cunningham Yes
Meredith Palmer
Brenden Calderon
Owen Smith
Bailey Cunningham No
Meredith Palmer No
Brenden Calderon
Yes
Owen Smith
Yes
Bailey Cunningham No
Meredith Palmer
Brenden Calderon
Owen Smith
Yes
Yes
Yes
Yes
Yes
No
Yes
Yes
Bailey Cunningham No
Meredith Palmer
Brenden Calderon
Owen Smith
Bailey Cunningham
Meredith Palmer
Brenden Calderon
Owen Smith
Bailey Cunningham Yes
Meredith Palmer No
Brenden Calderon Yes
Yes
Yes
Instructions
Sales
Amount
($ '000)
120
128
114
132
140
109
92
104
130
91
✓
138
123
119
133
134
113
124
93
100
109
134
135
91
91
132
91
107
113
115
136
103
127
120
11
P1
Accessibility: Investigate
Q#
(G)
(H)
(1)
(5)
***
Q#
Formulas Data Review View Tell me
Α' Α΄
A
V
(J)
=
(K)
=
三三三
P2
1
J
(A) Compute the total number of times the target was met across all salesperson
(B) Compute the total Sales generated in the month of March
(C)
Compute the total Sales generated by Owen Smith
(D) Compute the average Sales generated by Meredith Palmer
(E) Compute the total number of times the target was met by Brenden Calderon
(F) Compute the total sales generated by Bailey Cunningham when the target was met
Questions asked by Sales Manager
K
(K) Compute the Minimum monthly sales generated by Owen Smith when the target was NOT met
Correct Answer
ab Wrap Text v
L
Merge & Center v
Questions asked by Sales Manager
Compute the average Sales generated by Owen Smith when the target was met
Compute the Maximum monthly sales generated by Breen Calderon
Compute the Minimum monthly sales generated in the month of April
Compute the Maximum monthly sales generated by Brenden Calderon when the target was
met
(A) Compute the total number of times the target was met across all salesperson
(B) Compute the total Sales generated in the month of March
(C) Compute the total Sales generated by Owen Smith
(D) Compute the average Sales generated by Meredith Palmer
(F)
(E) Compute the total number of times the target was met by Brenden Calderon
Compute the total sales generated by Bailey Cunningham when the target was met
(G) Compute the average Sales generated by Owen Smith when the target was met
(H) Compute the Maximum monthly sales generated by Brenden Calderon
(1)
Compute the Minimum monthly sales generated in the month of April
SampleAnswer +
M
Compute the Maximum monthly sales generated by Brenden Calderon when the
target was met
NOT met
Compute the Minimum monthly sales generated by Owen Smith when the target was
MiniCase9_144
Your
Answer
N
Your
Answer
General
10
1009
115.44
140.00
$ % 9
38
482
1360
118.33
113
134
91
482
0
O
Expert Solution
![](/static/compass_v2/shared-icons/check-mark.png)
Step 1
Given Information:
Consider the given information:
Month | Salesperson | Target Met | Sales Amount |
Jan | Brenden Calderon | Yes | 120 |
Jan | Owen Smith | Yes | 128 |
Jan | Bailey Cunnigham | Yes | 114 |
Jan | Meredith Palmer | Yes | 132 |
Feb | Brenden Calderon | No | 140 |
Feb | Owen Smith | No | 109 |
Feb | Bailey Cunnigham | Yes | 92 |
Feb | Meredith Palmer | Yes | 104 |
March | Brenden Calderon | Yes | 130 |
March | Owen Smith | Yes | 91 |
March | Bailey Cunnigham | Yes | 138 |
March | Meredith Palmer | Yes | 123 |
April | Brenden Calderon | Yes | 119 |
April | Owen Smith | Yes | 133 |
April | Bailey Cunnigham | No | 134 |
April | Meredith Palmer | No | 113 |
May | Brenden Calderon | Yes | 124 |
May | Owen Smith | Yes | 93 |
May | Bailey Cunnigham | No | 100 |
May | Meredith Palmer | Yes | 109 |
June | Brenden Calderon | Yes | 134 |
June | Owen Smith | Yes | 135 |
June | Bailey Cunnigham | No | 91 |
June | Meredith Palmer | Yes | 91 |
July | Brenden Calderon | Yes | 132 |
July | Owen Smith | No | 91 |
July | Bailey Cunnigham | Yes | 107 |
July | Meredith Palmer | Yes | 113 |
Aug | Brenden Calderon | Yes | 115 |
Aug | Owen Smith | Yes | 136 |
Aug | Bailey Cunnigham | Yes | 103 |
Aug | Meredith Palmer | No | 127 |
Sep | Brenden Calderon | Yes | 120 |
Sep | Owen Smith | Yes | 99 |
Sep | Bailey Cunnigham | Yes | 139 |
Sep | Meredith Palmer | Yes | 129 |
Oct | Brenden Calderon | No | 120 |
Oct | Owen Smith | Yes | 93 |
Oct | Bailey Cunnigham | Yes | 117 |
Oct | Meredith Palmer | Yes | 118 |
Nov | Brenden Calderon | Yes | 102 |
Nov | Owen Smith | No | 121 |
Nov | Bailey Cunnigham | Yes | 102 |
Nov | Meredith Palmer | Yes | 123 |
Dec | Brenden Calderon | Yes | 103 |
Dec | Owen Smith | Yes | 131 |
Dec | Bailey Cunnigham | Yes | 97 |
Dec | Meredith Palmer | Yes | 138 |
Step by step
Solved in 7 steps with 11 images
![Blurred answer](/static/compass_v2/solution-images/blurred-answer.jpg)
Recommended textbooks for you
![MATLAB: An Introduction with Applications](https://www.bartleby.com/isbn_cover_images/9781119256830/9781119256830_smallCoverImage.gif)
MATLAB: An Introduction with Applications
Statistics
ISBN:
9781119256830
Author:
Amos Gilat
Publisher:
John Wiley & Sons Inc
![Probability and Statistics for Engineering and th…](https://www.bartleby.com/isbn_cover_images/9781305251809/9781305251809_smallCoverImage.gif)
Probability and Statistics for Engineering and th…
Statistics
ISBN:
9781305251809
Author:
Jay L. Devore
Publisher:
Cengage Learning
![Statistics for The Behavioral Sciences (MindTap C…](https://www.bartleby.com/isbn_cover_images/9781305504912/9781305504912_smallCoverImage.gif)
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](https://www.bartleby.com/isbn_cover_images/9781119256830/9781119256830_smallCoverImage.gif)
MATLAB: An Introduction with Applications
Statistics
ISBN:
9781119256830
Author:
Amos Gilat
Publisher:
John Wiley & Sons Inc
![Probability and Statistics for Engineering and th…](https://www.bartleby.com/isbn_cover_images/9781305251809/9781305251809_smallCoverImage.gif)
Probability and Statistics for Engineering and th…
Statistics
ISBN:
9781305251809
Author:
Jay L. Devore
Publisher:
Cengage Learning
![Statistics for The Behavioral Sciences (MindTap C…](https://www.bartleby.com/isbn_cover_images/9781305504912/9781305504912_smallCoverImage.gif)
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…](https://www.bartleby.com/isbn_cover_images/9780134683416/9780134683416_smallCoverImage.gif)
Elementary Statistics: Picturing the World (7th E…
Statistics
ISBN:
9780134683416
Author:
Ron Larson, Betsy Farber
Publisher:
PEARSON
![The Basic Practice of Statistics](https://www.bartleby.com/isbn_cover_images/9781319042578/9781319042578_smallCoverImage.gif)
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](https://www.bartleby.com/isbn_cover_images/9781319013387/9781319013387_smallCoverImage.gif)
Introduction to the Practice of Statistics
Statistics
ISBN:
9781319013387
Author:
David S. Moore, George P. McCabe, Bruce A. Craig
Publisher:
W. H. Freeman