MUNIT

Formulas / MUNIT
Return a unit matrix of a specified dimension.
MUNIT(dimension)
  • dimension - a required number specifying the dimension of the unit matrix that is returned

Examples

  • =MUNIT(3)

    The MUNIT function is used to generate a matrix of size NxN where N is the argument entered into the function. For example, this will generate a 3x3 matrix. This matrix will contain 1s along the diagonal and 0s in the other entries, making it a unit matrix. This is useful for algebraic applications, such as multiplying two matrices together.

  • =MUNIT(5)

    The MUNIT function can also be used to generate a 5x5 unit matrix. This is done by entering the formula into a Sourcetable cell. This will generate a 5x5 matrix with 1s along the diagonal and 0s in the other entries. This can be used with other matrices to perform matrix multiplication, which is a widely used algebraic operation.

  • =MUNIT(8)

    The MUNIT function can be used to create a unit matrix of any size, as long as the size is entered as an argument. For example, entering the formula above will generate an 8x8 unit matrix. This matrix can then be used for a variety of different operations, such as matrix multiplication.

  • =MUNIT(9)

    The MUNIT function is also useful for creating matrices of any size, as long as the size is entered as an argument. For example, entering the preceding formula will generate a 9x9 unit matrix. This matrix can then be used for a variety of operations.

Summary

The MUNIT function returns a unit matrix, also known as an identity matrix, of a given positive dimension. The function takes one argument and returns a number.

  • The MUNIT function takes one argument and returns the unit matrix for a given number of dimensions. The unit matrix, also known as the identity matrix, is a square matrix with ones on the main diagonal and zeros elsewhere.
  • The argument for the MUNIT function is the number of dimensions.


Frequently Asked Questions

What is the MUNIT Function?
The MUNIT function is a mathematical function that returns a unit matrix for a given dimension. A unit matrix is a square matrix of size n x n, where n is the dimension argument, with ones on the main diagonal and zeros everywhere else.
How do I use the MUNIT Function?
To use the MUNIT function, you need to pass it a single argument: the dimension of the matrix you want to create. The dimension argument must be a positive integer greater than zero. The MUNIT function will then return an array of numbers representing the unit matrix of the given dimension.
What is a unit matrix?
A unit matrix is a square matrix of size n x n, where n is the dimension argument, with ones on the main diagonal and zeros everywhere else.

Make Better Decisions
With Data

Analyze data, automate reports and create live dashboards
for all your business applications, without code. Get unlimited access free for 14 days.