18.9: L1.10- Exercises
- Page ID
- 51692
\( \newcommand{\vecs}[1]{\overset { \scriptstyle \rightharpoonup} {\mathbf{#1}} } \)
\( \newcommand{\vecd}[1]{\overset{-\!-\!\rightharpoonup}{\vphantom{a}\smash {#1}}} \)
\( \newcommand{\id}{\mathrm{id}}\) \( \newcommand{\Span}{\mathrm{span}}\)
( \newcommand{\kernel}{\mathrm{null}\,}\) \( \newcommand{\range}{\mathrm{range}\,}\)
\( \newcommand{\RealPart}{\mathrm{Re}}\) \( \newcommand{\ImaginaryPart}{\mathrm{Im}}\)
\( \newcommand{\Argument}{\mathrm{Arg}}\) \( \newcommand{\norm}[1]{\| #1 \|}\)
\( \newcommand{\inner}[2]{\langle #1, #2 \rangle}\)
\( \newcommand{\Span}{\mathrm{span}}\)
\( \newcommand{\id}{\mathrm{id}}\)
\( \newcommand{\Span}{\mathrm{span}}\)
\( \newcommand{\kernel}{\mathrm{null}\,}\)
\( \newcommand{\range}{\mathrm{range}\,}\)
\( \newcommand{\RealPart}{\mathrm{Re}}\)
\( \newcommand{\ImaginaryPart}{\mathrm{Im}}\)
\( \newcommand{\Argument}{\mathrm{Arg}}\)
\( \newcommand{\norm}[1]{\| #1 \|}\)
\( \newcommand{\inner}[2]{\langle #1, #2 \rangle}\)
\( \newcommand{\Span}{\mathrm{span}}\) \( \newcommand{\AA}{\unicode[.8,0]{x212B}}\)
\( \newcommand{\vectorA}[1]{\vec{#1}} % arrow\)
\( \newcommand{\vectorAt}[1]{\vec{\text{#1}}} % arrow\)
\( \newcommand{\vectorB}[1]{\overset { \scriptstyle \rightharpoonup} {\mathbf{#1}} } \)
\( \newcommand{\vectorC}[1]{\textbf{#1}} \)
\( \newcommand{\vectorD}[1]{\overrightarrow{#1}} \)
\( \newcommand{\vectorDt}[1]{\overrightarrow{\text{#1}}} \)
\( \newcommand{\vectE}[1]{\overset{-\!-\!\rightharpoonup}{\vphantom{a}\smash{\mathbf {#1}}}} \)
\( \newcommand{\vecs}[1]{\overset { \scriptstyle \rightharpoonup} {\mathbf{#1}} } \)
\( \newcommand{\vecd}[1]{\overset{-\!-\!\rightharpoonup}{\vphantom{a}\smash {#1}}} \)
\(\newcommand{\avec}{\mathbf a}\) \(\newcommand{\bvec}{\mathbf b}\) \(\newcommand{\cvec}{\mathbf c}\) \(\newcommand{\dvec}{\mathbf d}\) \(\newcommand{\dtil}{\widetilde{\mathbf d}}\) \(\newcommand{\evec}{\mathbf e}\) \(\newcommand{\fvec}{\mathbf f}\) \(\newcommand{\nvec}{\mathbf n}\) \(\newcommand{\pvec}{\mathbf p}\) \(\newcommand{\qvec}{\mathbf q}\) \(\newcommand{\svec}{\mathbf s}\) \(\newcommand{\tvec}{\mathbf t}\) \(\newcommand{\uvec}{\mathbf u}\) \(\newcommand{\vvec}{\mathbf v}\) \(\newcommand{\wvec}{\mathbf w}\) \(\newcommand{\xvec}{\mathbf x}\) \(\newcommand{\yvec}{\mathbf y}\) \(\newcommand{\zvec}{\mathbf z}\) \(\newcommand{\rvec}{\mathbf r}\) \(\newcommand{\mvec}{\mathbf m}\) \(\newcommand{\zerovec}{\mathbf 0}\) \(\newcommand{\onevec}{\mathbf 1}\) \(\newcommand{\real}{\mathbb R}\) \(\newcommand{\twovec}[2]{\left[\begin{array}{r}#1 \\ #2 \end{array}\right]}\) \(\newcommand{\ctwovec}[2]{\left[\begin{array}{c}#1 \\ #2 \end{array}\right]}\) \(\newcommand{\threevec}[3]{\left[\begin{array}{r}#1 \\ #2 \\ #3 \end{array}\right]}\) \(\newcommand{\cthreevec}[3]{\left[\begin{array}{c}#1 \\ #2 \\ #3 \end{array}\right]}\) \(\newcommand{\fourvec}[4]{\left[\begin{array}{r}#1 \\ #2 \\ #3 \\ #4 \end{array}\right]}\) \(\newcommand{\cfourvec}[4]{\left[\begin{array}{c}#1 \\ #2 \\ #3 \\ #4 \end{array}\right]}\) \(\newcommand{\fivevec}[5]{\left[\begin{array}{r}#1 \\ #2 \\ #3 \\ #4 \\ #5 \\ \end{array}\right]}\) \(\newcommand{\cfivevec}[5]{\left[\begin{array}{c}#1 \\ #2 \\ #3 \\ #4 \\ #5 \\ \end{array}\right]}\) \(\newcommand{\mattwo}[4]{\left[\begin{array}{rr}#1 \amp #2 \\ #3 \amp #4 \\ \end{array}\right]}\) \(\newcommand{\laspan}[1]{\text{Span}\{#1\}}\) \(\newcommand{\bcal}{\cal B}\) \(\newcommand{\ccal}{\cal C}\) \(\newcommand{\scal}{\cal S}\) \(\newcommand{\wcal}{\cal W}\) \(\newcommand{\ecal}{\cal E}\) \(\newcommand{\coords}[2]{\left\{#1\right\}_{#2}}\) \(\newcommand{\gray}[1]{\color{gray}{#1}}\) \(\newcommand{\lgray}[1]{\color{lightgray}{#1}}\) \(\newcommand{\rank}{\operatorname{rank}}\) \(\newcommand{\row}{\text{Row}}\) \(\newcommand{\col}{\text{Col}}\) \(\renewcommand{\row}{\text{Row}}\) \(\newcommand{\nul}{\text{Nul}}\) \(\newcommand{\var}{\text{Var}}\) \(\newcommand{\corr}{\text{corr}}\) \(\newcommand{\len}[1]{\left|#1\right|}\) \(\newcommand{\bbar}{\overline{\bvec}}\) \(\newcommand{\bhat}{\widehat{\bvec}}\) \(\newcommand{\bperp}{\bvec^\perp}\) \(\newcommand{\xhat}{\widehat{\xvec}}\) \(\newcommand{\vhat}{\widehat{\vvec}}\) \(\newcommand{\uhat}{\widehat{\uvec}}\) \(\newcommand{\what}{\widehat{\wvec}}\) \(\newcommand{\Sighat}{\widehat{\Sigma}}\) \(\newcommand{\lt}{<}\) \(\newcommand{\gt}{>}\) \(\newcommand{\amp}{&}\) \(\definecolor{fillinmathshade}{gray}{0.9}\)Part I
Reproduce the results in Examples 1–12.
Part II—Work the assigned problems
[13] A bank balance earning a constant rate of compound interest has these values: $1550 after 5 years, $2002 after 10 years, $2585 after 15 years, $3339 after 20 years, and $4313 after 25 years. What was the original deposit amount (that is, the balance after 0 years), and what annual interest rate was applied?
[14] The activity of a radioactive substance is measured on the same day each year for several years, with these results: 5.7 Curies after 1 year, 3.8 Curies after 2 year, 2.6 Curies after 3 years, and 1.7 Curies after 4 years. What is the decay rate of the substance? What will the activity be after 10 years?
Problems 15–24 have the same instructions, applied to different datasets. Copy and paste the datasets from the course web site copy of this topic into the Models.xls spreadsheet, rather than retyping them.
For each of the datasets listed below
- Display the dataset and visually determine which of the models discussed in this topic is most suitable for this data.
- Identify which points, if any, are outliers for this dataset.
- Fit an appropriate model to the dataset, omitting the outliers (if any are present).
- Report the best-fit model parameters and their standard deviation for this data.
[15] Dataset A
| [16] Dataset B
| [17] Dataset C
| [18] Dataset D
| [19] Dataset E
| ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
[20] Dataset F
| [21] Dataset G
| [22] Dataset H
| [23] Dataset I
| [24] Dataset J
|
[25] Scientists have found that the total energy requirements of animals increase somewhat more slowly than body size. For example, a 1.2-pound mongoose requires 47 kilocalories per day, a 10-pound fox requires 240, a 22-pound bobcat requires 440, a 100-pound wolf requires 1350, a 300-pound lion requires 3100, a 400-pound tiger requires 3850, and a 700-pound polar bear requires 5900.
- What are the best-fit parameters to this data for a “power” model? [The general formula for a power model is y = a*x^b.]
- What is the standard deviation of the data from the best-fit model?
- Does this data support the idea that a power model is appropriate for predicting the energy requirements of animals?
- What daily energy requirement can be expected for a 45-pound lynx?
[26] The frequency of earthquakes varies by their size, with stronger ones being less frequent. In a recent one-year reporting period, the number of earthquakes detected at a particular facility was: 302,417 magnitude-2 quakes, 36,288 magnitude-3 quakes, 4,354 magnitude-4 quakes, 525 magnitude-5 quakes, and 60 magnitude-6 quakes.
- What are the best-fit parameters to this data for an exponential model, where the magnitude is the input parameter and the earthquake count is the output variable?
- What is the standard deviation of the data from the best-fit model?
- Does the data support the idea that this relationship is exponential?
- How many magnitude-7 earthquakes does this model predict this facility will detect each year?
[27] For Dataset C, find the inverse model (that is, the model when the x and y columns are swapped).
[28] For Dataset J, find the inverse model (that is, the model when the x and y columns are swapped).
[29] For Dataset G, use Solver to find the best-fit parameters if the spreadsheet is modified to minimize the relative standard deviation. Compare these parameters to those found in Exercise 21.
|
|
|
|
| Exercise 30-34 Instructions The formulas supplied below (in both algebraic form and as the spreadsheet formula for C3) will fit the corresponding dataset well as soon as the best settings are found for the parameters a and b. For each formula supplied, make a worksheet that uses it as a model. Then put the specified dataset into the worksheet and use the Solver tool to find the a and b values that fit the dataset best. For Dataset K, use formula =1/($G$3+$G$4*A3) [Start with G3=5 & G4=1]
For Dataset L, use formula =$G$3*A3^$G$4 [Start with G3=1 & G4=1]
For Dataset M, use formula =$G$3*SIN($G$4*A3) [Start with G3=1000 & G4=1]
For Dataset N, use formula =$G$3*($G$4^-(A3^2)) [Start with G3=100 & G4=2]
For Dataset O, use formula =$G$3/(1+$G$4^A3) [Start with G3=10 & G4=1]
[Optional: for each model, choose names for the a and b parameters that are suggestive of the effect that parameter has on the model.] |
- Mathematics for Modeling. Authored by: Mary Parker and Hunter Ellinger. License: CC BY: Attribution