Question

cations 8-2a without specific rounding instructions, round your answers to two decimal places, show both decimal places (2 up).
a\tb\tc\td\te\tf\tg\th
1\tsymbol\tstock\tfebruary 25 close\tchange\t% change\tfebruary 24 close\tvolume in 1000s\tvolume in 100s
2\taapl\tapple inc.\t96.76\t0.66\t\t96.1\t27,393\t
3\tbbw\tbuild-a-bear workshop inc.\t13.98\t0.03\t0.22%\t\t188\t
4\tctb\tcooper tire & rubber co.\t40.3\t1.04\t\t39.26\t727\t
5\tf\tford motor co\t12.39\t0.37\t\t\t31,951\t
6\tintc\tintel corp\t28.8\t\t−1.90%\t\t26,432\t
7\tmsft\tmicrosoft corp\t51.18\t\t−2.80%\t52.65\t26,695\t
8\tntgr\tnetgear inc.\t39.66\t0.59\t1.50%\t\t228\t
9\tyhoo\tyahoo! inc.\t31.36\t\t1.30%\t\t19,842\t
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.

b. cooper tire & rubber co.

Explanation:

Part a: Apple Inc.

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 Apple Inc., the new close (February 25) is in cell C2, and the old close (February 24) is in cell F2. We want to store the formula in cell E2.

Step2: Construct the Formula

Using the cell references, the formula for cell E2 (percent change for Apple Inc.) is $=\frac{(C2 - F2)}{F2} \times 100$ (in Excel formula terms, it would be =(C2-F2)/F2*100 to get the percentage value).

Step1: Identify Cell References

For Cooper Tire & Rubber Co. (row 4), the new close is in cell C4, and the old close is in cell F4. We store the formula in cell E4.

Step2: Apply Percent Change Formula

Using the percent change formula $\text{Percent Change} = \frac{\text{New Value} - \text{Old Value}}{\text{Old Value}} \times 100\%$, the formula for cell E4 is $=\frac{(C4 - F4)}{F4} \times 100$ (in Excel, =(C4-F4)/F4*100).

Answer:

E2: =(C2-F2)/F2*100

Part b: Cooper Tire & Rubber Co.