Problem 1
In a few paragraphs, describe and reflect on how the digital world and the Big Data phenomenon have impacted your professional and personal life.
Problem 2
- Download the monthly (adjusted) closing prices for Microsoft stock (MSFT) between January 1, 2000 and December 30, 2018. Hint: the finance section on Yahoo is an excellent source of financial data.
- Construct a line plot of the stock prices. What story does this plot tell, if any?
- Construct a frequency distribution and percentage frequency distribution for the relative monthly changes in Microsoft’s adjusted closing prices. What can you learn from your analysis?
Problem 3
As you probably know, the Dow Jones Industrial Average (DJIA) is based on 30 companies. Worksheet “DJIA” in “Assignment 1.xlsx” contains various pieces of information about these 30 companies, including their stock price on June 21, 2019.
- Calculate the average and median stock price for these 30 companies
- Calculate the interquartile range and population standard deviation of the stock prices for these 30 companies.
- Calculate the z-score of the stock price for Apple and interpret it.
Problem 4
Worksheet “Credit Cards” in “Assignment 1.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.
