Displaying 20 results from an estimated 3000 matches similar to: "Newbie hung up with matrices"
2003 May 29
2
Newbie trying to Lag Variables in a regression
Perhaps I am making this too hard, but how does one regress y(t) on a
constant, x(t-1) and y(t-1)? I've tried the manuals and until I get
Dalgaard's book (just ordered on Amazon), I am stuck!
Thanks to all in advance for your patience and consideration.
2003 May 16
1
Newbie Matrix problem refined; Can't convert .csv data to matrix
Thanks to all for your previous help. I see now that my problem is
converting my .csv file of data into a matrix. My example is a (3x3) matrix
with a "header" row (that doesn't contain numerics).
Thanks again for your time and gracious consideration.
2003 May 30
1
Downloading packages from CRAN
Hello-
I am trying to download packages from CRAN to my Window-based system. I
downloaded the most recent version of Perl, as instructed in the Install
Manual and the "car" package, just as a trial.
Where should they "reside" within my computer: the unzipped Perl I have
placed at ...R/rw1070; the "car" package I unzipped and placed at
...R/rw1070/library. Is this
2003 May 23
3
Not getting all data to a text file via write.table
Hi all- Thanks in advance for your help.
I have a 2275x1 table of residuals from an lm() regression. I want to
analyze this further in Excel. I tried using:
df<-resid(object)
write.table(df)
and this yields a nice looking output in R, but because of screen
constraints, I seem to loose data "out-the-top" of the Console -- which
doesn't bother me, as long as I can see it
2011 Aug 06
4
row*matrix
Hi all, I'm learning R. I'm used to Matlab and am having the following issue:
I define a column vector and matrix and then multiply them. The result is
not what I expect:
v2 <- c(0,1,0)
M <- cbind(c(1,4,7),c(2,5,8),c(3,6,9))
M*v2
[,1] [,2] [,3]
[1,] 0 0 0
[2,] 4 5 6
[3,] 0 0 0
I expect the result to be a column, specifically the 2nd column of M.
2003 Jun 04
1
Error Using dwtest
Hello all-
I have two time series, Index1stdiff and Comps1stdiff. I regressed the
first on the second and R returned the summary stats I expected. Then I
looked at and plotted the residuals. I then wanted to assess
autocorrelation characteristics and tried to run a Durbin-Watson using:
library(lmtest)
dwtest(formula=Index1stdiff~Comps1stdiff,alternative=c("greater"))
I am
2010 Feb 02
2
Writing out csv files
In my code, I calculate the maximum values with 2 factors using
maxr=with(arrdf, tapply(rate,list(weekday,quarter), max, na.rm=T))
and I want to write out the file so that Excel can read it.
I used
write.table(maxr, fname, sep=",", col.names=TRUE, row.names=TRUE,
quote=TRUE, na="0")
which works, and yields something like
2010 Jan 02
1
Question on Reduce + rollmean
Hello useRs,
I'd like to perform a moving average on the dataset, xx. I've tried
combining the functions Reduce and rollmean but it didn't work.
> r <- function(n) rollmean(n, 2) # where 2 = averaging interval
> output < - Reduce("r", x)
Error in f(init, x[[i]]) : unused argument(s) (x[[i]])
Is there anything wrong with the code in the first place?
where
2011 Sep 07
1
Problem with configuring dovecot to take namespaces from database
Hello!
I'd like to set up dovecot to keep namespaces in database, keep more
than one namespace per user.
I try to create the simplest rule (even without tuple in db table) to
get new namespace, unfortunately it doesn't work.
My user_query is:
SELECT '/dane/domeny/%d/mail/%n/' as home, dovecot_typ_skrzynki ||':'||
'/dane/domeny/%d/mail/%n/' ||'.'||
2010 Apr 18
2
how to use Excel VBA's Shell() to call and execute R file
I have an R file R_test.R saved in C:\R_test folder. The R_test.R looks like
this:
setwd("C:/R_test")
rnorm(100)
write(rnorm(100),"data.txt")
q(save="no", runLast = F)
Next I would like use an Excel VBA/macro Shell() function to call R and
execute R_test.R file. The syntax is *Shell(pathname*[*,windowstyle*]*)*
I wrote an Excel macro RunRcode like this:
Sub
2011 Apr 01
4
Rexcel path problem
Hi,
I am running a test to call an R script with in excel using VBA. My VBA
code is shown bellow. The middle section of this mail also includes the
content of my Rscript. The bottom part shows the error message form the
R console.
It seems that Excel is opening the R console without any problems.
The problem I am seeing is that Rinterface.RRun instruction is
interpreting the "\T"
2009 Jul 27
1
creating and populating an environment
Hi, I often work with R by writing long(ish) Excel-VBA macros
interspersed with calls to R via RExcel. A typical example of this would
be:
Sub VBAMacro()
'fetch some data from an excel sheet
'do some basic stuff on said data
'transfer data from vba to R
'run some R statements
'get data back to vba
'show results on the excel sheet
'clean R by deleting all vars
2011 Jun 06
1
Question with RExcel
Dear all,
I?m doing some simulation studies in order to compare the estimates (and estimated standard deviations) from the ARMA(2,1) Model with an estimator that I?ve constructed. For carrying out the simulations I created a VBA project within Excel.
Now, I?m using the RExcel tool for running the R commands in the VBA project. I run 2500 simulation using the ?arima? function from R and it worked!
2013 Jul 12
2
Conexion excel vba con R y VBasic con R
Buenos días:
¿Hay alguna forma de conectar VBA de Excel con R, de forma que desde Excel
se puedan cursar instrucciones de R?, ¿ y V.Basic con R?
Gracias anticipadas.
Saludos
[[alternative HTML version deleted]]
2010 Apr 16
3
run R script from Excel VBA
I wrote a R script say called computeCovarMatrix.R and i want to call and
run this piece from Excel visual basic. does anyone know how to do that?
thanks,
KZ
[[alternative HTML version deleted]]
2013 Jul 12
1
Conexion excel vba con R y VBasic con R
Muchas gracias, Sergio.
Saludos cordiales.
Eduardo Freyre
-----Mensaje original-----
De: miguel.angel.rodriguez.muinos en sergas.es
[mailto:miguel.angel.rodriguez.muinos en sergas.es]
Enviado el: viernes, 12 de julio de 2013 12:39
Para: efreyre en movistar.es; r-help-es en r-project.org
Asunto: RE: [R-es] Conexion excel vba con R y VBasic con R
Hola Eduardo.
Lo que buscas lo puedes
2011 May 27
1
eigenvalues and correlation matrices
I'm trying to test if a correlation matrix is positive semidefinite.
My understanding is that a matrix is positive semidefinite if it is
Hermitian and all its eigenvalues are positive. The values in my
correlation matrix are real and the layout means that it is symmetric.
This seems to satisfy the Hermitian criterion so I figure that my real
challenge is to check if the eigenvalues are all
2010 Oct 27
1
R-Excel Macro mode
I'm using R-Excel's macro mode to make an R based Excel tool for inventory management. It's quite a lot of R-code which I made in R at first and now I am trying to transform it into excel. The R code is a simulation of a random path x times, put into matrices and then doing some transformations on it.
I pasted the R code on a seperate sheet in my Excel file, which by means of VBA I
2004 Aug 23
1
1.0-test33
http://dovecot.org/test/
I think I found and fixed the last bug that was giving me problems. Now
that Dovecot has been successfully working for a few hours, time for a
new test release :)
This release has major changes, so there might still be some bugs left.
Be careful.
If you're upgrading from previous 1.0-test release, you must delete all
existing dovecot.index.log files or you will get
2012 Oct 25
2
Egarch (1,1) with Student t distribution in RExcel
Hi
I want to implement Egarch (1,1) with t distribution model using RExcel and VBA.
May I know the syntax.
Following is the code that I 'm using.
rinterface.RRun "spec=ugarchspec(variance.model=list(model=(eGARCH),garchOrder=c(1,1)), mean.model=list(armaOrder=c(1,1), arfima=FALSE), distribution.model=(std))"
rinterface.RRun "fit = ugarchfit(Data = b, spec = spec)"