In a longitudinal study, patients has been recruited and followed up for a certain length of...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
In a longitudinal study, patients has been recruited and followed up for a certain length of time. During this period data has been collected for several variables as described below. Id= patients identification number hospAd date of hospital admission hospDis == date of hospital discharge DOB date of birth death death (1= yes) reHosprehospitalization (1 = yes) drVisIP = In person Dr. Visit (1= yes) drVisVR = virtual Dr. Visit (1= yes) datv = days at vacation Question to answer using R. Must provide R code and answer. 1. Average days in hospital 2. Average age of pts as of jan01,2023 3. How many patients have (a) died, (b) re-hopitalized 4. How many patients have any Dr visit 5. Provide summary statistics for the vacation days. Provide your comment for general population so that they have an understanding about the data. id hospAd hosp Dis 1948-07-23 96001 2020-04-20 2020-04-24 96002 2020-04-21 2020-04-25 1943-08-17 96003 2020-04-20 2020-04-27 1960-04-17 96004 2020-04-23 2020-05-01 1958-06-20 96005 2020-04-19 2020-04-27 1960-05-18 96006 2020-04-24 2020-04-27 1938-09-14 96007 2020-04-22 2020-04-27 1953-09-08 96008 2020-04-20 2020-04-27 1938-06-21 96009 2020-04-23 2020-04-28 1948-11-12 96010 2020-04-15 2020-04-29 1950-08-15 96011 2020-04-22 2020-04-30 1963-01-15 96012 2020-04-22 2020-05-02 1963-07-16 96013 2020-04-20 2020-05-03 1969-03-03 96014 2020-04-23 2020-05-03 1962-03-16 96015 2020-04-29 2020-05-03 1936-08-02 96016 2020-04-20 2020-05-04 1959-11-26 96017 2020-04-30 2020-05-04 1953-05-17 96018 2020-04-30 2020-05-03 1960-07-03 96019 2020-05-03 2020-05-04 1977-07-30 96020 2020-05-04 2020-05-05 1944-08-19 96021 2020-04-20 2020-05-05 1959-05-21 96022 2020-04-29 2020-05-06 1964-05-26 96023 2020-04-26 2020-05-06 1944-09-30 96024 2020-04-28 2020-05-07 1942-01-28 96025 2020-05-07 2020-05-08 1964-06-15 96026 2020-05-02 2020-05-09 1963-03-15 96027 2020-05-10 2020-05-11 1949-01-17 96028 2020-04-30 2020-05-10 1961-10-07 DOB death reHosp 1 1 1 1 1 1 1 1 drVislP 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 drVisVR 1 1 1 1 1 1 1 - PT 1 1 1 1 1 1 1 1 1 1 1 datV 22 31 31 27 28 31 30 31 20 31 30 31 31 31 31 31 31 31 31 31 31 26 31 31 29 26 31 31 In a longitudinal study, patients has been recruited and followed up for a certain length of time. During this period data has been collected for several variables as described below. Id= patients identification number hospAd date of hospital admission hospDis == date of hospital discharge DOB date of birth death death (1= yes) reHosprehospitalization (1 = yes) drVisIP = In person Dr. Visit (1= yes) drVisVR = virtual Dr. Visit (1= yes) datv = days at vacation Question to answer using R. Must provide R code and answer. 1. Average days in hospital 2. Average age of pts as of jan01,2023 3. How many patients have (a) died, (b) re-hopitalized 4. How many patients have any Dr visit 5. Provide summary statistics for the vacation days. Provide your comment for general population so that they have an understanding about the data. id hospAd hosp Dis 1948-07-23 96001 2020-04-20 2020-04-24 96002 2020-04-21 2020-04-25 1943-08-17 96003 2020-04-20 2020-04-27 1960-04-17 96004 2020-04-23 2020-05-01 1958-06-20 96005 2020-04-19 2020-04-27 1960-05-18 96006 2020-04-24 2020-04-27 1938-09-14 96007 2020-04-22 2020-04-27 1953-09-08 96008 2020-04-20 2020-04-27 1938-06-21 96009 2020-04-23 2020-04-28 1948-11-12 96010 2020-04-15 2020-04-29 1950-08-15 96011 2020-04-22 2020-04-30 1963-01-15 96012 2020-04-22 2020-05-02 1963-07-16 96013 2020-04-20 2020-05-03 1969-03-03 96014 2020-04-23 2020-05-03 1962-03-16 96015 2020-04-29 2020-05-03 1936-08-02 96016 2020-04-20 2020-05-04 1959-11-26 96017 2020-04-30 2020-05-04 1953-05-17 96018 2020-04-30 2020-05-03 1960-07-03 96019 2020-05-03 2020-05-04 1977-07-30 96020 2020-05-04 2020-05-05 1944-08-19 96021 2020-04-20 2020-05-05 1959-05-21 96022 2020-04-29 2020-05-06 1964-05-26 96023 2020-04-26 2020-05-06 1944-09-30 96024 2020-04-28 2020-05-07 1942-01-28 96025 2020-05-07 2020-05-08 1964-06-15 96026 2020-05-02 2020-05-09 1963-03-15 96027 2020-05-10 2020-05-11 1949-01-17 96028 2020-04-30 2020-05-10 1961-10-07 DOB death reHosp 1 1 1 1 1 1 1 1 drVislP 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 drVisVR 1 1 1 1 1 1 1 - PT 1 1 1 1 1 1 1 1 1 1 1 datV 22 31 31 27 28 31 30 31 20 31 30 31 31 31 31 31 31 31 31 31 31 26 31 31 29 26 31 31
Expert Answer:
Related Book For
Modern Database Management
ISBN: 978-0133544619
12th edition
Authors: Jeff Hoffer, Ramesh Venkataraman, Heikki Topi
Posted Date:
Students also viewed these programming questions
-
a. There are 1050 new students this school year. If of the total population is boys, find the number of girls. b. A korean mart sells banana milk, strawberry milk, and melon milk. 65% of the milks...
-
Planning is one of the most important management functions in any business. A front office managers first step in planning should involve determine the departments goals. Planning also includes...
-
The following additional information is available for the Dr. Ivan and Irene Incisor family from Chapters 1-5. Ivan's grandfather died and left a portfolio of municipal bonds. In 2012, they pay Ivan...
-
Jen and Berry's sells ice-creams from its factory-shop in Petone. There is a managing director (Maynard Dibble), a marketing manager (Mary Salman) and a production manager (Peter Pritchard). Maynard...
-
Using Mohrs circle, determine the moments of inertia and the product of inertia of the area of Prob. 9.72 with respect to new centroidal axes obtained by rotating the x and y axes 45° clockwise....
-
Bridgeport Windows Inc is in the process of setting a target price on its newly designed tinted window. Cost data relating to the window at a budgeted volume of 3,440 units are as follows. Per Unit...
-
Diagnostic Services Inc. (DSI) is a new company. It has been in business for only one year, offering diagnostic services to physicians in the Tampa/St. Petersburg, Miami, and Orlando markets. DSI...
-
If you were planning to do business in a culture that was opposite from your own on the cultural dimensions of power distance and individualism/ collectivism, what challenges would you expect to...
-
A firm has 10,000,000 shares of common stock outstanding, each with a market price of $15.00 per share. It has 80,000 bonds outstanding, each selling for $1020. The bonds mature in 15 years, have a...
-
Repeat Example 9.2, but with a feed pressure of 5.0 MPa. Compare your results to those obtained at a feed pressure of 1.0 \(\mathrm{MPa}\). Data From Example 9.2:- Air can be separated into...
-
A B Create a the truth table for the CMOS circuit below. Vdd B C OUT A 0 0 0 0 1 1 1 1 B 0 0 1 1 0 0 1 1 0 1 0 1 0 1 0 1 OUT
-
Although the remuneration seems low, it is commensurate with other pay packages. Revise the following sentences to use plain language and familiar words.
-
Why is it acceptable to use instant messaging abbreviations (such as BTW) and happy faces (emojis) in messages to friends but not in business messages?
-
Curtis is crippled with arthritis, but his crippling rarely interferes with his work. Revise the following sentences to reduce bias (e.g., gender, racial, ethnic, age, and disability).
-
Angered by slow computer service, complaints were called in by hundreds of unhappy users. Your Task. Revise the following sentences to avoid dangling and misplaced modifiers.
-
A passport cannot be issued until an application is completed and a recent photo is included. Revise the following statements to make them more positive and courteous.
-
In this question, we look into labor supply, i.e., the relationship between wage and quantity supplied of labor. Suppose that there is a consumer who earns income by working. Let w be the wage rate...
-
(a) Use integration by parts to show that (b) If f and g are inverse functions and f' is continuous, prove that (c) In the case where f and t are positive functions and b > a > 0, draw a diagram to...
-
Write an SQL query to list each customer who has bought computer desks and the number of units sold to each customer. Show how you constructed this query using a Venn or other type of diagram.
-
What are the two key types of security policies and procedures that must be established to aid in Sarbanes-Oxley compliance?
-
Take the query you scrapped from Problem and Exercise 9-45 and modify it to show only the U.S. region grouped by each quarter, not just for 2005 but for all years available, in order by quarter....
-
The following figures relate to the production of product X: If the years production is 20,000 units and this product uses 25 per cent of total factory production, the unit cost for product X in...
-
A company buys and sells units of product P as follows: Under a FIFO method, the gross profit on the sold item is: A. :20. B. :24. C. :25. D. :30. 1 January buy 2 at 30 1 February 1 March buy 3 at 40...
-
If the company in 10b uses the weighted average method, the gross profit is: A. :20. B. :24. C. :25. D. :30.
Study smarter with the SolutionInn App