|
-
Jan 24th, 2002, 09:33 AM
#1
Thread Starter
Member
Another Average ?
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
OddPrime
MCP
The wild world of geeks
coming soon at:
www.renegadegeeks.com
-
Jan 24th, 2002, 10:00 AM
#2
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
-
Jan 24th, 2002, 10:27 AM
#3
Thread Starter
Member
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 ??
Last edited by oddprime; Jan 24th, 2002 at 10:37 AM.
OddPrime
MCP
The wild world of geeks
coming soon at:
www.renegadegeeks.com
-
Jan 24th, 2002, 11:02 AM
#4
Thread Starter
Member
Found it
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
OddPrime
MCP
The wild world of geeks
coming soon at:
www.renegadegeeks.com
-
Jan 25th, 2002, 09:34 AM
#5
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.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|