Error log VBA

1. #NAME?
Example:
=cetak
using incomplete(do not list a parameter); calling a function but do not supply argument
=aloha()
calling unexist function
=aloha
calling unexist function (although with different notation)

2. #VALUE?
Example:
=mesin()
"not supplying parameters"

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

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

List of methods (function) of a cell

List of methods (function) of a cell, a block of cells (they are having same methods):
1. Activate
2. AddComment
3. AdvancedFilter
4. ApplyNames
5. ApplyOutlineStyles
6. AutoComplete
7. AutoFill
8. AutoFilter
9. AutoFit
10. AutoOutline
11. BorderAround
12. Calculate
13. CalculateRowMajorOrder
14. CheckSpelling
15. Clear
16. ClearComments
17. ClearContents
18. ClearFormats
19. ClearNotes
20. ClearOutline
21. ColumnDifferences
22. Consolidate
23. Copy
24. CopyFromRecordSet
25. CopyPicture
26. CreateNames
27. Cut
28. DataSeries
29. Delete
30. DialogBox
31. Dirty
32. EditionOptions
33. ExportAsFixedFormat
34. FillDown
35. FillLeft
36. FillRight
37. FillUp
38. Find
39. FindNext
40. FindPrevious
41. FunctionWizard
42. Group
43. Insert
44. InsertIndent
45. Justify
46. ListNames
47. Merge
48. NavigateArrow
49. NoteText
50. Parse
51. PasteSpecial
52. PrintOut
53. PrintPreview
54. RemoveDuplicates
55. RemoveSubtotals
56. Replace
57. RowDifferences
58. Run
59. Select
60. SetPhonetic
61. Show
62. ShowDependents
63. ShowErrors
64. ShowPrecedents
65. Sort
66. SortSpecial
67. Speak
68. SpecialCells
69. SubscribeTo
70. SubTotal
71. Table
72. TextToColumns
73. Ungroup
74. Unmerge