#lambda function

Impulsively started learning kotlin so I can impulsively develop an android app. It's similar enough to Java that I could skip most lessons in the course, but I needed some extra practice to wrap my head around anonymous and lambda functions.

This is the practice example I made up.

After limited success using AI to write an ISPRIME formula, I built my own ISPRIME Lambda function. My approach is shown step by step.

Prime Numbers (and AI) Using ChatGPT and other AI tools to write Excel formulas has become popular. Bill Jelen aka Mr Excel has a simple test to see whether the particular AI engine is reliable: ask for a formula to determine whether a number is a prime number. Until recently, the response is this formula to test cell A2: =ISPRIME(A2) This makes use of the well-known but nonexistent ISPRIME…

In two recent articles, Excel Lambda Moving Average and Improved Excel Lambda Moving Average, I described my efforts to build a Lambda moving average formula that worked the way I wanted it to. I’ve included average calculations for the first few data points before the number of points being averaged is met. I’t’ve also included only counting points within a set number of days, even if there are…

Moving Averages When averaging time-series data, you often want to smooth out peaks and valleys. A moving average is an easy way to smooth your data. When I track my weight, for example, I use a 7-day moving average. This smooths out peaks associated with weekends when I might go out to eat and enjoy a beer or two. The image below shows 25 random data points and a five-point moving average. The…

What is Python Lambda Function? | Learn Python Anonymous Functions in 1 ...

Hi, a new #video on #python #lambda #function is published on #codeonedigest #youtube channel. Learn the #programming with python #anonymous #function in 1 minute. Enjoy #coding with python lambda #functions.

LAMBDA Function to Build Three-Tier Year-Quarter-Month Category Axis Labels

A certain data layout can produce a chart axis which divides and subdivides the categories into logical subcategories, such as years, quarters, and months in the following chart. Generally, this data layout must be produced by hand, because it relies on an arrangement of filled and blank cells to help Excel parse the data into subcategories. In this post I’ll show how a LAMBDA formula can build…

Dynamic Array Histogram Dynamic Arrays make it easier than ever to generate a data range for a histogram, including a normal curve overlay. LET and LAMBDA functions make it even easier and more flexible.

My friend Thom and I had a discussion about tracking weight and using histograms to show the shape of the weight distribution. He told me he disliked the native Excel Histograms, and I agreed. I’ve written a lot of articles about histograms (see the list at the end of this article), and my commercial software, Peltier Tech Charts for Excel, provides a couple types of histogram which are much more…