1answer.
Ask question
Login Signup
Ask question
All categories
  • English
  • Mathematics
  • Social Studies
  • Business
  • History
  • Health
  • Geography
  • Biology
  • Physics
  • Chemistry
  • Computers and Technology
  • Arts
  • World Languages
  • Spanish
  • French
  • German
  • Advanced Placement (AP)
  • SAT
  • Medicine
  • Law
  • Engineering
Sloan [31]
2 years ago
12

Excel - Using the charts below how would I create an equation to calculate the cost for the other years using the annual API

Mathematics
1 answer:
Len [333]2 years ago
3 0
<h3>Explanation:</h3>

If we assume that the given cost of iPhone 6s (gray cell) is cell O114, then the cells around it get filled with formulas that calculate what the column header tells you.

Cell P114 is the ratio of this year's CPI to last year's, so will have the formula ...

  =N114/N113

Cell Q114 is the annual inflation rate. You can express this different ways, but the usual way is as a percentage. A percentage change is calculated as ...

  ((new value) -(old value))/(old value) × 100%

This can be rearranged to ...

  ((new value)/(old value) -1) × 100%

Of course, the ratio (new value)/(old value) is the one in column P, so the formula for cell Q114 is simply ...

  =P114-1

with the cell formatting is set to <em>show the value as a percent</em>.

___

The cell phone costs that go in column O can make use of the ratio calculated in column P, or they can be formulated using the CPI directly. Either way, the previous year's cell phone cost is the current year's cost divided by the ratio in column P. That is, cell O113 could be either of ...

  =O114/P114

  =O114/N114*N113

_____

Of course, once you put these formulas in the cells at the bottom of the table, you must fill them upward so they calculate values for previous years. The attachment shows a recreation of a small part of your table, with the formula bar showing the formula in the highlighted cell.

You might be interested in
Agora chess club has 16 members and gains a new memeber every month. The key club has 4 members and gains 4 new members every mo
salantis [7]

Answer:

4 months and you can check for yourself by plugin in 4 in both equations (e.g. 1(4)+16=4(4)+4

Step-by-step explanation:

To do this: Agora = 1x+16

Key Club = 4x+4

1x+16=4x+4

1x+12=4x

12=3x

4=x

4 0
3 years ago
Which three criteria do binomial experiments meet?
Snowcat [4.5K]

Answer:

Each of the n tests must have two success p or failure q results, they are mutually exclusive. The probability of success p of an event is fixed or constant, likewise for the probability of failure q. The tests are independent.

Step-by-step explanation:

3 0
2 years ago
What does theme add to a story? *
Ksju [112]
D, a theme is usually a message or life lesson to the characters or reader :)
5 0
3 years ago
How do you factor this math problem?<br> n²+24n+144
Aloiza [94]

The expression n^2+24n+144 expands to (n+12)(n+12)=(n+12)^2.

Hope this helps.

8 0
3 years ago
Read 2 more answers
There are 2 squares and 10 circles what is the simplest ratio
diamong [38]

Answer:

1:5

Step-by-step explanation:

4 0
3 years ago
Other questions:
  • Help yoooooooo!!! I’m failimg
    7·1 answer
  • People start to leave the stadium at the end of a football game. The number of people, PPP, that are left in the stadium mmm min
    7·1 answer
  • Hannah can clear the lot in 5.5 hours. damion can do the same job in 7.5 hours
    15·1 answer
  • Write to decimals whose quotient is close to 2.3
    13·1 answer
  • Writing a Polynomial Expression to Represent Perimeter A family needs to build fencing around their rectangular home and square
    16·2 answers
  • Need help 10 POINTS !!!
    15·2 answers
  • In which situation would you most likely factor out -1 from a trinomial?
    14·2 answers
  • Find the domain and range of the following graph<br> Domain:<br> Range:
    13·1 answer
  • Stel and Atana are deciding where to go next on Edena. Stel has made a map of the planet in which the planet's surface is divide
    11·1 answer
  • -8x - (3x + 6 ) = 4 - x
    5·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!