1. Refer to the EXCEL file student profile.xlsx, worksheet' variables' Identify the type of data for...

 

Transcribed Image Text:

1. Refer to the EXCEL file student profile.xlsx, worksheet' variables' Identify the type of data for each variable. (add another column named: type of variable) (11m) Ratio Nominal Ordinal 2. For the dataset student profile.xlsx, choose another (1) ratio variable. a) Form a grouped frequency table with 6 classes. (3m) b) Create a fully-labelled histogram to summarize the data. (4m) c) Write a short summary to explain the graph. (2m) 3. For the dataset student profile.xlsx, choose one (1) nominal variable a) Form a frequency table, showing the frequency and the relative frequency (proportion). (4m) b) Create a suitable graph (fully-labelled) to summarize the data. (4m) c) Write a short summary to explain the graph. (2m) 4. For the dataset student profile.xlsx, choose one (1) nominal variable and one (1) ordinal variable. Form a contingency table to show the relationship between the two variables. (4m) 5. For the dataset student profile.xlsx, choose two (2) ratio variables, a) b) Create a chart to display the relationship between the variables. Use EXCEL function to calculate quartile 1,2 and 3 for each variable. (3m) (6m) 6. For the dataset student profile.xlsx, choose two (2) ratio variables, a) Use EXCEL function to calculate the sample mean, median, mode, variance and standard (10m) deviation of each variable. b) Use EXCEL function to calculate the coefficient of skewness of each variable. (2m) Use EXCEL function to calculate the sample coefficient of variation of each variable. d) Among the 2 variables, which one has the least dispersed distribution? Justify your answer. (2m) (3m) 1. Refer to the EXCEL file student profile.xlsx, worksheet' variables' Identify the type of data for each variable. (add another column named: type of variable) (11m) Ratio Nominal Ordinal 2. For the dataset student profile.xlsx, choose another (1) ratio variable. a) Form a grouped frequency table with 6 classes. (3m) b) Create a fully-labelled histogram to summarize the data. (4m) c) Write a short summary to explain the graph. (2m) 3. For the dataset student profile.xlsx, choose one (1) nominal variable a) Form a frequency table, showing the frequency and the relative frequency (proportion). (4m) b) Create a suitable graph (fully-labelled) to summarize the data. (4m) c) Write a short summary to explain the graph. (2m) 4. For the dataset student profile.xlsx, choose one (1) nominal variable and one (1) ordinal variable. Form a contingency table to show the relationship between the two variables. (4m) 5. For the dataset student profile.xlsx, choose two (2) ratio variables, a) b) Create a chart to display the relationship between the variables. Use EXCEL function to calculate quartile 1,2 and 3 for each variable. (3m) (6m) 6. For the dataset student profile.xlsx, choose two (2) ratio variables, a) Use EXCEL function to calculate the sample mean, median, mode, variance and standard (10m) deviation of each variable. b) Use EXCEL function to calculate the coefficient of skewness of each variable. (2m) Use EXCEL function to calculate the sample coefficient of variation of each variable. d) Among the 2 variables, which one has the least dispersed distribution? Justify your answer. (2m) (3m)