Which Standard Deviation & Variance to use in Excel (and SQL!).
A look at STDEV, STDEVP, VAR and VARP- Amy M., from Developing SQL Queries for SQL Server, writes… “I know there are two functions for standard deviation and for variance in Transact-SQL, but I can never remember when to use which.” You are so right, Amy. It is hard to know when to use STDEV […]
How to Make a Histogram in Excel Using the Frequency Function
The Importance of Histograms and Descriptive Statistics The word “statistics” comes from the German word “stadt”. Stadt means “city” but in the 18th century each city was a state in its own right. And the people who ran those states needed to have the facts. What is the population? What is the food production? How […]
Microsoft Releases Office365
Microsoft has announced the worldwide availability of Office365, released as their next generation of productivity applications. The product makes the popular productivity tools such as Word, Excel and Powerpoint available as a cloud service, where the software will always be up to date. By accessing these applications as a cloud service, a business can benefit […]
Microsoft Office Web Apps – Changing the Way We Work
With the imminent launch of Microsoft Office 2010, one of the most eagerly awaited features is Office Web Apps. Office Web Apps enables accessing the Microsoft productivity tools such as Word, Excel, PowerPoint via a browser with the documents stored in a Windows Live account or maybe an organizations corporate SharePoint server. On the surface, […]