1. Working with a "real" sample
The attached file Exchange-Traded_Funds.csv lists a sample of
percent dividend yield for a
selection of ETFs. For the purpose of an exercise in descriptive statistics, consider it a simple
random sample of size 50 (even if we don’t really know how this sample was chosen)
Compute the following for the sample:
•Sample Mean
•Sample Variance
•Sample Standard Deviation
•Median
•1st and 3rd quartiles
•Have your spreadsheet draw a histogram
2 Regression
The data in the file lit-life.csv lists life expectancy and literacy rate for 107 countries. Determine
the correlation and the regression line equation, and include a data scatterplot, as well as a consider it a simple
random sample of size 50 (even if we don’t really know how this sample was chosen)
Compute the following for the sample:
•Sample Mean
•Sample Variance
•Sample Standard Deviation
•Median
•1st and 3rd quartiles
•Have your spreadsheet draw a histogram
2 Regression
The data in the file lit-life.csv lists life expectancy and literacy rate for 107 countries. Determine
the correlation and the regression line equation, and include a data scatterplot, as well as a