Answered step by step
Verified Expert Solution
Question
1 Approved Answer
3e^-y*0.5 + 3e^-y*1.0 + 3e^-y*1.5 + 3e^-y*2.0 = 98.39 This equation can be solved using an iterative (trial and error) procedure to give y =
3e^-y*0.5 + 3e^-y*1.0 + 3e^-y*1.5 + 3e^-y*2.0 = 98.39
This equation can be solved using an iterative ("trial and error") procedure to give y = 6.76%.
My teacher explained to me that this equation cannot be done by hand and that the y solution can only be resolved by using SOLVER on EXCEL. As I was trying to use it it showed me many options under =SOLVER. Can anybody explain how to use SOLVER on EXCEL and how to come up to the 6.76% solution? Highly appreciate it and thank you!
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started