Fisher Transformations and Frequency Distributions With Microsoft Excel

Search:

Fisher Transformations and Frequency Distributions With Microsoft Excel

Want to work with fisher transformations or frequency distributions? Microsoft Excel supplies some useful functions, including FISHER, FISHERINV and FREQUENCY.

Fisher Transformations using the FISHER and FISHERINV Functions

The Fisher’s z’ transformation converts Pearson’s r to the normally distributed variable z’.
You use the Fisher’s z’ to compute confidence intervals on Pearson’s correlation and on the difference between correlations.

The FISHER function computes from r to z’. The function has the following syntax:

=FISHER(r)

The FISHERINV function computes from z’ to r. The function has the following syntax:

=FISHERINV(z.)

Frequency Distributions using the FREQUENCY Function

The FREQUENCY function calculates how often values occur within a range of values, and then returns a vertical array of numbers. For example, use FREQUENCY to count the number of test scores that fall within ranges of scores. Because FREQUENCY returns an array, you must enter it as an array formula. The frequency formula uses the following syntax:

=FREQUENCY (data array, bins array)

where data array is an array of values for which you want to count frequencies and bins array is an array of bins (listed in ascending order and as upper limits) into which you want to group the values in the data array.

For example, if you wanted to create a frequency distribution using data array stored in B2:B21, a bins array stored in C2:C6 and you wanted to output your frequency distribution to the worksheet range D2:D6, you would select the range D2:D6, then enter:

=FREQUENCY (B2:B21,C2:C6)

and press Ctrl+Shift+Enter. When Excel constructs the frequency distribution, it counts the number of items with values less than or equal to the upper limit of the each bin.

Article Source: http://articlenexus.com

Seattle accountant and author Stephen L. Nelson wrote the MBA's Guide to Microsoft Excel, from which this short article is adapted. Nelson also writes and edits downloadable do-it-yourself business incorporation kits that entrepreneurs and investors can use for setting up a Incorporating in Pennsylvania or a Incorporating in Texas.

Please Rate this Article

Not yet Rated

Click the XML Icon Above to Receive Accounting Articles Via RSS!

Additional Articles From - Home | Accounting

Saving Money - By : Carson Danfield
In A Test Of The Best Outboard Motors - By : Salvador Motts
Linux web hosting: A comparative view of the web hosting server - By : Smit
Instant eBay Buyers Strategy - By : Scott Douglas
Easy business on On Ebay - By : Kapil00sir
Why Search Engine Optimization important for your website? - By : Hanene Mourey
Tips on How to Purchase Mayan Hammocks - By : mayan hammocks
Win Back Love without Fighting and Arguing - By : Anita Burnett
Overcoming Big Insurer Excuses for Not Paying Claims - By : Carson Danfield
Make the Most of Frequent-Flier Opportunities - By : Carson Danfield

STOP Paying for Your Ads! FREE Pay Per Click!

$8,132.26 Per Month on Craigslist

CraigsList Blackhat System

Everything you need for your website and home business.
	Adsense Site Builder
	Adsense Analyzer Software
	Clip Art
	Domain Names
	Header Graphics
	Make Money Online
	Photo Art
	Resell Products & Free Stuff
	SEO Software
	Web Hosting $4.95/mo
	Website Templates
	Web Site Promotion Tools
AdvancedWebsiteTools.com

	Print This Article
	Add To Favorites
	Email to Friends
	Ezine Ready

Submit Articles
Member Login
Top Authors
Most Popular Articles
Submission Guidelines
Ezine Notifications
Article RSS Feeds

(Your 160x160 ad here)
Only $50 a month-click here

Link Exchange
Blog by WordPress
Privacy Policy
Terms of Service
About Us
Contact Us
Banner Advertisements

Have you Victimized by a Business or the Government? File your consumer complaints or business complaints at BusinessReporter.net!

Structured Settlement?
Free information to help you learn more about structured settlements, your rights, and how to select the best company for you.

Affordable Discount Dental Plans
Choose from over 30 top-quality national and regional discount dental plans. Save 10% to 60% on most dental procedures

Remove Bad Credit
Legally Erase Bad Credit and Improve Your Credit Rating
with Self Help Credit Repair
Do It Yourself Credit Repair

Classic Autos
Replica Kit Cars

Staffing Resources
Online Recruiting

Links

Electronic Bargins

Hair Loss Remedies

Steiff Bears, Antique Bears

Model Railroading | Model Trains

McCain Sucks

Free Diabetic Supplies

Antique Radios | Ham Radios