The art and science of asking questions is the source of all knowledge.
– Thomas Berger
If you’re just stepping into the world of research, the sheer number of tools available in the market can be overwhelming. If you manage to hold your breath, swim through, and find a tool to answer your basic research questions, you now have to cope with its learning curve.
To help deal with these issues, we present you with the simplest of research tools—Zoho Sheet. There are features in Zoho Sheet that perform the duties of a basic research tool, without the hassle of typing lines and lines of code. Zoho’s products make the whole process easy, so let’s take you through the process of data collection and hypothesis testing.
In today’s world, we all seek knowledge amidst data. Be it primary or secondary, data is the lifeline of good research. But, in research, we need a hypothesis to test. So we decided to go with the following null and alternate hypotheses.
H0 – People who need to share their work prefer working with online spreadsheet platforms.
H1– People who need to share their work do not prefer working with online spreadsheet platforms.
The next step would be data collection. With Zoho Survey, creating and sharing questionnaires is simple. With a few clicks, you can share your questionnaire to the desired sample and get your results.
Zoho Survey, being the handy tool it is, provides an option to view your results in Zoho Sheet. Here’s a portion of our results.
Now the job is to simply convert the strings into numbers, so analysis becomes easier. We used the formula “=IF(D3=”Almost everyday”;3;IF(D3=”Minimum once a week”;2;IF(D3=”Maximum once a week”;1;IF(D3=”I don’t use spreadsheets often.”;0))))” to make the strings numeric. The same was done to the sharing column and the cloud/desktop column as well.
The resulting columns looked something like this.
These are the columns that will help us run the regression. Make sure to color code the respective string and number columns. This is not just for the aesthetics of it, but will also help you keep track of the dependent and independent variables. Fortunately, Zoho Sheet’s features like “Fill Color” and “Format Painter” make this a simple affair.
Now that we have the hypothesis set, and the dependent (Cloud/desktop) and independent (Sharing) variables, a simple formula will help us test the hypothesis.
In this example, we’ve used two different approaches.
In the first approach, we measured the slope of the X and Y variables, and then we went ahead and found the simple regression coefficient for them. The functions used were “=SLOPE” and “=CORREL.” These formulas provide accurate results and save us valuable time.
The results of the tests turned out pretty good, so now it’s time for interpretation.
A positive correlation and slope meant that there was indeed a positive relationship between the two variables. Hence, we do not reject the null hypothesis. You can even decide to decipher down the result using an IF function. Like this one, where the formulas used were “=IF(D52>0;”A positive slope. This means, the variables are positively correlated.”;IF(D52<0;”A negative slope. This means the variables are negatively correlated”;”No correlation found”))” and “=IF(D53>0;”A positive coefficient. This indicates that there is a positive relationship between the variables”;IF(D53<0;”A negative coefficient. This indicates that there is a negative relationship between the variables”;”There is no correlation”))”. This can prevent misinterpretation and make your result even more accurate.
This is just one example of how Zoho Survey and Sheet can be used to enhance your research experience. Zoho Sheet also allows you to add people and collaborate with them, so you can always work along with your team. Imagine not having to mail every draft of your spreadsheet to your thesis guide. Bliss, right? Simply add your team and your guide as collaborators. And don’t sweat losing the data, as it’s always there in the cloud.
Here’s the embedded Sheet, in case you needed to take a look.
Keep asking the right questions and Zoho will keep helping you answer them.