StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

POGenerate Random Weighted value
primarykey
Id
4030427
data
AcceptedAnswerId
4062364
AnswerCount
6
ClosedDate
CommentCount
6
CommunityOwnedDate
CreationDate
2010-10-27T06:12:50.280
FavoriteCount
8
LastActivityDate
2010-11-03T04:24:32.423
LastEditDate
2017-05-23T10:32:35.693
LastEditorUserId
-1
OwnerUserId
191837
ParentId
0
PostTypeId
1
Score
10
ViewCount
4287
LastEditorDisplayName
text
Body
Edit: I've rewritten the question in hopes that the goal is a little clearer. This is an extended question to this question <a href="https://stackoverflow.com/questions/445235/generating-random-results-by-weight-in-php">here</a>, and I really like the function provided in <a href="https://stackoverflow.com/questions/445235/generating-random-results-by-weight-in-php/445363#445363">this answer</a>. In the answer above, one is able to set the probability of hitting an extreme, with higher numbers producing a higher probability of getting lower numbers and vice-versa. The issue is that I must set the probabilities for 3 groups. Those groups are Lowest Value (LV), Highest Value (HV), and Middle Value (MV). However, to simplify the request, we can consider <code>EVP=HVP=LVP</code>. Given any range, the HV/LV should appear based on the specified EVP and, as you progress/degress through the range from each extreme, the probability of the next value in the range will increase, or decrease, based on the distance between EVP and MVP. Using an example range of 1-6, with 1 and 6 being weighted at 5% (EVP), the probability spread would be 1/6 is 5%, 2/4 is 15%, and 3/4 is 30% (MVP), totalling 100%. The reverse should also be possible, swapping EVP and MVP should produce an inverse of the graph below. Here's an image that I hope will convey the results expected from the given example. Middle weighted: <img src="https://i.stack.imgur.com/WHuK1.png" alt="Middle Weighted Graph"> Bonus: It would be most excellent if I was able to set HVP and LVP separately producing a result similar to the graph below (Note: The graph is not accurate to specification above). Middle weighted (bonus): <img src="https://i.stack.imgur.com/WW3Em.png" alt="Middle Weighted Bonus Graph"> Thanks!
Tags
<c#><php><random>
Title
Generate Random Weighted value
singulars
PostAcceptedAnswerId
1. PO
 singulars
 PostTypePostTypeId
 PTAnswer
PostParentId
1. This table or related slice is empty.
PostTypePostTypeId
1. PTQuestion
UserLastEditorUserId
1. USCommunity
UserOwnerUserId
1. USKevin Peno
plurals
PostLinksPostIdRelatedPostId
1. PL
 singulars
 LinkTypeLinkTypeId
 LTLinked
2. PL
 singulars
 LinkTypeLinkTypeId
 LTLinked
PostLinksRelatedPostIdPostId
1. PL
 singulars
 LinkTypeLinkTypeId
 LTLinked
2. PL
 singulars
 LinkTypeLinkTypeId
 LTLinked
PostsAcceptedAnswerId
1. This table or related slice is empty.
PostsParentIdCreationDate
1. PO
 singulars
 PostTypePostTypeId
 PTAnswer
2. PO
 singulars
 PostTypePostTypeId
 PTAnswer
3. PO
 singulars
 PostTypePostTypeId
 PTAnswer
VotesPostIdCreationDate
1. VO
 singulars
 PostPostId
 POGenerate Random Weighted value
 UserUserId
 USKevin Peno
 VoteTypeVoteTypeId
 VTBountyStart
2. VO
 singulars
 PostPostId
 POGenerate Random Weighted value
 UserUserId
 USDavid Titarenco
 VoteTypeVoteTypeId
 VTFavorite
3. VO
 singulars
 PostPostId
 POGenerate Random Weighted value
 UserUserId
 This table or related slice is empty.
 VoteTypeVoteTypeId
 VTUpMod
CommentsPostId

Querying!

Guidance

A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.