Questions
COMM_V 205 101 102 103 2025W1 Exam B2 (R) 2025W1 Final - Requires Respondus LockDown Browser
Multiple fill-in-the-blank
Suppose you have given a subset of our North American Stock Market dataset in a data frame called compdf. There are all the 50 columns. Similar to our North American Stock Market dataset, gvkey and fyear combination uniquely identifies each observation in compdf. If you execute length(unique(compdf$loc)), you are returned 7. If you execute compdf %>% group_by(gvkey) %>% summarise(count = n()) , all the values under count column are 20. Suppose you executed the following code successfully. df1 <- compdf %>% group_by(loc, fyear) %>% summarise(stat1 = mean(at, na.rm = TRUE), stat2 = max(stat1)) df1 should have [Fill in the blank] rows and 4 columns. If the information provided in the question is not sufficient, please type "not enough information".
View Explanation
Verified Answer
Please login to view
Step-by-Step Analysis
The task asks for filling two blanks in a pipeline that groups by loc and fyear, then computes two summaries per group.
First, understand what df1 will contain: after grouping by loc and fyear, you produce one row per distinct pair of (loc, fyear) across the entire compdf dataset, since summarise reduces each group to a single row.
Second, examine the structure of compdf as described: there are 7 distinct loc values (length(unique(compdf$loc)) = 7). You are told that within the data, every gvkey has 20 observations (the gr......Login to view full explanationLog in for full answers
We've collected over 50,000 authentic exam questions and detailed explanations from around the globe. Log in now and get instant access to the answers!
Similar Questions
Suppose you had a dataset (assigned to data frame object called df). You know that it has 100 observations with a single numerical column called a. All observations for a are equal to 100. You then run the following code: df$b <- df$a df$a <- 0 mean(df$a != df$b) What did R output when the entire code was executed successfully? [Fill in the blank]
Suppose df has 30 rows with 3 numeric columns named d, e, and f. When you executed length(which(df$d >= 5)) the output returned is 20. Then, you executed df <- df %>% mutate(d = if_else(d >= 5, 5, 0)) TRUE/FALSE: When you execute the following line of code, the result returned can be less than 10. length(which(df$d == 0))
Suppose you had a dataset (assigned to data frame object called df). df has 100 observations with a single numerical column called col1. col1 value of each observation is equal to 10. You then run the following code: df$col2 <- df$col1 df$col1 <- 0 mean(df$col2) What did R output when the entire code was executed successfully? [Fill in the blank]
Assume that you run the following code. just_above_ave = min(student$grade[which(student$grade >= mean(student$grade))]) Then, you decided to get the same result in an alternative way. df5 <- student %>% filter(grade >= mean(grade)) %>% summarise(min(grade)) the value in df5[1,1] is equal to just_above_ave.
More Practical Tools for Students Powered by AI Study Helper
Making Your Study Simpler
Join us and instantly unlock extensive past papers & exclusive solutions to get a head start on your studies!