This chapter teaches you near various numerical measures of describing data. For example, what new knowledge or techniques did y'all discover? What was the most difficult task? Easiest? How almost the video? Whatever improvements?Īnybody must make at least one post. Don't submit my charts, submit yours.ġ2) After completing the Excel graphing practise, please provide at least one post near your thoughts about this practise and about using Excel for graphing. I give these to you so that y'all can run into the "concluding destination." However, you might want to delete them and try to recreate the tables and charts on your own. In the Excel model that I provide to you, you lot volition come across my "finished" graphs. This is "nominal" data.ġ0) Using the provided G&Thousand weight data (this is "ratio" data) provided below, create a frequency tabular array, a histogram, a frequency polygon chart, a cumulative frequency polygon chart, and a combination chart using the "weight" data. Nine) Using your 1000&M data (i.due east., your bag of G&Ms), create a frequency table, a bar chart, a pie chart, and a relative frequency bar nautical chart using the " color" G&Grand data. In the by, many students who were already familiar with Excel enjoyed this boosted video and learned a few new things.Įxcel Overview and Fundamentals (sixteen minutes)Ĭh02 Excel: Describing Information Graphically (26 minutes) For those who might be new to Excel, I am giving you this additional video, Excel Overview and Fundamentals explaining some of the nuts of using Excel.
#HOW TO ADD ANALYSIS TOOLPAK IN EXCEL MAC 2017 HOW TO#
PowerPoints, i per page (PDF) ConsignmentĨ) Watch my Excel video virtually how to chart data using Excel. PowerPoints, i per folio (PDF) Excel Overview and Fundamentals PowerPoints Brand sure to give yourself enough time to do this assignment it is a little involved.Īnnotation: If yous happen to exist absent-minded this calendar week or taking the grade online, yous will demand to buy a bag of Grand&Ms, preferably about a 1.75 oz. We do not have any "issues" assignments to do, but you practise take the project below to complete and submit on Moodle. 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)
