High score for help! Excel matlab is more suitable for mathematical modeling.
If modeling, it must be very strong in Matlab. Excel has strong data processing ability, but its function is too simple, so it is suitable for office use. Of course, proficient people can use it badly, but it is more troublesome. Excel is much worse in flexibility of operation, data visualization and data analysis. Matlab has strong numerical operation and symbolic operation, especially numerical operation. The basic unit of data storage and calculation is matrix, which brings great convenience to data processing. In addition, Matlab can seamlessly connect with Excel (including C, C++, FORTAN and other programming languages) and can import data. As far as programming is concerned, Excel can't program itself, but matlab has hundreds or even thousands of internal functions, which can realize various functions and can write programs many times according to its own needs. Excel cannot realize symbolic operation, solve various equations, solve optimization problems, simulate, perform logical operations and so on. Finally, I want to tell you that Excel is rarely used in mathematical modeling, and matlab, lingo, mathematica, maple and other mathematical software are most commonly used.