7.42 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 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 A marketing manager says that there is a relationship between the marketing budget and sales volume. He provided the following table of the marketing budget (in thousand $) and the amount of sales (in million $). He insists that if the marketing budget increases to 23, 25, and 27 thousand dollars, the sales will increase accordingly. Is he correct? To support your answer, you may need to use Microsoft Excel to:
1. Put the data in the spreadsheet.
2. Decide between the marketing budget and the sales amount-which one depends on the other (x and y of the curve).
3. Plot the marketing budget versus sales volume.
Use the Microsoft Trendline data analysis tool to:
4. Determine the curve that best fits the plotted data and the curve equation.
S. Find out the R2 value. The closer to 1, the stronger the relationship.
Analyze the result.
Marketing Budget (in thousand $)