---

Instructions

 

I) This assignment is based on Lesson 2.

II) Create a worksheet with the following calculations:

— See V below for what your worksheet should look like.

 

Question 1)

• • Come up with four numbers between 1 and 20 (including 1 and 20) such that
    • • their sample standard deviation is between 1 and 2

   

  Question 2)
  

  • • Come up with four numbers between 1 and 20 (including 1 and 20) such that
      • • the first two numbers are the same (e.g. 1,1 or 2,2, etc.)
        • the sample standard deviation of the four numbers is between 6 and 8

     

    Question 3)

    Come up with four numbers between 1 and 20 (including 1 and 20) such that

    • • • • the first two numbers are the same (e.g. 1,1 or 2,2, etc.)
          • the sample standard deviation of the four numbers is between 6 and 8

     

    III) Rename your worksheet
    

    Rename the worksheet name from Sheet1 to some other name that you like. (Points will be deducted if you do NOT rename the worksheet. You do not need to use the same name (E2) as shown in V below.)

     

    IV) Correct file extension
    

    — Save your Excel file with the file extension .xlsx (or .xls if you are using an older version of Excel).

     

    V) Here is what your spreadsheet should look like:
    

    (Come up with your own numbers! Don’t copy from the screenshot below.)

    

    -END-

---