Start learning with our library of video tutorials taught by experts. Get started
Viewed by members. in countries. members currently watching.
In Excel for Mac 2011 Essential Training, author Curt Frye gives a comprehensive overview of Excel, the full-featured spreadsheet software from Microsoft. The course covers key skills such as manipulating workbook and cell data, using functions, automating actions, printing worksheets, and collaborating with others. Exercise files accompany the course.
In the previous movie, I showed you how to create line charts where you measured something, such as daily sales revenue, and recorded the day where you took each measurement. In this movie, I will show you how to create XY scatter charts, where you measure two variables - such as daily sales and rainfall for the day - and plot the information on the chart. The idea is that you are trying to discover if there is any relationship between those two variables. There are mathematical ways to do it, but often times just a quick visual inspection can give you an idea as well. Here I have my data, and as I said, I have rainfall data and the number of customers that came in on a given day when that amount of rainfall occurred.
Unlike when I create a line chart where I have a time series where I would have one measurement for 2005, one measurement for 2006, and so on, because I am capturing two independent variables, I can have repeat values. So, for example, I have zero inches of rainfall in quite a few days, and I also have 196 customers on a couple of days as well. So in this case, repetition of values in either column doesn't matter. So to create the XY scatter chart, I click any cell in the data list, and then on the Charts tab, I can click Scatter and then click the Marked Scatter chart.
This is the basic scatter chart type. Click that and Excel creates my chart. And when you take a look at it, you see that on days when there is zero rainfall, there were generally between 150-200 customers, and then the more rain there was, the fewer people came by the store. You will notice that things pick up again. When there is one inch of rain, I guess people figure that it's raining. It's not overcast and drizzly like it is here, so we might as well go out. But that's the sort of thing that you can tell when you look at data using an XY chart.
Find answers to the most frequently asked questions about Excel for Mac 2011 Essential Training.
Here are the FAQs that matched your search "":
Sorry, there are no matches for your search ""—to search again, type in another word or phrase and click search.
Access exercise files from a button right under the course name.
Search within course videos and transcripts, and jump right to the results.
Remove icons showing you already watched videos if you want to start over.
Make the video wide, narrow, full-screen, or pop the player out of the page into its own window.
Click on text in the transcript to jump to that spot in the video. As the video plays, the relevant spot in the transcript will be highlighted.