00:01
For this problem, we are told that the following table shows the population in millions of the united states in five -year intervals from 1950 to 2000.
00:10
And we are asked to develop a line chart depicting the population growth and to write a brief report summarizing our findings.
00:17
So i won't be writing a full report, but i'll walk you through the entirety of how to create a chart in excel.
00:24
And then i'll also give some sort of point form notes about the findings.
00:28
So we have year.
00:30
You can see that it is in five year intervals.
00:33
So i just put in year 1950, then equals select 1950 and put plus five.
00:41
Now i'll select 195 and drag down.
00:47
I dragged it down too far, drag it back up a little bit, and we can see that the equation used fills in.
00:54
So we have up to 2000.
00:56
Now i'll copy down the data.
00:59
I'll actually pause the recording.
01:00
For this.
01:02
All right, so i've copied down the information into a little table here.
01:07
Then we are asked to develop a line chart...