
Thursday, 26 December 2013
Wednesday, 25 December 2013
Membuat sistem
Membuat sistem adalah bagaimana
1. menamakan inputan-inputan
2. bagaimana memproses inputan (+,-,/,*) sehingga menghasilkan outputan
1. menamakan inputan-inputan
2. bagaimana memproses inputan (+,-,/,*) sehingga menghasilkan outputan
MS. Excel: Data analysis
Analysis tools
1. Anova: Single Factor
2. Anova: Single Factor With Replication
3. Anova: Two-factor Without Replication
4. Correlation
5. Covariance
6. Descriptive Statistics
7. Exponential smoothing
8. F-test two Sample using variance
9. Fourier analysis
10. Histogram
11. Moving Average
12. Random Number Generation
13. Rank and Percentile
14. Regression
15. Sampling
Data:
1. Single data
2. Group of data
Upon sets of data:
1. find the simmilliarity
1. Anova: Single Factor
2. Anova: Single Factor With Replication
3. Anova: Two-factor Without Replication
4. Correlation
5. Covariance
6. Descriptive Statistics
7. Exponential smoothing
8. F-test two Sample using variance
9. Fourier analysis
10. Histogram
11. Moving Average
12. Random Number Generation
13. Rank and Percentile
14. Regression
15. Sampling
Data:
1. Single data
2. Group of data
Upon sets of data:
1. find the simmilliarity
MS. Excel: Perform a regression analysis
Their types
Types of regression:1. Linear regression
2. Exponential regression
3. Multiple regression
Their calculating
Linear regression
x is dependent
y is independent
LOGEST function
you use it to analyze data that is non-linear
GROWTH function
Find points that lie along that curve
SLOPE function
Tables
"Building a table is build a list of questions"
"Building a table is listing all the components and its range of values"
"Building a table is listing all the components and its range of values"
Tuesday, 24 December 2013
When did you use Microsoft excel VBA
Use microsoft excel vba when do:
1. Repetitive task (search and find)
2. Modified task
But the basic is excel menu itself. The VBA is just its complement.
1. Repetitive task (search and find)
2. Modified task
But the basic is excel menu itself. The VBA is just its complement.
Subscribe to:
Posts (Atom)