By Stephen Nelson Microsoft Excel supplies two useful statistical functions for making beta probability calculations, BETADIST and BETAINV. Perhaps surprisingly, neither function is difficult to use as long as understand the inputs that supply data to the function. Understanding the beta probability density function, BETADIST The BETADIST function returns the cumulative beta probability density function. […]

## Monthly archives for May, 2009

## 11 Factors That Determine Your College Textbook Supplements Writing Income

By John Soares You can make good money writing instructor’s manuals, student study guides, test questions, Internet exercises, and many other types of supplements for college textbooks; I average $50 per hour or more. However, you have to know the right formula for getting those high-paying assignments from editors, and getting those same editors coming […]

## How to Calculate Demographic Information in Microsoft Excel

By Betty Hughes Microsoft Excel “custom functions” can do a variety of tasks related to address and zip code information, such as creating zip code lists, checking the validity of mailing addresses, even calculating driving time and driving distance. Custom functions, also referred to as User-Defined Functions or UDFs, perform complex tasks or calculations and […]

## There is More to Medical Writing Than Meets the Eye

By Cyndy Kryder Think you only need to understand science to become a medical writer? Think again. Despite the term medical in the phrase medical writing, when you work in this field you won’t be writing exclusively for medical professionals. Depending on your niche and expertise, in addition to doctors, nurses, and other health care […]

## How to Forecast Future Values with Microsoft Excel

By Stephen Nelson The FV function calculates the future value of a loan or investment given its interest rate, the term (or number of payments), the payment, the present value (or loan balance), and, optionally, the type-of-annuity switch. If you set the type-of-annuity switch to 1, Excel assumes payments occur at the beginning of the period, following the […]

## How to Calculate Gamma Probability Distributions with Microsoft Excel

By Stephen Nelson Want to work with gamma probability distributions? Microsoft Excel supplies some useful functions, as this short article illustrates. Want to work with gamma probability distributions? But a quick explanation is order if you’re not familiar with this powerful statistical concept and technique. Here’s the situation: If a Poisson process produces successes at […]

## Microsoft Training – An Important Step to Get Ahead on the Career Ladde...

By James Copper Microsoft training courses are essential for anyone who owns, or works, with a computer. Microsoft is the leader in software technology and most computers run on its programs. Every year the software is updated hence what you learnt a few years back needs to be updated. In work situations, someone with a […]

## Creative Writer’s Transition Sentences

Creative writers and journalists sometimes have a problem with transitioning smoothly from one paragraph to the other, especially when they are changing the subject. Learning transition sentences is not really that hard. When we hop from topic to topic w/o a transition sentence, we “jar” the reader. While sentence transitions may be the last line […]

## Breaking Into Freelance Medical Writing

By Cyndy Kryder When I speak at freelance medical writing seminars, I can always count on someone who is just getting started in the business to come up to me and ask, “Now what should I do?” I’m delighted to give up-and-coming freelance medical writers a little personal advice. And my first tip always is […]

## How to Calculate Hypergeometric Distributions with Microsoft Excel

By Stephen Nelson Excel provides a sometimes useful statistical function for making hyper geometric distribution calculations. (Note: People sometimes call the distribution “hypergeometric” [one word] rather than a “hyper geometric” [two words].) Background information on Hyper Geometric Distributions The hyper geometric probability distribution is much like the binomial probability distribution. The hyper geometric distribution describes […]

## How to Calculate Confidence Intervals with Microsoft Excel

By Stephen Nelson Confidence intervals often give you useful insights into data sets you’re trying to better understand. A confidence interval is the interval around a sample mean into which you expect the population mean to fall a certain percentage of the time. If you have a sample of size n and know the sample […]

## Productivity Tips for IE, MS Word, Outlook

By Pawan Bangar IF WE say that it was mainly because of the Windows operating system that a Computer could become a personal computer it would not be an exaggeration. The revolution is still on. Windows is far beyond what a common man presently knows and uses. Internet surfing For searching something, search engines are […]

## How to Calculate Binomial Probability Distributions with Microsoft Excel

By Stephen Nelson A binomial distribution describes the outcome of a multi-step experiment, consisting of n identical trials, where each trial ends in either a success or a failure and the probability of a success p does not change from trial to trial. This useful statistical analysis can be performed relatively easily using Microsoft Excel […]

## Top 5 Technical Writing Skills That Pay Big

By Mathieu Delaborde A technical writer is a professional writer who designs, writes, creates, maintains and updates technical documentation including online help, user guidance, white papers, design specifications, system manuals and other documents. A technical writer’s key undertaking is to come up/write technical documentation for technical, business and consumer audiences. Technical writing can be on […]

## How to Calculate Present Values with Microsoft Excel

By Stephen Nelson The PV function calculates the present value of an annuity, or future value, given the periodic rate, number of periods, payment, future value (or balloon payment), and, optionally, the type-of-annuity switch. Sometimes, why you would use this function seems strange. But it’s often useful when working with loans or with investments. For […]

## 24 Time-Saving Keyboard Shortcuts For Microsoft Word

By Carol Bentley Direct Response Business writing is different to ordinary business writing and many of the automatic features in Word are an absolute nightmare! In the first of this series of mini-articles I explained how to stop Word being ‘bossy’ and taking over your document. Now you can discover 24 of the keyboard shortcuts […]

## Technical Writing – The Difference Between a Process and a Procedure

By Bryan S. Adar In Shakespeare’s Henry IV, Part 1, Act III, Scene 1, in an argument about how to divide a piece of land, one character says that he’ll “cavil on the ninth part of a hair.” Cavil means to quibble over an unimportant point. Even better, it’s a really annoying and trivial objection. […]

## Microsoft Word Basics – Selecting Text Using The Keyboard

By Chris Le Roy One of the most efficient methods for selecting text is to use the keyboard. There are essentially two methods for selecting text – 1. Involves Using the Shift Key 2. Involves Using the F8 key and going into Extend Mode The second option will be discussed in the following topic. To […]