Hi:

I'll use some fake data to show you how to get the plots. To get the data
from Excel into
R, there are several ways to do it: converting the Excel file into csv and
using read.csv() in
R is one method and the XLSReadWrite package is another. Here's a link from
the R Wiki:
http://rwiki.sciviews.org/doku.php?id=tips:data-io:ms_windows&s=read%20excel

It sounds like what you want is a plot of the 95th percentiles of the
latency by
transaction rate for each transaction type. Here are a couple of ways to do
that using
some fake data.

df <- data.frame(rate = rep(seq(10, 50, by = 10), each = 12),
         type = rep(rep(c('Order', 'ACK', 'FILL'), each = 4), 5),
         latency = rpois(60, 3))
library(ggplot2)
library(lattice)

# get 95th percentiles
# Several ways to do this; I'll use ddply() from the plyr package (which
loads with ggplot2)
latq95 <- ddply(df, .(rate, type), summarise, lq95 = quantile(latency,
0.95))

# ggplot2 way to get the graph:
p <- ggplot(latq95, aes(x = rate, y = lq95, shape = type))
p + geom_point(size = 2) + geom_line() +
      xlab('Transaction rate') + ylab('95th percentile')

# lattice method of getting the graph:
xyplot(lq95 ~ rate, data = latq95, groups = type, type = c('p', 'l'),
   xlab = 'Transaction rate', ylab = '95th percentile',
   auto.key = list(text = levels(latq95$type), space = 'right',
                          points = FALSE, lines = TRUE))

Hope this is what you were after...

Dennis


On Mon, Apr 5, 2010 at 1:55 PM, jeff d <jdavidson@forwardthinkgroup.com>wrote:

>
> Hi,
>
>  I'd like to move from excel to R because our dataset are so large. Here's
> what my data looks like:
>
> Transaction Rate   Run#       Transaction Type        Location    Latency
> in
> Seconds
>                   10        1                       Order
> A                            0
>                   10        1                       Order
> B                            3
>                   10        1                       Order
> C                            1
>                   10        1                       Order
> D                            2
>                   10        1                       ACK
> A                            0
>                   10        1                       ACK
> B                            5
>                   10        1                       ACK
> C                            2
>                   10        1                       ACK
> D                            2
>                   10        1                       FILL
> A                            0
>                   10        1                       FILL
> B                            2
>                   10        1                       FILL
> C                            3
>                   10        1                       FILL
> D                            2
>
> - we have about 1000 runs per transaction rate (run# 1..1000)
> - we have 50 transaction rates (transaction rate 10..500 incrementing by
> 10)
>
> We'd like to be able to create a graph where:
> - Y axis = 95 pecentile latency of transaction type data (order, ack, fill)
> - X axis = transaction rate
>
> I've read the basic doc, created some simple plots, could someone get me
> going in the right direction?
>
> tia,
> jd
>
>
>
> --
> View this message in context:
> http://n4.nabble.com/new-to-R-analysis-of-latency-data-tp1752096p1752096.html
> Sent from the R help mailing list archive at Nabble.com.
>
> ______________________________________________
> R-help@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.
>

	[[alternative HTML version deleted]]

