Home

"Contiguous Reference" error when using Data Analysis Tool

%3CLINGO-SUB%20id%3D%22lingo-sub-833582%22%20slang%3D%22en-US%22%3E%22Contiguous%20Reference%22%20error%20when%20using%20Data%20Analysis%20Tool%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-833582%22%20slang%3D%22en-US%22%3E%3CP%3EGreetings.%26nbsp%3B%20I%20am%20a%20beginner%20level%20user%20in%20Excel%20and%20am%20doing%20a%20paper%20for%20my%20Master's%20Degree.%26nbsp%3B%20I%20have%20followed%20a%20tutorial%20video%20for%20how%20to%20use%20the%20Data%20Analysis%20tool%20in%20Excel%20by%20using%20the%202%20Sample%20t-Test.%26nbsp%3B%20My%20problem%20occurs%20after%20selecting%20my%20ranges.%26nbsp%3B%20As%20you%20can%20see%20in%20my%20screenshots%20that%20I%20tried%20arranging%20them%20vertically%20and%20horizontally%20with%20the%20same%20result.%20Would%20be%20grateful%20to%20whoever%20can%20tell%20me%20what%20I%20need%20to%20differently.%26nbsp%3B%20Of%20course%20it%20works%20perfectly%20in%20the%20tutorial%20video%20but%20I%20am%20obviously%20missing%20something%20somewhere.%26nbsp%3B%20Thank%20you!%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F129663iE55619705D869F77%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22Error%20Message.PNG%22%20title%3D%22Error%20Message.PNG%22%20%2F%3E%3C%2FSPAN%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F129664i89C4826E767C91D1%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22Scenario%201.PNG%22%20title%3D%22Scenario%201.PNG%22%20%2F%3E%3C%2FSPAN%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F129662i4DB3BE0ACDE11C4D%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22scenario%202.PNG%22%20title%3D%22scenario%202.PNG%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-833582%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
DougCooley
Occasional Visitor

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! 

Error Message.PNGScenario 1.PNGscenario 2.PNG

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
16 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
11 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
*Updated 9/3* Syncing in Microsoft Edge Preview Channels
Elliot Kirk in Articles on
217 Replies