Solve a system of linear equations using Excel Solver

preview_player
Показать описание
Use Excel Solver to solve 6 unknowns and 6 equations:

Example of 6 unknowns and 6 equations:
a + b - 2c + d + 3e - f = 4
2a - b + c + 2d + e - 3f = 20
a + 3b - 3c - d + 2e + f = -15
5a + 2b - c - d + 2e + f = - 3
-3a - b + 2c + 3d + e + 3f = 16
4a + 3b + c - 6d - 3e - 2f = -27
Рекомендации по теме
Комментарии
Автор

IT WORKED! I don't understand how or why but it did. I wish there had been more emphasis and explanation for key parts but it worked!

tuckergreen
Автор

Thanks for great video. Please help. How to find: MAXy for ax1+bx2+cx3+dx4=y or in your example only for a + b - 2c + d + 3e - f = MAX ?

mstipich