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:
  • 12.2 Scatter Plots
  • 12.3 The Regression Equation
• 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

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

• Openstax Introductory Statistics:
  • 2.3 Measures of the Location of the Data
  • 2.5 Measures of the Center of the Data
  • 2.6 Skewness and the Mean, Median, and Mode
  • 2.7 Measures of the Spread of the Data
• Introductory Statistics by Sheldon Ross, 3rd edition: Sections 3.2-3.5
• Statistics with Microsoft Excel by Beverly J. Dretzke, 5th ed., AVERAGE( : ), VARP( : ), STDEVP( : ), P. 36 – 45

WeBWorK. Sets 2.5, 2.6 & 2.7

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

• Openstax Introductory Statistics:
  • 1.3 Frequency, Frequency Tables, and Levels of Measurement
  • 2.1 Stem-and-Leaf Graphs (Stemplots), Line Graphs, and Bar Graphs
  • 2.2 Histograms, Frequency Polygons, and Time Series Graphs
• Introductory Statistics by Sheldon Ross, 3rd edition: Sections 2.1-2.4
• Statistics with Microsoft Excel by Beverly J. Dretzke, 5th edition: SORT, FREQUENCY, P. 28 – 29

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.