QUESTION IMAGE
Question
plications 8-2a
13.
14.
note: please make sure to properly format your answers. all dollar figures in the answers need to include the dollar sign and any amount over 1,000 should include the comma ($2,354.67). all percentage values in the answers need to include a percentage sign (%). for all items without specific rounding instructions, round your answers to two decimal places, show both decimal places (5.06).
| a | b | c | d | e | f | g | h | |
|---|---|---|---|---|---|---|---|---|
| 2 | aapl | apple inc. | 96.76 | 0.66 | 96.1 | 27,393 | ||
| 3 | bbw | build-a-bear workshop inc. | 13.98 | 0.03 | 0.22% | 188 | ||
| 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.66 | 0.59 | 1.50% | 228 | ||
| 9 | yhoo | yahoo! inc. | 31.36 | 1.30% | 19,842 |
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. text box ×
b. cooper tire & rubber co. text box ×
Part a: Apple Inc. (Row 2)
Step1: Recall % Change Formula
The formula for percentage change is $\text{\% Change} = \frac{\text{New Value} - \text{Old Value}}{\text{Old Value}} \times 100\%$. For Apple, the new close (February 25) is in cell C2, old close (February 24) is in cell F2. So the formula in cell E2 (where % Change is stored) should be based on this.
Step2: Construct the Formula
To calculate the percentage change for Apple (row 2), the formula is $=\frac{(C2 - F2)}{F2} \times 100\%$. In spreadsheet terms (like Excel), this is =(C2 - F2)/F2 (the formatting to percentage will handle the % sign, but the calculation is $\frac{\text{New} - \text{Old}}{\text{Old}}$).
Part b: Cooper Tire & Rubber Co. (Row 4)
Step1: Identify Cells
For Cooper Tire (row 4), new close is C4, old close is F4. Use the same % change formula: $\text{\% Change} = \frac{\text{New} - \text{Old}}{\text{Old}} \times 100\%$.
Step2: Write the Formula
In cell E4 (where % Change is stored), the formula is $=\frac{(C4 - F4)}{F4} \times 100\%$. In spreadsheet syntax, this is =(C4 - F4)/F4.
Final Answers (Spreadsheet Formulas):
a. For Apple Inc. (cell E2): =(C2 - F2)/F2
b. For Cooper Tire & Rubber Co. (cell E4): =(C4 - F4)/F4
(Note: These formulas, when entered in Excel/Google Sheets and formatted as percentage, will give the correct % change. For example, for Apple: $(96.76 - 96.1)/96.1 \approx 0.006868 \approx 0.69\%$ when rounded to two decimals, which matches the concept of percentage change.)
Snap & solve any problem in the app
Get step-by-step solutions on Sovi AI
Photo-based solutions with guided steps
Explore more problems and detailed explanations
Step1: Identify Cells
For Cooper Tire (row 4), new close is C4, old close is F4. Use the same % change formula: $\text{\% Change} = \frac{\text{New} - \text{Old}}{\text{Old}} \times 100\%$.
Step2: Write the Formula
In cell E4 (where % Change is stored), the formula is $=\frac{(C4 - F4)}{F4} \times 100\%$. In spreadsheet syntax, this is =(C4 - F4)/F4.
Final Answers (Spreadsheet Formulas):
a. For Apple Inc. (cell E2): =(C2 - F2)/F2
b. For Cooper Tire & Rubber Co. (cell E4): =(C4 - F4)/F4
(Note: These formulas, when entered in Excel/Google Sheets and formatted as percentage, will give the correct % change. For example, for Apple: $(96.76 - 96.1)/96.1 \approx 0.006868 \approx 0.69\%$ when rounded to two decimals, which matches the concept of percentage change.)