Sunday, 12 April 2015

5 Questions

The questions that I shall ask my data set are as follow:


1.      What are the top 5 months in term of unit sold?
Ans: The metric used for this question is unit sold and attribute in the question is months. The reason we choose the graph visualization is that because data can be easily seen with this visualization and it’s easy to figure top 5 cities with unit sold. The conclusion that can be drawn from this question is that November rank 1st in term of unit sold, 2nd is December, 3rd is October, 4th is May, and 5th is September.

2.      Which city has highest revenue?
Ans: The metric used in this question is revenue and the attribute for the question is cities. The reason for selecting graph visualisation is that because data can be easily seen with this visualization and it’s easy to figure out the city with the highest revenue. The conclusion that can be drawn from the question is that the city with highest revenue is New York.

3.      What city has the highest cost?
Ans: The metric used in this question is cost and the attribute for the question is cities. The reason for selecting graph visualisation is that because data can be easily seen with this visualization and it’s easy to figure out the city with the highest cost. The conclusion that can be drawn from the question is that the city with highest cost is Baltimore.

4.      What are the top 5 cities in term of revenue?
Ans: The metric used in this question is revenue and the attribute for the question is cities. The reason for selecting graph visualisation is that because data can be easily seen with this visualization and it’s easy to figure out the city with the highest revenue. The conclusion that can be drawn from the question is that the New York is on 1st place. 2nd is Baltimore, 3rd is Lockport, 4th is Harrisburg, and 5th is flushing.

5.      What are the top 5 cities with lowest cost?

Ans: The metric used in this question is cost and the attribute for the question is cities. The reason for selecting graph visualisation is that because data can be easily seen with this visualization and it’s easy to figure out the city with the highest cost. The conclusion that can be drawn from the question is that the Morristown is on 1st place. 2nd is Nutley, 3rd is Rutherford, 4th is Chantilly, and 5th is Wilmington.

The graph chose to display the data is a bar graph as it allows an easy comparison to the other data listed.