Graphs help you visualize your data and Excel helps you create them. In this video, learn how to use Excel to help you depict your data.
- [Instructor] Let's turn our attention to some of Excel's graphics capabilities that are most useful for statistical work. In the exercise file 01_03, we have some data for a small bookstore. Books sold versus day of the week. One way to represent this data set is with a bar graph, which Excel calls a column chart. Every graph in Excel is a chart, and in Excel bar chart means something else. The easiest way to create a column chart is to select all the data. Click on Monday and cell C2, hold down the Shift key, then click on the sales for Friday in cell D6. Select the Insert tab. In the charts area, click the icon that looks like a column chart, and move the mouse without clicking over all the options. Excel shows you what the chart would look like if you select the option you're hovering over. Move the mouse to the first one under 2D charts, Clustered Column, and click. The chart appears. Click Chart Title, and type book sales versus day of the week. When you create a graph, you must label the axes. Click the plus sign and the box to the right of the chart and click the Axis Titles checkbox. Axis title boxes appear on the graph. You click in each one and type in the formula bar. Type day of the week for the horizontal or x-axis, and book sales for the vertical or y-axis. I'm not a big fan of having the y-axis in this orientation, so that I have to twist my head to read it. To straighten this out, double-click the axis title. A formatting panel appears on the right. Click the icon with two arrows, size and properties. In the text direction box, select horizontal. Notice that the chart doesn't have a line where the y-axis should be. To add the line, click on the y-axis. And the formatting panel now allows you to format the axis. Click the bucket icon, and then Line. Click the solid line radio button, and then under color, select black. To make the x-axis black, go on the x-axis, and now the formatting panel enables you to format the x-axis. You can use that plus sign to add data labels, which are helpful if you put the chart on a PowerPoint slide to show to an audience. It's also easy to change the chart type, even after you've created the chart. Right-click inside the chart, not on a column, and select Change Chart Type from the popup menu. In the dialogue box, select line chart on the left, and on the top pick line with markers. Click okay, and there's a result. I usually don't use this type of chart with names on the x-axis, but in this case, the days of the week are equivalent to the numbers one through five, and they're equally spaced apart, so it's okay. Control + Z gets the original chart back, same as Command + Z on a Mac. At the bottom of the spreadsheet, click the scatterplot tab. This opens a page with data on advertising and sales. Perhaps sales depends on advertising, and maybe the more money spent on advertising, the higher the sales. We can visualize this relationship with a scatterplot. More about this later in the course. Click cell C2, hold down the Shift key, and click cell D11. Click the Insert tab. And in the charts area, select insert scatter x, y, or bubble chart. Roll the mouse around, see what they all look like, and then pick the first option. And that's a scatterplot that captures the relationship between advertising and sales. Again, you can use the plus sign to add elements to the chart, like access titles. Excel has many more possibilities, but this will get you started.
- Explain how to calculate simple probability.
- Review the Excel statistical formulas for finding mean, median, and mode.
- Differentiate statistical nomenclature when calculating variance.
- Identify components when graphing frequency polygons.
- Explain how t-distributions operate.
- Describe the process of determining a chi-square.