Data analysis toolpak excel mac 2011 how to#
You will learn how to use Excel to create a variety of graphs that you learned almost in this chapter. For this topic, in that location are merely "concept" questions for you to answer, and no "issues" to exercise. Vii) Do the Ch02 Concepts Self-Assessment on Moodle for this topic. Lecture PowerPointsĪforementioned notes as to a higher place (1, 2, 3 & 4)Ĭh02 Lecture: Describing Data Graphically (24 minutes) When given data, looking at it graphically is an excellent start step in determining what it might advise. This chapter will orient you to the topic of "Graphic Presentation" of data. Ch02: Describing Information Graphically: Frequency Tables,įrequency Distributions, and Graphic Presentation For this topic, there are just "concept" questions for you to reply and no "problems" to do. Iii) The "Terms" (above) is also from the author, and I provide these to you considering they might help yous understand the topic.Ĥ) Lookout my lecture video on this topic.Ĭh01 Lecture: What is Statistics? (sixteen minutes)ĥ) Practice the Concepts Cocky-Assessment on Moodle for this topic. Ii) The self-report guide (above) is provided past the author. Lecture PowerPointsġ) Review the lecture notes (above) for this chapter. This chapter will orient you to why we study statistics, and some terminology that we will use throughout the class. I have purposely separated material past textbook chapter, just to keep organized. Much of this I suspect you lot have had in a previous course or two, so I think many volition not struggle much with this week's materials. This utility may not run in all versions of Excel. You do not need to add together this utility to your Excel unless you want to experiment. Here is the MegaStat Add together-in that I referenced in the Chapter 3 video. Here is a link to the Excel file, Excel-01, for this calendar week'due south assignments. To compute measures of position using Excel. To compute the mean and standard deviation of grouped information using Excel. To compute and interpret the hateful, the median, mode, weighted mean, geometric mean, range, variance, and standard departure using Excel. To summarize qualitative and quantitative variables with frequency and relative frequency tables, bar and pie charts, histograms, and frequency polygons using Excel. To distinguish between nominal, ordinal, interval, and ratio levels of measurement.
To recognize variables as qualitative or quantitative, and discrete or continuous. To differentiate between descriptive and inferential statistics. To think why noesis of statistics is important.
0 kommentar(er)
