CLS-Stats Lambda Functions

Download: E2-LambdaFunctionMgmt.xlsx

Description

Much of the functionality for the CLS-Stats add-in comes from named lambda functions that you can use in your workbooks. They can be shared with colleagues (who don’t need the add-in installed for the functions to work) and are cross-platform, working on Macs, PCs, tablets, and the browser.

This screencast dives a little into the weeds of these lambdas, specifically where they exist and how to manage them. Mostly you don’t need to worry about them, they just work, but sometimes things will come up and you need to understand a little bit of what is going on under the hood. That’s what this screencast is about.

You will follow along with the first part of the screencast, starting with the Excel file that is attached above. Open that file and start the video.

Tasks

Most of this video is watching and listening but you will be active in the beginning, doing the following tasks.

• Generate 100 random numbers using the cell formula =L.rlnorm(100) in cell A1#. Congratulations, you just used your first CLS-Stats lambda function!
• Plot the kernel density estimate (KDE) of the numbers you just generated along with a boxplot of the data. To do this, use the Ctrl-Shift-K keyboard shortcut or go to Analysis $\to$ Kernel Density to launch the window. Type in A1# in the first input box and click “Run”.
• Watch and listen for the rest of the screencast. Feel free to play around with the lambda management functions (you can’t really hurt anything) if you want.