Tech Tool:Spreadsheet Software
Software Videos:Spreadsheet Data Analysis Tools
The following table shows the increase of the teenage population in the past 10 years in a European country as well as the increase in demand for a specific nonalcoholic drink.
1. Download the exercise data file.
2. Graph the teenage population for the past 10 years.
3. Graph the demand for the past 10 years.
4. Plot the teenager population (x, independent variable) versus the demand (y, dependent variable).
Year | Demand | Teenage population |
1 | 487000 | 9123000 |
2 | 560000 | 10189000 |
3 | 601000 | 11570000 |
4 | 689000 | 12584000 |
5 | 788000 | 13965000 |
6 | 854000 | 15191000 |
7 | 902000 | 17321000 |
8 | 957000 | 19247000 |
9 | 991000 | 21096000 |
10 | 1010000 | 23095000 |
We need at least 10 more requests to produce the solution.
0 / 10 have requested this problem solution
The more requests, the faster the answer.