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
7. Print each graph on a separate sheet. Be sure your name is on each page that you print.
8. Print your worksheet.
Use a highlighter or colored ink to mark your answers on the worksheet. Label each answer with the number of the exercise that it is addressing.