By using the data in the image provided: Find central tendencies and measures of

Question

By using the data in the image provided:

Find central tendencies and measures of positions of the raw data using Excel.

a.) Find the mean, standard deviation of sample, variance of sample, and mode, of each quantitative data set.

b.) Find the five number summary of the continuous quantitative data set only

Question 1: How many televisions does your household have? Discrete Question 2: What is the average number of minutes it takes you to get to campus from home? Continuous Question 3: What is your favorite Chicago sports team? Categorical Question 4: Do you agree/disagree that President Trump should be impeached? opinion Question 2 Question 3 Person Question 4 Question 1 Gender 1 F 5 10 Fire Strongly Agree F 1 5 Cubs No opinion 3 M 3 2 Cubs No Opinion 4 2 25 Cubs Agree 5 F 3 20 Bulls Agree 6 F 1 5 Blackhawks No Opinion 7 M 5 7 Cubs Disagree 8 F 2 7 Blackhawks Agree 9 M 1 10 White Sox Disagree 10 M 2 25 Blackhawks Agree 11 M 3 20 Blackhawks Agree 12 F 2 15 White Sox Agree 13 1 15 Cubs Agree 14 M 25 Cubs Agree 15 M 3 15 Cubs Agree 16 F 2 15 Agree Cubs 17 M 40 Bears Strongly Disagree 18 F 1 7 Blackhawks Agree 19 F 30 White Sox Agree 20 M 2 10 White Sox Strongly Agree 21 M 2 15 Agree Bears 22 M 2 12 Bears Disagree 23 F 3 15 none Agree 24 F 3 15 Bears Strongly Agree 25 M 4 30 Bears Disagree 26 F 2 35 White Sox No Opinion 27 M 2 25 Cubs Strongly Agree 28 F 1 25 Bulls Disagree 29 F 1 25 Wolves Strongly Agree 30 F 20 Agree Bears 12.5 Cubs Strongly Agree 32 M 2 30 Blackhawks Strongly Agree 33 M 4 60 Cubs No Opinion 34 F 2 45 Bulls Strongly Agree 35 M 6 5 Bulls No Opinion 36 M 2 7 White Sox Strongly Disagree 37 F 3 10 Blackhawks Agree 38 F 3 12 Wolves Agree 39 M 3 26 Blackhawks Strongly Agree 40 F 3 30 Blackhawks Agree

Explanation / Answer

a)

Q1-How many television does yor household

Ans:93
Q2:what is the average number of min it takes you to get to campus from home?
Ans:762.5
Q3:What is your favourate chicago sport team
Ans:Blackhawks
Q4:Do you agree/Disagree that presisdent trump should be impeached?
Ans:Agree

b)Five number summary

Min 2
Max 60
Med(quartile 2) 15
Qquartile 1 10
quartile 3 25

Que1 Que2 Que3 Que4 Sum 93 762.5 Mean 2.325 19.0625 SD 1.248332 12.23184 Var 1.558333 149.6178 Mode 2 15

Related Questions

Navigate

• Browse (All)
• Browse B
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.