Excel is defined as being for numerical analysis and manipulation, so that is its purpose. A large amount of what it does deals with numbers. Much of that is in analysing figures to get all sorts of things, like totals, averages, ranking, frequency, validation, highest values, lowest values, most commonly occuring values and a wide range of other things.
There are a number of potential ways, but they come under the heading of What-If Analysis.
They are often used for when Excel is doing what is called What-If Analysis.
One can find an Excel data analysis program when one goes to the site of BPI Consulting. One can buy the program from the site to facilitate better statistical analysis in Microsoft Excel.
Spreadsheets like Excel are idea for doing What-If Analysis.Spreadsheets like Excel are idea for doing What-If Analysis.Spreadsheets like Excel are idea for doing What-If Analysis.Spreadsheets like Excel are idea for doing What-If Analysis.Spreadsheets like Excel are idea for doing What-If Analysis.Spreadsheets like Excel are idea for doing What-If Analysis.Spreadsheets like Excel are idea for doing What-If Analysis.Spreadsheets like Excel are idea for doing What-If Analysis.Spreadsheets like Excel are idea for doing What-If Analysis.Spreadsheets like Excel are idea for doing What-If Analysis.Spreadsheets like Excel are idea for doing What-If Analysis.
what-if analysis or sensitivity analysis Its What-if Analysis
The total number of columns in versions of Excel up to Excel 2003 is 256 columns. The total number of columns in Microsoft Excel 2007 and onwards is 16384. The total number of rows up to Excel 2003 is 65536. From Excel 2007 it is 1048576.
Excel is a spreadsheet and a spreadsheet is a tool for doing numerical analysis and manipulation. So Excel and any other spreadsheet application are ideal for doing statistical analysis. Excel has a huge range of ways of doing statistical analysis. It can be done through simple formulas, like totalling things up. It can be done with the specialised built-in statistical functions. It can be done by using a range of charts. There are lots of other special facilities too.
can anybody help me with this.
It is an add-in for Excel that allows the user to perform Quantitative Managerial Analysis functions. See related links for information.
Lotus 123 and Microsoft Excel are electronic spreadsheet applications. Both can be used for doing statistics because spreadsheets are for numerical analysis and manipulation.Lotus 123 and Microsoft Excel are electronic spreadsheet applications. Both can be used for doing statistics because spreadsheets are for numerical analysis and manipulation.Lotus 123 and Microsoft Excel are electronic spreadsheet applications. Both can be used for doing statistics because spreadsheets are for numerical analysis and manipulation.Lotus 123 and Microsoft Excel are electronic spreadsheet applications. Both can be used for doing statistics because spreadsheets are for numerical analysis and manipulation.Lotus 123 and Microsoft Excel are electronic spreadsheet applications. Both can be used for doing statistics because spreadsheets are for numerical analysis and manipulation.Lotus 123 and Microsoft Excel are electronic spreadsheet applications. Both can be used for doing statistics because spreadsheets are for numerical analysis and manipulation.Lotus 123 and Microsoft Excel are electronic spreadsheet applications. Both can be used for doing statistics because spreadsheets are for numerical analysis and manipulation.Lotus 123 and Microsoft Excel are electronic spreadsheet applications. Both can be used for doing statistics because spreadsheets are for numerical analysis and manipulation.Lotus 123 and Microsoft Excel are electronic spreadsheet applications. Both can be used for doing statistics because spreadsheets are for numerical analysis and manipulation.Lotus 123 and Microsoft Excel are electronic spreadsheet applications. Both can be used for doing statistics because spreadsheets are for numerical analysis and manipulation.Lotus 123 and Microsoft Excel are electronic spreadsheet applications. Both can be used for doing statistics because spreadsheets are for numerical analysis and manipulation.
The last row number for Excel 2007 is 1048576.
Spreadsheet applications are ideal for What-If Analysis. Excel lets you put in different formulas and different values for those formulas and then you can analyse the results when different combinations of values are used. All of this can be very quickly changed and different functions and features can be used to enhance this process, giving Excel a wide range ways of doing What-If Analysis effectively.