Question

without specific rounding instructions, round your answers to two decimal places, show both decimal places (5.06)

1\ta\tb\tc\td\te\tf\tg\th
\tsymbol\tstock\tfabruary 25 close\tchange\t% change\tfebruary 24 close\tvolume in 1000s\tvolume in 100s
2\taapl\tapple inc.\t96.76\t0.06\t\t96.1\t27,303\t
3\tbbw\tbuild-a-bear workshop inc.\t13.08\t0.03\t0.22%\t\t100\t
4\tctb\tcooper tire & rubber co.\t40.3\t1.04\t\t39.20\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,095\t
8\tntgr\tnetgear inc.\t39.66\t0.59\t1.50%\t\t228\t
9\tyhoo\tyahoo! inc.\t31.36\t\t1.30%\t\t10,042\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. \tblank
b. cooper tire & rubber co. \tblank

Explanation:

Part a: Apple Inc. (Row 2)

Step1: Recall % Change Formula

The formula for percent change is $\text{\% Change} = \frac{\text{New Value} - \text{Old Value}}{\text{Old Value}} \times 100\%$. For Apple, the new close (Feb 25) is in cell C2, old close (Feb 24) is in cell F2. So the formula in cell E2 (where % Change is stored) should be:
$=\frac{(C2 - F2)}{F2} \times 100$ (in Excel formula terms: =(C2-F2)/F2*100)

Step2: Verify with Values

C2 = 96.76, F2 = 96.1. Plugging in: $\frac{96.76 - 96.1}{96.1}=\frac{0.66}{96.1}\approx 0.006868$, times 100 is $\approx 0.69\%$ (matches the change logic).

Part b: Cooper Tire & Rubber Co. (Row 4)

Step1: Apply % Change Formula

New close (Feb 25) is C4, old close (Feb 24) is F4. Formula in cell E4: $\frac{(C4 - F4)}{F4} \times 100$ (Excel: =(C4-F4)/F4*100)

Step2: Check with Values

C4 = 40.3, F4 = 39.26. $\frac{40.3 - 39.26}{39.26}=\frac{1.04}{39.26}\approx 0.02649$, times 100 is $\approx 2.65\%$ (consistent with change value 1.04).

Answer:

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