Question: Although the file is in the same folder where the project is located, R cannot see the data until you load it into memory (

Although the file is in the same folder where the project is located, R cannot see the
data until you load it into memory (until you load it into R itself). Remember you need
to tell R how you want it to remember the object for future references. In this case, I
chose the name schoolf_data, so I recall that it is about school finances (but of course,
you could have named it something else). To do that, run the following command (or
an appropriate modification if you want a different name):
schoolf_data-read.csv("ccd_finance16.csv")
You'll need to load the package ggplot2, dplyr, and readr. If you haven't already done
so, install them.
library (dplyr)
library (ggplot2)
library (readr)
Which and how many variables does this dataset contain? You can get a list using the
command names (), which should have the dataset you loaded as an argument. You can
see what each variable represents in the Dictionary section in this link.
What does each row (observation) of this dataset represent? Also, how many observations
does the dataset contains?
Add a new variable to the data called pupil_rev_total with total per-pupil revenue for
each school district (use the mutate function).
Try to estimate the average per pupil revenue of school districts in the U.S. in 2016 with
the function mean applied on the vector of data pupil_rev_total. Unfortunately, you
will not be able to see much besides an NA as the output.
It looks like some observations have missing data, ergo the NA you got above. Include the
na.rm=TRUE option to ignore these observations. Now, once mroe, what is the average
per pupil revenue of school districts in the U.S. in 2016? You should get a proper number
this time.
What is the standard deviation of per pupil revenue (you can use the function sd)? How
do you interpret this number?
 Although the file is in the same folder where the project

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!