Descriptive Statistics
Instructions:
Submit a word file containing your responses. You can simply use this page for drafting your answers
Question 1. (1 point)
Consider the following data sets:
A: 9, 12, 13, 10, 11, 7, 13 B: 10, 10, 10, 10, 10, 11, 9 C: 1, 1, 10, 19, 19, 1, 19
a) Calculate the mean of each data set using Excel.
b) Calculate the standard deviation of each data set using Excel. c) Which data set has the largest standard deviation? What does it tell us about the data set?
Question 2.
List three variables, and how they are measured, for which you could use the mode as the most appropriate measure of central tendency.
Question 3. (1 point)
The variable is measured in a survey as follows: Please indicate your sector of employment:
o Public sector
o Non-profit sector
o Private sector
What is the level of measurement of this variable? What descriptive statistics could be calculated for this variable?
Question 4.
The heights (in centimeters) of students of a class are as follows: 165, 167, 178, 190, 158, 167, 174, 148. Find the variance using Excel.
See the following video on using Excel to calculate descriptive statistics:
https://www.youtube.com/watch? v=bz4009uUZmI
Last Completed Projects
topic title | academic level | Writer | delivered |
---|