What can be done here (see the bottom of the page for detailed instructions)

  • One sample t-test

  • Two sample unpaired t-test

  • Paired t-test

  • Two sample unpaired Welch t-test,

  • Test for Homogeneity of variance (F test)

  • Box plot

  • Paired Plot

If you are using this , please cite us ! click to see Citation

Gopinath et al., (2021). grapesAgri1: Collection of Shiny Apps for Data Analysis in Agriculture. Journal of Open Source Software, 6(63), 3437, https://doi.org/10.21105/joss.03437

Prepare excel file by reading instruction below

In this web application, you only just need to upload the Excel file in CSV format. To Prepare excel file follow the instructions below

  • Open a new blank excel file

  • Copy and paste observations into a new sheet (use only one sheet) of a new excel file

  • Observations under each groups for t test should be pasted as columns.

  • Only quantitative variables are allowed. If any observation is missing type 'NA'

  • Don't type or delete anything on other cells without data

  • You can use any names for your columns. No space is allowed in the Column name. If space is required use underscore ‘_’ or ‘.’ full stop; for example ‘Variable name’ should be written as Variable_name or Variable.name

  • Data should be arranged towards upper left corner and row above the data should not be left blank.

  • Don't type and delete anything on other cells without data. If so select those cells, right click and click clear contents

  • Give names to all column, Don't add any unnecessary columns that is not required for analysis

  • For Paired t-test number of observations under each group must be same

  • Once all these are done, your file is ready. Now you have to save it as CSV file. It is very simple. Follow the instruction below.

How to save an excel file as CSV

  • File --> Save As --> (in the dialogue box appearing), select save as type: csv (comma delimited)

  • Now save your file in any name

  • After file preparation click on the analysis button above

  • Upload this file in to the application for analysis.

Your final file should look like this

How to save your excel file as csv before proceeding for analysis?

click file --> save as