Sep 02 2019 09:41 AM
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!
Mar 19 2021 08:02 AM
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?
May 20 2021 11:18 PM
May 25 2021 02:46 PM
Hi @DougCooley
Can you share that video tutorial?
May 25 2021 04:41 PM
May 25 2021 04:44 PM
Jun 11 2021 10:17 AM
Solution: In the tab where you have the data located, find a blank cell and start data analysis from there, rather than starting data analyses in a different tab.
Fill out data analyses as needed, click "in new worksheet". The data analyses will be generated in a new worksheet. Hope this helps!
Jun 13 2021 12:10 AM