Excel Assignment $(30$ Points$)$

$(10$ Points$)$ Data Entry In this section you should not be keying in any values except the starting value by hand. Have Excel do the iteration for you.

a$.$ In one column enter numbers starting with $0$ and ending with $25,$ counting up by $1.$ We will call this column A$.$

b$.$ In a second column enter numbers starting with $1$ and ending with $51,$ counting up by $2.$ We will call this column $B.$

c$.$ In a third column enter the values of

$f(x)=7e^{4x}$

starting with $x=0$ and ending with $x=25,$ counting up by one in $x.$ We will call this column C$.$

d$.$ Print these three columns on a single sheet of paper.

$2.(10$ Points$)$ Plotting and Curve Fitting

a$.$ Plot column A versus column A$.$ On the same figure plot column B versus column A$.$ Make sure each set of points uses a different symbol. Note: When we say $"$B versus A$,"$ this means that B should be our vertical axis and A should be our horizontal axis.

b$.$ Fit both of these data sets with linear trendlines.

c$.$ Display the equations of each of these trendlines on the graph.

d$.$ Plot column $C$ versus column A$.$ On the same figure plot column C versus column B$.$ Make sure each set of points uses a different symbol.

e$.$ Fit both of these data sets with exponential trendlines.

f$.$ Display the equations of each of these trendlines on the graph.

$(10$ Points$)$

a$.$ Add a descriptive legend and axis titles to both graphs.

b$.$ Label the axes of each graph. Since these plots don't correspond to any real data simply make up some names.

c$.$ Print each graph on its own piece of paper. Make sure the graphs take up the full width of the page.