solving equations - pearson education求解方程——皮尔森教育

《solving equations - pearson education求解方程——皮尔森教育》由会员上传分享，免费在线阅读，更多相关内容在应用文档-天天文库。

1、SolvingEquationswithExcelOneofthemostimportantusesofcomputersinmathematicsistosolvesystemsofequations.Later,weshallseeexamplesofequationsthatcannotbesolved,exceptwiththeuseofacomputer.Inthissection,weshallintroduceoneofthemostpowerfultoolsthatcomeswithExce

2、l,TheExcelSolver.Thissolvercanbeusedtosolvesystemsofequationsaswellastofindmaximaandminima.HereweshowhowtosolvesomesimpleequationsusingSolver.OneequationwithonevariableExample1LetususetheSolvertosolveequation3x+10=x+4.Itsimplifiesthesolutionprocessifwerewr

3、itetheequationto3x+10–x–4=0.SetupthespreadsheetsothatitlookslikeFigure1.Theentriesinrow1indicatethecontentsinrow2.CellA2containstheargumentx.x=0isenteredasapreliminaryguess.IncellB2istheformulathatcorrespondstotheequationwewanttosolve.Theformulatakesthecon

4、tentofA2asanargument.Youcanseehowtheformulaisenteredintheformulabar.IncellB2youseetheresult,6,whentheinitialguessonxis0.Figure1,Solving3x+10–x–4=0InordertosolvetheequationyounowloadtheSolvertool.YoufindthistoolontheToolsmenuinExcel.IfyoucannotfindSolveront

5、heToolsmenu,theSolverhasprobablynotbeeninstalled.ConsulttheExceldocumentationonhowtoinstallthisfeature.AfterloadingtheSolver,settheSolveruptosolvetheproblem.YoudothisbyaskingtheSolvertosetthecontentofcellB2equaltozerobychangingthecontentofA2.TheSolverDialo

6、gboxshouldlooklikeFigure2.10Figure2,Solverdialogboxfortheproblem3x+10–x–4=0PressingSolvemakessolvercomputeananswer.AdialogboxappearsthatinformsyouwhethertheSolverfoundasolutionornot.Withalinearprobleminonevariable,theSolverwillalwaysfindasolution.Thespread

7、sheetshouldnowlooklikeFigure3.Figure3,Thesolutionfortheproblemfor3x+10–x–4=010ThedialogboxreportsthatSolverhasfoundasolution.IncellA2thevalueofxthatsolvestheproblemisreportedtobex=–3.IncellB2onecanseethat3(-3)+10–(–3)–4actuallyequalszero.Thisexamplewaseasy

8、.Butforanumberofreasons,Solverdoesnotalwaysfindasolution.Considertheequation.SettinguptheSolverinthesamewayasthepreviousproblemmakestheSolverreportthatitcouldnotfindafeasiblesolution.Itiseasytoseewhatgoeswron