Excel Activity 3 - Binomial Distribution 20240106

xlsx

School

DePaul University *

*We aren’t endorsed by this school

Course

137

Subject

Statistics

Date

Feb 20, 2024

Type

xlsx

Pages

Uploaded by ProfResolve13407

Student Opinion rec_opinion samples_5 1 not favor 0 4 2 favor 1 2 3 favor 1 3 4 favor 1 3 5 favor 1 2 6 not favor 0 4 7 favor 1 4 8 not favor 0 4 9 favor 1 4 10 favor 1 3 11 not favor 0 3 12 favor 1 2 13 not favor 0 4 14 favor 1 4 15 not favor 0 2 16 not favor 0 1 17 not favor 0 1 18 not favor 0 3 19 not favor 0 4 20 favor 1 3 21 not favor 0 3 22 favor 1 1 23 not favor 0 4 24 not favor 0 4 25 not favor 0 2 26 not favor 0 3 27 not favor 0 3 28 not favor 0 2 29 favor 1 4 30 not favor 0 2 31 favor 1 4 32 not favor 0 1 33 not favor 0 3 34 favor 1 2 35 favor 1 4 36 favor 1 3 37 favor 1 1 38 favor 1 4 39 not favor 0 3 40 favor 1 1 41 not favor 0 2 42 not favor 0 3 1 of 5. C favor of 1 of 5. C favor of 3 of 5. Cr by-side. I Expected Push the the Form and reta do you t Your com 3 of 5. Cr by-side. I Expected Push the the Form and reta do you t Your com 2 of 5. C using the Expected Distributi 2 of 5. C using the Expected Distributi

43 not favor 0 1 44 favor 1 5 45 favor 1 4 46 not favor 0 2 47 favor 1 3 48 not favor 0 2 49 not favor 0 3 50 favor 1 3 51 favor 1 2 52 not favor 0 3 53 favor 1 3 54 not favor 0 4 55 not favor 0 3 56 not favor 0 3 57 not favor 0 1 58 not favor 0 3 59 favor 1 2 60 favor 1 4 61 favor 1 2 62 favor 1 5 63 favor 1 3 64 favor 1 3 65 favor 1 3 66 not favor 0 3 67 favor 1 2 68 not favor 0 3 69 not favor 0 4 70 not favor 0 3 71 favor 1 4 72 favor 1 2 73 not favor 0 1 74 favor 1 3 75 favor 1 3 76 favor 1 3 77 not favor 0 4 78 favor 1 2 79 not favor 0 4 80 favor 1 4 81 not favor 0 3 82 favor 1 3 83 favor 1 5 84 favor 1 3 85 favor 1 3 5 of 5. Us size ( n = 2 compute 1) that no 2) that le 3) that 95 4) that m 5) that 85 6) that as cafe. 5 of 5. Us size ( n = 2 compute 1) that no 2) that le 3) that 95 4) that m 5) that 85 6) that as cafe. 4 of 5. Co samples g standard values to their expe enough t acceptab Your com 4 of 5. Co samples g standard values to their expe enough t acceptab Your com

86 not favor 0 2 87 favor 1 4 88 not favor 0 2 89 favor 1 4 90 favor 1 3 91 favor 1 4 92 not favor 0 3 93 not favor 0 0 94 favor 1 3 95 not favor 0 4 96 favor 1 4 97 favor 1 4 98 not favor 0 4 99 not favor 0 5 100 not favor 0 5 101 not favor 0 3 102 not favor 0 3 103 favor 1 3 104 favor 1 4 105 favor 1 1 106 favor 1 1 107 not favor 0 3 108 favor 1 2 109 favor 1 2 110 favor 1 2 111 favor 1 4 112 favor 1 3 113 favor 1 1 114 not favor 0 3 115 not favor 0 3 116 favor 1 2 117 favor 1 2 118 not favor 0 2 119 favor 1 2 120 favor 1 2 121 not favor 0 2 122 not favor 0 3 123 favor 1 2 124 favor 1 2 125 favor 1 3 126 not favor 0 2 127 favor 1 4 128 not favor 0 3

Your preview ends here

Eager to read complete document? Join bartleby learn and gain access to the full version

Access to all documents
Unlimited textbook solutions
24/7 expert homework help

