Step 1

a) We can draw scatter plot using Excel as follows,

Enter the data in Excel and select it.

Go to insert \(\displaystyle\rightarrow\) scatter \(\displaystyle\rightarrow\) select 1st scatter plot \(\displaystyle\rightarrow\) add trendline to the plot \(\displaystyle\rightarrow\) Tick on display equation on plot and display R square on the plot.

We get result as follows,

Step 2

b) From the above scatter plot, we can observe that, the regression equation for logarithmic model is,

\(\displaystyle\hat{{{y}}}={4.3429}{\ln{{\left({x}\right)}}}+{120}\)

and \(\displaystyle{R}^{{{2}}}={1}\)

Since, the value of \(\displaystyle{R}^{{{2}}}={1}\) for Logarithmic function, the logarithmic function is the best choice for modeling the data.