Author: Anonymous

In the carsReal data frame, cars of which condition have the lowest variability in price?

Midterm.RData Download the file Midterm.RData to a known location. (Sometimes the download process changes the name of the file by appending (1) or (2), etc. to the file name. If this happens, be sure to rename the local file to just Midterm.RData.)Load the RData file by, at the R prompt, typing:> load(“Midterm.RData”)Note the quotation marks around the file name. This will result in a data frame called cars being placed in your global environment. This is data regarding used cars posted for sale on Craig’s List. The column (variable) names should be self explanatory. Note that lat refers to latitude and long refers to longitude. For all exam questions referring to this data, you should do all your work in R.How many columns (variables) does the data frame have?

Create a column chart of the number of cars in carsReal by size. When the chart has been created, click on Export in the Plot window, then Save as Image, then save the file (it will save to your working directory), and then attach the file and submit it here.

Which color is the “least popular” in the data frame — that is, the fewest cars in the data frame have this color. Enter the color below exactly as it appears in the data frame.

Provide below the Excel expression you’d put in cell M2 to determine total Sales (that is total $ value) of all Paperback books sold to Females older than 25. Use the cells M4, M5 and M6 in your expression. (You do not have to copy this expression down.)

Provide below the Excel expression you’d put in cell K19 to show number of purchasers between the ages of 10 and 15 inclusive. You should be able to copy your expression down to provide the number of purchasers in the other age ranges provided.

How many cars in the carsReal data frame have a price

Provide the R expression below to create a new column in the carsReal data frame called HighMileage that has TRUE if the odometer value is greater than 100,000 and FALSE otherwise.

Provide below what you would need to add to your original, default histogram statement to specify that the y axis should start at 0 and end at 70,000. (Again, do not repeat the entire statement, just what you need to add to it.

Which of the following is an appropriate plot for the variable transmission?