Compute the mean number of days to maturity Compute the median number of days

Compute the mean number of days to maturity compute

This preview shows page 4 - 7 out of 44 pages.

Compute the mean number of days to maturity. Compute the median number of days to maturity. Calculate the Variance of the Days to Maturity sample. Calculate the Standard Deviation of the Days to Maturity sample.
Image of page 4
Median Mean
Image of page 5
sex org ini indi inf prwe preq prwd prwc prwco icad icim icimo icpa icpy su tr cptw itl PR 1 Define correlation and describe how it's typically used. 1 4.92 4.50 5.00 4.75 4.67 5.00 4.56 3.92 4.50 4.86 5.00 5.00 4.50 4.33 4.56 4.75 4.80 5.00 5.63 1 3.67 4.00 3.67 2.00 4.33 4.25 3.22 3.00 3.00 3.43 4.40 4.00 2.50 3.67 2.50 3.75 3.70 5.00 4.53 1 3.25 3.00 3.50 2.75 4.33 4.50 2.38 2.33 2.00 3.14 3.80 3.00 3.00 1.33 2.75 3.50 3.50 3.25 4.02 1 3.17 3.00 3.00 2.25 4.00 4.00 3.56 2.92 2.50 2.86 4.20 3.00 3.50 3.00 3.00 3.75 3.20 4.00 3.93 1 3.67 3.50 3.83 2.75 4.00 3.75 3.44 3.25 2.00 2.00 4.80 5.00 2.50 2.00 1.63 3.75 3.80 4.00 4.06 1 3.75 3.50 3.33 3.75 3.33 2.75 3.56 3.00 3.50 3.43 3.80 4.00 4.00 3.00 3.50 3.25 4.00 4.75 4.16 1 4.42 4.00 4.00 3.33 4.67 3.75 3.11 3.50 4.50 4.14 3.60 4.50 3.50 4.33 4.21 4.00 4.40 3.00 5.02 2 Calculate the correlation between cptw & itl using the CORREL function. 1 3.67 4.00 3.83 3.75 4.00 4.00 3.11 2.75 3.00 3.43 4.00 4.00 4.50 3.33 3.50 4.00 3.40 4.75 4.35 1 4.67 3.50 4.00 2.75 4.00 3.25 3.67 3.91 5.00 3.71 4.20 4.50 4.00 4.33 3.88 3.00 4.20 5.00 5.07 1 3.75 4.00 3.83 4.00 4.00 3.75 3.00 2.25 2.50 3.71 4.60 4.50 5.00 3.33 3.88 3.00 3.90 5.00 4.40 1 4.08 3.00 4.50 3.75 4.00 3.75 2.78 1.92 3.00 3.29 4.80 4.00 4.50 3.33 3.31 3.25 3.80 4.75 4.62 3 Calculate the correlation between cptw & itl using the Correlation analysis tool in Data Analysis found in the Data tab on the Ribbon. 1 3.83 4.00 3.67 2.75 4.00 4.00 3.67 3.08 3.00 3.57 4.60 4.00 2.50 3.00 3.50 3.75 4.20 4.50 4.49 1 4.00 2.50 2.50 3.50 3.33 4.00 2.33 2.17 2.50 3.71 4.80 4.50 2.00 1.33 3.69 2.75 3.90 4.00 4.19 1 4.00 3.50 3.17 3.00 4.00 4.00 3.33 3.42 3.00 2.86 4.60 4.50 4.50 2.67 2.94 3.50 4.00 4.50 4.44 1 2.92 3.00 3.00 3.00 4.00 3.50 2.67 2.44 2.50 3.60 4.00 4.00 3.00 3.67 2.71 2.33 3.38 4.00 3.85 1 3.92 2.50 3.33 3.75 3.67 3.75 2.89 2.33 3.00 2.71 4.60 4.00 3.50 2.00 2.31 3.00 4.00 3.50 4.33 1 3.17 3.00 3.67 2.25 4.00 3.25 3.11 2.92 2.50 3.00 3.40 3.50 3.00 3.67 2.50 3.00 3.30 5.00 3.75 4 What does the term best linear combination mean? 1 4.08 4.50 4.00 3.50 4.00 4.00 3.67 2.92 3.00 3.71 4.60 4.00 2.50 3.67 2.56 4.50 3.50 5.00 4.69 1 3.75 4.00 3.67 3.75 4.00 3.75 2.78 1.92 2.00 3.00 4.20 4.00 3.50 2.33 3.25 3.25 3.40 4.00 4.16 1 3.58 4.00 3.67 3.75 4.33 3.75 2.56 2.67 2.00 3.86 4.60 5.00 3.00 3.00 2.94 3.00 3.60 4.00 4.28 1 3.42 3.50 3.33 3.75 3.67 3.75 2.67 2.58 2.50 3.14 4.60 4.50 3.50 2.67 3.47 3.25 3.50 4.00 4.05 1 4.67 4.00 4.67 4.50 4.33 4.00 2.89 2.00 2.50 3.71 4.80 4.50 4.50 3.33 3.00 3.50 3.70 5.00 4.93 1 4.00 4.00 3.50 3.50 4.33 3.75 2.67 2.92 2.50 3.29 4.20 4.00 3.00 2.67 3.25 3.00 4.00 5.00 4.40 1 4.33 4.00 4.33 4.50 4.00 4.00 3.78 3.17 3.00 3.57 4.20 4.50 4.50 3.67 4.00 3.00 4.30 5.00 4.53 1 3.42 2.50 3.50 2.25 4.67 2.50 2.67 1.67 1.50 2.57 4.40 3.50 3.00 2.33 2.50 1.25 3.00 3.00 3.95 1 2.25 3.00 2.00 2.00 2.33 3.25 3.00 2.25 1.50 2.71 4.60 5.00 3.00 3.00 1.69 3.00 2.60 2.75 2.97 5 1 4.42 3.50 4.00 4.00 4.00 4.00 3.56 3.00 3.00 4.71 4.80 4.50 4.50 4.00 4.31 4.00 4.30 5.00 4.77 1 4.33 3.50 4.00 3.50 4.67 4.00 3.56 2.92 2.50 3.71 5.00 5.00 2.50 3.67 2.93 3.75 4.20 5.00 4.73 1 4.00 3.50 3.50 3.75 4.00 3.75 3.25 2.58 3.00 3.71 4.00 4.00 3.50 4.00 3.44 3.25 4.00 4.75 4.37 1 3.83 3.00 3.00 2.50 4.33 4.00 3.11 2.75 2.50 3.57 4.60 3.50 3.00 2.33 3.56 3.50 3.70 4.75 4.40 6 1 2.50 3.50 3.50 3.25 4.00 4.00 3.11 2.25 2.00 3.14 4.20 3.00 3.50 2.67 3.06 3.25 2.60 4.25 3.72 1 4.75 4.50 4.67 4.50 5.00 4.50 4.00 2.42 2.50 4.29 5.00 5.00 4.00 3.67 4.00 4.50 4.60 5.00 5.17 1 3.58 3.50 2.50 2.75 4.00 3.25 2.33 2.58 2.00 2.86 4.00 4.00 3.00 2.67 2.13 2.50 3.30 3.50 3.94 1 4.67 4.50 4.67 4.75 4.67 3.75 3.67 2.92 2.50 4.00 4.40 5.00 4.00 4.00 4.06 4.25 4.60 5.00 4.81 1 4.17 4.00 4.00 4.25 4.33 4.00 2.56 2.50 2.50 4.71 5.00 4.50 3.00 3.00 3.81 3.25 4.10 5.00 4.80 1 2.83 3.50 2.67 3.75 3.67 2.75 1.89 1.92 2.50 2.71 4.40 3.00 3.50 2.67 3.25 3.00 3.00 4.00 3.81 1 2.50 3.00 3.00 2.50 3.33 3.25 2.44 1.83 1.50 2.57 4.60 3.00 3.50 2.00 3.06 1.50 3.00 3.75 3.39 1 4.75 2.50 4.50 4.25 4.00 4.25 4.67 2.58 4.50 4.14 5.00 5.00 5.00 3.67 4.00 2.50 4.40 5.00 5.23 1 3.50 3.00 3.40 3.25 3.67 4.00 2.67 2.42 2.50 2.00 4.80 5.00 4.00 4.00 3.23 2.00 3.90 3.50 3.88 7 Create a one-way Pivot Table tabulating the frequency of sex. 1 2.58 4.00 1.83 3.00 4.33 4.50 2.00 2.25 1.50 2.71 4.80 4.00 4.00 3.33 1.56 3.25 2.70 3.50 3.84 1 4.42 4.00 4.17 3.00 4.33 4.75 3.75 4.17 4.00 3.83 4.80 5.00 3.00 4.33 3.73 3.67 4.30 4.25 4.99 1 4.00 3.50 3.83 3.75 3.67 4.00 3.11 2.67 2.50 3.29 4.20 3.50 4.50 3.33 3.94 2.75 3.50 3.50 4.19 1 3.67 4.00 3.67 4.25 3.33 4.50 2.89 3.08 3.00 3.14 3.80 4.00 1.50 3.33 3.06 3.00 3.50 4.25 4.00 1 4.25 3.50 3.80 4.00 4.00 3.50 3.33 3.42 4.00 3.86 4.20 5.00 4.50 3.67 3.75 3.75 4.30 5.00 4.73 1 3.50 3.50 3.17 2.50 3.67 4.25 3.33 2.33 2.00 3.14 4.40 4.00 4.00 3.00 3.06 4.00 3.80 4.00 3.98 1 3.92 3.00 3.33 3.25 3.33 3.25 3.11 2.50 3.00 3.57 4.40 4.00 4.50 3.67 3.38 3.50 3.60 5.00 4.23 1 3.33 3.50 3.17 2.75 4.33 4.00 2.56 2.50 3.00 3.29 4.60 4.50 3.00 3.33 2.88 3.00 3.60 5.00 4.37 8 Create a Scatterplot (Scatter Diagram) of itl and the predicted value of itl (PR). Place in the box below. 1 3.92 3.50 3.67 3.75 3.67 3.00 3.11 2.83 3.00 2.57 4.60 3.50 4.50 2.67 3.44 3.75 3.80 3.50 4.31 1 3.92 4.00 3.33 3.75 3.33 4.25 3.44 3.00 3.00 4.14 4.60 4.00 4.50 3.67 4.06 3.75 3.90 3.50 4.39 1 3.92 4.00 3.50 3.75 3.33 3.75 3.75 3.33 3.00 3.86 4.80 4.00 4.00 3.00 4.00 3.75 4.30 4.50 4.38 1 4.67 4.00 4.00 3.50 4.67 3.25 3.00 2.33 2.50 3.86 4.60 5.00 4.00 4.00 4.00 3.50 4.30 5.00 4.81 1 4.00 3.50 4.00 4.00 4.00 3.75 3.67 3.08 3.50 3.57 4.40 4.00 2.50 2.67 3.69 3.50 4.00 4.50 4.57 1 3.08 3.50 2.33 1.00 4.00 2.50 2.67 3.08 3.50 2.29 4.80 5.00 3.00 1.67 3.63 3.75 3.70 4.00 4.17 1 3.58 3.50 3.33 3.50 4.00 4.00 3.33 2.67 4.00 2.86 4.40 4.00 4.00 3.00 3.25 3.00 3.50 5.00 4.55 1 4.42 4.00 4.17 4.25 4.00 3.50 3.11 2.75 2.50 3.14 4.40 4.00 4.00 3.33 3.63 3.75 3.80 3.50 4.47 1 4.33 3.50 4.50
Image of page 6
Image of page 7

You've reached the end of your free preview.

Want to read all 44 pages?

  • Fall '15
  • Threesome

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture