{[ promptMessage ]}

Bookmark it

{[ promptMessage ]}

xl08-graphicaldisplays1-1 - Lesson 10 Excel/Data Analysis...

Info iconThis preview shows pages 1–3. Sign up to view the full content.

View Full Document Right Arrow Icon
Lesson 10- Excel/Data Analysis - Graphing (charting) the data Most presentations and displays of data are enhanced by attractive and informative charts. Charts are a pictorial presentation of data - often found in tables. Some data can be represented by more than one chart type but other data require a specific type of chart. Often a chart can only be made from data of one type. Making a simple chart is very easy in excel. The difficult parts will be to decide what chart to make from the data you have and then to make the chart as informative as you can. Assuming the data selected is correct and that you have the desired chart type, make sure your chart has: a good title, that all axes (x and y) have correct titles if needed (almost always needed) the legends are correct and present if needed (usually needed if more than one series is present) that all the data is clearly visible. How to make a chart: Select the data your want charted ... Insert Charts ... Choose the chart type
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
Common Chart Types Column Chart -This is one of the most common types of graphs used to show relationships between different data values. These different data values are shown as columns along the vertical axis. Each column represents a single data point. Single or multiple series can be plotted using a Column Chart. Example s include - a comparison between the populations of different countries or the profits of three different companies for each month of the year. Bar Chart - this is essentially the same as a column chart but rotated by 90 degrees Pie Chart (or circular) - Simple pie charts can only be used for one series of data. Pie charts are mainly used to show the percent contribution of each part to a whole. Each slice of the pie represents a different data point. Examples of these charts include - showing the percentage of students coming from each emirate in a class or showing the percent contribution of the population of the UAE coming from each ethnic group. Histogram - this is very similar to a column chart. The only main difference is that it plots a frequency of occurrence rather than the actual data points. It is often necessary to group data into bins (a grouping) before plotting the graph. Categorical data histograms look just like column charts. Numerical data histograms have no spacing between the columns. Line Chart - these charts are excellent at showing trends over time. Each data point in a data series is connected by a continuous line. Single or multiple data series can be plotted . Examples include: - gold or oil prices over time - profits of a business over time - numbers of endangered species over time etc. XY- Scatter Graph - these graphs (charts) are used to show correlation (or lack of it) between two sets of numerical data. A number of trends (or regression types) are available including linear and exponential. If a correlation exists, excel will provide the trend line, the equation and the R squared value.
Background image of page 2
Image of page 3
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}