Viva le Blog!
Internet and computer life
Wednesday, 25 December 2013
Membuat sistem
Membuat sistem adalah bagaimana
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
Wolframalpha
http://www.wolframalpha.com/
s
Wolfram is the chief designer of wolfram alpha
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"
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.
Thesaurus
The dinosaurus? No, thesaurus is similliarity of a meaning
Example:
Care = Mind, Worry, Attention, Custody, Caution, Treatment
Mind, worry, attention, custody, caution, treatment are care's similliar meaning
Newer Posts
Older Posts
Home
Subscribe to:
Posts (Atom)