How to export spreadsheet data to GNU R for statistical analysis ?

More Alexander V. Perig's questions See All

Which mathematical techniques it is possible to apply to simulation of academic journal publishing processes ?

I'm thinking about a paper concerning mathematical simulation of processes of journal selection - review - correction - publication - indexation of journal's published manuscript. I wonder which...

05 June 2018 8,640 1 View

What is wrong with modern society and modern social sciences, which are simply helpless in educational practice ?

20 February 2018 I have seen very unpleasant phenomenon near five-storey blocks of flats where I live. There was a group of 10-15 local boys-teenagers, who chorus sang a popular Russian song "It...

01 February 2018 5,197 48 View

How researcher has to publish his/her new results if publisher mechanically uses iThenticate without reading article & novelty?

There are researchers who study one and the same class of problems for all his/her life. And how this researcher has to publish his/her new results if publisher mechanically uses iThenticate...

07 August 2016 6,688 1 View

How to compare two groups with only two measurements?

Hiiiii everyone! I have an enquiry on statistical analysis. I was looking for many forum and it's still cannot solve my problem. I want to compare means of two groups of data but only with two...

03 March 2021 8,796 3 View

Enhanced Yellow Fluorescent Protein (Aequorea victoria) DNA sequence?

I am on the lookout for the Enhanced Yellow Fluorescent Protein (Aequorea victoria) DNA sequence. Does anyone know where I can find it? Thank you in advance

03 March 2021 3,568 1 View

What kind of fluid could I use for a pitfall trap that also does not invalidate molecular testing?

Hi, I want to start testing pitfall trap to obtain ants samples, but I need to conduct molecular analysis on those insects. So, what kind of fluid can I use? Ethanol expires too early and I need...

03 March 2021 5,978 5 View

What's the best way to measure growth rates in House sparrow chicks from day 2 to day 10?

What's the best way to measure growth rates in House sparrow chicks from day 2 to day 10? Since, the growth curve from day 2 to 10 won't be like the "Logistic curve" it might not follow logistic...

03 March 2021 1,401 3 View

Logistical regression using SPSS for a dichotomous dependent variable, with an independent variable of 1, 2, 5 and 10 seconds?

I have an experiment with 28 participants The independent variable is the times 1, 2, 5, and 10 used as the cross hairs during a task These 4 times were tested using 4 different blocks, each...

03 March 2021 9,692 2 View

Do we need to write protocol for a second study of a systematic review that has been registered and published?

I have conducted and published a systematic review and meta-analysis research with the topic related to public health and health pomotion (protocol was registed in PROSPERO). Now we want to...

03 March 2021 8,920 3 View

How to increase a model accuracy ?

dear community, my model is based feature extraction from non stationary signals using discrete Wavelet Transform and then using statistical features then machine learning classifiers in order to...

03 March 2021 6,994 5 View

Do I need to do linear regression before running mediation analysis using PROCESS MACRO by Hayes ?

I just wanted to check if I need to run a linear regression separately if I am using PROCESS MACRO to run mediation analysis. Thank you.

02 March 2021 4,359 3 View

How to normalise data on OPM package from R Studio ?

Good afternoon, I recently used OmniLog from BIOLOG for my experimentations : I tested the metabolism of different strains on 2 types of plates. I have 16 strains of 3 different groups...

02 March 2021 3,584 1 View

Sample dilution for quantitative analysis using ELISA?

If the detection range is in ng/ml but the reference range is in ug/ml for a molecule or protein in serum or plasma .how to dilute and what is the initial volume to be taken for quantitative analysis

02 March 2021 7,670 3 View

Nishal Kumar

http://www.r-tutor.com/r-introduction/data-frame/data-import

The above tutorial might be helpful in loading spreadsheet data in R .

Jochen Wilhelm

Not mentioned in the tutorial linked by Nishal is the library "xlsx" and read.xlsx(). It reads both xls and xlsx files and does not require a Perl runtime installation.

Onother packege is "XLConnect" and the fuction readWorksheetFromFile().

Further links:

http://www.milanor.net/blog/?p=779

http://cran.r-project.org/doc/manuals/r-release/R-data.html

Jan Breitschuh

Are we talking about large (6M) or huge (6G) sheets? Typically you may import from CSV, XLS or SPSS. What will be your favourite?