1 answer:
Answer:
i)
Find the attached
ii)
The mathematical model that best fits the data is;
The quadratic model
Step-by-step explanation:
i)
A scatter-plot can easily be constructed using applications such as Ms. Excel.
In Ms. Excel, enter the data into 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 fitted.
The mathematical model that best fits the data is;
The quadratic model
Since it has the largest R-squared value of 1.00
You might be interested in
