I’m studying for my Statistics class and don’t understand how to answer this. Can you help me study?

Unit 1 Discussion

Previous Next

Title 2: Introduction to Excel

This Discussion will introduce you to Excel. Excel is an application that can perform many types of statistical analysis on data. Excel can also be used to create graphs and charts.

First, choose any Excel Discussion Dataset. The Excel Discussion Datasets folder is located within the Course Resources content item. Open this dataset on your computer using Excel. Using this dataset, answer the following questions.

1. What is the name of the dataset?
2. What does each observation (row) in the dataset represent?
3. Each dataset is a sample from a population. What population does your dataset represent?
4. What does each column in the dataset represent? (List and describe each variable)
5. Give the name of one qualitative variable and one quantitative variable from the data set. Explain how you can tell that a variable is qualitative or quantitative.
6. Choose one of the variables from your dataset and classify it according to the “levels of measurement” (nominal, ordinal, interval, or ratio). Explain how you know.

Please create personalized and substantive responses to at least two other student main posts. In your response, include the following:

1. Did the student identify the correct population, given the dataset they selected? Why or why not? If the population is not correct, please note what you think it should be.
2. Did the student choose and identify one quantitative and qualitative variable? How can you tell that that their selections are correct?
3. Which variable did the student select to evaluate level of measurement and what was the level of measurement selected? Is this level correct? How can you tell? If not, what is the correct level for the variable and why?

Reading and Resources

• Begin by reading the course Syllabus and course Announcements.
• Read the assigned chapters from the following textbook:

Bennett, J., Briggs, W.L. & Triola, M.F. (2013) Statistical Reasoning for Everyday Life (4th ed.). Upper Saddle, NJ: Pearson.

• Chapter 1: “Speaking of Statistics” and Chapter 2: “Measurements in Statistics”

Reading the textbook and reviewing the textbook examples are excellent methods for starting each unit. Reading the textbook offers context and explanations for new concepts and methods. Completing the textbook examples on paper (and with Excel) is a great way to practice and learn the new methods and concepts introduced. Student feedback has suggested that reading the textbook and practicing the textbook examples has been particularly helpful if completed before the unit Seminar. Some students have reported that keeping a notebook handy, and recording new definitions or concepts encountered while reading is helpful, more organized, and stress reducing.

This chapter includes a section that offers examples using technologies such as Excel. In addition, at the end of each chapter section, or at the end of the chapter, are review exercises that are very helpful for practicing and preparing.

In this course, students may use Excel for any statistical calculations. Excel can be used to evaluate data in many ways. Excel can be used to calculate numerical measures, such as measures of center (such as mean and median) and measures of variation (variance, standard deviation, and range), as well as many other measures such as min, max, and correlation (r-value). Excel can also be used to create visualizations, such as histograms, bar graphs, pie graphs, scatterplots, and others. Excel may also be used to create linear regression equations. Because Excel is a very common tool, the Internet and YouTube both contain considerable support resources and tutorials.

TEXTBOOK

Bennet, J, & Briggs, W, & Triola, M ( Statistical Reasoning: For everyday life ( 4th Edition).