All categories

3 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]3 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

Express the ratio below in its simplest form.1:1.5<br>

Soloha48 [4]

Answer:

that is the simplest form

Step-by-step explanation:

6 0

3 years ago

Read 2 more answers

Spencer wants to burn 450 calories while biking. Biking burns about 10 calories per minute. When Spencer goes biking, he usually

kupik [55]

Answer:

The equation to find the total number of minutes (including rest) that Spencer should plan to be out biking is $10(m-15)=450$ .

Spencer should plan for 60 minutes to be out biking.

Step-by-step explanation:

Given:

Total calories need to burn = 450 calories

Calories burn per minute = 10

number of minutes he rest = 15

We need to find the total number of minutes (including rest) that Spencer should plan to be out biking.

Solution:

Let Total minutes of biking be 'm'.

So we can say that.

Calories burn per minute multiplied by the difference of total minutes and number of minutes he rest is equal to Total calories need to burn.

framing in equation form we get;

$10(m-15)=450$

Hence the equation to find the total number of minutes (including rest) that Spencer should plan to be out biking is $10(m-15)=450$ .

On Solving the above equation we get;

First we will divide both side by 10 we get;

$\frac{10(m-15)}{10}=\frac{450}{10}\\\\m-15=45$

Now adding both side by 15 we get;

$m-15+15=45+15\\\\m=60\ minutes$

Hence Spencer should plan for 60 minutes to be out biking.

4 0

3 years ago

28/29 and 30 plz short explanation thanks

zzz [600]

Integers are numbers like ...-3, -2, -1, 0, 1, 2, 3... and so on. So, according to this definition, let's solve this problem:

28. We know that the product of three integers is -3. So, the statement states that we have three factor, so:

a.b.c = -3

The possible values of the factors are:

Factors are: 3, 1 and -1 in which case:

(3)(1)(-1) = -3

Factors are: -3, 1 and 1 in which case:

(-3)(1)(1) = -3

29. In this problem we know two nonzero integers, that is, they cannot be equal to zero. Thus, they must have different sign, that is, one of them must be positive and the other negative. For instance:

-9 and 2

(-9)(2) = -18, So -18 is less than -9 and 2

Another example:

1 and -8

(1)(-8) = -8, So -8 is equal to -8 and -8 is less than 1.

30. The sign of the product of two integers with the same sign is positive, that is:

(+)(+) = (+) and

(-)(-) = (+)

So, the sign of the product of three integers with the same sign are two options:

<u>Option 1.</u> The three integers are positive in which case:

(+)(+)(+) = (+), So the sign of the product is positive

<u>Option 2.</u> The three integers are negative in which case:

(-)(-)(-) = (-), So the sign of the product is negative.

This option two gives us that result because:

(-)(-) = (+) and (+)(-) = (-)

5 0

3 years ago

PLZZ HELP find the area of the triangle QRS?

defon

Answer:

180 is the answer

Step-by-step explanation:

Step-by-step explanation:

To find out areas of rectangles, you have to count the left side of the rectangle which is (12) and then count the bottom of the rectangle which is (15)

Then multiply 12 times 15 to find out the area

15 x 12= 180

what do you mean CDEF

and can I get brainliest?

3 0

3 years ago

5 2/3 x 3/4 soooooo fraction question in grade 5 sooo five and two thirds times three fourths so yeah pls get this answered quic

guajiro [1.7K]

Answer: EDIT: the answer is 4 3/12

Step-by-step explanation:

Hope this helps ya, sweetie!

If you ever need help ask people here on Brainly or contact me by my mail at

tutorbydemand05 at g****.com

Have a marvelous day!! {:0)

5 0

2 years ago

Read 2 more answers