129 not favor 0 3 130 favor 1 3 131 favor 1 4 132 not favor 0 3 133 not favor 0 3 134 not favor 0 2 135 not favor 0 3 136 favor 1 3 137 favor 1 2 138 favor 1 4 139 favor 1 1 140 favor 1 3 141 not favor 0 1 142 favor 1 2 143 favor 1 2 144 favor 1 2 145 favor 1 3 146 not favor 0 4 147 favor 1 2 148 not favor 0 4 149 not favor 0 3 150 favor 1 2 151 favor 1 3 152 favor 1 4 153 favor 1 2 154 favor 1 3 155 favor 1 2 156 favor 1 4 157 favor 1 3 158 not favor 0 4 159 favor 1 1 160 favor 1 5 161 favor 1 1 162 not favor 0 4 163 favor 1 0 164 favor 1 1 165 not favor 0 3 166 not favor 0 5 167 favor 1 2 168 favor 1 1 169 not favor 0 3 170 favor 1 3 171 favor 1 2

172 not favor 0 1 173 favor 1 2 174 not favor 0 4 175 favor 1 3 176 favor 1 3 177 favor 1 3 178 favor 1 4 179 not favor 0 1 180 not favor 0 2 181 favor 1 4 182 not favor 0 2 183 not favor 0 5 184 not favor 0 2 185 favor 1 2 186 not favor 0 3 187 not favor 0 2 188 not favor 0 3 189 favor 1 2 190 favor 1 2 191 not favor 0 3 192 favor 1 4 193 favor 1 2 194 favor 1 4 195 favor 1 4 196 favor 1 5 197 not favor 0 4 198 not favor 0 1 199 favor 1 3 200 favor 1 1 2 3 2 4 3 3 3 3 3 3 3 1 5 3

3 3 3 1 2 1 3 4 2 2 3 2 3 4 2 2 4 3 2 4 1 3 3 2 2 4 1 2 2 1 4 2 3 4 3 5 4 1 2 3 1 3 3

Your preview ends here

Eager to read complete document? Join bartleby learn and gain access to the full version

Access to all documents
Unlimited textbook solutions
24/7 expert homework help

4 1 4 3 2 3 2 2 3 2 3 2 4 5 2 3 4 1 1 1 3 3 2 4 4 2 4 3 4 3 3 2 2 4 4 5 2 3 2 5 2 3 2

Compute the population proportion of students who are in f a new on-campus cafe. Compute the population proportion of students who are in f a new on-campus cafe. reate a histogram chart to display both distribution bars side- In the Chart Title text box place this title: Sample and d Distributions Comparison. e Calculate Now button several times. (This can be found on mulas ribbon.) Notice that the Sample Distribution changes ains a comparable shape to the Expected Distribution. What think could be the explanation? mments on the results: reate a histogram chart to display both distribution bars side- In the Chart Title text box place this title: Sample and d Distributions Comparison. e Calculate Now button several times. (This can be found on mulas ribbon.) Notice that the Sample Distribution changes ains a comparable shape to the Expected Distribution. What think could be the explanation? mments on the results: Create a sample distribution table (a relative frequency table) e 300 samples in samples_5. Add to this a column showing the d Distribution (the probabilities based on a Binomial tion). Create a sample distribution table (a relative frequency table) e 300 samples in samples_5. Add to this a column showing the d Distribution (the probabilities based on a Binomial tion).

sing Excel's Binomial Distribution functions, the population 200) and the Population Proportion value calculated in Task 1, e the following probabilities: o more than 125 students support the cafe. ess than 105 students suppoet the cafe. 5 or more students support the cafe. more than 135 students support the cafe. 5 students support the cafe. s many as 125 and no fewer than 105 students support the sing Excel's Binomial Distribution functions, the population 200) and the Population Proportion value calculated in Task 1, e the following probabilities: o more than 125 students support the cafe. ess than 105 students suppoet the cafe. 5 or more students support the cafe. more than 135 students support the cafe. 5 students support the cafe. s many as 125 and no fewer than 105 students support the ompute the sample mean and standard deviation of the generated; and, compute the expected mean and expected deviation from the population proportion. (Round these o two decimal places.) Compare the sample statistics with ected values. Would you say that the results are close to be the same? What would explain why any difference is ble? mments on the results: ompute the sample mean and standard deviation of the generated; and, compute the expected mean and expected deviation from the population proportion. (Round these o two decimal places.) Compare the sample statistics with ected values. Would you say that the results are close to be the same? What would explain why any difference is ble? mments on the results:

Your preview ends here

Eager to read complete document? Join bartleby learn and gain access to the full version