Question: The program is Microsoft Excel. (5 pts) You solve a more general problem: Given a table of numbers called ToN, compute the Average, Min, and
The program is Microsoft Excel.
(5 pts) You solve a more general problem: Given a table of numbers called ToN, compute the Average, Min, and Max for each column. We call this the Avg-Min-Max problem. Because solving the Avg-Min-Max problem requires a LAMBDA (to be covered next week) you will get significant help here in the assignment and in the Lab. Here is a formula to solve the Avg-Min-Max problem for any table of numbers. \[ \begin{array}{l} \text { =LAMBDA (ToN, LET ( } \\ \text { avg, BYCOL (ToN, LAMBDA (col, AVERAGE }(\text { col })) \text { ), } \\ \text { min, BYCOL (ToN, LAMBDA (col, MIN }(\text { col })) \text { ), } \\ \text { max, BYCOL (ToN, LAMBDA (col, MAX (col))), } \\ \text { row_headers, }\{\text { "average"; "minimum" } ; \text { "maximum" }\}, \\ \text { result, HSTACK (row_headers, VSTACK (avg, min, max)), } \\ \text { result)) ( }\{1,2,3 ; 2,3,4 ; 3,4,5\}) \end{array} \] Warning: this is a spilling formula: make sure there are 3 free rows down and enough free columns to the right. Use the SEQUENCE function to create a larger test case: the 10 times 10 multiplication table with 10 rows and 10 columns. Show the multiplication table and apply the above Avg-Min-Max problem solution to it
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
