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