Chapter+8+Optional+Exercise

Col is the abbreviation for column 8 notice that col

This preview shows page 2 - 3 out of 4 pages.

appears in the formula after the minus sign.  (“Col” is the abbreviation for column.) 8. Notice that Col Mean is followed by a set of parentheses and that the red box is  inside of them.  Basically, the formula wants to know which column mean we are  talking about.  We know there is only one column, but the computer is stupid, so we  have to tell it.  Go back to the  Table Columns  box and once again click on “Y on  Page 151.”  It will appear in the formula inside of the parentheses. 9. We’re done.  Click OK to accept the formula and OK again to get out of the New  Column dialogue, and you should see a set of numbers in the column called  “Deviations.”  If you did everything correctly, they should match the deviations on  page 151. Absolute Values We are going to do almost exactly the same thing as when we created Deviations, with one  slight exception. 1. Right click on the open space to the right of the data and click on  New Column Change the column name to “Absolute Deviations.”   2. Click on the  Column Properties  button and again select  Formula . 3. Here is the only difference from how we created the first formula.  Go to the  Functions (grouped)  box and click on  Numeric .  The first option is  Abs  for  absolute values.  Click on it and you will see straight lines appear before and after  the red box.
Image of page 2

Subscribe to view the full document.

Image of page 3
You've reached the end of this preview.
  • Winter '08
  • Signorielli,N
  • Column, Yi, new column, red box

{[ snackBarMessage ]}

What students are saying

  • Left Quote Icon

    As a current student on this bumpy collegiate pathway, I stumbled upon Course Hero, where I can find study resources for nearly all my courses, get online help from tutors 24/7, and even share my old projects, papers, and lecture notes with other students.

    Student Picture

    Kiran Temple University Fox School of Business ‘17, Course Hero Intern

  • Left Quote Icon

    I cannot even describe how much Course Hero helped me this summer. It’s truly become something I can always rely on and help me. In the end, I was not only able to survive summer classes, but I was able to thrive thanks to Course Hero.

    Student Picture

    Dana University of Pennsylvania ‘17, Course Hero Intern

  • Left Quote Icon

    The ability to access any university’s resources through Course Hero proved invaluable in my case. I was behind on Tulane coursework and actually used UCLA’s materials to help me move forward and get everything together on time.

    Student Picture

    Jill Tulane University ‘16, Course Hero Intern