While working on a homework assignment, I am attempting to create a Frequency Distribution. From the course text and research I am able to create a frequency band with a single number (ie. 10, 20, 30, etc.). However, I am having difficulty creating the band with a number range (ie. $0-$999,999 or $1,000,000-$5,000,000).
Is there a specific formula to create the range that I am missing? Can I have an example please with specific instructions and formula used in excel?