La herramienta de escenario Buscar objetivo es complementaria a la herramienta escenario de What if .The Goal Seek scenario tool is complementary to the What If scenario tool.La herramienta qué le indica el impacto de realizar un cambio, mientras que la herramienta Buscar objetivo le indica los factores subyacentes que deben cambiar para lograr el resultado deseado.The What-If tool tells you the impact of making a change, whereas the Goal Seek tool tells you the underlying factors that must change to achieve a desired result.
![]() -->
Excel keyboard shortcuts for U.S. Keyboard layout for Windows, Mac, iOS, Android, Windows 10 app, and Web.
Por ejemplo, supongamos que su objetivo es aumentar la satisfacción del cliente.For example, let's say your goal is to increase customer satisfaction.Puede usar el análisis de búsqueda de objetivo para determinar qué factores serían más probables para aumentar la satisfacción del cliente y decidir si esos cambios son rentables.You can use Goal Seek analysis to determine which factors would be most likely to increase customer satisfaction, and decide whether those changes are cost-effective.
Cuando la herramienta finaliza su análisis, crea dos columnas nuevas en la tabla de datos de origen.When the tool finishes its analysis, it creates two new columns in the source data table.Estas columnas muestran la probabilidad de que se pueda lograr el resultado de destino y el cambio recomendado, si existe.These columns show the likelihood that the targeted outcome can be achieved, and the recommended change, if any.
La herramienta puede analizar un conjunto de datos y hacer predicciones para el conjunto completo; también es posible crear el análisis y, a continuación, ir probando los escenarios de uno en uno.The tool can analyze a set of data and make predictions for the entire set, or you can create the analysis and then test scenarios one at a time.
Usar la herramienta de escenario Buscar objetivoUsing the Goal Seek Scenario Tool
RequisitosRequirements
Esta herramienta usa el algoritmo de regresión logística de Microsoft, que puede procesar valores numéricos o discretos.This tool uses the Microsoft Logistic Regression algorithm, which can process either numeric or discrete values.
Puede ejecutar la predicción varias veces y seleccionar otras columnas posteriormente, pero cada combinación de un objetivo y un cambio debe calcularse de forma independiente.You can run the prediction multiple times, and select different columns later, but each combination of a goal and a change must be calculated separately.
Puede obtener mejores resultados si selecciona columnas para el análisis que contengan información útil.You can achieve better results if you select columns for analysis that contain useful information.No obstante, si incluye muy pocas columnas, puede resultar difícil obtener un resultado.However, if you include too few columns, it might be difficult to obtain a result.
Cuando cree predicciones de una en una, asegúrese de que selecciona una fila que no contiene el resultado deseado o puede obtener un error.When you create predictions one at a time, be sure to select a row that does not already contain the desired result, or you may get an error.En otras palabras, si el propósito de la búsqueda de un objetivo consiste en determinar factores que animan a comprar bicicletas, solo debería incluir los clientes que no han comprado una bicicleta.In other words, if the purpose of goal seeking is to determine factors that encourage bike purchases, you should only include customers who did not purchase a bike.
Descripción de los resultados de un análisis Buscar objetivoUnderstanding the Results of Goal Seek Analysis
Cuando se crea un escenario de búsqueda de objetivo, la herramienta hace tres cosas:When you create a goal seeking scenario, the tool does three things:
Si prueba los escenarios de búsqueda de objetivo de uno en uno, puede ver los resultados interactivamente.If you test goal-seeking scenarios one at a time, you can view the results interactively.Esto es lo mismo que crear una consulta de predicción singleton.This is the same as creating a singleton prediction query.
La herramienta informa en el panel de resultados del cuadro de diálogo si fue correcto encontrar un escenario que logre el objetivo deseado.The tool reports in the Results pane of the dialog box whether it was successful in finding a scenario that achieves the desired goal.Si se encontró una solución correcta, la herramienta también genera una recomendación que le indica el cambio necesario.If a successful solution was found, the tool also generates a recommendation that tells you the required change.Por ejemplo, la herramienta Buscar objetivo puede indicarle que la distancia de trabajo debe ser inferior a 5 kilómetros.For example, the Goal Seek tool might tell you that the commuting distance should be less than 5 miles.
Resultados de ejemplo:Example results:
La búsqueda de objetivo para Interest in Buying encontró una solución.Goal Seeking for Interest in Buying has found a solution.
Coincidencia más cercana obtenida al cambiar 'Conmute distance' a '2-5 miles'.Closest match obtained by changing 'Commute distance' to '2-5 miles'.
Dado que este resultado se basa en una fila existente de la tabla de datos, eso significa que, para un cliente concreto, si todos los demás datos sobre ese cliente permanecieran iguales, pero su distancia al trabajo se redujera hasta situarse entre 2 y 5 millas, habría más probabilidades de que comprase una bicicleta.Because this result is based on an existing row in the data table, it means that, for a particular customer, if all else about the customer stayed the same but the customer's commute was reduced to 2-5 miles, the customer would be somewhat more likely buy a bicycle.
Si crea predicciones de búsqueda de objetivos para todas las filas de la tabla de Excel especificando toda la tabla, la herramienta crea dos nuevas columnas en la tabla de datos original.If you create goal-seeking predictions for all the rows in the Excel table by specifying Entire table, thetool creates two new columns in the original data table.La primera columna que se agrega a la tabla contiene una marca de verificación en un círculo verde para indicar que se puede conseguir el objetivo o una marca X en un círculo rojo para indicar que no es posible realizar ningún cambio que permita alcanzar el objetivo.The first column that is added to the table contains either a check mark in a green circle, to indicate that the goal can be met, or an X mark in a red circle, to indicate that no changes can be made that will enable the goal.
La segunda columna contiene el cambio recomendado.The second column contains the recommended change.
Nota
El nivel de confianza de la recomendación y su éxito están predeterminados por el algoritmo y no se pueden cambiar.The confidence level for the recommendation and its success are predetermined by the algorithm and cannot be changed.
Herramientas relacionadasRelated Tools
El Cliente de minería de datos para Excel, que es un complemento independiente que ofrece funciones de minería de datos más avanzadas, incluye asistentes para crear modelos de minería de datos que predicen el comportamiento.The Data Mining Client for Excel, which is a separate add-in that provides more advanced data mining functionality, includes wizards for creating data mining models that predict behavior.Para obtener más información, vea crear un modelo de minería de datos.For more information, see Creating a Data Mining Model.
Para obtener más información acerca del algoritmo usado por la herramienta de escenario Buscar objetivo , vea el tema 'algoritmo de regresión logística SQL ServerSQL Server de Microsoft' en los libros en pantalla de.For more information about the algorithm used by the Goal Seek scenario tool, see the topic 'Microsoft Logistic Regression Algorithm' in SQL ServerSQL Server Books Online.
Consulte tambiénSee Also
Excel for Office 365 Excel for Office 365 for Mac Excel for the web Excel 2019 Excel 2016 Excel 2019 for Mac Excel 2013 Excel 2010 Excel 2007 Excel 2016 for Mac Excel for Mac 2011 Excel for iPad Excel for iPhone Excel for Android tablets Excel for Android phones Excel for Windows Phone 10 Excel MobileMany users find that using an external keyboard with keyboard shortcuts for Excel helps them work more efficiently. For users with mobility or vision disabilities, keyboard shortcuts can be easier than using the touchscreen, and are an essential alternative to using a mouse. Notes:.To quickly find a shortcut in this article, you can use the Search. Tip: You can also select Home Paste Paste Special.To pick an option in the dialog, press the underlined letter for that option.
Notes:.The settings in some versions of the Mac operating system (OS) and some utility applications might conflict with keyboard shortcuts and function key operations in Office for Mac. For information about changing the key assignment of a keyboard shortcut, refer to Mac Help for your version of the Mac OS, your utility application, or refer to.If you don't find a keyboard shortcut here that meets your needs, you can create a custom keyboard shortcut. For instructions, go to.Many of the shortcuts that use the Ctrl key on a Windows keyboard also work with the Control key in Excel for Mac.
However, not all do.To quickly find a shortcut in this article, you can use the Search. Note: Changing system function key preferences affects how the function keys work for your Mac, not just Excel for Mac. After changing this setting, you can still perform the special features printed on a function key. Just press the FN key. For example, to use the F12 key to change your volume, you would press FN+F12.If a function key doesn't work as you expect it to, press the FN key in addition to the function key. If you don't want to press the FN key each time, you can change your Apple system preferences. Notes:.If you're familiar with keyboard shortcuts on your MacOS computer, the same key combinations work with Excel for iOS using an external keyboard, too.
The shortcuts listed in this article are the only ones that will work in this version of Excel.To quickly find a shortcut, you can use the Search. Notes:.If you're familiar with keyboard shortcuts on your Windows computer, the same key combinations work with Excel for Android using an external keyboard, too. The shortcuts listed in this article are the only ones that will work in this version of Excel.To quickly find a shortcut, you can use the Search. Press Ctrl+F and then type your search words.In this topic.Navigate the worksheetToPressMove one cell to the rightTab keyMove one cell up, down, left, or rightArrow keysWork with cellsToPressSaveControl+SCopyControl+CPasteControl+VCopy formattingControl+Shift+CCutControl+XUndoControl+ZRedoControl+Y orControl+Shift+ZBoldControl+BItalicControl+IUnderlineControl+USelect allControl+AFindControl+FInsert a line break within a cellAlt+EnterSee also. Notes:.If you're familiar with keyboard shortcuts on your Windows computer, the same key combinations work with Excel Mobile using an external keyboard, too. The shortcuts listed in this article are the only ones that will work in this version of Excel.To quickly find a shortcut, you can use the Search. Notes:.To quickly find a shortcut, you can use the Search.
Press Ctrl+F and then type your search words.When you use Excel for the web, we recommend that you use Microsoft Edge as your web browser. Because Excel for the web runs in your web browser, the keyboard shortcuts are different from those in the desktop program. For example, you’ll use Ctrl+F6 instead of F6 for jumping in and out of the commands.
Also, common shortcuts like F1 (Help) and Ctrl+O (Open) apply to the web browser – not Excel for the web.If you use Narrator with the Windows 10 Fall Creators Update, you have to turn off scan mode in order to edit documents, spreadsheets, or presentations with Office for the web. For more information, refer to.In this article.Quick tips for using keyboard shortcuts with Excel for the web.You can find any command quickly by pressing Alt+Windows logo key+Q to jump to Tell Me, In Tell Me, you can just type a word or the name of a command you want (available only in Editing view). Tell Me searches for related options, and provides a list. Tips: If a spreadsheet opens in the Reading view, editing commands won’t work.
![]() Comments are closed.
|
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
January 2023
Categories |