Problem $1$:

In an Excel workbook, create a spreadsheet representing bacterial growth.

Open Microsoft Excel and make a New blank spreadsheet

Create a data set consisting of two parallel vertical columns of $x-y$ data starting at $A5$ and

$B5,$ respectively, with $x$ values $(t=$ elapsed time in hours$)$ ranging from $0$ to $5$ in increments

of $0\mathrm{.}5,$ and $y$ values $(N=$ the final number of bacteria$)$ according to the equation $N=N_0{2}^{\frac{t}{d}},$

where, $N_0$ is the initial number of bacteria, and $d$ is the doubling time $($in minutes$).$ Make $N_0$

and $d$ adjustable by $($absolute$)$ referencing cells $A2$ and $B2,$ respectively. To start with, set

the values of $N_0$ to $10$ and $d$ to $20($i$.$e$.$ cell $A2=10,$ cell B$2=20)$

Create the text labels $N_0$ and $d$ in cells $A1$ and $B1,$ respectively.

Create a scatter plot with red closed circle symbols.

Add a blue solid trendline $($pick one type$)$ and display the line equation on the plot.

Label the axes appropriately: $x$ is Time $($hr$),y$ is Number of Bacteria.

Try adjusting the $N_0$ and $d$ parameters and see how this affects the plot.

Create two more $y$ data columns in which $y$ varies with $x$ according to the equation in

with column$-$referenced $t$ values$),$ but in each $d$ will vary according to multipliers $($absolute$)$

referenced in cells D$2$ and E$2,$ respectively, as $N=N_0{2}^{\frac{t}{d+ltiplier}}.$ Initially, set the

multipliers to values of $1\mathrm{.}1$ and $1\mathrm{.}2.$

Add these new data sets to the original scatter plot by copying the new columns one at a

time and pasting them onto the plot.

Vary the multipliers in D$2$ and E$2$ and see how this alters the plots relative to one another.

Cell referencing:

$A4$ both column and row are relative

$A$4$ column is absolute; row is relative

A $$4$ column is relative; row is absolute

$A $$4$ column is absolute; row is absolute

Try copying your time data column $($x$)$ from Sheet $1$ and paste it into a new sheet $($Sheet $2).$

Copy the column of number calculations $(y)$ from Sheet $1$ and paste the LINK next to the

time column $(x)$ in Sheet $2.$ You have now referenced data from Sheet $1$ and linked these

data presented in another sheet $($Sheet $2).$ please provide picture