Printable View
I need to find the mathmatical equation
to compute an average number of time a users have gone to a certin form.
This is the data I have
7 = 182
6 = 200
5 = 299
4 = 366
3 = 338
2 = 201
1 = 43
I want to produce something that says
this form is accessed on average 4 times.
or whatever the average amount is ... what is the equation to figure this out ?
Thanks
Are you sure you want the average and not the mode or the
median? The mode is the most often seen value. In this case, it
would 4.
I think you are really looking for is the median. If you sort the
table by number of times and find the mid-point in the set, that is
the median. It is often used in datasets where the actual
average would be seriously skewed:
1
2
3
3
3
4
5
6
7
8
1000
Average: 95.1
Mode: 3
Median 4
Well what about like this
1 use 1
2 uses 1
3 uses 3
4 uses 1
5 uses 1
6 uses 3
7 uses 1000
What would the median be? would it still be 4 or
would it now be 7 ??
Its pretty much just like my other
problem i had.
7 * 182 = 1274
6 * 200 = 1200
5 * 299 = 1495
4 * 366 = 1464
3 * 338 = 1014
2 * 201 = 402
1 * 43 = 43
----------------------
1629 / 6892 = 4.23
so on my answer would be 4.23 times..
what is this median ? mean ? average ? something else ?
Thanks
In the for what it's worth category
1 use 1
2 uses 1
3 uses 3
4 uses 1
5 uses 1
6 uses 3
7 uses 1000
the median would be 1000.
Assume that each time a form is used a record is appended to a
table where the record keeps track of the name of the form. At
the end of the time period, you would have
1 record for 1
1 record for 2
3 records for 3
1 record for 4
1 reocrd for 5
3 records for 6
1000 records for 7 for a total of 1010 records
sort the records by name of the form, and pick the 505th record.
That is the median.
The mode is 7. the mode is defined as the most often seen value.