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.
CS 340 Milestone One Guidelines and Rubric Overview: For this assignment, you will implement the fundamental operations of create, read, update,
Retail Transaction Programming Project Project Requirements: Develop a program to emulate a purchase transaction at a retail store. This
7COM1028 Secure Systems Programming Referral Coursework: Secure
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
CS 340 Final Project Guidelines and Rubric Overview The final project will encompass developing a web service using a software stack and impleme
Sun | Mon | Tue | Wed | Thu | Fri | Sat |
---|---|---|---|---|---|---|
29 | 30 | 31 | 1 | 2 | 3 | 4 |
5 | 6 | 7 | 8 | 9 | 10 | 11 |
12 | 13 | 14 | 15 | 16 | 17 | 18 |
19 | 20 | 21 | 22 | 23 | 24 | 25 |
26 | 27 | 28 | 29 | 30 | 31 | 1 |