PLEASE SHOW HOW I WOULD INSERT IT ONTO EXCEL PLEASE! 1.) Make a 92% confidence i
ID: 3232744 • Letter: P
Question
PLEASE SHOW HOW I WOULD INSERT IT ONTO EXCEL PLEASE!
1.) Make a 92% confidence interval using Excel functions for the continuous data set mean.
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 AgreeExplanation / Answer
Hence ,92 % CI for above continuous data set is (21.78,16.35).
(We can also use data analysis/descripitive statistics tool in Excel for doing this,if have latest version of microsoft office in the system,we have to just give the range of data,it will calculate all the parameters like mean,std dev,error,skewnesskurtosis,CI,z value etc.)
Person Q2. 1 10 Mean =AVERAGE(B2:B41) 19.0625 2 5 std. dev =STDEV(B2:B41) 12.23184 3 2 std. error =E3/SQRT(40) 1.934023 4 25 Critical z* value for 92% CI =NORMSINV(0.92) 1.405072 5 20 Upper bound =Mean+z*std error 21.77994 6 5 Lower bound =Mean-z*std error 16.34506 7 7 8 7 9 10 10 25 11 20 12 15 13 15 14 25 15 15 16 15 17 40 18 7 19 30 20 10 21 15 22 12 23 15 24 15 25 30 26 35 27 25 28 25 29 25 30 20 31 12.5 32 30 33 60 34 45 35 5 36 7 37 10 38 12 39 26 40 30