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,757 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,711 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 442 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,693 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,580 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,802 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 6,031 4 View

How to learn more about SPSS and its Application?

I would like to learn more about SPSS and Its application especially in regards to data analysis. Please suggest me how I can learn more about it. Thank you so much.

11 August 2024 9,101 4 View

Handling Missing Data and Building a Predictive Model with Incomplete Information ?

I am developing a predictive model for a water supply network that involves 20 influencing points. However, I only have historical data for 10 out of these 20 points. I would like to know how to...

10 August 2024 4,005 2 View

Has anyone applied Python in the field of textile engineering for data analysis, automation, or smart textiles?

I'm currently exploring the application of Python in textile engineering, specifically in areas like data analysis, process automation, and the development of smart textiles. I'm interested in...

10 August 2024 7,429 2 View

Is Galaxy.org good to use for research for analyzing data and for publication?

Hello all, I wanted to know, can I use galaxy (USA, Europe or Australia) platform for analyzing the shotgun data, and can it be used for publication purpose as well? Thanks :)

06 August 2024 6,610 4 View

Do experts have journals in the field of artificial intelligence and big data that are not indexed by SCI or EI?

05 August 2024 8,836 2 View

How to convert a privately loaded document into a public document?

I attempted to make a privately uploaded text public but a window appeared that said an error occurred. There was no explanation provided as to why there was an error or what might be done to...

05 August 2024 8,025 7 View

If we are using snowball sampling technique, how do we justify the true representativeness of the sample statistically? is there any statistical test?

Are there any statistical methods to justify your sampling technique using SPSS or AMOS?

05 August 2024 9,153 4 View

What are possible strategies can be used to analyze data under sequential explanatory mixed method approach?

Better ways to analyze the qualitative and quantitative data in a sequential explanatory mixed method approaches

04 August 2024 2,703 6 View

How can I interpret the data without the need of solving it manually?

How can I interpret the data gathered without solving?

03 August 2024 9,054 3 View

Training for new staff?

I am looking for some training for new staff that will be starting in a self contained classroom with students with ASD. Most new staff have little to no experience working with students with ASD....

03 August 2024 6,717 3 View