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.x y7.4 5.336.3 11.181.5 9.325.7 12.124.5 13.62.6 12.536.1 9.576.5 9.31253.8 13.972.1 10.25Group of answer choicesExponentialLinearThere is no discernable trend.Quadratic
Question
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.x y7.4 5.336.3 11.181.5 9.325.7 12.124.5 13.62.6 12.536.1 9.576.5 9.31253.8 13.972.1 10.25Group of answer choicesExponentialLinearThere is no discernable trend.Quadratic
Solution
-
Abre Microsoft Excel.
-
Copia y pega los datos proporcionados en dos columnas, una para "x" y otra para "y".
x y 7.4 5.33 6.3 11.18 1.5 9.32 5.7 12.12 4.5 13.6 2.6 12.5 6.1 9.57 6.5 9.31 3.8 13.97 2.1 10.25 -
Selecciona los datos de ambas columnas.
-
Ve a la pestaña "Insertar" y selecciona "Gráfico de dispersión" (Scatterplot).
-
Observa el gráfico de dispersión generado.
Para determinar la mejor línea de tendencia:
- Haz clic derecho en uno de los puntos de datos en el gráfico.
- Selecciona "Agregar línea de tendencia" (Add Trendline).
- Prueba con las diferentes opciones de líneas de tendencia: lineal, cuadrática (polinómica de orden 2) y exponencial.
- Observa cuál de las líneas de tendencia se ajusta mejor a los datos.
Con base en la observación del gráfico y las líneas de tendencia, selecciona la opción que mejor represente los datos:
- Exponencial
- Lineal
- No hay una tendencia discernible.
- Cuadrática
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
Angela calculates statistics for her company. She collected data on the number of items in an order and the profit the order made. She created the following scatterplot. If a new order has 54 items, predict the profit the order will make. To do this, use Excel to find a trendline. Then use the trendline to predict the number of dollar in profit the company can expect. Round to the nearest dollar.Items Profit48 344842 410939 473349 316345 387518 436620 445522 468035 472916 402029 514513 3555Group of answer choices$2050 in profit$2405 in profit$2108 in profit$2099 in profit
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.