You walk 2 miles in 1/2 hours. At that rate, how long will it take you to walk 3 miles?
2 answers:
You might be interested in
Answer:
i)
Find the attached
ii)
The mathematical model that best fits the data is;
y = 7.19 + 12.8 ln x
Step-by-step explanation:
i)
A scatter-plot can easily be constructed using applications such as Ms. Excel and Stat-Crunch.
In Ms. Excel we first enter the data in any two adjacent columns. Next, highlight the data, then click the insert ribbon and select the scatter-plot option.
Excel returns a scatter-plot chart as shown in the attachment below.
ii)
After obtaining the scatter-plot, we shall need to add a trend line in order to determine the mathematical model that best fits the data given.
Click anywhere inside the chart, then select the design tab under chart tools. Click on the Add Chart element in the upper left corner of the excel workbook and select more trend-line options. This feature will enable us to fit any trend-line to our data.
Select any trend line option ensuring you check the boxes; Display Equation on chart and Display R-squared value on chart.
Find the attached for the various trend-lines.
The mathematical model that best fits the data is;
y = 7.19 + 12.8 ln x
Since it has the largest R-squared value of 0.9905
