Jan_31 - ECM Tutorial Jan 31-Feb 4, 2011 Review: We have...

Info iconThis preview shows pages 1–2. Sign up to view the full content.

View Full Document Right Arrow Icon
ECM Tutorial Jan 31-Feb 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 R-squared 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
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Image of page 2
This is the end of the preview. Sign up to access the rest of the document.

Page1 / 2

Jan_31 - ECM Tutorial Jan 31-Feb 4, 2011 Review: We have...

This preview shows document pages 1 - 2. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online