Description
Please answer all questions! Excel File uploaded (some questions are uploaded as file) and some are already answered. please keep it in correct number ordered how I did it
1. A researcher who begins with observing a data pattern, analyzes that pattern, and develops a theory is utilizing which type of logical reasoning? A) Deductive B) Inductive C) Aristotlean D) Positivism
2. Which of the following statements is NOT true about “theory”? A) It is an explanation of a social behavior B) We use theories to prove our concept is correct C) Theories can be debated D) None of the above
3. From the following statement, which is the “operationalized” measure? “In order to test the validity of household bargaining theoretical perspectives, we examine children’s wellbeing, as measured by the number of times they smile in a given 5 minute interval, in controlled environments of the household.” A) House bargaining theory B) Children C) Numbers of times smiled D) Controlled environments
5. In the following statement, what is the DEPENDENT VARIABLE? “I predict that increased age leads to increased incidents of slipping and falling” A) Age B) Education C) Slipping and falling D) None of the above
12. Based on the frequency table, above in Q11, what is the most appropriate visual chart/graph? A) Pie chart B) Bar graph C) Scatterplot D) Trendline
13. Assume you want to calculate a mean for two distinct groups of people separately, which of the following excel functions would you use? A) =COUNTIF B) =COUNTIFS C) =AVERAGE D) =AVERAGEIFS
14. Assume you want to show a visual chart/graph for the number of people in each state for your sample (i.e. 3 –> New York, 7 –> Pennsylvania, 11 –> New Jersey), what would be the most appropriate chart/graph to show? A) Pie chart B) Bar graph C) Scatterplot D)Trendline
17. In the file, Exam Data, what is the average age of the respondents in this data? A) 35 B) 38 C) 43 D) 47
In the file, Exam Data, what is the appropriate code if you want the frequency of self-described middle-class respondents?
In the file, Exam Data, what is the appropriate code if you want the frequency of self-described middle-class respondent?A) =averageifs(a2:a26, “=low”) B) =countif(b2:b26, “=Middle”) C) =countif(a2:a26, “=Middle”) D) =averageif(c2:c26, “=Middle”)
19. From the file, Exam Data, what is the corresponding CUMULATIVE PROPORTION for anyone with at least a bachelors degree, if you construct a frequency table (2 decimal answer)
20. From the file, Exam Data, what is the average annual earnings for Lower Class respondents (2 decimals)?
21. From the file, Exam Data, what is the average annual earnings for Higher Class respondents (2 decimals)?
22. From the file, Exam Data, what is the most appropriate chart/graph if you want to examine the relationship between var2 and var3? A) pie chart B) Bar graph C) Scatterplot D) Trendline
24. From the file, Exam Data, what is the standard deviation of var2?
25.From the file, Exam Data, what is the total sum of squares of var3?
26. From the file, Exam Data, explain why you should NOT calculate a standard deviation for var4.
27. From the file, Exam Data, calculate the mean earnings for ALL EDUCATION GROUPS (2 decimals)
Group 1:
Group 2:
Group 3:
Group 4:
Group 5:
28. From the question above, Q27, what is the most appropriate chart/graph to show the above averages? A) Pie Chart B) bar graph C) scatterplot D)trend line
29. From the file, Exam Data, what is the standard deviation for age (2 decimals)
31. From the file, Exam Data, what is the z-score for someone who is 55 years old (2 decimals)?
32. From the file, Exam Data, what is the annual earnings of a person who is exactly Z = 1 ABOVE the mean earnings (2 decimals)?
33. From the file, Exam Data, what is the annual earnings of a person who is exactly Z = 1.5 BELOW the mean earnings (2
decimals)?
34. What is the probability of observing respondents between Z = -1 (38,679) and Z = 1 (135,161) in earnings? Round to 2 decimals.
35. From the file, Exam Data, what is the total probability of observing someone between the age of 24 and 60? Write in decimal format.
Unformatted Attachment Preview
var1
Low
Low
High
Low
Middle
Low
High
Low
Low
High
Middle
Middle
Middle
Low
Low
High
Low
Middle
Middle
Middle
Middle
Low
High
Low
High
var2
var3
65000
35000
111000
75000
90000
35000
91000
88000
41000
220000
72000
122000
86000
51000
22000
185000
22000
68000
59000
93000
77000
77000
182000
100000
106000
var4
24
38
51
44
38
31
33
47
62
58
22
34
33
54
28
26
51
60
48
36
39
23
56
52
87
var5
1
1
3
2
4
2
3
1
4
2
3
2
4
1
2
3
3
3
2
4
1
2
3
2
4
1
1
5
2
2
3
2
2
1
4
4
2
4
2
1
4
2
5
5
2
4
3
4
2
5
Variable
var1
var2
var3
var4
var5
Label
Self-reported class distinction
Income (in US dollars per year)
Age
Region
Education Degree
Values
Low, Middle, High
0 to 999,999
18 to 95
1 = NE, 2 = SE, 3 = NW, 4 = SW
1 = High School, 2 = Some College, 3 = Bachelors Degree, 4 = Masters Degree, 5 = Doctorate, JD, MD
Purchase answer to see full
attachment
