Refer to Global Financial Performance Dataset which reports financial information on 148 global companies with 12 variables. Refer to Global Financial Performance Dataset which reports financial information on 148 global companies with 12 variables.

Answer the following questions:

1. A. Which of these variables are quantitative and which are qualitative?

B. Determine the level of measurement for each of the variables.

2. Select variable "Employees" and determine the mean, median, mode and standard deviation. Are there any outliers? Is the distribution skewed or symmetric? Write a brief summary of the distribution of Employees.

3. Select variable "Sales" and determine the coefficient of skewness. Based on this, comment on the shape of "Sales' distribution

4. Select variable "Cost of sales" and determine the range and standard deviation. Based on the standard deviation values of question no. 3 and no. 4. which distribution is more dispersed? State your reason.

5. A. Draw a scatter diagram with the Sales on the horizontal axis and Net Income on the vertical axis. Based on the diagram, make three statements about the relationship between Net Income and Sales.

B. Select another two variables of your choice. Repeat 5a. (i.e. draw a scatter diagram and make three statements about the relationship between these two variables).

6. A. Under variable x3 Economic Industry, select "Automobiles". There are 5 automobiles under this category. Express the ROI spent by NISSAN MTRS, HONDA MOTOR, DAIMLER, and VOLKSWAGEN as an index, using TOYOTA as a base. What percent more (or less) ROI does the automobile companies of NISSAN MTRS, HONDA MOTOR, DAIMLER, and VOLKSWAGEN spent on investment than the TOYOTA?

B. Under variable x3 Economic Industry, select any of the following category that has 3 entries (i.e. 3 companies).

For example select only ONE of the following category:

Construction Materials

Communications Equipment

IT Services

Semiconductors & Semiconductor Equipment

Machinery

Food Products

Tobacco

Media

Repeat 6a., i.e. express ROI spent by (for example) company 1 and 2 using company 3 as a base. What percent more (or less) ROI does company 1 and 2 spent on investment than company 3? Please download the excel file here for the data set and variables: https://usaupload.com/shared/43gt4ps2qsq_4a4y0xd_yzir50u0i0teemw-miefw6qfvulg1y_0p9daqk69zmz-5kveklu2_6pu1dn14hw9ni5fkz4g-0-p0s51l76e4urxaij27kg4jf7z1-gadtu_