What do you do when you get an error that says your input contains non-numerical data even though all your data values are indeed numbers (I checked, made sure the values weren't strings)?
It is likely you are including column header with the data without checking header checkbox in the dialog box. You have to indicate that you have included headers in the data.
As someone who struggles with Excel and is very insecure when it comes to data analysis, I can say this video is perfect to understand the basics. Thank you! Also, I love how you embellished the sheet in respect to the people who would hypothetically then read it. The little details make a huge difference. Great video!
Hello. Thank you soo much. My question is to you is that while computing the frequency table should i assume the starting point of lower bin always 0? or this is only for this particular dataset which you have shown? another question is, after getting the Frequency table if i want to delete Histogram, and only want to keep the Frequency table, will that be possible? Also is it possible to calculate Frequency table for more than one column simultaneously or it should always be separate? Please reply.
The starting bin need not be zero. For e.g if numbers are negative, let’s say we want to count companies which have negative profits, then all our upper and lower bins will be negative. If you do not want histogram, you can uncheck the chart output button. Or else delete it later. Deleting histogram will not delete frequency table. If you want to generate counts for more than one column use frequency formulae in excel rather than the data analysis menu.
cell A36 and cell A39 are incorrect as P(13<=x) means x=>13 which is NOT the left grey area in Panel F cell A36 and cell A39 both should be: P(X<=13 and X>=18) which are the 2 grey areas shown in Panel F. cheers. love your videos.
He did that!!!! Loved watching him move throughout excel like a master! I’m taking intermediate business applications and i hope to become this proficient one day! Thanks for the video!
