The assignment is to be submitted as a word document created in rmarkdown, with the rmarkdown documentused to create it.

The exercise consists of plotting with ggplot to better understand data, so called Exploratory Data Analysis.Plot and analyse using ggplot. You can use the ggplot builder in the Addins dropdown menu in the toolbar.

1.The caschool.rds dataset in the shared folder has school data. The caschool dataset has data on testscores and other variables for different school districts - see table below. Use ggplot to plot scatterplotsto see how other variables are correlated with the test scores. Interpret the results.

a) How is the student teacher ratiostrrelated to the testscore?

b) How is the share of english learnersel_pctrelated to testscore?

c) Repeat the plot in a) above, but now withel_pctas the color of each point

d) Repeat the plot with the average incomeavgincas the size of each point.

Variable

Description

testscr Average of math and english scores str Student teacher ratio county Name of county. calw_pct Percent qualifying for CalWorks (income assistance). meal_pct Percent qualifying for reduced-price lunch (for poor students). computer Number of computers per student. expn_stu School expenditure per student. avginc District average income (in USD 1,000).

2.The Excel file lengths.xlsx contains the length and weight of students and their gender. Plot a scatterplotwith different colors for men and women. What do you see?

3.This exercise will use thefilter()function in thetidyversepackages to select observations, andggplot to plot. The gapminder.rds dataset in the shared folder has data on life expectancy, GDP percapita and population over time for different years. Plot and interpret the results.

a)Plot the GDP growth over time for countries in Europe with different colored lines for each country.

b)Plot lifeExp and GDP as a scatterplot for Europe for a single year of your choice. Make the pointsize the population.

I would like to get your google drive link to upload excel files and dataset related to this exercise