# Excel formula help

posted by Kimberly

Formula to multiply the number in cell 4k times standard deviation of the numbers in cell z2 through z10
I don't understand cell z2 through z10
(4kxz2xz10)

1. Writeacher

To indicate a range of cells to be included in a formula, you use a colon between the first and last. Example

To add all the numbers in cells c3 through c8, you'd write =sum(c3:c8)

Something similar is going on here, but I have no clue about how to calculate standard deviation for any reason!

Use + to indicate adding two cells.
Use - to indicate subtracting one cell from the other.
Use * to indicate multiplication.
Use / to indicate division.

READ AND STUDY at least the first three of the links in those search results I sent you before.

2. bobpursley

## Similar Questions

1. ### Data Analysis Help

Arithmetic operations, cell references, and __________ can be used in Excel formulas. constants macros programs procedures is it A 2Using the mouse to select a specific cell is when creating a formula is called: sizing. moving. accessing. …
2. ### Math

Consider the following spreadsheet: What formula would you use to calculate the number in cell B2?
3. ### words

12. You’ve created a pie chart in Excel and placed it in a PowerPoint presentation. When you edit the pie chart in Excel, the pie chart in PowerPoint doesn’t retain the changes you’ve made. This means that the object has been …
4. ### operating system

How would you write a formula to multiply the number in a cell z675 times the number in cell a 1
5. ### Excel computers

How would you write a formula to multiply the number in cell k4 times the standard deviation of the number in cell z2 through z10
6. ### Excel

How would you write a formula to divide the number in the cell v45 by the number in cell b78
7. ### Computers excel

How would you write a formula to divide the quantity of cell c1 plus c 8 by the number in a 98