Applied Econometrics. This work is due in 9 hours

YOU HAVE TO USE PROGRAM RSTUDIO  

Instruction: there is a dataset attached called “caschool”, it is an excel file. I also upload the description of the data. It is the explanation of the data. If you don’t read it you won’t be able to answer questions below. You should import the data into your RSTUDIO ( I will not accept excel solutions), and answer following questions: 

1. How many variables are in the data set?

2. What are “str” and “testscr” variables?(from the description)

3. What is the mean and variance of str and testscr (please provide units too)?

4. What is the correlation and covariance between str and testscr?

5. Provide the scatterplot between str and testscr?

6. What is standard deviation and standard error of each variable (please provide units too)?

7. Run a regression of testscr on str? What is the population model equation and what is the regression equation. 

8. What is the predicted testscr for a str of 20.