1 / 22

Welcome to MM207 - Statistics!

Welcome to MM207 - Statistics!. To resize your pods: Place your mouse here. Left mouse click and hold. Drag to the right to enlarge the pod. Unit 2 Seminar Monday 8:00 – 9:00 pm ET Professor: Dan Watson Good Evening Everyone!. To maximize chat, minimize roster by clicking here.

ian-stanley
Download Presentation

Welcome to MM207 - Statistics!

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Welcome to MM207 - Statistics! To resize your pods: Place your mouse here. Left mouse click and hold. Drag to the right to enlarge the pod. Unit 2 Seminar Monday 8:00 – 9:00 pm ET Professor: Dan Watson Good Evening Everyone! To maximize chat, minimize roster by clicking here

  2. Organizing Data: Graphs and Tables • Common GraphsHistogram Circle graphs (Pie chart)Bar graphs Time series graphPareto chart Stem-and-leaf plot • Excel templates for creating Histograms and Pie Char https://docs.google.com/leaf?id=0B0ucIB81tO7DYjg0YjQzNDAtMDA2Yy00YzMzLWE1NzAtMTdlMjQ3OTJkY2Nm&sort=name&layout=list&num=50 • Additional resources available in the classroom by clicking on: Unit 11 -> Web Resources Analysis Toolpak Histogram Add-in

  3. Creating a Histogram in Excel

  4. Creating a Histogram in Excel Enter in Left and Right Endpoints for Classes Calculate Midpoint by using the formula =(A4+B4)/2. Copy this cell (ctrl+c), Highlight the remaining midpoint cells and select paste (ctrl+v).

  5. Creating a Histogram in Excel Enter in Frequency for Column D Calculate Relative Frequency by using the formula =(D4)/50. Copy this cell (ctrl+c), Highlight the remaining relative frequency cells and select paste (ctrl+v).

  6. Creating a Histogram in Excel Click on ‘Insert’ -> ‘Chart’ -> ‘Column’ Highlight the Frequency and select appropriate histogram

  7. Creating a Histogram in Excel To set the x axis, right click on the chart and select ‘Select Data’, click on ‘Category (x) axis labels, and highlight the Midpoints

  8. Creating a Histogram in Excel To make the bars touch each other, right click on one of the bars and select ‘Format Data Series’ Set the Gap Width to 0%

  9. Creating a Histogram in Excel Finished Product! -> Copy and Paste Histogram into your Word Document

  10. Creating a Pie Chart in Excel Creating a Pie Chart is the same procedure Click on ‘Insert’ -> ‘Chart’ -> ‘Pie’

  11. Mode, Median, and Mean Summary • Mean: The mean is the arithmetic average of the data set. (page 67) • Median: The median is the central value of an ordered data set. (page 68) • Mode: The mode of a data set is the value that occurs most frequently. (page 69)

  12. Mode, Median, and Mean Summary • Mean: The mean is the arithmetic average of the data set. (page 67)

  13. Mode, Median, and Mean Summary • Median: The median is the central value of an ordered data set. (page 68)

  14. Mode, Median, and Mean Summary • Mode: The mode of a data set is the value that occurs most frequently. (page 69)

  15. Mode, Median, and Mean Summary • Mode: The mode of a data set is the value that occurs most frequently. (page 69)

  16. Range Summary • Range is the difference between the largest and smallest values in a data set

  17. Sample Standard Deviation • The variance is a measure of how far a set of numbers are spread out from each other

  18. Sample Standard Deviation • The sample standard deviation gives you how the data is spread about the sample mean.

  19. Sample Standard Deviation • The sample standard deviation gives you how the data is spread about the sample mean.

  20. Empirical Rule • Empirical Rule for data with a bell-shaped distribution, the standard deviation has the following characteristics. • About 68% of the data lies within one standard deviation of the mean. • About 95% of the data lies within two standard deviations of the mean. 3. About 99.7% of the data lies within three standard deviations of the mean.

  21. Empirical Rule

  22. Empirical Rule

More Related