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 + times? MY STUDENT NUMBER IS 0372784.

AutoSave On Del BusinessStatistics Template.Last Modified: Sat at 8:37 PM Search (Alti Jaspreet Kaur Gill K File Home Insert Page Layout Formulas Data Review View Help Comments Share 20 AutoSum Calibri w 11 - A A == 29 Wrap Text General 49 o 19 ch) Analyze Data X Out [B Copy Paste Format Painter Cipboard DZ X OA Insert Delete Format BIU-- Merge & Center $ -% -% Clear Conditional Formatas Cell Formatting Table Styles Styles Sort & Find & Filter Select Editing Font Alignment Number Calls Analysis -AVERAGE(A2:A118) B D E F H 1 j L M N o 0 R aver #DIV/0! standard deviat Divide by Zero Error minimum for question Help on this Error maximum for question Show Calculation Steps count in this rat Ignore Error Edit in Cormular users that clicked 10-A till Error Checking Options.. users that clickod 11 A times = chance that user will click 10+A or 11+A times = chance that two users in a row will click 10-A on 11+A Limes 1 1 Clicks 2 19 3 47 5 6 10 7 8 14 9 10 S 11 129 13 14 8 15 16 19 17 18 5 19 20 18 21 22 17 23 24 16 25 26 10 27 28 11 29 + Dala Clicks Seconds Accesibility: Good to go Reacy 1004 Type here to search O o EH 14 7C Cloudly A OOG 4) ENG 9:06 AM 2022-04-25 AutoSave On Del BusinessStatistics Template.Last Modified: Sat at 8:37 PM Search (Alti Jaspreet Kaur Gill K File Home Insert Page Layout Formulas Data Review View Help Comments Share 20 AutoSum Calibri w 11 - A A == 29 Wrap Text General 49 o 19 ch) Analyze Data X Out [B Copy Paste Format Painter Cipboard DZ X OA Insert Delete Format BIU-- Merge & Center $ -% -% Clear Conditional Formatas Cell Formatting Table Styles Styles Sort & Find & Filter Select Editing Font Alignment Number Calls Analysis -AVERAGE(A2:A118) B D E F H 1 j L M N o 0 R aver #DIV/0! standard deviat Divide by Zero Error minimum for question Help on this Error maximum for question Show Calculation Steps count in this rat Ignore Error Edit in Cormular users that clicked 10-A till Error Checking Options.. users that clickod 11 A times = chance that user will click 10+A or 11+A times = chance that two users in a row will click 10-A on 11+A Limes 1 1 Clicks 2 19 3 47 5 6 10 7 8 14 9 10 S 11 129 13 14 8 15 16 19 17 18 5 19 20 18 21 22 17 23 24 16 25 26 10 27 28 11 29 + Dala Clicks Seconds Accesibility: Good to go Reacy 1004 Type here to search O o EH 14 7C Cloudly A OOG 4) ENG 9:06 AM 2022-04-25