Select all columns except DISTID, DISTNAME and PSUID and store it as a tibble called ihdstbl1.

INSTRUCTIONS TO CANDIDATES

ANSWER ALL QUESTIONS

Instructions

1. Find your sheet in the excel file shared with you and save it as a separate excel workbook.

2. install the “readxl” package.

3. import the data from excel into R and store it as a table called ihdstbl by using the following command:

ihdstbl <- readxl::read_xlsx(file.choose())

4. A window will pop up. Locate and choose the excel file you had just created.

5. Work on the Source pane, and save your script as a .R file which has to be submitted.

Questions

Question 1

Select all columns except DISTID, DISTNAME and PSUID and store it as a tibble called ihdstbl1.

Question 2

Create a pivot table grouped by STATEID with columns that display for each state, the following summaries:

1. median of COPC called median_consumption.

2. median of NWORK called employd_persons_activity_hh.

3. mean of HHASSETS called hh_assets.

4. mean of INCOME called income

Store this as new_tbl.

 

Attachments:

Related Questions

. The fundamental operations of create, read, update, and delete (CRUD) in either Python or Java

CS 340 Milestone One Guidelines and Rubric  Overview: For this assignment, you will implement the fundamental operations of create, read, update,

. Develop a program to emulate a purchase transaction at a retail store. This  program will have two classes, a LineItem class and a Transaction class

Retail Transaction Programming Project  Project Requirements:  Develop a program to emulate a purchase transaction at a retail store. This

. The following program contains five errors. Identify the errors and fix them

7COM1028   Secure Systems Programming   Referral Coursework: Secure

. Accepts the following from a user: Item Name Item Quantity Item Price Allows the user to create a file to store the sales receipt contents

Create a GUI program that:Accepts the following from a user:Item NameItem QuantityItem PriceAllows the user to create a file to store the sales receip

. The final project will encompass developing a web service using a software stack and implementing an industry-standard interface. Regardless of whether you choose to pursue application development goals as a pure developer or as a software engineer

CS 340 Final Project Guidelines and Rubric  Overview The final project will encompass developing a web service using a software stack and impleme