Statistics Analysis Calculations in MS Office Excel 2010
To calculate the statistics analysis calculations sometimes we are not enough to calculate it manually, because if only calculate the data then there are some digits are not terinput the analytical calculation result will be wrong and the resulting data is not valid or Balance. actually has a lot of applications that can be used to perform a statistical calculation using several tools such as: Matlab, SPSS, Statistica and others.
well this time I will give you tips and solutions on how to calculate the statistical data by using MS Office Excel is certainly on your computer and it is definitely installed Office already provides the facility to calculate the accounting data through the facilities of Add-ins that you can activate.
well we started just tips and solutions like this:
Video Enabling Add-in Statistics in MS Office Excel 2010
Analysis Toolpak add-ins is a ysng available in Microsoft Excel 2010 Analysis Toolpak In there are several facilities to analyze data such as Anova: Single Factor ANOVA: Two Factor With Replication, Anova: Two Factor withot Replication, Correlation, Covariance, Descriptive Statistics, Exponential Smoothing, F-Test Two-Sample for Variances, Fourier Analysis, Histogram, Moving Average, Random Number Generation, Rank and Percentile, Regression, Sampling, t-Test: Paired Two Sample for Means, t-Test: Two Sample Asumming Equal variances, t-Test: Two Sample Asumming Unequal variances
To enable the Analysis Toolpak Add-Ins in Excel 2010
- Click the Office button Select Excel Options
- When the Excel Options window select Add Ins In the Manage select Excel Add Ins, then click Go Dialog box appears. Akan Add-Ins Check the Analysis ToolPak Click OK
- If the message "Microsoft Office Excel can not run tthis add-in, This feature is not currently installed. Would you like to install it now?" Click Yes
- Configuration Progress window will appear below Wait until the process is complete install the add-ins
- If you successfully installed the add-in stretcher, it will appear at Exel new ribbon menu, the Data Analysis
- Display the features contained in the Data Analysis can be seen below
0 komentar:
Post a Comment