1. (Submit a screenshot of the histogram) Create a histogram for column "Mark" using Excel Data Analysis Function with the following bin in data range C1: C6. Output range is E1. Adjust the chart so that the lower right corner is in cell P20. Edit the chart title so that it is read as "Chart Created by your name" (replace with your name). Rename the bin in column E so that it includes both the lower limit and upper limit ( for example, 0 to 49, 50 to 59, 60 to 69 etc). Add data labels - outside end. Remove gap among bars (set gap width to 0%).

BIN: 49, 59, 69, 79, 89, 99

2. Describe the natures of the histograms(uniform, normal, skewed left, skewed right).

3. Using Excel or by hand, construct a frequency distribution table, relative frequency distribution, and cumulative relative frequency distribution of the data using the following class limit(zero decimal with %):

Lower Limit	Upper limit
0	49
50	59
60	69
70	79
80	89
90	99

Stat1P98 Assignment 1 Dr. Pauline Fu

4. (Submit a screenshot from Excel with your name in cell F1) Using Excel to calculate the descriptive statistic: mean, median, standard deviation (for sample), first quartile (Q1), third quartile (Q3), and interquartile range (IQR). Use QUARTILE.INC for quartile. Keep 3 decimals where applicable.

5. (Submit a screenshot of Box-plots). Construct a box-plot for the data. Use your name as the chart title. Identify 5-number summary on the box-plot. Calculate 1.5*IQR. How do you determine the outliers? Keep whole numbers.

6. Suppose a student has a final mark of 65. calculate the z-score for this student. Keep 3 decimals. Explain to someone about this z-score who does not have statistics knowledge.

7. Based on the design of the study and data collection method,

a. Identify the sample and the population

b. The mean you calculated in question 4 is a parameter. True or False?

c. How would you name the data based on the measurement scale (nominal, ordinal, interval, and ratio)

d. The data is obtained by using probability sampling or non-probability sampling?

e. If you want to conduct a study about this data, is the study observational study or design of experiment?

Final Mark (Read-Only) Q Search Sheet Home Insert Page Layout Formulas Data Review View '+ Share Cut Calibri (Body) 11 . A- A = _ AutoSum Wrap Text General AP. Copy Fill Paste BI UT Y Av Merge & Center $ ~ % " 00 .00 Conditional Format Cell Insert Delete Format Sort & Format Formatting as Table Styles Clear Filter N25 X V fx A B C D E F G H I J K L M N P Q R T U V W X Y Z AA Name Box 7 Sheet1 + Ready + 100%Final Mark (Read-Only) Q Search Sheet Home Insert Page Layout Formulas Data Review View '+ Share Cut Calibri (Body) 11 . A- A _ AutoSum Wrap Text General AP. Copy Fill Paste BI UT Y Av Merge & Center $ ~ % " 00 .00 Conditional Format Cell Insert Delete Format Sort & Format Formatting as Table Styles Clear Filter N25 X fx A B C D E F G H I J K L M N 0 P Q R T U V W X Y Z AA 44 90 86 15 Sheet1 + Ready + 100%Final Mark (Read-Only) Q Search Sheet '+ Share Home Insert Page Layout Formulas Data Review View _ AutoSum Cut Calibri (Body) 11 . A- A = Wrap Text General AP. Fill Copy $ ~ % ) 00 .00 Conditional Format Cell Insert Delete Format Sort & Clear Paste BI UT Y Av Merge & Center Formatting as Table Styles Filter Format N25 X V fx U V W X Y Z AA A B C D E F G H I J K L M N P Q R T 87 51 63 108 109 110 111 112 113 114 115 116 117 118 119 120 122 123 124 125 126 127 128 129 130 121 Sheet1 + + 100% ReadyQ Search Sheet Final Mark (Read-Only) '+ Share Formulas View Home Insert Page Layout Data Review _ AutoSum AP. Cut 11 . A- A Wrap Text General Calibri (Body) Fill Copy .00 Conditional Format Cell Insert Delete Format Sort & Clear Filter Paste BI UT Y Av Merge & Center $ ~ % " 00 Formatting as Table Styles Format N25 X V fx Y Z AA J K L M N 0 P Q R T U V W X A B C D E F G H I 130 Be 131 67 132 80 133 3 134 81 135 85 136 74 137 88 138 139 140 141 142 143 144 145 146 147 148 149 150 164 165 166 167 168 169 170 171 172 59 173 73 Sheet1 + + 100% ReadyQ Search Sheet Final Mark (Read-Only) '+ Share Home Insert Page Layout Formulas Data Review View _ AutoSum AP. Cut Calibri (Body) 11 . A- A = Wrap Text General Fill Sort & Copy Merge & Center $ ~ % " 00 .00 Conditional Format Cell Insert Delete Format Clear Styles Filter Paste BI UT Y Av Formatting as Table Format N25 X V fx T U V W X Z AA C D E F G H 1 J K L M N 0 P Q R S A B 173 73 174 90 175 54 176 72 177 54 178 56 179 56 180 181 182 183 184 185 186 187 188 189 190 191 192 195 196 199 200 201 202 203 204 205 206 207 208 209 210 211 78 212 70 213 214 215 216 71 217 Sheet1 + + 100% ReadyQ Search Sheet Final Mark (Read-Only) '+ Share Formulas View Home Page Layout Data Review Insert _ AutoSum AP. Cut Calibri (Body) 11 . A- A = Wrap Text General Fill Insert Delete Format Sort & Copy Merge & Center $ ~ % " 00 .00 Conditional Format Cell Clear Filter Formatting as Table Styles Paste BI UT Y Av Format N25 X v fx R S T U V W X Z AA J K L M N 0 P Q B C D E F G H I 216 71 217 76 218 77 219 73 220 77 221 72 222 75 223 71 224 74 225 73 226 227 228 229 230 231 232 233 234 235 236 237 238 239 240 241 242 243 244 245 246 247 248 249 250 251 252 77 253 80 254 255 74 256 72 257 78 258 259 80 Sheet1 + + 100% ReadyQ Search Sheet Final Mark (Read-Only) '+ Share Home Insert Page Layout Formulas Data Review View _ AutoSum AP. Cut Calibri (Body) 11 . A- A Wrap Text General Fill Sort & Copy Merge & Center $ ~ % ) 00 .00 Conditional Format Cell Insert Delete Format Clear Filter BI UT Y Av Formatting as Table Styles Paste Format N25 X V fx Z AA K L M N 0 P Q R S T U V w X A B C D E F G H 1 J 259 80 260 74 261 76 262 75 263 79 264 72 265 80 266 73 267 72 268 77 269 270 71 271 272 273 274 275 276 277 278 279 280 281 282 283 284 285 286 287 288 289 290 291 292 293 294 295 296 297 77 298 299 300 301 302 Sheet1 + + 100% ReadyQ Search Sheet Final Mark (Read-Only) '+ Share Home Insert Page Layout Formulas Data Review View _ AutoSum AP. Cut Calibri (Body) 11 . A- A Wrap Text General Fill Copy .00 Conditional Format Cell Insert Delete Format Sort & Merge & Center $ ~ % " Clear Styles Filter Paste BI UT Y Av Formatting as Table Format N25 X V fx R S T U V w X Y Z AA P Q A B C D E F G H I J K L M N 0 280 18 281 74 282 77 283 78 284 285 76 286 73 287 79 288 76 289 77 290 72 74 299 300 301 302 303 304 305 306 307 308 309 310 311 312 313 314 315 316 317 318 319 320 321 322 323 324 Sheet1 + + 100% Ready