write a function Percentages$\_$CSA using a LAMBDA

that inputs a column of names $($e$.$g$.,$ season names$)$ and produces a row of percentages for the

alphabetically sorted unique names. The percentages specify the fraction of total rows containing

a unique name $($e$.$g$.,$ Winter$).$ Test your function with the Season data in the Festivals worksheet.

Notice that the length of the row of percentages depends on the data and needs to be computed

dynamically. Use two implementations to write your function Percentages$\_$CSA, the first using

FILTER and the second using the function Percentages$\_$from$\_0\_1\_$table$\_$CSA given below. We

give you almost a complete FILTER solution because FILTER will be covered in detail in the next

topic. Call the function with the FILTER implementation Percentages$\_$FILTER$\_$CSA. Call the

function with the $0\_1\_$table as an intermediate result Percentages$\_0\_1\_$table$\_$CSA.

$=$LAMBDA$($Names$,$LET$($

SortedUnique,SORT$($UNIQUE$($UNKNOWN$\_1)),$

CountOne,LAMBDA$($s$,$ROWS$($FILTER$($Names$,$Names$=$s$))),$

CountsFILTER,MAP$($SortedUnique$,$ UNKNOWN$\_2),$

Percentages,CountsFILTER$/$SUM$($UNKNOWN$\_3),$

Show,IFERROR$($HSTACK$($SortedUnique$,$CountsFILTER,Percentages$),""),$

Result,TRANSPOSE$($CHOOSECOLS$($Show$,1,3)),$

Result$))(\{"$Winter$"$;"Summer";"Winter";"Spring";"Fall";"Winter";"Summer"$\})$

You complete this LAMBDA by changing UNKNOWN$\_1,$ UNKNOWN$\_2,$ UNKNOWN$\_3$ to the

correct names. For example, UNKNOWN$\_1$ needs to be the formal argument Names.