Assignment of AI and data science

  How to use goal seek in Excel Let’s learn how to use the goal seek function in Excel 👍🏻 Go to the data tab. 2. Expand the What-if analysis tools list in the forecast group. Click Goal seek to open the goal seek dialog box. Select the formula cell that you want to get the desired result into the set cell box. Enter the desired output in the “to value” cell box. Select the variable input cell for the “By changing cell” box. Click OK to get the goal seek status dialogue box. The goal seek status will show whether it found a solution or not. It will also show you, the new input value to get the given value for the target cell.  FINAL OUTPUT:- BEFORE:- AFTER:-

Use Scenario Manager Using Scenario Manager in Excel can help you analyze different sets of data and see how changes in variables can affect your results. Essentially, you’ll be able to create various "what-if" scenarios to predict outcomes and make informed decisions. By the end of this guide, you’ll be able to set up and use Scenario Manager with ease. Steps to do scenario manager Step 1: Open your Excel file Open your Excel file where you want to use Scenario Manager. Make sure your data is well-organized with clear headings and values. This will help you easily identify which cells you want to change. Step 2: Go to the Data tab Click on the "Data" tab at the top of the Excel window. The Data tab contains numerous tools for data analysis, including the Scenario Manager. Step 3: Click on What-If Analysis In the Data tab, find the "What-If Analysis" option and click on it. This will open a dropdown menu that includes different tools for forecasting and sc...

  What is it? The  data table in Excel  can be used to change two variables. Users need to provide input variables. Excel returns the output based on the formula and variables given by the users. Step 1:  Create a table with various interest rates, as shown in the below image. Step 2:  In the formula cell (H14), type the actual EMI formula, i.e., cell K10. Step 3:  Select the newly created table. Go to the  Data . Under the Forecast group, click on the  What-If Analysis  drop-down list and choose the  Data Table .  Click in the 'Column input cell' box (the percentages are in a column) and select cell h11. We select cell h11 because the percentages refer to cell h11 (% sold for the highest price).  Note: this is a one variable data table so we leave the Row input cell blank. 4. Click OK. Result:

  Steps to create dropdown list Prepare Your List: First, create a list of items you want to appear in the drop-down list. Enter these items in a single column or row in your worksheet. For example, you can enter them in cells c7 to c18. Output:- Select the Cell for the Drop-Down: Click on the cell where you want the drop-down list to appear. Output:- Open Data Validation: Go to the  Data  tab on the Ribbon. Click on  Data Validation  in the Data Tools group. Output:- Set Up Data Validation: In the Data Validation dialog box, go to the  Settings  tab. In the  Allow  box, select  List . Output:- Enter the Source: In the  Source  box, enter the range of cells that contain your list items. For example, if your list is in cells  C8 to C18enter =$C$8:$C$18 Alternatively, you can click the small button to the right of the Source box and then select the range directly on the worksheet. Output:-   Complete the Setup: Cli...