Research on the application of Excel genetic algorithm in mathematical modeling of College Students

Modern college students want students how to use Excel for mathematical modeling, in the operation process to use a variety of algorithms, including genetic algorithm. However, many college students have not yet mastered the specific application methods. Therefore, this paper will carry out research. Through the table function, function and mixed programming function of Excel, the dynamic changes of genetic algorithm optimization process in Excel are displayed, and simulation charts are generated. The visualization of genetic algorithm optimization process can be realized through the icon, which provides reference for college students. Through the research, college students will have a deeper understanding of the essence and optimization process of genetic algorithm, and can master the genetic algorithm in a short time. Then, the algorithm will be applied to the combination optimization, function optimization and other mathematical modeling optimization problems, and finally solve the problem.