#### • Class 11 Physics Demo

Explore Related Concepts

# how to find range of grouped data

From Wikipedia

Home range

Home range is the area where an animal lives and travels in. It is closely related to, but not identical with, the concept of "territory".

The concept that can be traced back to a publication in 1943 by W. H. Burt, who constructed maps delineating the spatial extent or outside boundary of an animal's movement during the course of its everyday activities. Associated with the concept of a home range is the concept of a utilization distribution, which takes the form of a two dimensional probability density function that represents the probability of finding an animal in a defined area within its home range. The home range of an individual animal is typically constructed from a set of location points that have been collected over a period of time identifying the position in space of an individual at many points in time. Such data are now collected automatically using collars placed on individuals that transmit through satellites or using mobile cellphone technology the position of the animal, using global positioning systems (GPS) technology, at regular intervals .

The simplest way to draw the boundaries of a home range from a set of location data is to construct the smallest possible convex polygon around the data. This approach is referred to as the minimum convex polygon (MCP) method which is still widely employed, but has many drawbacks including often overestimating the size of home ranges.

The best known methods for constructing utilization distributions are the so-called bivariate Gaussian or normal distribution kernel methods. This group of methods is part of a more general group of parametric kernel methods that employ distributions other than the normal distribution as the kernel elements associated with each point in the set of location data.

Recently, the kernel approach to constructing utilization distributions was extended to include a number of nonparametric methods such as the Burgman and Fox's alpha-hull method. and Getz and Wilmers local convex hull (LoCoh) method This latter method has now been extended from a purely fixed-point LoCoH method to fixed radius and adaptive point/radius LoCoH methods.

Although, currently, more software is available to implement parametric than nonparametric methods (because the latter approach is newer), the cited papers by Getz et al. demonstrate that LoCoH methods generally provide more accurate estimates of home range sizes and have better convergence properties as sample size increases than parametric kernel methods.

Computer packages for implementing parametric and nonparametric kernel methods are available online.

Question:I have a vast amount of data in an excel spreadsheet e.g. average weight from 0 to 10,000 or amount from 0 to 1 million I need to group the entries by categories of let's say: 0-200 201-300 301-400 etc. The idea is to create Thresholds that could be grouped in a pivot table or an excel chart. There could be a way with the IF function but excel inly supports 6 consecutive IFs in the same function. Would there be any way to create a table with thresholds and the link it to a column of my data. Thank you in advance Thanks for your answer. I was thinking of making a column with a label for each value according to which categorie it falls into. For example any value between 0-200 would get a lable of "0-200" , in order to be possible for them to be grouped in a chart or pivot. Instead of having thousands of values, we end up with let's say 10 thresholds. Even in a database, we would have the same issue.

Answers:This might be something a pivot table would be good for, but I've never used them, so I'll suggest something else... Create a table somewhere, as you mentioned, with your thresholds. Say in AA1:AB10 AA1:AA10 = the lower limit (i.e. 0, 201, 301...) AB1:AB10 = upper limit (i.e. 200, 300, 400...) In your new column next to your data, use a VLOOKUP formula to look at your data (say in B1) and return the threshold it belongs to: = VLOOKUP( B1, $AA$1:$AB$10, 1, TRUE) Copy/drag the formula down. The above will result in either "0" or "201" or "301" for each value in column B. If this is all you use, the second column of your lookup table isn't necessary. However, if you want the result to be "0 - 200" or "201 - 300" then use this formula: = VLOOKUP( B1,$AA$1:$AB$10, 1, TRUE)&" - " &VLOOKUP( B1,$AA$1:$AB$10, 2, TRUE) The "2" tells it to return a result from the second column (AB). The TRUE tells it to match with B1 or the next closest but lower value. (FYI: FALSE demands an exact match only).

Question:Or is this even possible as histograms contain grouped, continuous data? Would appreciate any reply. :-)

Answers:Well funny you should ask that I have a GCSE module 1 test tomorrow, and we need to know this. Firstly, where the curve is you need to go to where the curve finishes and then follow across until you reach the y axis. Let's say, the curve ends at 80. You'd half 80 to give you 40, and go to 40 on the y-axis. You'd do a straight line from 40 across, but stop as soon as you reach the curve. Once you've met the curve, draw a straight line down to the x-axis. This will be your median. To do the lower quartile, the same applies, you just need to half the median, so you'd go to 20 on the y-axis. To find the upper quartile you'd go to 60, as this is 40 and the lower quartile or 20. To fine the inter quartile range you'd do what ever you got for you upper quartile, minus what ever you got for your lower quartile. Hope this helps. (:

Question:Find the quartiles in each set of data. 15,3,7,6,2,14,9,25,8,28,1

Answers:First, arrange the numbers in ascending order, 1, 2, 3, 6, 7, 8, 9, 14, 15, 25, 28 We're lucky since we have 11 numbers. The median (Q2) is the value in the center, which is 8. Now we have 5 numbers on either side of the median. Q1 is the center of the lower group, which is 3. Q3 is the center of the upper group, which is 15.

Question:the following is a sample of 35 chapter five statistics test 90, 80, 77, 88, 92, 93, 99, 87, 56, 79, 68, 98, 78, 79, 76, 88, 83, 91, 96, 84, 68, 98, 87, 77, 81, 85, 89, 91, 76, 78, 85, 86, 99, 83, 87 Number of data elements. sample mean sample standard deviation level of confidence 95% the confidence interval the margin of error Can u please teach me how to find all those on my calculator i have a TI-84!? pleaseeeeeee help meeeeee