mba 522 13 Labels box in Regression Tool pak

mba 522 13 Labels box in Regression Tool pak - mark in the...

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
Checking off the Labels box in Excel’s Regression Analysis Tool Students often miss a very important detail in reading the appendix for ch. 12. Note the steps described in the appendix of chapter 12 for Excel. In step 5, if you select cells C1 and B1 (which are the column headings or variable names for Y and X), then you MUST select "Labels" by checking off the little box next to it. That way, Excel recognizes that the first cells hold variable names and are not numerical values. A mistake that students often make is the following: They don't select the variable name in the range for X and Y, but they do put the check
Background image of page 1
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: mark in the box for labels. Therefore, Excel assumes that the first cell is the variable name and does not count it in the number of observations! This can lead to wrong answers b/c the first pair of X and Y values never get included in the calculations performed by Excel. You can easily check to make sure you have not made a mistake by noticing the "observations" reported in your Excel printout. If it does not match the paired observations of X and Y that you meant to include in the study, you should go back and run your analysis again. Dr. J....
View Full Document

Ask a homework question - tutors are online