I want to see my output in a new worksheet. Or you can see the output into a new workbook.You can also show the output in a new worksheet, by default this option is selected.
You can show your output in the same worksheet, in that case, you will select the Output range option and on the right side field, you will set the cell where you want to see the output. In the bin range, I select values in the cells B2 to B11. You can now complete a number of advanced data analysis tasks using Excel. In the Input range, I select these values from cell A2 to A41. After you have added the Analysis ToolPak to your Excel software, you will find it on the Data tab. Or I can double click on the histogram option. You will find several Data Analysis tools in the window. Creating Histogram Using Analysis ToolPakĬlick on the Data Analysis command in the data tab. Now you find the Data Analysis command will be showing under the Analysis group of commands in the Data tab. If you don't have it installed, and you can't find your original Microsoft Office discs, then you may be at a loss. 
Microsoft Excel tidak hanya digunakan sebagai tempat untuk menghimpun data tetapi juga dapat digunakan untuk.
Analysis ToolPak check box is not selected. The Analysis ToolPak is used to add some very handy worksheet functions to Excel. Microsoft Excel merupakan salah satu software yang paling populer dan mudah digunakan. under Manage drop-down, Excel Add-ins is already selected.
0 kommentar(er)
