answersLogoWhite

0


Best Answer

Bin ranges normally represent a set of values to be used in a function, like for creating Histograms. Bin numbers represent the intervals that you want the Histogram tool to use for measuring the input data in data analysis. When you use the Histogram tool, Excel counts the number of data points in each data bin. A data point is included in a particular bin if the number is greater than the lowest bound and equal to or less than the greatest bound for the data bin. If you omit the bin range, Excel creates a set of evenly distributed bins between the minimum and maximum values of the input data. Bin ranges can be found in other things too, and you will sometimes see functions asking for them.

User Avatar

Wiki User

βˆ™ 14y ago
This answer is:
User Avatar
More answers
User Avatar

Wiki User

βˆ™ 12y ago

You would set it up initially as an ordinary set of data. It is when it is used in some functions that the data is referred to as a bin range. So it is really only in the context of using a function that it becomes known as a bin range. How specifically you use it will depend on the function.

This answer is:
User Avatar

Add your answer:

Earn +20 pts
Q: How do you create a bin range in Microsoft Excel?
Write your answer...
Submit
Still have questions?
magnify glass
imp
Related questions

Did Bin Laden create the Afghanistan war?

No; he did not "create" a war.


How do you create a wedding ceremony on bin weevils?

you can't create one.


How do you get the big antenna on bin weevils?

you can get a big antenna on bin weevils when you create your weevil.


How do you create my very own Bin Weevils?

You go onto the bin weevils website of course!


Microsoft Windows recycle bin same Ubuntus trash bin?

Not exactly, ones called 'Recycle Bin" and the other "Trash". Apart from Linux not moving some files to the trash bin (settings mainly) they work pretty much the same.


How do you create a histogram in Excel?

= = First of all, you need to open an Excel spreadsheet. Then go to 'TOOLS' in the menu bar and select 'ADD INS.' Choose 'ANALYSIS TOOL PACK' and click okay. Now we're on to making the histogram~ On your excel spreadsheet (the one that contains the data) you're going to have to to create. a column for the number of bins needed. This 'bin' of which I spoke of is the grouping of data based on the range of data you have. Find the range of data by doing this~ First, go to 'DATA' in the menu bar and select 'SORT.' Then choose the column you would like to sort and choose ascending or descending order. Then choose a different column on your spreadsheet and simply add the bins Navigate to "TOOLS, DATA ANALYSIS" and then select Histogram. Click on the small box to the right for input range. Highlight the column on your spreadsheet containing the data that you choose to be binned. This will turn into your frequency value. After that, highlight the bins column for the bin range. Go to 'OUTPUT OPTIONS' and choose 'NEW WORKSHEET PLY:' and then choose a name for the worksheet. It will be set up with a brand new, titled spreadsheet with 2 columns (bin and frequency). Then you highlight the frequency column of data and go to 'CHART WIZARD' pick column graph. Click on 'SERIES TAB CATEGORY (X) LABELS' to make sure that your x axis is labeled 'BIN.' Then you just complete it like normal. Help from~ http://www.pas.rochester.edu/~pavone/particle-www/teachers/analysis/HISTOGRAMS.htm


What is the three most common icon of the computer?

recycle bin internet explorer Microsoft word


What are bin and cue files?

Bin/Cue files are "image" files that a CD Burning software uses to create a CD


How do you create an alias my CD to CD usr local bin command?

alias mycd="cd /usr/local/bin"


How do you create a magazine on Bin Weevils?

You need to be a bin tycoon then go to flem manor and go inside the room that has a top hat on a green background above it.


I accidentally deleted a file from my computer, is there any sort of recycle bin recovery software available online?

Windows has a built in Recycle Bin in all versions of Windows. This is available to help to recover files accidnetly deleted. You can retrieve a file in the recycle bin in Microsoft. It remains until the files are emptied from the Recycle bin. If the deleted files have been


How do you create a new code in bin weevils?

i dont know i want to know that tooo soz