Question: Assignment 2: (CLO 5): MS Excel application: Determine any four related variables, two of them are qualitative (Categorical) and two are quantitative (Numerical). a. Input
Assignment 2: (CLO 5): MS Excel application: Determine any four related variables, two of them are qualitative (Categorical) and two are quantitative (Numerical). a. Input sufficient data about the four variables (a random sample of 50 or more) in MS-Excel sheet b. Prepare frequency distribution tables for one qualitative and one quantitative variable. c. Prepare appropriate graphs for each of the two tables. d. Prepare a pivot table (cross tabulation) consists of two qualitative variables (in rows and columns) and one quantitative variable as values. e. Conduct descriptive analysis for the two quantitative variables (summary measures) f. Find the coefficient of variation (CV) and compare the dispersion of the two variables
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
