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
Let 2? + 112 = 3<br>What values make an equivalent number sentence after completing the square?​
Alexandra [31]

Answer:

Step-by-step explanation:

Here, x² + 13x = -3

Here, as x² + 13x would remain same, you have to add or subtract equivalent number from both sides,  

x² + 13x + 3 = 0

7 0
3 years ago
3m² – 6m² - 7m +14<br>​
Reptile [31]
-3m^2 - 7m + 14. Hope it helps!
7 0
3 years ago
5. Two angles are supplements if their sum is 180 degrees. The measurement of one angle is five more than six times its suppleme
ankoles [38]
25 degrees would be the smaller angle
5 0
3 years ago
Find the domain, range and if it’s a function.
Marta_Voda [28]
Domain: {-1}
Range: {0, 4, 9, 15}
Function? No

Explanation:
The domain is the x value in the given points. The only x value is -1.
The range is the y value in the given points.
You can tell if this is a function if it has repeating x values or not. Since the x value of -1 repeats, it is not a function.

Hope this helps, and please mark brainliest :)
6 0
2 years ago
Here are two column vectors
Contact [7]

Answer:

a = (  \frac{ - 6}{2} )

Step-by-step explanation:

-2g=?

- 2( \frac{3 }{ - 1} ) \\  \\  ( \frac{ - 6}{2} )

8 0
2 years ago
Other questions:
  • An empty box weighs 200g The box is filled with birthday party goody bags and it now weighs 6.2kg Each goody bag weighs 150g Wor
    9·1 answer
  • at a country concerts the ratio of the number of boys to the number of girls 2 to 7.if there are 250 more girls than boys how ma
    11·1 answer
  • Enter an expression that represents the fallowing statement and then solve the expression. 2 less than the product of 6 and -10.
    8·1 answer
  • Determine if the graph is symmetric about the x-axis, the y-axis, or the origin.
    13·2 answers
  • Show that (3√2-1)² + (3+√2)² is an integer and find its value​
    5·1 answer
  • Need help in these two only PLEASEE!! School is starting tomorrow
    15·1 answer
  • Which statement is correct regarding the measurements of the parallelogram?
    9·1 answer
  • A and B take M days to complete a task together if A takes 27 days more than A and B to complete the task alone. And if B takes
    9·1 answer
  • I dont think I can write this out via phone; any help?
    12·2 answers
  • What is the value X?<br><br> If 4x + 9y = 13, AND 3x + 3 = 4
    15·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!