This preview shows pages 1–2. Sign up to view the full content.
ECM Tutorial Jan 31Feb 4, 2011
Review:
We have three objectives in this tutorial.
First, use scatter plot to analyze the linear relationship between two variables. You
need to know how to plot a scatter graph, add a linear trendline and display fitted
equation and Rsquared value on chart.
Second, use Excel to generate random numbers. Calculate summary statistics.
Third, calculate the Normal/t/F accumulative distribution functions. Also, give
probability, calculate the value of a normally/t/F distributed random variable.
Commands:
Mean: “=average(a1:a100)”; Variance: “=var(a1:a100)”;
Median:“=median(a1:a100)”; Standard deviation: “=stdev(a1:a100)”;
Correlation: “=correl(a1:a100,b1:b100)”;
Roundup: “=roundup(a1:a100,0)” (Numbers saved in A1:A100 will be converted
into integers, or numbers without dismal. If you want them to be numbers with one
place dismal, type in “=roundup(a1:a100,1)”.)
Accumulative normal distribution:
“ = n o r m d i s t (
x
,
m i u
,
s i g m a
This preview has intentionally blurred sections. Sign up to view the full version.
View Full Document
This is the end of the preview. Sign up
to
access the rest of the document.
 Spring '11
 tanaka

Click to edit the document details