- Autosave On Del Businessstatistics Template Last Modified Sat At 8 37 Pm Search Alti Jaspreet Kaur Gill K File Home In 1 (110.35 KiB) Viewed 38 times
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 7°C Cloudly A OOG ° 4) ENG 9:06 AM 2022-04-25