z-test

%3CLINGO-SUB%20id%3D%22lingo-sub-3242466%22%20slang%3D%22en-US%22%3Ez-test%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3242466%22%20slang%3D%22en-US%22%3E%3CP%3EHey.%3C%2FP%3E%3CP%3E%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20I%20am%20unable%20to%20perform%20a%20z-test%20analysis.%20Every%20time%20I%20serve%2C%20it%20shows%20I%20have%20entered%20non-numeric%20data.%20I%20don't%20know%20what%20it%20is.%20Could%20you%20please%20help%20me%20out%20with%20this%3F%20The%20data%20also%20contains%20negative%20numbers.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3242466%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EBI%20%26amp%3B%20Data%20Analysis%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Visitor

Hey.

          I am unable to perform a z-test analysis. Every time I serve, it shows I have entered non-numeric data. I don't know what it is. Could you please help me out with this? The data also contains negative numbers.

1 Reply

@Tabish650 Select the cells which contain the actual numbers. Does Excel show a small icon next to the selected numbers? If yes, click it and select "Convert to number"

NumberStoredAsText.gif