Anne Lin

The biggest takeaway from this course is how important it is to analyze data and finding errors in data. I would tell someone that this course teaches you how to sort, clean, and use data in Excel and Tableau. Also, how you would transform data into useful infographics.

Amazon stores information about different products for consumers to search and choose from. If the information was to go on a spreadsheet, the columns would be: Product name, Category, Price, Seller, Rating, Number Purchased.

American Daily Routine

From this article and data set, I found it interesting that the 3 activities those who are employed so with their time is sleep, work, and socializing/leisure/relaxing time. Those who are unemployed spend most of the time sleeping, socializing/leisure/relaxing, and household activities.

An example of a KPI that I use the number of miles I walk everyday around campus. This is specific and measurable, miles is a precise measure for distance. It is achievable, I can change my routes around campus. It is relevant, the more I walk the better it is on my health. It is also time-variant. I can look at my miles, over a week, day, or month.

The mistake that I have done that was listed in the article was #10, opening a CSV file directly on Excel. After making edits to the CSV file on Excel and trying to save it, I discovered that it did not save my edits.

Who Earns More Income in American Households?

This article illustrates graphs and statistics that show the trend of more females making more than their male spouses. There is a graph that shows a comparison of the amount of women who made more in 1970 compared to 2015. In 1970, only 7% of women made more than…[Read more]

From Hoven’s article, I think the most important principle is Simplify. By simplifying data, it is easier to read and understand the core point of what the data is saying. Data that cannot be understood would not serve a purpose.

https://fivethirtyeight.com/features/what-100-year-old-hurricanes-could-teach-us-about-irma/
This article explains how looking at historical data of hurricanes. Most people think that the rise in climate and heat leads to stronger, more frequent hurricanes. However, looking at the last 100 years of hurricanes, there is actually no correlation…[Read more]

One conventional wisdom I heard was that the higher up the degree of education you have, the higher your salary will be.
One way to collect data that will prove or disprove this statement is by recording salaries of people that only have a high school education, a undergraduate degree, doctorate degree, and so on. You would get the average…[Read more]