Forum Discussion
"Contiguous Reference" error when using Data Analysis Tool
Greetings. I am a beginner level user in Excel and am doing a paper for my Master's Degree. I have followed a tutorial video for how to use the Data Analysis tool in Excel by using the 2 Sample t-T...
I have the same problem on my desktop but not on my laptop.
When I change the options to use R1C1 referencing, I do not get the error and the ATP works well
When I change the options to use R1C1 referencing, I do not get the error and the ATP works well
The error message is inaccurate. For me, it was because I was trying to do the histogram on a different sheet as the input data. Fixed by starting data analysis from the sheet where the input data existed, rather than where I wanted the output.
