Descriptive statistics

%3CLINGO-SUB%20id%3D%22%5C%26quot%3Blingo-sub-3151841%5C%26quot%3B%22%20slang%3D%22%5C%26quot%3Ben-US%5C%26quot%3B%22%3EDescriptive%20statistics%26lt%3B%5C%2Flingo-sub%26gt%3B%3CLINGO-BODY%20id%3D%22%5C%26quot%3Blingo-body-3151841%5C%26quot%3B%22%20slang%3D%22%5C%26quot%3Ben-US%5C%26quot%3B%22%3E%3CP%3EFor%20my%20dissertation%2C%20my%20supervisor%20wants%20me%20to%20carry%20out%20descriptive%20statistics%20for%20some%20of%20my%20questions%3B%20I%20am%20trying%20to%20carry%20out%20descriptive%20statistics%20for%20one%20of%20my%20questions%20which%20contains%20different%20age%20categories%20(such%20as%2018-20%2C%2060%2B%2C%20and%20a%20prefer%20not%20to%20say%20option)%20but%20whenever%20I%20try%20to%20carry%20this%20out%2C%20I%20keep%20getting%20a%20message%20saying%20'input%20range%20contains%20non-numeric%20data'.%20Why%20is%20this%20happening%3F%20I'm%20struggling%20to%20carry%20out%20descriptive%20statistics%20on%20SPSS%20so%20I%20want%20to%20do%20it%20on%20Excel%20instead.%26lt%3B%5C%2FP%26gt%3B%26lt%3B%5C%2Flingo-body%26gt%3B%3CLINGO-LABS%20id%3D%22%5C%26quot%3Blingo-labs-3151841%5C%26quot%3B%22%20slang%3D%22%5C%26quot%3Ben-US%5C%26quot%3B%22%3E%3CLINGO-LABEL%3EExcel%26lt%3B%5C%2Flingo-label%26gt%3B%26lt%3B%5C%2Flingo-labs%26gt%3B%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3C%2FLINGO-SUB%3E
New Contributor

For my dissertation, my supervisor wants me to carry out descriptive statistics for some of my questions; I am trying to carry out descriptive statistics for one of my questions which contains different age categories (such as 18-20, 60+, and a prefer not to say option) but whenever I try to carry this out, I keep getting a message saying 'input range contains non-numeric data'. Why is this happening? I'm struggling to carry out descriptive statistics on SPSS so I want to do it on Excel instead.

2 Replies

@FrancesH1810 Sounds like the data in your Excel file isn't "clean": Numbers recognized as numbers for example, but rather seen/treated as text.
When you select the cells which should contain numbers, a small icon should appear. Click that icon it will allow you to change the numbers to numbers:

2022-02-11_17-36-42.jpg

 

@Jan Karel Pieterse thank you