PLEASE SHOW HOW I WOULD INSERT THIS INTO EXCEL PLEASE! By using the data in the

Question

PLEASE SHOW HOW I WOULD INSERT THIS INTO EXCEL PLEASE!

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 Person Gender Question Question 2 Question 3 Question 4 1 F 5 10 Fire Strongly Agree No Opinion 3 M 3 2 Cubs No Opinion 4 F 2 25 Cubs Agree F 3 20 Bulls Agree Disagree White Sox. Disagree 10 M 2 25 Blackhawks Agree 11 M 3 20 Blackhawks Agree 12 F 2 15 White Sox Agree 15 M 3 15 Cubs Agree 16 F 2 15 Cubs Agree 17 M 0 40 Strongly Disagree Bears White Sox Agree 20 M 2 10 White Sox Strongly Agree 21 M 2 15 Bears Agree 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 Disagree Wolves Strongly Agree 30 F 2 20 Bears Agree 31 F 2 12. s Cubs Strongly Agree 32 M 2 30 Blackhawks Strongly Agree 133 M 4 60 Cubs No Opinion 34 F 2 45 Bulls Strongly Agree 135 M 6 Bulls No Opinion White Sox Strongly Disagree 137 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.) Find the mean, standard deviation of sample, variance of sample, and mode, of each quantitative data set.

Here the average number of minutes it takes you to get to campus from home.

All these statistics we can find using MINITAB.

steps :

ENTER data into MINITAB sheet --> Stat --> Basic statistics --> Display descriptive statistics --> variables : select data column --> Statistics --> click on all the statistic --> ok --> ok

Descriptive Statistics: C1

Variable Mean StDev Variance
C1 19.06 12.23 149.62

Mode is the most frequent value.

Mode = 15

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

Five number summary is minimum, first quartile, second quartile, third quartile, and maximum.

  Minimum Q1 Median Q3 Maximum

2.00 10.00 15.00 25.00 60.00

Related Questions

Navigate

• Browse (All)
• Browse P
• Subjects

---