Each assay was measured with 3 parameters (T, D, and P) for 3 days. Some assay has
Question:
Each assay was measured with 3 parameters (T, D, and P) for 3 days. Some assay has missing all values or values of one/two parameter/s. The data is given in the table below:
name | T1 | D1 | P1 | T2 | D2 | P2 | T3 | D3 | P3 |
A | 0.12 | 52 | 1 | 0.9 | 53 | 1 | 0.7 | 55 | 1 |
B | NA | NA | NA | 0.9 | 52 | 2 | 0.5 | 54 | 2 |
C | 0.3 | 60 | 3 | 0.8 | 51 | 2 | 0.63 | 60 | NA |
D | 0.4 | 51 | 4 | 0.83 | 56 | 3 | NA | NA | 3 |
Question:
a) find out the number of missing data (i.e. count NA values) for each assay. Summarize how many assays have complete measurements, how many are missing one/or more values (Use is.na(), apply(), sum())
b) for each parameter (T,D, and P), make a boxplot for each timepoint to check if there are any outliers. ( First, reshape the data to combine observations for the same parameter across each timepoint into a one vector/or data frame first. Do that for all parameteres)
c) re-arrange the data to make time series plot for each parameter using facet_wrap() in ggplot
Introduction to Management Science A Modeling and Cases Studies Approach with Spreadsheets
ISBN: 978-0078024061
5th edition
Authors: Frederick S. Hillier, Mark S. Hillier