Bonanome | MAT 1372/OL57 | Fall 2021

Category: Class Agendas (Page 7 of 8)

Lesson 4: Covariance and Coefficient of Correlation

Hi everyone! Read through the material below, watch the videos, work on the Excel lecture and follow up with me if you have questions.

 

Learning Outcomes.

  • Collect, organize and graph raw data.
  • Compute statistical parameters (covariance, correlation coefficient).
  • Compute a regression equation and use it to make predictions.

Topic. This lesson covers: Covariance and Coefficient of Correlation

  • Openstax Introductory Statistics:
  • Introductory Statistics by Sheldon Ross, 3rd edition: Sections 2.5, 3.7
  • Statistics with Microsoft Excel by Beverly J. Dretzke, 5th ed., COV(X,Y), CORREL(X,Y)

WeBWorK. Sets 12.2 and 12.3

Continue reading

Lesson 3: Measures of Central Location and Variability

Hi everyone! Read through the material below, watch the videos, work on the Excel lecture and follow up with me if you have questions.

 

Learning Outcomes.

  • Compute statistical parameters (mean, median, mode, average deviation, variance, and sample standard deviation)

Topic. This lesson covers: Measures of Central Location and Variability

WeBWorK. Sets 2.5, 2.6 & 2.7

Continue reading

Lesson 2: Graphical Descriptive Techniques

Hi everyone! Read through the material below, watch the videos, work on the Excel lecture and follow up with your instructor if you have questions.

 

Learning Outcomes.

  • Collect, organize and graph raw data.
  • Know the difference between numerical and categorical variables.
  • Create grouped frequency distributions and histograms. Class intervals should be of equal width, chosen to effectively reveal informative patterns in the data, between 5 (for overview) and 15 (for some detail).
  • Describe a graphical display by first describing the overall pattern (e.g., roughly symmetrical or skewed right or left) and then deviations from that pattern, such as outliers.
  • Understand that the vertical axis of the histogram may be scaled for frequency or percentage (proportion), but the choice of vertical scaling will not affect the important features revealed by a histogram.
  • Excel: know how to freeze panes, sort and filter data, format tables, make charts and use pivot tables.

Topic. This lesson covers: Graphical Descriptive Techniques

WeBWorK: Sets 1.3, 2.1 & 2.2 

Creating a Histogram – Example from Excel Lecture 2 

Below you will find videos to help you organize and display data in Excel. By 2016, Microsoft had added a histogram to its charts. By clicking on the bottom axis, you can specify the number of bins or the class width. A further option is to use the data array calculation “frequency”. Here is a step-by-step guide. Once you have the table, you can create appropriate labels using columns of the left and right boundaries for each interval and  the “concatenate” function.

Continue reading
« Older posts Newer posts »