Excel Project 2
docx
keyboard_arrow_up
School
University of North Dakota *
*We aren’t endorsed by this school
Course
GEOL220
Subject
Information Systems
Date
Feb 20, 2024
Type
docx
Pages
3
Uploaded by Kylagodi12
Excel Project 2: Question 1: What do you notice about the wedges and their sizes and the % value given to countries like China on each of your three charts? Is it consistent? Why?
China is pretty consistent in size for two of the wedges and values, this makes sense as China is one of the largest gold producing countries. China is not listed on the first chart, this is possibly due to too much data being shown and having to have a reduction in information, but this lead is a misanalysis in information as well. Question 2: Does it seem like you should have a cutoff for how many countries you have in your chart? Yes, it does seem like there should be a cut-off for how many countries you have in your chart. By reducing the number of countries, it would be easier to compare the data. Question 3: Is it easy to compare production from year to year?
It is not easy to compare year to year. There is too much data being displayed that it creates a “mess” that shows the viewer nothing. Question 4: Are the number of countries matching up with the number of lines plotted?
There are multiple countries that are not listed even though there are lines that are plotted. Question 5: Is it easier to compare data from year to year in the Pivot Chart or the standard charts you
already created?
It is easier to compare data year to year in the Pivot chart then the standard charts already created. The pivot chart allows for the selection of each year to compare and the filtering of the unwanted years or other variables. a.
For the Rainfall data set, which chart gave the most informative results? Why?
The bar graph of Day of Rain per State gives the most informative results. A viewer can easily look at this graph and see which state has the most or least days of rain per year.
b.
For the Rainfall data set, which chart gave the most useless results? Why? The chart of total days of rain vs total inches per US city gave the must useless results. There is too much information being displayed that is can be harder for the viewer to understand what is
in the graph. As well each bar of data does not align with each city, meaning that there is missing information for the viewer. c. For the Gold Production data set, which chart gave the most informative results? Why? The Top 25 Gold Production chart gives the most informative results because it is easy to understand. This visualization easily gives the viewer knowledge on who produced to the most gold per kg annual worldwide.
d. For the Gold Production data set, which chart gave the most useless results? Why? The bar graphs for production of each country by year gave the most useless results. Each graph has to much information that you could not interpret any results from reading the graphs.
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help