Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

please use Rstudio USE RSTUDIO PLEASEEEE 1. MInneapolis2013.txt Download the minneapolis2013.txt on Canvas and answer these following questions. Check the following link to learn about

please use Rstudio image text in transcribedUSE RSTUDIO PLEASEEEE

1. MInneapolis2013.txt Download the minneapolis2013.txt on Canvas and answer these following questions. Check the following link to learn about the data Minneapolis2013. a. (1 pts) Read as a data frame and assign it to and print first 3 cases. b. (1 pts) How many cases are there? c. (1 pts) How many unique values in the variable? - Hint: use function. d. (1 pts) How many cases have as their first choice? e. (2 pts) How many cases have as their first, as second, and third choice? Print all cases that satisfy the above conditions. 2. us_rent_income in \#install_packages("tidyr") library(tidyr) data( "us_rent_income") rent $ variable == "income"), ] a. (1 pts) Which states have median rent that is greater than 1,300 and less than 1,500? b. (1 pts) Which states have median rent that is greater than 1,500 or less than 500 ? c. (1 pts) How to check if all states have median rent that is less than 2,000 ? d. (1 pts) Check if the state names and their orders are the same in the income and rent data frames. e. (1 pts) Print the states where median income is less than 30,000 and median rent is greater than 1,000. f. (2 pts) Create a subset income 1 from by only including the cases where median income is greater than 35,000 or less than 25,000 . Check if there is any missing values in income1 . g. (1 pts) Create a subset rent1 from rent by deleting GEoID variable. Then, check the number of rows and columns. h. (1 pts) Create a subset rent_Cent_East from rent 1 by excluding following 13 states: "Nevada", "New Mexico", "Montana", "Arizona", "Idaho", "Alaska", "Oregon", "Wyoming", "Washington", "Utah", "California", "Colorado", "Hawaii". How many cases remain in rent_Cent_East

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Database Design And SQL For DB2

Authors: James Cooper

1st Edition

1583473572, 978-1583473573

More Books

Students also viewed these Databases questions

Question

Choosing Your Topic Researching the Topic

Answered: 1 week ago

Question

The Power of Public Speaking Clarifying the

Answered: 1 week ago