Using Your Student Number for All Questions & Formulas The problems below use constants labelled A, B, C, and D. These are digits taken from your student number as follows: A is the digit in the ones place (the right-most number) B is the digit in the tens place (second from the right) C is the digit in the hundreds place D is the digit in the thousands place Here are some examples: If your student number is 55553012, then your constants are A=2, B=1, C=0 and D=3. If your student number is 83475993, then your constants are A=3, B=9, C=9 and D=5. If your student number is 55557200, then your constants are A=0, B=0, C=2 and D=7

3) On the CLICKS DATA SHEET (the second worksheet in your excel workbook) answer the following questions: Instructions: From your DATA sheet, copy the data from the clicks column into the worksheet labelled CLICKS and do the work for this problem in that worksheet. a. Is the data continuous or discrete? Is the data qualitative or quantitative? Explain how you know this in the Word document. b. Generate a histogram of this data (generated inside the excel worksheet from your data in the CLICKS worksheet), using a bin for each value. Give the chart a title, label the axes and copy it into your Word document. c. Use Excel formulas AVERAGE and STDEV.P to calculate the mean and standard deviation inside your excel worksheet. Provide the results also in your Word document. d. Calculate y ( + ), for the upper limit and lower limit. From your data results from on the CLICKS worksheet, use the COUNTIFS formula in Excel to count the number of users in your data that clicked x number of times withinin your calculated lower and upper limits of your calculated data range. Using the COUNTIF result, determine the probability of your data falling within the upper and lower limit range. This is denoted by : ( + ), Does the percentage of your data fall within the percentage required for a normal distribution , as we discussed in class? PAGE 4 Required : Provide your results and explanation in the Word document, and refer to the histogram. e.Based on the data, what is the estimated probability that two users in a row will click 10 + or 11 +A times? data of clicks is below:

5

14

13

6

18

22

21

4

16

13

16

6

14

16

20

18

7

5

16

15

16

7

12

20

10

7

7

9

16

7

20

8

12

6

15

4

16

9

13

21

5

14

20

16

5

16

6

12

15

6

18

16

21

7

7

12

22

4

15