in a Excel file containing the following: 1) a worksheet labeled ‘ Scatterplot ’
ID: 3208902 • Letter: I
Question
in a Excel file containing the following:
1)a worksheet labeled ‘Scatterplot’containing a labeled (males and females in different colors), this exercise will use the attached dataset about. Make sure your title and axis labels are appropriate. If necessary, change the range of the x-axis so the data points are not all “scrunched” up. Don’t forget title and axis labels.
Dataset Note: gender: 1 = male, 2 = female
height: in inches
weight: in pounds
2) a worksheet labeled ‘Measures’ containing your answer to the following question:
What determines which numerical measures of center and spread are appropriate for describing a distribution of a quantitative variable? Which measures will you use in each case?
Hints:
The question is asking about numerical measures of both center and spread. Make sure you know what the possible measures of center and the possible measures of spread are.
It is also asking about how you would decide which measures are appropriate for a distribution, and what your decision would be in different cases.
Make sure your answer addresses all parts of the question.
3) a worksheet labeled “Variables” containing your answers to the following questions:
A)Given the problem: How well can scores on the OLI Checkpoints be predicted by the number of OLI activities completed?
a. What is the explanatory variable? What type of variable is it?
b. What is the response variable? What type of variable is it?
c. What would be an appropriate visual display for examining the relationship between these two variables?
B)Given the problem: How do the OLI Checkpoint scores of the males in this class compare to those of the females?
d. What is the explanatory variable? What type of variable is it?
e. What is the response variable? What type of variable is it?
f. What would be an appropriate visual display for examining the relationship between these two variables?
Gender Height Weight 1 66.00 140.00 1 72.00 145.00 1 73.50 160.00 1 73.00 190.00 1 69.00 155.00 1 73.00 165.00 1 72.00 150.00 1 74.00 190.00 1 72.00 195.00 1 71.00 138.00 1 74.00 160.00 1 72.00 155.00 1 70.00 153.00 1 67.00 145.00 1 71.00 170.00 1 72.00 175.00 1 69.00 175.00 1 73.00 170.00 1 74.00 180.00 1 66.00 135.00 1 71.00 170.00 1 70.00 157.00 1 70.00 130.00 1 75.00 185.00 1 74.00 190.00 1 71.00 155.00 1 69.00 170.00 1 70.00 155.00 1 72.00 215.00 1 73.00 155.00 1 73.00 155.00 1 71.00 150.00 1 68.00 155.00 1 69.50 150.00 1 73.00 180.00 1 75.00 150.00 1 66.00 135.00 1 69.00 160.00 1 66.00 130.00 1 73.00 155.00 1 68.00 150.00 1 74.00 148.00 1 73.50 155.00 1 70.00 150.00 1 67.00 140.00 1 72.00 180.00 1 75.00 190.00 1 68.00 145.00 1 69.00 150.00 1 71.50 164.00 1 71.00 140.00 1 72.00 142.00 1 69.00 136.00 1 67.00 123.00 1 68.00 155.00 2 61.00 100.00 2 66.00 120.00 2 68.00 130.00 2 68.00 138.00 2 63.00 121.00 2 70.00 125.00 2 68.00 116.00 2 69.00 145.00 2 69.00 150.00 2 62.75 112.00 2 68.00 125.00 2 66.00 130.00 2 65.50 120.00 2 66.00 130.00 2 62.00 131.00 2 62.00 120.00 2 63.00 118.00 2 67.00 125.00 2 65.00 135.00 2 66.00 125.00 2 65.00 118.00 2 65.00 122.00 2 65.00 115.00 2 64.00 102.00 2 67.00 115.00 2 69.00 150.00 2 68.00 110.00 2 63.00 116.00 2 62.00 108.00 2 63.00 95.00 2 64.00 125.00 2 68.00 133.00 2 62.00 110.00 2 67.00 150.00 2 61.75 108.00Explanation / Answer
2)
For measures of center its preferely to use the mean and median .Whereas for the spread the range and Inter-Quartel Range will be used.
For symmetric distributions with no outliers,one should use the mean to find the measure of center.For all othercases we should use the median to find the measure of center.The range is an okay measure to find the measure of spred of a distribution.But when one is using the median is as the measure of center,we should use IQR,and when we are using the mean as the measure of center,we should use the standard deviation.
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.