similar to: Importing an Excel file

Displaying 20 results from an estimated 4000 matches similar to: "Importing an Excel file"

2004 Oct 22
3
Convert a list in a dataframe
Hi, I've a list containing parameters (intercepts & coefficients) of 12 regressions fitted > coeff [[1]] (Intercept) anno -427017.1740 217.0588 [[2]] (Intercept) anno -39625.82146 21.78025 ..... [[12]] (Intercept) anno 257605.0343 -129.7646 I want create a data frame with two columns (intercept and anno)using data in these list. Any help
2004 Oct 27
2
Skewness and Kurtosis
Hi, in which R-package I could find skewness and kurtosis measures for a distribution? I built some functions: gamma1<-function(x) { m=mean(x) n=length(x) s=sqrt(var(x)) m3=sum((x-m)^3)/n g1=m3/(s^3) return(g1) } skewness<-function(x) { m=mean(x) me=median(x) s=sqrt(var(x)) sk=(m-me)/s return(sk) } bowley<-function(x) { q<-as.vector(quantile(x,prob=c(.25,.50,.75)))
2004 Jul 21
2
Testing autocorrelation & heteroskedasticity of residuals in ts
Hi, I'm dealing with time series. I usually use stl() to estimate trend, stagionality and residuals. I test for normality of residuals using shapiro.test(), but I can't test for autocorrelation and heteroskedasticity. Is there a way to perform Durbin-Watson test and Breusch-Pagan test (or other simalar tests) for time series? I find dwtest() and bptest() in the package lmtest, but it
2004 Nov 10
1
Loading some function at R startup
Dear R-users, I've built these functions usefell for me to import/export data from/to Excel: importa.da.excel<-function(){read.delim2("clipboard", dec=",") ## questa funzione consente di importare dati da Excel in R ## selezionare in Excel le celle che contengono i dati, ## compresi in nomi delle colonne ## Autore: Vito Ricci email:vito_ricci at yahoo.com ## Data di
2004 Aug 09
2
Using R "boxplot" function in Excel
Hi, I have downloaded the "R-Com and I was able to run "Interactive Graphics Demo 2" in excel. However, I couldn't create my own boxplot. Whenever I tried to run any code, it always say" Error in loading DLL", even "=rput(A1,A2:A20)". Any idea about what's going wrong? A detailed explaination about how to use R-Excel tool would be greatly appreciated.
2004 Oct 20
2
R & Graphs
Dear R-users, I'm finding for a R-package concerning graphs. Is there some kind of that package? I've a set of correlation coeffients between several variable and I wish to built a graph to link variables correlated. Many thanks. Best, Vito ===== Diventare costruttori di soluzioni "The business of the statistician is to catalyze the scientific learning process." George
2004 Jul 07
1
Daily time series
Hi, I'm dealing with time series with 1 observaton for day (data sampled daily). I will create a ts object using that time series and the function ts(). In ts() help is written: The value of argument 'frequency' is used when the series is sampled an integral number of times in each unit time interval. For example, one could use a value of '7' for 'frequency' when
2004 Sep 21
5
S-PLUS and R
Hello, How do I import data from Excel onto R? I am using S-Plus Envstat module. I need to use some of the data that already exist in the Envstat and put it into R to make graphs, find basic informations like mean, median, standard deviation, etc. I have been reading the help links, but I don't see anything in reference to this. Please help me! -Maher Lina
2004 Nov 12
4
Mode in case of discrete or categorial data
Thanking John for his suggestion I build this function which get the mode of both categorial and discrete data. Mode<-function(x){t<-table(x) if (is.numeric(x)) as.numeric(names(t)[t == max(t)]) else (names(t)[t == max(t)]) } Any other improvement and suggestion will welcome. Best Vito > s [1] 1 1 6 1 1 7 6 5 6 2 1 4 5 6 6 7 3 5 4 1 7 3 7 3 3 7 7 2 1 4 4 2 7 7 6 6 1 2 [39] 5 1 7 7
2004 Aug 12
4
Help with generating data from a 'not quite' Normal distriburtion
I would be very grateful for any help from members of this list for what might be a simple problem... We are trying to simulate the behaviour of a clinical measurement in a series of computer experiments. This is simple enough to do in R if we assume the measurements to be Gaussian, but their empirical distribution has a much higher peak at the mean and the distribution has much longer tails.
2004 Nov 15
1
R: how can draw probability density plot?
I hope this example could help you best vito > x<-seq(-3.5,3.5,0.1) > x [1] -3.5 -3.4 -3.3 -3.2 -3.1 -3.0 -2.9 -2.8 -2.7 -2.6 -2.5 -2.4 -2.3 -2.2 -2.1 [16] -2.0 -1.9 -1.8 -1.7 -1.6 -1.5 -1.4 -1.3 -1.2 -1.1 -1.0 -0.9 -0.8 -0.7 -0.6 [31] -0.5 -0.4 -0.3 -0.2 -0.1 0.0 0.1 0.2 0.3 0.4 0.5 0.6 0.7 0.8 0.9 [46] 1.0 1.1 1.2 1.3 1.4 1.5 1.6 1.7 1.8 1.9 2.0 2.1 2.2 2.3
2004 Nov 17
1
R: log-normal distribution and shapiro test
Hi, from what you're writing: "The logaritmic transformation "shapiro.test(log10(y))" says: W=0.9773, p-value= 2.512e-05." it seems the log-values are not distributed normally and so original data are not distributed like a log-normal: the p-value is extremally small! Other tests for normality are available in package: nortest compare the log-transformation of your ecdf
2004 Nov 17
8
referencing values of strings
Say you have a vector named x and a function which returns the character string "x" . How would I take "x" as an input and return the vector x? DISCLAIMER: This e-mail message and any attachments are inte...{{dropped}}
2004 Jul 12
7
Excel file
Hi, How do I open an excel file in R? I have save the excel file in unicode text format, but it is not possible to open the file in R. /Pernilla
2004 Sep 10
2
converting to data frame
Is there a method that converts a csv file to a data frame ? M
2004 Aug 04
1
spatial econometric model for a simultaneous system
Hi, Is there any package or functions in R that can perform tests and estimation for a spatial econometric model in a simultaneous system? Thank you!!! Xia Feng
2004 Aug 03
1
Data manipulation query
Hi, Not sure if I am making a simple problem complex but still here we go: I have a data frame with four columns say, X1 X2 X3 and X4. I want to break X4 into deciles and for each deciles obtained, I want to see corresponding elements of X1. Ideally, the output should be in a tabular fashion as shown below: Deciles 1 Deciles 2 .... Deciles 10 X1-1 X1-2 X1-99 X1-5 X1-3 X1-10
2004 Aug 10
1
Help with Normal Range Estimation for repated measures
I would be grateful if members of the list could point me in the direction of any code (preferably in R) that will allow me to estimate 95th percentiles from a set of repeated measurements. For example, we are interested in a clinical measurement where we have 3 measures for 14 subjects and 2 measurements on 24 subjects and single measurement on 36 subjects. We want to combine these to form a
2004 Oct 14
1
(no subject)
Hi, Why this code is good in S-plus, and don't good in R ? getMethod("[","matrix") thanks
2004 Jul 22
2
Programmation pour MLE
Bonjour, Je veux cherché l’estimateur de vraisemblance maximal (MLE)d’une fonction à 3 paramètre inconue étant donné une échantillon de taille 50 (les observations des valeurs de x) alors comment je peux procédé La fonction de densité est définie par : f(x)= 1/3(g(a1)+g(a2)+g(a3)) avec g(ai)=(exp(ai)*ai^x)/x! pour i=1,2,3. Je vous remercie beaucoup. A. Elhabti