Michael Hooker Microscopy Facility (MHMF.ORG)

MS - Excel Tasks

Calculating Frequency Distribution Histograms

• Data is a list of values. e.g. random numbers between 1 to 10
• Decide on bins (sizes and number). e.g. 0 to 1, 1 to 2, ...... 9 to 10
• Tools ---> Data Analysis - if not present Tools --> Add Ins --> Data Analysis (select)
• Histogram (select)
• Input Range e.g. A2..E22
• Bin Range e.g. G2..G12
• Output Range e.g. I1
• Frequency Distribution Table is generated
• Use standard graph functions

		Copyright 2001-08  Dr. M. Chua, Office of Research, University of North Carolina, Chapel Hill, NC 27599
Go Back	Booking Resources	Questions/Comments: Michael Chua