Make a range variable and a function of a range variable into a matrix.

Team,

I have a range variable and a function of a range variable and I need to combine these into a single matrix.

The matrix would have two columns and 100 rows.

Please see the attached worksheet.

Thanks,

Dr. Atlas

Best answer by LucMeekes

A range is NOT an array, but you can use a range to create an array.

Once you have the (input) array, you can feed it to your function to get an (output) array; you may have to vectorise your function call.

You can plot the output array versus the input array, and you can augment the two arrays to form a matrix:

See attached worksheet!

Success!
Luc

Answer

23-Emerald IV

A range is NOT an array, but you can use a range to create an array.

Once you have the (input) array, you can feed it to your function to get an (output) array; you may have to vectorise your function call.

You can plot the output array versus the input array, and you can augment the two arrays to form a matrix:

See attached worksheet!

Success!
Luc

Sign up