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

Info icon This 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
Image of page 1

Info icon This 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.
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 ]}

What students are saying

  • Left Quote Icon

    As a current student on this bumpy collegiate pathway, I stumbled upon Course Hero, where I can find study resources for nearly all my courses, get online help from tutors 24/7, and even share my old projects, papers, and lecture notes with other students.

    Student Picture

    Kiran Temple University Fox School of Business ‘17, Course Hero Intern

  • Left Quote Icon

    I cannot even describe how much Course Hero helped me this summer. It’s truly become something I can always rely on and help me. In the end, I was not only able to survive summer classes, but I was able to thrive thanks to Course Hero.

    Student Picture

    Dana University of Pennsylvania ‘17, Course Hero Intern

  • Left Quote Icon

    The ability to access any university’s resources through Course Hero proved invaluable in my case. I was behind on Tulane coursework and actually used UCLA’s materials to help me move forward and get everything together on time.

    Student Picture

    Jill Tulane University ‘16, Course Hero Intern