I have the following data and am trying to find the percentage of bid
values purchased for that price.
So let's say I have a bid of 5 and it's sold 2 times for $3 and $5.
Since
the original bid was $5, the
percentage of times that that bid value results in a sold purchase AT that
specific bid level was
1/3 because of the three time where the bid was three, it ended up being
sold for $5 one time.
So I'm wonder how to generate that info in R. The percentage of a bid being
sold at the same purchase
price. Can anyone point me in the right direction.
f = data.frame(bid=c(3,5,5,8,3,5,4,2,3,5), purchase=c(6,3,4,5,5,5,6,2,3,7),
sold=c(0,1,0,0,0,1,1,0,0,1))
f
Thanks.
--
*Abraham Mathew
Statistical Analyst
www.amathew.com
720-648-0108
@abmathewks*
[[alternative HTML version deleted]]
Daisy Englert Duursma
2012-Aug-09 00:52 UTC
[R] Calculating percentages across multiple columns
Your question is very unclear.Can you provide a better question or at least a column of outputs you expect and an example with the dataframe you provided? On Thu, Aug 9, 2012 at 8:29 AM, Abraham Mathew <abmathewks at gmail.com> wrote:> I have the following data and am trying to find the percentage of bid > values purchased for that price. > > So let's say I have a bid of 5 and it's sold 2 times for $3 and $5. Since > the original bid was $5, the > percentage of times that that bid value results in a sold purchase AT that > specific bid level was > 1/3 because of the three time where the bid was three, it ended up being > sold for $5 one time. > > So I'm wonder how to generate that info in R. The percentage of a bid being > sold at the same purchase > price. Can anyone point me in the right direction. > > f = data.frame(bid=c(3,5,5,8,3,5,4,2,3,5), purchase=c(6,3,4,5,5,5,6,2,3,7), > sold=c(0,1,0,0,0,1,1,0,0,1)) > f > > > Thanks. > > > -- > *Abraham Mathew > Statistical Analyst > www.amathew.com > 720-648-0108 > @abmathewks* > > [[alternative HTML version deleted]] > > ______________________________________________ > R-help at r-project.org mailing list > https://stat.ethz.ch/mailman/listinfo/r-help > PLEASE do read the posting guide http://www.R-project.org/posting-guide.html > and provide commented, minimal, self-contained, reproducible code.