How can I split data into 70 % training and30% testing set in SPSS or excel please?

Saima Afaq @Saima_Afaq

08 August 2016 0 3K Report

How can I split data into 70 % training and 30% testing set in SPSS or excel please?

Kindly tell me the step involved.

Thank you

Badges
Science topic

Similar topics
Moths
Data

More Saima Afaq's questions See All

Case control matching in R (or spss), based on age, sex and ethnicity?

Hi, I have a data frame that includes people who developed end stage renal disease (ESRD) and those who didn't (controls). I want to match my cases with controls based on age, sex and ethnicity....

01 February 2018 7,613 5 View

Measurement bias in longitudinal study?

Hi, I am looking at longitudinal data where parameter say "blood creatinine levels" is measured at different follow up intervals, say "time 1", "time 2" and "time 3". I want to see the change in...

05 June 2017 9,597 4 View

Meta-analysis of non-overlapping strata-The Mantel-Haenszel Formula?

I have stratified my results according to Ethnicity (south asians and Europeans), Gender (Male and female) and Age (4 different age groups). So I have a Beta value (from regression) for South...

09 October 2016 330 2 View

How to assess accuracy of prediction model?

Hi, Can any one suggest a statistical test to determine the accuracy of a prediction model? The prediction model has been developed using multiple linear regression and the variables are...

08 September 2016 5,546 18 View

How should I write my results in terms of R2?

I have used R2 to assess the efficacy of my prediction model (which i developed using multiple linear regression) i want to write my results now in terms of R2 and the predictors that are involved...

08 September 2016 2,497 3 View

Do you know how to test an interaction between a covariate and an independent variable using SPSS?

I am determining the association between physical activity and fasting glucose levels amongst South Asians and Europeans using Multivariate linear regression. I want to see the possible...

05 June 2016 1,718 3 View

Dealing with outliersin spss?

What are various options for dealing with outliers please and which is the best one? Thank you Saima

04 May 2016 5,938 4 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

Binary Logistic Generalized Linear Mixed model in SPSS. Is it doable?

I want to analyses the proportion of swimming sperm of three species of fish in two salinities. To analyse the proportion of swimming sperm in a Generalized Linear Model, I would use a Binary...

03 March 2021 2,297 3 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

What test should i use in comparing the correlation between categorical and continuous variables?

Dear all, I have the variable (Surgery duration) represented by values in minutes and the variable (preoperative neuropraxia cases) represented as (Yes/No) values. I want to compare these two...

03 March 2021 5,427 5 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

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

1. What is the impact of having different scales in a survey? and how can we solve this problem before and after data collection (Literature)?

1. What is the impact of having different scales in a survey? and how can we solve this problem before and after data collection (Literature-based reflection)? Thank you for your time and for...

03 March 2021 2,870 3 View

How to find the mean, SD and CI in SPSS?

Hi, I hope that someone can help me with this task: I have 5 groups of participants which are numbered in SPSS from 1 to 5 (according to their group number) and are all under the variable group....

03 March 2021 506 3 View

What degree of missing data in a particular case/participant results in Expectation-Maximisation no longer working?

I'm dealing with a mediation model and am using the PROCESS module in SPSS. Due to SPSS and PROCESS being limited in the imputation methods - being unable to handle multiple imputation - the other...

02 March 2021 4,362 1 View

How to code open-ended questions in SPSS?

Hello all, In SPSS I am going to code 2 open-ended questions. I have already read all the answers and I made a list of the most important categories to which I can code the answers. This question...

02 March 2021 1,757 4 View