Question

cations 8-2a
without specific rounding instructions, round your answers to two decimal places, show both decimal places (2.00).

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

Explanation:

Part a: Apple Inc.

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

Step2: Construct the formula

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

Part b: Cooper Tire & Rubber Co.

Step1: Identify values

For Cooper Tire & Rubber Co., new close is in C4, old close in F4, and we store the formula in E4.

Step2: Apply % Change formula

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

Answer:

s:
a. $E2 = \frac{C2 - F2}{F2} \times 100\%$ (or spreadsheet formula =((C2-F2)/F2)*100)
b. $E4 = \frac{C4 - F4}{F4} \times 100\%$ (or spreadsheet formula =((C4-F4)/F4)*100)