University:
California State University, Northridge
Course:
MGT 380 / Introduction to Human Resource Management
Academic year:

2021
Views:

418

Pages:

1
Author:

blakestar2o1o

Business Analytics Assignment Assignment Problem 1 As you probably know, the Dow Jones Industrial Average (DJIA) is based on 30 companies. Worksheet DJIA IN HW2. XLSX contains various pieces of information about these 30 companies, including their stock price on June 21, 2019. a) Calculate the average and median stock price for these 30 companies b) Calculate the interquartile range and population standard deviation of the stock prices for these 30 companies. c) Construct a box-and-whisker plot of the stock prices for these 30 companies. d) Calculate the z-score of the stock price for Apple and interpret it. Problem 2 Worksheet CREDIT C ARDS in HW2.XLSX contains demographic information as well as the total annual charges for 5,000 credit card holders. I planted 5 fairly obvious “mistakes” (e.g., outliers, blanks, “impossible” values) in the data. Can you find them? Please report the account number and what you think the mistake is for each. Problem 3 Worksheet COVID-19 in HW2.XLSX contains data about COVID-19 for the “top” 50 countries (as of Sep 22, 2020;). In particular, the worksheet contains the total number of cases, the total number of deaths, the total number of tests, as well as the population for each country. a) Calculate z-scores for the total number of cases, the total number of deaths, and the total number of tests for each country. What can you learn from these statistics? b) Now calculate the same z-scores for the same variables but “normalized” for the population. In other words: divide each of the variables by the size of the population (in millions) and then calculate z-scores. What can you learn from these statistics and how are they different from the ones you calculated in part a)? Which ones make more sense? c) Now calculate the “mortality rate” for each country by dividing the total number of deaths by the total number of cases. Which are the countries with the highest and lowest rates? What is the average and what is the median mortality rate? d) Create a histogram for the mortality rate between 0% and 12% such that each category covers one percent. What does this histogram tell you? Can you relate it to the relationship between the average and median mortality rate? e) Create treemaps for the total number of cases, the total number of cases per 1M residents and for the mortality rate. f) Create “map” charts for the total number of cases and for the mortality rate.