Using Solver for a simple condition
The maximum of the planck radiation curve vs wavelength is satisfied
when x = 5 - 5 exp(-x),
where x = hc/(kT)/wavelength.
-
Suggestions
-
type 'x' in cell A3
-
enter '2' in cell B3
-
type 'expr' in cell A6
-
enter '=5-B3-5*exp(-B3)' in cell B6
-
Bring up Solver under Tools
-
Follow the instructions and see if it converges to the answer of 4.965..
-
Now try an initial x value of 15 and try again.
-
Next try an initial x value of -4 and see what happens
-
Solver is quite general and can be helpful in many different situations
-
But ... it can fail if you don't start in the right vicinity.
-
When you are searching for a solution in which 2 or 3 variables are being
adjusted, it becomes more important to start in the right neighborhood.
Using Solver to Fit Radioactive Decay Data
-
Bring up the DecayData.xls spreadsheet
-
This has decay rate vs time in the lefthand columns
-
An equation on the sheet reminds you of how count rate depends on the decay
constants and initial parameters
-
You need to construct a column of calculated decay rates in column D as
a function of time
-
Column E will contain the difference between columns C and D, squared
-
You will want to minimize the sum of all the squared differences
-
Solver will do this if you tell it to adjust the four parameters and find
a minimum
-
For silver the decay constants are ln(2)/144 = .0048 and ln(2)/25 = 0.0277,
roughly.
-
The background count rate is assumed negligible or already folded into
the data.