Posts Tagged ‘Reference’
Excel Quick Tip Tutorial on Calculating Standard Deviations
Posted by: Jordan in Narrow Focus on April 13th, 2009
Standard Deviation: The usual variation from a mean (~average) in a group of numbers. The average variation from the average.
If you’re thinking there should be a simple way to calculate the standard deviation of a column in excel you’re right there is! The formula is:
=STDEV(A1,A2)
or generically:
=STDEV(cell range)
Here are some examples of how STDEV() can be used:
How to Merge Text Into One Cell
Posted by: Jordan in Narrow Focus on March 30th, 2009
Combining two or more strings and values into one cell by gluing them together is know as concatenation. In Excel concatenation can be express in two ways:
=CONCATENATE(A1,A2)
OR
=A1&A2
Where the arguments can be upto 30 cells and / or custom strings enclosed by quotes.
Here are some examples of how it can be used:
How to Calculate Totals Using SUM() in Excel
Posted by: Jordan in Narrow Focus on March 29th, 2009
Totaling the values within a group of cells, columns, or rows is done using the SUM() function. It looks like this:
=SUM(A1,A2)
Here are some examples of how it can be used:
How to Find an Average in Excel
Posted by: Jordan in Narrow Focus on March 27th, 2009
Finding an average of a group of cells in Excel is done using the AVERAGE() function. It looks like this:
=AVERAGE(A1,A2)
Here are some examples of how it can be used:
Cheat Sheets for PHP
Posted by: Jordan in Time Saving References on January 30th, 2009
When editing on the web it’s always nice to have a few good references on hand. Every new project has a unique blend of markup and scripting, remembering all that syntax isn’t always easy. Add some of these references to your documents folder to refresh your memory whenever you need it.