Contact
12 programs
Explore the site

BESSELK Function (LibreOffice Calc)

Mathematical Advanced LibreOffice Calc LibreOffice 3.0

The BESSELK function returns the modified Bessel function of the second kind, Kₙ(x). It is used in engineering, physics, probability, and differential equation modeling involving exponential decay and cylindrical symmetry.

Verification status: Consult the documentation and examples below. Native application testing has not been documented for this guide. How formula examples are checked

The **BESSELK** function returns the **modified Bessel function of the second kind**, denoted Kₙ(x). This special function appears in engineering, physics, probability theory, and solutions to differential equations involving **exponential decay**, **radial diffusion**, and **cylindrical symmetry**.

What the BESSELK Function Does

  • Computes Kₙ(x), the modified Bessel function of the second kind
  • Supports real values of x > 0
  • Supports integer orders n
  • Used in heat transfer, diffusion, EM fields, and probability distributions

Syntax

BESSELK(x; n)

Arguments

  • x:
    The input value (real number > 0).

  • n:
    The order of the Bessel function (integer ≥ 0).

Basic Examples

Compute K₀(x)

=BESSELK(1; 0)
→ 0.421024438

Compute K₁(x)

=BESSELK(2; 1)
→ 0.113893872

Using a cell reference

=BESSELK(A1; B1)

Advanced Examples

Heat conduction in cylindrical coordinates

=BESSELK(r / k; 0)

Radial diffusion model

=BESSELK(A1 * B1; 1)

Probability: Laplace distribution kernel

=BESSELK(ABS(A1); 0)

Combine with BESSELI for general solutions

=C1 * BESSELI(A1; 0) + C2 * BESSELK(A1; 0)

Normalize for large x (avoid underflow)

=BESSELK(A1; 0) * EXP(A1)

Use in modified Bessel differential equation

=BESSELK(A1; 1) + A1 * BESSELK(A1; 0)

Edge Cases and Behavior Details

BESSELK returns a numeric value

Accepts:

  • Real x > 0
  • Integer n ≥ 0

Behavior details

  • Order n must be an integer
  • Kₙ(x) → ∞ as x → 0⁺
  • Kₙ(x) → 0 as x → ∞
  • K₀(x) has a logarithmic singularity at x = 0
  • BESSELK decays exponentially for large x

Invalid input → Err:502

BESSELK of an error → error propagates

Common Errors and Fixes

Err:502 — Invalid argument

Cause:

  • x ≤ 0
  • n is not an integer
  • Non-numeric input

Fix:

  • Ensure x > 0
  • Wrap n with INT()
  • Validate numeric input

Underflow for large x

Cause:

  • Kₙ(x) becomes extremely small

Fix:

  • Multiply by EXP(x) to stabilize

Best Practices

  • Use BESSELK for exponential-decay and radial-diffusion models
  • Combine with BESSELI for full differential-equation solutions
  • Normalize large x values to avoid underflow
  • Use INT(n) to enforce integer order
  • Pair with EXP, LN, and POWER for analytic transformations
BESSELK is essential for modeling diffusion, heat transfer, EM fields, and any system governed by modified Bessel differential equations with exponential decay.
  • Use BESSELI for complementary modified Bessel solutions
  • Use BESSELJ and BESSELY for ordinary Bessel functions
  • Use EXP, LN, and POWER for analytic transformations

By mastering BESSELK and its companion functions, you can build powerful engineering, physics, and mathematical models in LibreOffice Calc.