Please download the Banking data from the Dataset folder in

Please download the “Banking” data from the “Dataset” folder in your Blackboard navigation link. Description of all variables in the dataset is listed in your textbook Appendix A.5.

1. Draw the bar chart using Excel for variable x4

2. Draw the pie chart using Excel for variable x5.

3. Construct the frequency distribution table for variable x1. Note: you must first decide the number of classes, then class width, lower limit and upper limit for each class. You may need to use the count if function in Excel.

4. Please draw the histogram for variable x1.

5. Please calculate the descriptive statistics for the variable x1:

a. Range

b. Mean

c. Median

d. Sample variance

e. 1st quartile

f. 3rd quartile

g. Interquartile range

6. Please draw the scatter diagram for the following two variables

x1 and x2

x2 and x3

7. How do you describe the relationship between variables in problem 6?

Solution

_______________________________________________________________________________________