Forum Discussion
DougCooley
Sep 02, 2019Copper Contributor
"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-Test. My problem occurs after selecting my ranges. As you can see in my screenshots that I tried arranging them vertically and horizontally with the same result. Would be grateful to whoever can tell me what I need to differently. Of course it works perfectly in the tutorial video but I am obviously missing something somewhere. Thank you!
8 Replies
Sort By
- Yea_SoBronze Contributor
Hi DougCooley
Can you share that video tutorial?
- DougCooleyCopper ContributorIt was so long ago that I cannot access it
- Yea_SoBronze Contributorso at this point your question is immaterial, have you solved that question?
- AkramNajjarCopper ContributorI 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- IanHernandezCopper Contributor
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.
- nonnahsCopper Contributor
I have the same problem. I reference cells in another sheet using data analysis, hit ok, and it comes up with a contagious cell reference error. When I look at the cells I referenced, it's changed completely to "Data!R2C8:R62C12"
Have you fixed your problem? If so, how?