All categories

2 years ago

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

Kia is tiling a floor. The floor is a square with sides length 12 feet. Kia wants the tiles the tiles to be a squares with side

Volgvan

Answer:

36 tiles

Step-by-step explanation:

There will be 6 tiles in each direction, so the tiles covering the floor form a 6×6 array. The number needed is 6×6 = 36.

4 0

3 years ago

105 + 35m = expression . Apply the distributive property and the greatest common factor to write an equivalent

andrey2020 [161]

Answer:

Step-by-step explanation:

The distributive property:

105 = 35 × 3

35m = 35 × m

105 + 35m = 35 × 3 + 35 × m = 35 × (3 + m)

4 0

3 years ago

What number multiplied by 4/7 has a product of 1

Tanzania [10]

Answer:

7/4

Step-by-step explanation:

As multiplying 4/7 by 7/4 give 28/28 which is equivalent to 1.

8 0

2 years ago

Read 2 more answers

BD=16 and ÁT is the<br> perpendicular bisector of BD. Y=?

iren2701 [21]

Answer:

$y= 5$

Step-by-step explanation:

Given

$BD = 16$

$BC = 2y - 2$

$CD = y + 3$

Required

Find y

$BD = BC + CD$

So, the expression becomes

$16 = 2y - 2 + y + 3$

Collect like terms

$16 = 2y + y- 2 + 3$

$16 = 3y+1$

Collect like terms

$3y = 16 - 1$

$3y = 15$

Make y the subject

$y= 15/3$

$y= 5$

8 0

3 years ago

Hi, can you please help me answer this direct proportion question?

Oksanka [162]

Answer:

X = 100

Step-by-step explanation:

In proportion questions, they want you to multiply one of the sides by a variable, (i usually represent it with K) and then change the proportion sign to an equal.
This is because proportional means they have a ratio between them, with one side increasing by "k" for each increase in the other side.

Multiply the left by k, so $y = \frac{k}{\sqrt{x} }$
we know that y= 5, for x = 36, so sub this in the equation
$5 = \frac{k}{\sqrt{36} }$
simplify $5 = \frac{k}{6 }$
re-arrange for k, <u>k = 5*6 = 30</u>
now we know k, we can create the real equation, $y = \frac{30}{\sqrt{x} }$
sub in 3 as y
$3 = \frac{30}{\sqrt{x} }$
<u>x = 100</u>

4 0

2 years ago