Question about Excel?

Katherine631ByKatherine631

Hello,

For my seminar paper, I had various people complete a questionnaire. I now want to analyze it in Excel using the correlation coefficient (to compare the questionnaire results with other characteristics). One question on the questionnaire, for example, asked how long the person slept at night. Possible answers included 5-8 hours or less than 5.

How do I enter the value 5-8 or less than 5 in Excel so that I can further evaluate (with the correlation coefficient)?

Thanks!

(1 votes)
Loading...

Similar Posts

Who can help with the task?

Bygutefrage108

was ist an der ausgabe falsch FileNotFoundError Traceback (most recent call last) Cell In[4], line 1 —-> 1 with open("../data/dictionary.txt", 'r') as file: 2 for line in file: 3 word = line.strip() File ~\anaconda3\Lib\site-packages\IPython\core\interactiveshell.py:324, in _modified_open(file, *args, **kwargs) 317 if file in {0, 1, 2}: 318 raise ValueError( 319 f"IPython won't let you open fd={file}…

Subscribe
Notify of
3 Answers
Oldest
Newest Most Voted
Inline Feedbacks
View all comments
GutenTag2003
GutenTag2003
1 year ago

How to enter 5-8 or less than 5 in Excel

You can use this as a column header, use tick fields and evaluate them accordingly.

0
Katherine631
Author
Katherine631
1 year ago
Reply to  GutenTag2003

But if I do this, I cannot calculate the correlation coefficient, as I need numbers for it.

0
GutenTag2003
GutenTag2003
1 year ago
Reply to  Katherine631

If you need from 5-8, also the 6 and 7, you will need to specify all for ticking and then enter for evaluation.

0