construct a scatterplot and identify the mathematical model that best fits the data. assume that the model is to be used only for the scope of the given data and consider only linear, quadratic, logarithmic, exponential, and power models. use a calculator or computer to obtain the regression equation of the model that best fits the data. you may need to fit several models and compare the values of r2.

the table below shows the weight of crops of oranges and the resulting gallons of juice. using the weight as the independent variable, find the regression equation of the best model.

y = –13.07 + 0.079x

y = 264.43 e1.0001x

y = 0.079x0.998

y = –7511.9 + 923.99 ln x

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

a

step-by-step explanation: