課程大綱： Excel For Statistical Data Analysis培訓
Aggregating Data in Excel
Statistical Functions
Outlines
Subtotals
Pivot Tables
Data Relation Analysis
Normal Distribution
Descriptive Statistics
Linear Correlation
Regression Analysis
Covariance
Analysing Data in Time
Trends/Regression line
Linear, Logarithmic, Polynomial, Power, Exponential, Moving Average Smoothing
Seasonal fluctuations analysis
Comparing Populations
Confidence Interval for the Mean
Test of Hypothesis Concerning the Population Mean
Difference Between Mean of Two Populations
ANOVA: Analysis of Variances
Goodness-of-Fit Test for Discrete Random Variables
Test of Independence: Contingency Tables
Test Hypothesis Concerning the Variance of Two Populations
Forecasting
Extrapolation
加入高級會員獲得助教答疑
