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+
$40 USD/m
Billed monthly
Grade+
Homework Help
Study Guides
Textbook Solutions
Class Notes
Textbook Notes
Booster Class
10 Verified Answers
Class+
$30 USD/m
Billed monthly
Class+
Homework Help
Study Guides
Textbook Solutions
Class Notes
Textbook Notes
Booster Class
7 Verified Answers

Related Documents

Related Questions