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.The program is Microsoft Excel. (5 pts) You solve a more general

(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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!