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

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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!