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

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

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

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.

## This note was uploaded on 05/17/2011 for the course ECO 220 taught by Professor Tanaka during the Spring '11 term at University of Toronto.

### 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
Ask a homework question - tutors are online