I'm relatively new to Linux, and have just downloaded R (to install it on my home machine). I want to use R for a simulation project, but I don't know if it is possible and how. Here is the description:
I want to give thousands of Means and Standard Deviations to the program, and get the returned p-value (and Confidence Interval if possible). The Mean, SD pairs are stored in a MySQL database (can be exported to a text file, if R works with them better) and I want to save the p-values in a separate table of the DB.
What I want to know is:
1) How to run t-test based on Mean and SD in R?
2) How to get the list of Mean and SDs from the DB/text file?
3) How to save the returned p-values to the DB/text file?
I would be grateful if you could help me with some of the above, or at least show me exactly where to find relevant information.
Btw, I have used SPSS in Windows for years, and have some experience with STATA, so don't bother yourself about the jargon.