-What-if analysis is a tool used to analyse data deeply regarding to your perspective.Like when you have your results but you want to see how other inputs works.
-IT is uses three tools to be effective,which allows one to switch between snenarios.
-You can put a value in a certain cell of a column to attain a certain prediction you want hence it will give the outcome or rather one can use the total amount to predict a score for a student in a subject.eg:
when predicting a total amount of a sale,,,
-It has three tools that it uses:
1.Scenario Manager
-This allows the user to use cases as he/she might want(average,medium,high) to determine different cells of a column in a table to get the end goal by using the (sncenarios).Then it has a summary feature where one can view the summary of the cases.
2.Goal seek
-This helps one to determine the value required to find the end goal:For example when you have the total scores of students in maths,,but one student is missing a mark,,you use the goal seek with the value of the total marks to get the mark of missing student.
3.Data table
-This is making a table out of the original data that you may want to use.
You definetly highlight the columns and rows or variables you want from the table.
Top comments (0)