Question

lications 8-2a without specific rounding instructions, round your answers to two decimal places, show four decimal places (3-09). 13. 14. chart with columns a (symbol), b (stock), c (february 25 close), d (change), e (% change), f (february 24 close), g (volume in 1000s), h (volume in 100s); rows 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 that will store the exact volume for each stock in column i. use the left side of the equation to indicate in which cell to store the formula. a. build-a-bear workshop inc. text box × b. netgear inc. text box ×

Explanation:

Part a: Build - A - Bear Workshop Inc.

Step 1: Identify the volume column and unit

The volume for Build - A - Bear Workshop Inc. is in column G with the unit "Volume in 1000s" for some stocks and "Volume in 100s" for others? Wait, no, looking at the table, for Build - A - Bear Workshop Inc. (row 3), the volume is in column G with the label "Volume in 1000s"? Wait, no, row 3, column G is 188. Wait, the problem says "Volume in 1000s" and "Volume in 100s"? Wait, no, the table has column G: "Volume in 1000s" and column H: "Volume in 100s"? Wait, no, looking at the table:

Row 2: G is 27,393 (Volume in 1000s), so actual volume is 27,393 * 1000.

Row 3: G is 188 (Volume in 1000s? Wait, no, maybe the labels are: column G is "Volume in 1000s" (so multiply by 1000) and column H is "Volume in 100s" (multiply by 100). Wait, for Build - A - Bear Workshop Inc. (row 3), column G is 188. So if column G is "Volume in 1000s", then the actual volume is \(188\times1000\). But wait, maybe the labels are different. Wait, the problem says "Write a formula that will store the exact volume for each stock in column I. Use the left side of the equation to indicate in which cell to store the formula."

For row 3 (Build - A - Bear Workshop Inc.), the cell in column I (let's say I3) should have the formula. The volume is in column G, row 3 (G3) with the unit "Volume in 1000s"? Wait, no, looking at row 2: G2 is 27,393 (Volume in 1000s), so actual volume is 27,393 * 1000. Row 3: G3 is 188 (Volume in 1000s? Or maybe "Volume in 100s"? Wait, no, the label for column G is "Volume in 1000s" and column H is "Volume in 100s"? Wait, the table headers:

Column G: "Volume in 1000s"

Column H: "Volume in 100s"

Wait, row 2: G2 = 27,393 (Volume in 1000s) → actual volume = 27,393 * 1000

Row 3: G3 = 188 (Volume in 1000s? Or maybe "Volume in 100s"? Wait, no, the label for column G is "Volume in 1000s", so for row 3, G3 is 188 (Volume in 1000s) → actual volume = 188 * 1000? But that seems too big. Wait, maybe column G is "Volume in 100s" for some? No, the header is "Volume in 1000s" for G and "Volume in 100s" for H? Wait, no, the table as given:

Row 1:

G: Volume in 1000s

H: Volume in 100s

So for row 2 (AAPL), G2 = 27,393 (Volume in 1000s) → actual volume = 27,393 * 1000

Row 3 (BBW), G3 = 188 (Volume in 1000s) → actual volume = 188 * 1000? But that would be 188,000. Wait, maybe the label for G is "Volume in 100s" for BBW? No, the header is the same. Wait, maybe I misread. Let's check the problem again.

The problem says: "Write a formula that will store the exact volume for each stock in column I. Use the left side of the equation to indicate in which cell to store the formula."

For Build - A - Bear Workshop Inc. (row 3), the volume is in column G (G3) with the unit "Volume in 1000s"? Wait, no, G3 is 188, and if it's "Volume in 100s", then 188 100 = 18,800. Wait, maybe the labels are mixed. Wait, row 2: G2 = 27,393 (Volume in 1000s) → 27,393 1000 = 27,393,000

Row 3: G3 = 188 (maybe "Volume in 100s") → 188 * 100 = 18,800

Row 4: G4 = 727 (Volume in 1000s) → 727 * 1000 = 727,000

Row 5: G5 = 31,951 (Volume in 1000s) → 31,951 * 1000 = 31,951,000

Row 6: G6 = 26,432 (Volume in 1000s) → 26,432 * 1000 = 26,432,000

Row 7: G7 = 26,695 (Volume in 1000s) → 26,695 * 1000 = 26,695,000

Row 8: G8 = 228 (maybe "Volume in 100s") → 228 * 100 = 22,800

Row 9: G9 = 19,842 (Volume in 1000s) → 19,842 * 1000 = 19,842,000

Ah, so for stocks where the volume in G is a small number (like 188, 228), it's "Volume in 100s", and for larger numbers (like 27,393, 31,951), it's "Volume in 1000s"? No, the header is "Volume in 1000s" f…

Step 1: Identify the volume column and unit

For Netgear Inc. (row 8), the volume is in column G (G8) with the label "Volume in 1000s"? Wait, G8 is 228. If we follow the same logic as row 2, where G2 (27,393) is multiplied by 1000, then for row 8, G8 = 228, so the formula for I8 (column I, row 8) is \(I8 = G8\times1000\). But wait, 228 1000 = 228,000, which is reasonable. Alternatively, if it's "Volume in 100s", 228 100 = 22,800. But since the header for G is "Volume in 1000s", we use that.

Step 2: Write the formula

The cell to store the formula is I8, and the formula is \(I8 = G8\times1000\)

Answer:

s:
a. \(I3 = G3\times1000\)

b. \(I8 = G8\times1000\)