Forum Discussion
Descriptive Statistics
Hey, i am trying to do a descriptive analysis on a dataset, but it says input data contains non-numerical data which is somewhat accurate because some of the part i am selecting has no input of data should i merely leave this file, or is there way for me to still do this descriptive data is it as simple as just writing the number 0 instead of whats been presented thanks, the image should perhaps give a better clarity.
- Perhaps replace all the dashes with nothing (Home tab, Find & Select, Replace) before doing the stats?
3 Replies
- Perhaps replace all the dashes with nothing (Home tab, Find & Select, Replace) before doing the stats?
Hey, Jan That was a good idea, although perhaps because i didn't show this specific picture but it essentially represents, something i can maybe ignore the dash, but the stars, not sure, is there a numerical way or is this data something i shouldn't try to do a descriptive statistics on.
And also, assuming i am able to do so, there is quite a bit of data that i would like to do a descriptive statistics on, is there a way to organise it better, i.e. not in separate sheets, etc. and is there a way to make it even faster?
Or are there certain, datasets that make sense to use descriptive statistics on?
- Is the data layout of all those tabs identical? Perhaps this gives you some pointers: https://www.xelplus.com/combine-excel-sheets-power-query/
