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
it took Peter 3 hours to drive to his friend in Connecticut when he was driving with the average speed 54 mph.Find the constant
Vsevolod [243]

Answer:


Since k is constant (the same for every point), we can find k when given any point by dividing the y-coordinate by the x-coordinate.

so i assume it could be 162 sorry if i am wrong let me know if it is right or not

8 0
3 years ago
Write an expression for cos 68° using sine
Anettt [7]

Answer:

sin22°

Step-by-step explanation:

Using the cofunction identity

cos x = sin (90 - x), then

cos68° = sin(90 - 68)° = sin22°

8 0
3 years ago
Will Give Brainliest, Answer ASAP m∠O = <br> m∠N =
irina1246 [14]

Answer:

∠ O = 61°, ∠ N = 119°

Step-by-step explanation:

In a parallelogram

Consecutive angles are supplementary

Opposite angles are congruent, thus

x + 2x - 3 = 180

3x - 3 = 180 ( add 3 to both sides )

3x = 183 ( divide both sides by 3 )

x = 61°

Thus

∠ O = ∠ M = x = 61°

∠ N = ∠ P = 2x - 3 = 2(61) - 3 = 122 - 3 = 119°

6 0
3 years ago
A triangle has sides of (2x), (x - 7) and (3x - 20).
LiRa [457]
2x+x-7+3x-20=87cm
6x-27=87
6x=114
x=19
Therefore the sides are:12cm, 38cm, and 37cm
7 0
3 years ago
#17-1: Simplify this complex fraction. 1/3 / 6/9
Gnesinka [82]

\huge{\boxed{\frac{1}{2}}}

To divide by a fraction, you multiply by its reciprocal, which you find by flipping the numerator and the denominator. \frac{1}{3} \div \frac{6}{9} = \frac{1}{3} * \frac{9}{6}

Multiply the numerators and the denominators separately. \frac{1}{3} * \frac{9}{6} = \frac{1*9}{3*6} = \frac{9}{18}

Simplify by dividing both sides of the equation by 9. \frac{9 \div 9}{18 \div 9} = \boxed{\frac{1}{2}}

3 0
3 years ago
Read 2 more answers
Other questions:
  • How do you interpret algebraic expressions in terms of their context
    8·2 answers
  • Lucy is financing $370,000 to purchase a house. How much money will she save over the life of a 30-year, fixed-rate loan by buyi
    12·1 answer
  • Which pair represents equivalent ratios? A Begin fraction . . . 2 over 3 . . . end fraction . . . and . . . begin fraction . . .
    12·2 answers
  • Applying Triangle Classification Theorems
    12·2 answers
  • Given lines l, m and n are all parallel and cut by two transversal lines, find the value
    12·1 answer
  • What is the slope of a line parallel to the line whose equation is 18x - 3y = -45 fully reduce your answer
    6·1 answer
  • A $150 bike was on sale for 30% off the original price. How much money does a person save if she buys it on sale?
    7·2 answers
  • Tiffany bought a shirt worth c dollars and got a discount of 8% on the original price. Which expression shows the total amount s
    11·1 answer
  • Can you please help me with this question ❣​
    5·1 answer
  • A vial holds 2 milliliters of pixie dust.
    15·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!