Question

unless specific rounding instructions, round your answers to two decimal places, show both decimal places (3.00)

a | b | c | d | e | f | g | h
1 | symbol | stock | february 25 close | change | % change | february 24 close | volume in 1000s | volume in 100s
2 | aapl | apple inc. | 90.70 | 0.60 | | 90.1 | 27,303 |
3 | bbw | build-a-bear workshop inc. | 13.98 | 0.03 | 0.22% | | 108 |
4 | ctb | cooper tire & rubber co. | 40.3 | 1.04 | | 39.26 | 727 |
5 | f | ford motor co | 12.39 | 0.37 | | | 31,951 |
6 | intc | intel corp | 28.8 | | -1.90% | | 26,432 |
7 | msft | microsoft corp | 51.18 | | -2.80% | 52.65 | 26,695 |
8 | ntgr | netgear inc. | 39.60 | 0.59 | 1.50% | | 228 |
9 | yhoo | yahoo! inc. | 31.36 | | 1.30% | | 19,042 |

write a formula to determine the percent change for each of the following. use the left side of the equation to indicate in which cell to store the formula.
a. apple inc. blank box
b. cooper tire & rubber co. blank box

Explanation:

Step1: Recall Percent Change Formula

The formula for percent change is $\text{Percent Change} = \frac{\text{New Value} - \text{Old Value}}{\text{Old Value}} \times 100\%$. For stock data, the "New Value" is the February 25 Close (column C), and the "Old Value" is the February 24 Close (column F).

Step2: Formula for Apple Inc. (Row 2)

For Apple Inc., the cell for % Change is E2. The new value is C2 (90.76), old value is F2 (90.1). So the formula in E2 is $=\frac{(C2 - F2)}{F2} \times 100$ (in Excel formula terms, it's =(C2-F2)/F2*100).

Step3: Formula for Cooper Tire & Rubber Co. (Row 4)

For Cooper Tire & Rubber Co., the cell for % Change is E4. New value is C4 (40.3), old value is F4 (39.26). So the formula in E4 is $=\frac{(C4 - F4)}{F4} \times 100$ (in Excel formula terms, it's =(C4-F4)/F4*100).

Answer:

a. For Apple Inc. (cell E2): =(C2-F2)/F2*100
b. For Cooper Tire & Rubber Co. (cell E4): =(C4-F4)/F4*100