matlab functions in microsoft excel -凯发k8网页登录

execute matlab^® functions using data in microsoft^® excel^® and display results in spreadsheets

after you have data in a microsoft excel spreadsheet, you can execute matlab functions using various methods. for example, you can use the microsoft excel ribbon, context menu, worksheet cells, or vba macros. to find matlab functions in a visual way, use the matlab function wizard. for differences among these methods, see .

functions

	evaluate matlab command given microsoft excel data
	evaluate matlab command given microsoft excel data and designate output location
	evaluate matlab command in matlab
	return standard spreadsheet link errors or full matlab errors

topics

execute matlab functions in microsoft excel

learn about different spreadsheet link™ function types, execution methods, and how to specify arguments to execute matlab functions.
export data in a named range of a worksheet, execute a matlab function using the microsoft excel ribbon, and import results into microsoft excel.
export data in a named range of a worksheet, execute a matlab function using the microsoft excel context menu, and import results into microsoft excel.
export data in a named range of a worksheet, execute a matlab function using microsoft excel worksheet cells, and import results into microsoft excel.
export data in a named range of a worksheet, execute a matlab function using a microsoft excel vba macro, and import results into microsoft excel.
calculate the singular value decomposition of a matrix using a microsoft excel vba macro.

execute matlab functions using real data

build a mathematical model of a data set, organize the data, and display it using a microsoft excel worksheet.
interpolate, organize, and display data using a microsoft excel worksheet.
price options and build a binomial tree in a microsoft excel worksheet.
analyze three portfolios using rates of return for six time periods in a microsoft excel worksheet.
determine a set of cash flow amounts and dates given a portfolio of five bonds in a microsoft excel worksheet.

execute matlab functions using matlab function wizard

find a matlab function, select a function signature, specify arguments, and execute the function using the matlab function wizard.
write a custom matlab function and find it using the matlab function wizard.