Huseyin ABANOZ

If you need to display a graph of a varible for different configurations, lattice package comes in handy. R code and results are given below. library ( "lattice" ) # prepare data vectors for different k values k5x = c ( 0.04576659038901602 ,  0.04576659038901602 ,  0.04576659038901602 ,  0.04576659038901602 ,  0.04576659038901602 ,  0.07627765064836003 ) k5y = c ( 0 ,  0.047619047619047616 ,  0.047619047619047616 ,  0.09523809523809523 ,  0.2857142857142857 ,  0.3333333333333333 ) k10x = c ( 0.04576659038901602 ,  0.04576659038901602 ,  0.04576659038901602 ,  0.04576659038901602 ,  0.06102212051868802 ,  0.09153318077803203 ) k10y = c ( 0 ,  0.047619047619047616 ,  0.047619047619047616 ,  0.09523809523809523 ,  0.2857142857142857 ,  0.3333333333333333 ) k25x = c ( 0.04576659038901602 ,  0.04576659038901602 ,  0.04576659038901602 ,  0.045766590389016...

  1.     Introduction Select   count (*),  category ,  subcategory  from   table   where  somecontions = true   group   by  category ,  subcategory Suppose you extracted data from database which contains data according to a category and a shared subcategory. You need to display this data with an excel chart. Unfortunately it is not easy to build a chart using structure of data. It is required to reorganize this data to easily build a chart out of this data. 2.     Problem Definition Category is hour. Sub-category is status. This table contains hourly status values of some variable. To use this data in excel to create a chart, data needs to be re-organized. New table should have a matrix like layout. Row of the matrix should contain category values while Column of the matrix needs to contain sub-category values. Resulted table should look like picture below. 3-...