Presenting data in the form of table. For the data set shown by the table.Create a scatter plot for the data.Use the scatter plot to determine whether an exponential function, a logarithmic function, or a linear function is the best choice for modeling the data.

UkusakazaL

UkusakazaL

Answered question

2021-08-08

Presenting data in the form of table. For the data set shown by the table, Solve,
a) Create a scatter plot for the data.
b) Use the scatter plot to determine whether an exponential function, a logarithmic function, or a linear function is the best choice for modeling the data. (If applicable, you will use your graphing utility to obtain these functions.)
Intensity (wattd per meter2)Loudness Level (decibels)0.1(loud thunder)1101(rock concert, 2 yd from speakers)12010(jackhammer)130100(jet take off, 40 yd away)140

Answer & Explanation

Ian Adams

Ian Adams

Skilled2021-08-16Added 163 answers

Step 1
a) We can draw scatter plot using Excel as follows,
Enter the data in Excel and select it.
Go to insert scatter select 1st scatter plot add trendline to the plot Tick on display equation on plot and display R square on the plot.
We get result as follows,
image
Step 2
b) From the above scatter plot, we can observe that, the regression equation for logarithmic model is,
y^=4.3429ln(x)+120
and R2=1
Since, the value of R2=1 for Logarithmic function, the logarithmic function is the best choice for modeling the data.

Do you have a similar question?

Recalculate according to your conditions!

New Questions in College Statistics

Ask your question.
Get an expert answer.

Let our experts help you. Answer in as fast as 15 minutes.

Didn't find what you were looking for?