Homework Help is Here – Start Your Trial Now!
Math
Statistics
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
MATLAB: An Introduction with Applications
6th Edition
ISBN:9781119256830
Author:Amos Gilat
Publisher:Amos Gilat
Chapter1: Starting With Matlab
Section: Chapter Questions
Problem 1P
See similar textbooks
icon
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
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
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
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
steps

Step by step

Solved in 7 steps with 11 images

SEE SOLUTIONCheck out a sample Q&A here
Blurred answer
Recommended textbooks for you
MATLAB: An Introduction with Applications
MATLAB: An Introduction with Applications
Statistics
ISBN:
9781119256830
Author:
Amos Gilat
Publisher:
John Wiley & Sons Inc
Probability and Statistics for Engineering and th…
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 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…
Elementary Statistics: Picturing the World (7th E…
Statistics
ISBN:
9780134683416
Author:
Ron Larson, Betsy Farber
Publisher:
PEARSON
The Basic Practice of Statistics
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
Introduction to the Practice of Statistics
Statistics
ISBN:
9781319013387
Author:
David S. Moore, George P. McCabe, Bruce A. Craig
Publisher:
W. H. Freeman
SEE MORE TEXTBOOKS