Akira created a model that shows the ground coverage of moss, G, m months after she planted the first patch of 1500 square centimeters.   She wants to calculate when the moss coverage will reach 2700 square centimeters. Below is what she calculated in Excel. Explain the error she made. Explain what she should have done. Do the calculation to find out when the moss coverage will reach 2700 square centimete

Calculus: Early Transcendentals
8th Edition
ISBN:9781285741550
Author:James Stewart
Publisher:James Stewart
Chapter1: Functions And Models
Section: Chapter Questions
Problem 1RCC: (a) What is a function? What are its domain and range? (b) What is the graph of a function? (c) How...
icon
Related questions
Question

Akira created a model that shows the ground coverage of moss, G, m months after she planted the first patch of 1500 square centimeters.

 

She wants to calculate when the moss coverage will reach 2700 square centimeters. Below is what she calculated in Excel.

  1. Explain the error she made.
  2. Explain what she should have done.
  3. Do the calculation to find out when the moss coverage will reach 2700 square centimeters.
The image shows a spreadsheet with the following details:

- Cell A1 contains the label "m".
- Cell B1 has the value "2700".
- Cell A2 contains the label "G".
- Cell B2 contains a formula: `=1500 * 1.023 ^ B1`.

Explanation of the formula in cell B2:
- `1500`: This is a base value or constant.
- `1.023`: This represents a growth factor or rate.
- `B1`: This refers to the value in cell B1, which is "2700".

The formula calculates the result of multiplying 1500 by 1.023 raised to the power of the value in cell B1 (2700). This type of calculation is commonly used in exponential growth or compound interest problems.
Transcribed Image Text:The image shows a spreadsheet with the following details: - Cell A1 contains the label "m". - Cell B1 has the value "2700". - Cell A2 contains the label "G". - Cell B2 contains a formula: `=1500 * 1.023 ^ B1`. Explanation of the formula in cell B2: - `1500`: This is a base value or constant. - `1.023`: This represents a growth factor or rate. - `B1`: This refers to the value in cell B1, which is "2700". The formula calculates the result of multiplying 1500 by 1.023 raised to the power of the value in cell B1 (2700). This type of calculation is commonly used in exponential growth or compound interest problems.
Expert Solution
Step 1

Calculus homework question answer, step 1, image 1

steps

Step by step

Solved in 2 steps with 2 images

Blurred answer
Similar questions
Recommended textbooks for you
Calculus: Early Transcendentals
Calculus: Early Transcendentals
Calculus
ISBN:
9781285741550
Author:
James Stewart
Publisher:
Cengage Learning
Thomas' Calculus (14th Edition)
Thomas' Calculus (14th Edition)
Calculus
ISBN:
9780134438986
Author:
Joel R. Hass, Christopher E. Heil, Maurice D. Weir
Publisher:
PEARSON
Calculus: Early Transcendentals (3rd Edition)
Calculus: Early Transcendentals (3rd Edition)
Calculus
ISBN:
9780134763644
Author:
William L. Briggs, Lyle Cochran, Bernard Gillett, Eric Schulz
Publisher:
PEARSON
Calculus: Early Transcendentals
Calculus: Early Transcendentals
Calculus
ISBN:
9781319050740
Author:
Jon Rogawski, Colin Adams, Robert Franzosa
Publisher:
W. H. Freeman
Precalculus
Precalculus
Calculus
ISBN:
9780135189405
Author:
Michael Sullivan
Publisher:
PEARSON
Calculus: Early Transcendental Functions
Calculus: Early Transcendental Functions
Calculus
ISBN:
9781337552516
Author:
Ron Larson, Bruce H. Edwards
Publisher:
Cengage Learning