Exercise #2 Due Feb 10

Part A

Beginning in 1996, mandatory placement assessment was required at Texas Tech before a student could enroll in Calculus I.

Choose either two Calc I student evaluation sets or two Calc II student evaluation sets. (One of the sets should be prior to 1996 and one of the sets should be after 1996.)

For each data set:

1. Sort the data by the question type from the Evaluation Form

Q 1. The overall quality of this courses was:

Q 2. The overall effectiveness of the instructor was:

Q 3. I would tell other students that the instructor was:

2. Sort each of the grouped questions by the Weighted Mean (Response)
3. Compute for each of the three groups of questions a new composite Weighted Mean (Repsonse) for the semester

Excel = 5, Good = 4, Average = 3, Weak = 2, Poor = 1

4. Make a conclusion about whether there is any evidence from the data sets you examined to support a conclusion that there has been a positive change in student perceptions of Calc I or Calc II when comparing pre-mandatory placement assessment to post-mandatory placement assessment.

Part B

Choose a dataset from the StatLib DataSets Archive for which there is at least one discrete variable and one continuous variable, e.g.,

• Baseball Data

  Discrete: Position Played or Player's Team

  Continuous: Batting Average (Computed) or Salary

  Discrete: Number of Years in Majors or Player's Team

  Continuous: Earned Run Average or Salary

• Cars Data

  Discrete: Number of Cylinders

  Continuous: Miles Per Gallon or Weight or Acceleration

• Federalist Papers:

  Discrete: Text Name

  Continuous: Any of the Tagged Observations

• Sleep:

  Discrete: Predation Index or Overall Danger Index

  Continuous: Body Weight or Brain Weight or Life Span or Gestation Time

• Vinni Johnson:

  Discrete: Number of Field Goals

  Continuous: Number of Field Goal Attempts

  The data set should contain a minimum of 50 values. The discrete variable should take on between 3 and 20 values.

  1. Identify the dataset, the discrete variable and the continuous variable.
  2. Import the dataset into Excel, provide appropriate headers for the columns
  3. Sort the data set by the discrete variable and by the continuous variable
  4. For each value of the discrete variable:
  • Provide a count of how many data values there are.
  • Find/compute the mean, median, minimum, maximum and range for the continuous variable.