Applied Statistics Laboratory
Question 1: Data Frame: Gift Boxes
An online order of 12 small boxes of the same type was received. Upon delivery, the dimensions of the 12 boxes were measured by four students. The data are recorded in the below table. The measurements are in centimeter.
Small boxes
Name Width (cm) Length (cm) Height ( cm )
Ben box 1 3.61 5.30 1.63
box 2 3.52 5.31 1.58
box 3 3.53 5.31 1.63
Craig box 1 3.64 5.33 1.53
box 2 3.65 5.34 1.58
box 3 3.66 5.35 1.58
Kristy box 1 3.63 5.28 1.57
box 2 3.64 5.31 1.53
box 3 3.63 5.33 1.57
Molly box 1 3.60 5.31 1.48
box 2 3.61 5.28 1.46
box 3 3.55 5.26 1.42
Suppose we do not care about who made the measurements. Use EXCEL to construct a proper data frame that is ready to be import to "R".
(Hint: determine the number of subjects and the number of variables.)
Give your answer of the data frame by providing a screen-shot displaying the dataframe in "R". Instructions as follow. Import the data to "R". Display the data frame in "R" by clicking on the "view data set" button. Then, use 'print-screen' (found on your keyboard) to copy the screen with the the data set; control-V to paste it in MS Word; click on the picture, select 'crop' from the 'format' tab and crop the picture; press 'ESC' when finish cropping; resize the picture appropriately.
Note: Your answer must include the entire dataframe. That is, all subjects and all variables must be shown in your answer. Use sensible names for the variables. See also 'Writing Up Your Assignment' on the cover page.
Question 2: Data Frame: Salinity Measurement
A laboratory technician made up 3 batches of solution for salinity measurement. The 3 batches of solution are of different unknown concentration and are labelled with 'A', 'B' or 'C'. Five students took samples from each of the 3 batches and measured the salinity. The measurements (in gram per litre (g/l)) are recorded as follow.
Salinity
Name A B C
Salvo Montalbano 8.94 3.15 1.53
Sherlock Holmes 9.44 3.24 1.78
Snow White 9.44 3.16 1.56
Peter Pan 8.94 3.15 1.53
Mary Poppins 8.95 2.48 1.22
Suppose we do not care about who made the measurements. Use EXCEL to construct a proper data frame that is ready to be import to "R".
(Hint: determine the number of subjects and the number of variables.)
Give your answer of the data frame by providing a screen-shot displaying the dataframe in "R". Instructions as follow. Import the data to "R". Display the data frame in "R" by clicking on the "view data set" button. Then, use 'print-screen' (found on your keyboard) to copy the screen with the the data set; control-V to paste it in MS Word; click on the picture, select 'crop' from the 'format' tab and crop the picture; press 'ESC' when finish cropping; resize the picture appropriately.