1. The dataset in the file MobileCommerce.xlsx contains the following mobile commerce penetration values, the percentage of the country population that bought something online via mobile phone in the past month, for 28 of the worlds economies: 11,15,19,21,21,23,23,23,23,15,26,26,26,27,28,30,31,33,33,33,36,37,38,40,40,41,47,55.

b) Calculate the variance, standard deviation, range, coefficient of variation, and Z scores. Are there any outliers?

c) Are the data skewed? If so, how?

d) Based on the results a) through c) what conclusions can you reach concerning mobile commerce usage in the population a. The mean Mobile Commerce Penetration is ___________________ b. Half the countries have values greater than or equal to ________________ c. The average scatter around the mean is ______________ d. The lowest value is __11__ for __Japan_(country) and the highest value is _55_ for _South Korea_(country)

2. Go to UCI data repository (https://archive.ics.uci.edu/ml/index.php) and identify any dataset that contains numerical and nominal values. (An example of how to download data is shared in a separate document) Using Microsoft Excel or any other statistical software

a. Calculate and interpret the central tendency measures (Mean, Median, Mode) for each numerical variable

b. Calculate and interpret the dispersion/spread measures (Variance, Standard Deviation, Range) for each of the numerical variables.

c. What conclusions can you reach about your chosen data set

3. In the dataset Fortune5 00.xlsx Scatter chart in the following figure was created using sample data for profits and market capitalizations from a sample of firms in the Fortune 500

a) What do you observe with respect to the relationship between Profits and Market Capitalization?

b) Compute the covariance between profits and market capitalization what does the covariance indicate about the relationship between profits and market capitalization?

c) Calculate the correlation coefficient between profits and market capitalization. What does the correlation coefficient indicate about the relationship between profits and market capitalization?