MTC 499 Chapter Notes - Chapter 1: Gerontology Research Group, Lincoln Near-Earth Asteroid Research, European Route E18

30 views3 pages

Document Summary

To begin using solver in excel, this additional feature had to be added into the spreadsheet in order to use it. I did this (cid:271)(cid:455) si(cid:373)pl(cid:455) (cid:272)li(cid:272)ki(cid:374)g the (cid:858)file(cid:859) ta(cid:271), the(cid:374) (cid:858)optio(cid:374)s(cid:859) a(cid:374)d the(cid:374) (cid:272)li(cid:272)ki(cid:374)g (cid:858)add-i(cid:374)s(cid:859) (cid:272)ategor(cid:455). Excel add-i(cid:374)s. here (cid:455)ou (cid:449)ill fi(cid:374)d a sele(cid:272)tio(cid:374) of add i(cid:374)s for e(cid:454)(cid:272)el; this is (cid:449)here i sele(cid:272)ted (cid:858)sol(cid:448)er add i(cid:374). (cid:859) i (cid:272)li(cid:272)ked this tick box and then clicked ok. I used cell referencing to create the equation given in the problem below. To make reading the formula easier i renamed the cell to represent x to be x. This meant in the f(x) box the fo(cid:396)(cid:373)ula (cid:396)ead (cid:862)=(cid:454)^(cid:1008)-2*x^3-8*x^2-(cid:1008)*(cid:454)+(cid:1007)(cid:863). Whe(cid:396)e the (cid:454) i(cid:374) this fo(cid:396)(cid:373)ula (cid:449)as (cid:272)ell b(cid:1010)(cid:894)(cid:448)a(cid:396)ia(cid:271)le(cid:895). O(cid:374)(cid:272)e i had do(cid:374)e this i (cid:449)e(cid:374)t i(cid:374)to the (cid:858)data(cid:859) ta(cid:271) a(cid:374)d (cid:272)li(cid:272)ked (cid:858) ol(cid:448)e(cid:396). (cid:859) he(cid:396)e a (cid:858) ol(cid:448)e pa(cid:396)a(cid:373)ete(cid:396)s(cid:859) (cid:271)o(cid:454) ope(cid:374)s (cid:449)he(cid:396)e the (cid:858) et o(cid:271)je(cid:272)ti(cid:448)e(cid:859) is the specific value for b7 in this case.

Get access

Grade+20% off
$8 USD/m$10 USD/m
Billed $96 USD annually
Grade+
Homework Help
Study Guides
Textbook Solutions
Class Notes
Textbook Notes
Booster Class
40 Verified Answers
Class+
$8 USD/m
Billed $96 USD annually
Class+
Homework Help
Study Guides
Textbook Solutions
Class Notes
Textbook Notes
Booster Class
30 Verified Answers

Related Documents

Related Questions