All Questions
24 questions
0
votes
0
answers
38
views
Discrepancy between XIRR in R and Excel
I am having an issue slightly similar to this question, I have a quarterly data that the excel and R brings different values e.g. the following in excel =XIRR(I2:I28, B2:B28) brings a value of 2.9802E-...
- 1
1
vote
1
answer
788
views
Calculate intraclass correlation (ICC) on each column and return a dataframe with results
I have a dataframe based on a questionnaire, all participants answer the questionnaire 2 times. based on this a dataframe with all participants and questionnaire items is formed.
The dataframe looks ...
user21538383
1
vote
2
answers
197
views
How to calculate IRR function by group
I'm trying to calculate IRR by group using the package "jrvFinance" - function "irr" but i don't know how.
I have this for only 1 group:
example:
pr1 <- data.frame(idC=1,period ...
- 39
1
vote
0
answers
136
views
Package 'irr', function 'icc': Unrealistic p-values in output
I'm getting crazy over this issue:
I'm computing (lots of) ICCs at the moment to assess the retest-reliability of brain-parameters using the function 'icc' in the package 'irr' by Matthias Gamer. ...
- 11
0
votes
0
answers
580
views
Inter-rater reliability with Light's kappa in R
I have 4 raters who have rated 10 subjects. Because I have multiple raters (and in my actual dataset, these 4 raters have rated the 10 subjects on multiple variables) I've chosen to use the Light's ...
- 59
1
vote
0
answers
238
views
Error in R when using psych- Error in if (n.obs < n.obs.original) message("Warning, missing data were found for ", : argument is of length zero
Whenever I try to analyse my data using R it comes up with the above error message does anybody know why this is?
- 11
0
votes
1
answer
858
views
Calculate percentage agreement between values in every row
I'm trying to calculate the intra-class correlation between two raters and multiple subjects. However, I also want to be able to determine the raters' agreement for each and every subject so I can ...
- 15
0
votes
1
answer
1k
views
Different Robust Standard Errors of Poisson regression in Stata and R
i am not getting the same results by following Hilbe's, J. 2011 procedure (herein referred to as "the book") on page 20. The procedure is for computing Poisson regression with robust ...
- 69
1
vote
2
answers
627
views
Is weighted Kappa calculated by `irr` package in R wrong?
I found the irr package has 2 big bugs for the calculation of weighted kappa.
Please tell me if the 2 bugs are really there or I misunderstood someting.
You can replicate the bugs using the following ...
- 1,279
1
vote
1
answer
567
views
How to generate a summary table (flextable) for r-markdown from irr output?
I have run 3 different Kappa2 analysis using the irr package.
library(irr)
data("diagnoses", package = "irr")
# Analysis 1
kappa2(diagnoses[, c("rater1", "rater2&...
- 35
7
votes
0
answers
506
views
How to calculate new list of payment
First of all, apologies for posting the same question again.
I want to add the grace period to a repay table for the flat interest calculation method such that the interest amount can be received for ...
- 477
0
votes
2
answers
57
views
How to add additional rows to an imported csv?
I am currently loading multiple csv-files into R in the following form:
read.csv("Cashflows2.csv", header = F, )
V1 V2
1 Date Payments
2 18/08/2017 -20495*
3 18/04/2018 639....
- 7
-1
votes
1
answer
401
views
How to run a function on multiple csv's at the same time
I have a set of 3 csv's which are all saved in the below directory:
setwd("~/R/CashFlows")
The csv's are named:
"Cashflows1.csv" "Cashflows2.csv" "Cashflows3.csv"
And are all in a form similar to ...
- 7
0
votes
1
answer
502
views
Calculating the annualized internal rate of return
How would i write a simple function to calculate the annualized internal rate of return for the below dates and payments in csv form:
19/10/2003 -13275
19/11/2003 940.49
19/12/2003 884.71
19/01/...
- 7
0
votes
1
answer
97
views
Remove all rows for a key with no sign change in a specific variable
I am trying to run an xirr function on several ID's but I get an error message saying:
Error in uniroot(xnpv, interval = interval, cf = cf, d = d, tau = tau, :
no sign change found in 1000 ...
0
votes
1
answer
184
views
Restructuring data (for IRR-analysis)
I have the following data-frame df (fictitious data) with several variables var1, var2, ..., var_n:
var1<-c("A","A","A","B","A","C","C","A", "A", "E", "E", "B")
var2<-c(NA,"1","1","5","6","2","...
- 1,875
1
vote
1
answer
1k
views
Krippendorff's Alpha using R - Error in sort.list(y) : 'x' must be atomic for 'sort.list' Have you called 'sort' on a list?
I'm trying to compute the inter-rater reliability between 3 raters and I have 7100 rows of data. So for example each row is like this:
5,4,3
> data <- read.csv("/home/xyz/Desktop/tc.csv", ...
- 19
1
vote
1
answer
1k
views
How do I get R to calculate a negative IRR scenario?
I have been doing stochastic cash flow modeling. In some of these scenarios, IRR is negative (cash flows out exceed cash flows in over time). R seems to hate this. I get a uniroot error. I have used ...
- 351
3
votes
3
answers
1k
views
How can I incorporate if statement when calculating IRR in R?
This is a simple function I use to calculate IRR. However, there are incidences when all cash flows are negative and return "Error in uniroot(npv, c(0, 1), cf = cf) : f() values at end points not of ...
- 127
1
vote
2
answers
1k
views
Computing IRR using optim
I want to find the internal rate of return (IRR), basically the 'rate' that makes my NPV function go to zero, using the optim function.
My current code for the NPV function (which works) is:
npv <...
- 11
3
votes
1
answer
2k
views
Kappam.light from irr package in R: Warning sqrt(varkappa), NAns produced, kappa = NA, z-value=NA and p-value=NA
I'm trying to calculate the inter-observer reliability in R for a scoring system using Light's kappa provided by the irr package. It's a fully crossed design in which fifteen observers scored 20 ...
- 33
2
votes
1
answer
172
views
Package in R: error messages and zero subjects
My data frame (Test1) is correctly formatted n*m (n= 300 subjects, m= 15 raters):
x rater1 rater2 rater3 ...... rater15
y
Case1 1 1 NA
Case2 1 NA NA
Case3 2 1 2
.
.
.
Case300
Fleiss & Error ...
- 21
1
vote
2
answers
1k
views
Different results for IRR computation between R and MS Excel
The internal rate of return (IRR) or economic rate of return (ERR) is a rate of return used in capital budgeting to measure and compare the profitability of investments.
I wrote some R code to ...
- 294
3
votes
2
answers
1k
views
Looking for Accurate Ruby, Javascript, or R Excel RATE() or IRR() Function Implementation
I'm currently looking for working and accurate implementations of Excel's RATE() and IRR(). I am coding in Javascript targeting modern browsers and Ruby 2.0.0 within Rails 4. My goal is to be able to ...
- 4,062