E1.11: Exercises

1. Organize your work so that everything you want to print appears in Columns A-I. Material that appears to the right of that will not print on the same piece of 8.5 by 11 paper.
2. If you have the graph selected when you choose “Print” it will only print the graph. Since you need to show the numerical work as well as the graph for these, before you print, make sure that nothing is selected.
3. Never print long columns of numbers. These are only useful to view or compute with—not to read.

Part I.

1. Graph [latex]y=4+2{{(x-3)}^{2}}[/latex] on the values [latex]0\le{x}\le12[/latex] and, on the same axes, graph [latex]y=10x[/latex].
   1. Determine what range of x-values has the first formula value smaller than the second formula value. (Where is the curved graph below the straight line?)
   2. Use the graph to estimate the y-value of [latex]y=4+2{{(x-3)}^{2}}[/latex] when [latex]x=14[/latex].
2. Use the graph to estimate which x gives the lowest value for y when [latex]y=4+2{{(x-3)}^{2}}[/latex] on the values [latex]0\le{x}\le12[/latex].
3. Use a spreadsheet to graph [latex]y=\sqrt{12x+3}[/latex] for input values between 0 and 6.
4. In the spreadsheet, put =PI() into a cell.       See that it gives 3.14… with high precision.
5. Use a spreadsheet to compute the average of these six test grades: 72, 85, 69, 79, 92, 71.   Then change the first score to 102 and see how the average updates to give a new value.
6. Use a spreadsheet to find the maximum of all the data values from the set of data below.       Then replace the first value in the “Men” column, 67, with the number 85. Notice that the computed maximum changes to 85 as soon as you do this.

   Men	Women
   67	62
   57	55
   63	59
   49	68
   52	42

7. Use copy and paste to get the data from column A in Example 17 to put into column A of a spreadsheet. Use formulas to find the average, standard deviation, maximum, and minimum of the set of values, putting the appropriate formulas into column C and labels in column D describing what the formula cell to the left is computing.
8. Use the STDEV function to compute the standard deviation of these grades: 72, 85, 69, 79, 92, 71 (the same values listed in Exercise 5 above).
9. Use the MAX and MIN formulas to compute the largest and smallest grades in Exercise 5.
10. Consider the formula [latex]y=2{{(x-3)}^{2}}+4[/latex]. Make a spreadsheet to graph that formula in a more general way, as[latex]y=a{{(x-h)}^{2}}+k[/latex].
    1. Then use it to investigate the effects of changing h on the shape and position of the graph.
    2. Then use it to investigate the effects of changing k on the shape and position of the graph.
    3. Then use it to investigate the effects of changing a on the shape and position of the graph.

Part II.

15. Use the AVERAGE function to find the average of these 8 quiz scores: 7, 9, 10, 5, 8, 9, 6, 7

20. Use the SQRT function to graph [latex]M=2+\sqrt{8x-7}[/latex] for values of x between 1 and 12.
21. For Topic B. Formulas and Graphing problem in Part II about the drug dosage, use a spreadsheet to make a more comprehensive graph to estimate more accurately the time for the concentration to be reduced to 2 ml/l. Give your estimate in hours with decimals, not in hours and minutes.
22. For Topic B. Formulas and Graphing problem in Part II about the landing speed, use a spreadsheet to make a more comprehensive graph in the appropriate part of the graph to estimate the weight which will have a landing speed of 100 ft/sec. to the nearest hundred pounds.
23. For Topic B. Formulas and Graphing problem in Part II about the logistic formula, use a spreadsheet to make a more comprehensive graph in the appropriate part of the graph to estimate the time when the value of P will be 900.
24. For Topic B. Formulas and Graphing problem in Part II about the break-even point, use a spreadsheet to make a more comprehensive graph so that you can estimate the break-even point to the nearest hundred thermometers.
25. Consider the formula [latex]y=2{{(1.5)}^{x}}[/latex]. Make a spreadsheet to graph that exponential formula in a more general way, as [latex]y=a{{(b)}^{x}}[/latex] for values of x between -6 and 6. Use that spreadsheet to investigate the effect of changing the value of the base, b, where [latex]b>0[/latex]. Choose some values for the base less than 1 and some greater than 1.   In your solution, write a summary of what you found and give at least three graphs to support your summary.
26. Consider the formula [latex]y={{x}^{2}}[/latex]. Make a spreadsheet to graph that power formula in a more general way, as [latex]y={{x}^{p}}[/latex] for values of x between 0 and 6.   Use that spreadsheet to investigate the effect of changing the value of p, where [latex]0.3<p<4[/latex]. Choose some values for the power, p, less than 1 and some greater than 1. In your solution, write a summary of what you found and give at least three graphs to support your summary.

Licenses & Attributions