Assignment:
Use the data from the class survey. Prepare an Excel worksheet using the ages and the guessed income columns
|
Age
|
Guessed Incomes (in $1000s)
|
|
31
|
50
|
|
39
|
40
|
|
47
|
60
|
|
26
|
70
|
|
48
|
42
|
|
46
|
28
|
|
41
|
40
|
|
37
|
60
|
|
37
|
50
|
|
50
|
35
|
|
42
|
43
|
|
29
|
50
|
|
40
|
50
|
|
35
|
40
|
1. For each variable, get the summary statistics using the tools, data analysis
2. For each variable, get the mean and the standard deviation using the paste function.
3. For each variable, draw a histogram. Put appropriate labels on the histogram.
4. Using age as the x variable and guess income as the y variable, draw a scatterplot. Put appropriate labels on the scatterplot.
5. Find the linear regression line. Draw it on the scatterplot and label it with the proper equation.
6. Find the correlation coefficient, r. Also find r2