sCopy and paste the following data into Excel. Create a scatterplot of the data and use the scatterplot to determine if the data would best be represented by a linear, quadratic, or exponential trendline.x y6.2 9.912.4 205.1 12.242.8 18.025.7 11.327.4 7.054.2 15.315.7 11.553.4 16.84Group of answer choicesLinearQuadraticExponentialThere is no discernable trend.
Question
sCopy and paste the following data into Excel. Create a scatterplot of the data and use the scatterplot to determine if the data would best be represented by a linear, quadratic, or exponential trendline.x y6.2 9.912.4 205.1 12.242.8 18.025.7 11.327.4 7.054.2 15.315.7 11.553.4 16.84Group of answer choicesLinearQuadraticExponentialThere is no discernable trend.
Solution
- Copia y pega los siguientes datos en Excel:
x y
6.2 9.9
12.4 20
5.1 12.2
42.8 18.0
25.7 11.3
27.4 7.0
54.2 15.3
15.7 11.5
53.4 16.8
-
Selecciona los datos y ve a la pestaña "Insertar".
-
En el grupo "Gráficos", selecciona "Dispersión" y elige el tipo de gráfico de dispersión que prefieras.
-
Una vez creado el gráfico de dispersión, observa la distribución de los puntos.
-
Para determinar la mejor línea de tendencia, haz clic derecho en uno de los puntos de datos y selecciona "Agregar línea de tendencia".
-
En el panel de opciones de la línea de tendencia, prueba con las opciones "Lineal", "Cuadrática" y "Exponencial".
-
Observa cuál de las líneas de tendencia se ajusta mejor a los datos.
-
Basado en la línea de tendencia que mejor se ajuste, selecciona una de las siguientes opciones:
- Lineal
- Cuadrática
- Exponencial
- No hay una tendencia discernible
Similar Questions
Copy and paste the following data into Excel. Create a scatterplot of the data and use the scatterplot to determine if the data would best be represented by a linear, quadratic, or exponential trendline. Then use Excel to find the equation of the appropriate trendline. x y5 94932.94.9 67521.32.4 535.333.9 9943.324.5 44726.32.8 1264.074.7 534293.4 4357.411.4 63.314Which is the correct equation for the appropriate trendline?Group of answer choices𝑦=4.6233𝑥(5.9181)𝑦=13072𝑥2−63411𝑥+69096𝑦=23784𝑥−56454𝑦=4.1865𝑒(2.0135𝑥)
The following data has a quadratic relationship. Copy and paste the data into Excel. Use Excel to find the equation of the quadratic trendline. Remember a quadratic trendline is called polynomial with order 2 in excel.x y1 2875 79311 8179 90713 6299 90715 34313 6297 8993 589Group of answer choices𝑦=3.3824𝑥+650.91𝑦=421.56𝑥0.214𝑦=−12.25𝑥2+200𝑥+99.25𝑦=582.85𝑒0.0103𝑥
The following data has a linear relationship. Copy and paste the data into Excel. Use Excel to find the equation of the linear trendline.x y1 67 2111 313 1113 369 267 215 1619 51Group of answer choices𝑦=5.3437𝑥0.7289𝑦=8.1789𝑒0.1113𝑥𝑦=−9𝐸−16𝑥2+2.5𝑥+3.5𝑦=2.5𝑥+3.5
When do you need to add a trendline on a plot ?Group of answer choicesTo find the error level on dataTo see if data is closely matchedTo see how close data is to a special fitTo see if data is following a correct trend
It is one that may be summarized by a straight line.Select one:a.outliersb.scatter plotc.nonlinear relationshipd.linear trend
Upgrade your grade with Knowee
Get personalized homework help. Review tough concepts in more detail, or go deeper into your topic by exploring other relevant questions.