![what is the quick analysis tool in excel? what is the quick analysis tool in excel?](https://www.tutorialspoint.com/excel_data_analysis/images/sparklines.jpg)
read more.Īssume you are a selling a 1000 product at 15 rupees, your total anticipated expense is 12500 and profit is 2500. The data inputs in one variable data table are either in a single column or across a row. read more.” In this article, I will show you One variable data table in Excel One Variable Data Table In Excel One variable data table in excel means changing one variable with multiple options and getting the results for multiple scenarios.
![what is the quick analysis tool in excel? what is the quick analysis tool in excel?](https://www.pcassistonline.co.uk/HelpandAdvice/images/quickanalysistool_excel_2016.png)
In simple terms, it helps determine what effect does changing the two variables have on the result.
![what is the quick analysis tool in excel? what is the quick analysis tool in excel?](https://howtoexcelatexcel.com/wp-content/uploads/2020/09/Quick-Analysis-Sparklines-1024x574.gif)
We have two kinds of data tables here “One variable data table” and “ Two-variable data table Two-variable Data Table A two-variable data table helps analyze how two different variables impact the overall data table. The data table can create different scenario tables based on the change of variable. We have already seen two wonderful techniques under What-If Analysis in Excel. In order to get an overall average of 85, Andrew has to score 99 in the final exam. Excel will take a few seconds to complete the process, but eventually, it shows the end result like the below one. So we need to change the cell B6, which is the cell for the final subject’s score. The next and final part is by changing which cell you want to see the impact. This is nothing but for what value we need to set the cell, i.e., Andrew’s overall average GOAL (85).
![what is the quick analysis tool in excel? what is the quick analysis tool in excel?](https://www.excel-easy.com/examples/images/quick-analysis/quick-analysis-tool.png)
Set Cell is nothing but which cell we need the final result, i.e., our overall average cell (B7).