Posted by **Kimberly** on Sunday, January 27, 2013 at 2:28pm.

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

I have never had excel

(4kxz2xz10)

Please write this correctly

- Excel formula help -
**Writeacher**, Sunday, January 27, 2013 at 2:40pm
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.

- Excel formula help -
**bobpursley**, Sunday, January 27, 2013 at 2:48pm
http://www.gifted.uconn.edu/siegle/research/normal/stdexcel.htm

## Answer this Question

## Related Questions

- Excel help - How would I write a formula to multiply the number in cell k4 times...
- Excel computers - How would you write a formula to multiply the number in cell ...
- Excel help please - How would I write a formula to multiply the number in cell ...
- Excel - How would you write a formula to divide the number in the cell v45 by ...
- Data Analysis Help - Arithmetic operations, cell references, and __________ can ...
- words - 12. You’ve created a pie chart in Excel and placed it in a PowerPoint ...
- operating system - How would you write a formula to multiply the number in a ...
- basic excel - Write one Microsoft excel formula that works for conditions below ...
- Computers excel - How would you write a formula to divide the quantity of cell ...
- Math - Consider the following spreadsheet: What formula would you use to ...