I will convert ordinal survey data to interval data using msi in r
About this Gig
Are you struggling to convert your ordinal Likert-scale survey data into interval data for statistical analysis?
Many classic Excel add-ins (like STAT97 or older .xla tools) fail on modern 64-bit Office systems due to frmWizard VBA compile errors. I offer a clean, fast, and 100% error-free data transformation service using R Studio to convert your raw survey responses via the Method of Successive Interval (MSI).
What I will do for you:
- Transform Ordinal scale data (e.g., Likert 14 or 15) into continuous Interval scale data.
- Process both Pre-Test and Post-Test datasets (Experimental & Control groups).
- Calculate total interval scores for each respondent.
- Deliver clean, formatted Excel outputs ready for SPSS, R, or further statistical tests (t-Test, N-Gain, ANOVA, etc.).
What you will receive:
- Fully converted Excel file (.xlsx) with item-by-item interval scores and total sums.
- Optional R Script (.R) used for the exact transformation.
Why choose this service?
- No 32-bit/64-bit compatibility errors.
- Fast delivery and mathematically precise results.
Feel free to send me a message before placing an order if you have custom requirements!
Platform:
Excel
•
Google Sheets
•
Other
Development technology:
VBA
•
Python
•
RStudio
Expertise:
Formulas
•
Functions
•
Cleaning
•
Other
FAQ
What file formats do you accept?
I accept Microsoft Excel files (.xlsx, .xls) and CSV files (.csv).
Will the output data be ready for SPSS or statistical testing?
Yes! The output is provided in a clean Excel file containing decimal interval values and total scores, ready to be imported into SPSS, R, or Excel for further analysis.
Can you process both Pre-Test and Post-Test datasets?
Absolutely. Depending on the package chosen, I can process multiple sheets including Pre-Test, Post-Test, Control, and Experimental groups.