(Use the Empirical Rule tab from the spreadsheet). Determine the 68%, 95%, and 99.7% values of the Empirical Rule in terms of the 20 heights
(Use theEmpirical Ruletab from the spreadsheet). Determine the 68%, 95%, and 99.7% values of the Empirical Rule in terms of the20 heightsin your height study.
What do these values tell you?
Post a screen shot of your work from the Week 5 Excel spreadsheet.
(Use the normal probability tab from the spreadsheet). Based on your study results, what percent of the study participants are shorter than you? What percent are taller than you?
Post a screen shot of your work from the Week 5 Excel spreadsheet.
3.Week_3_Descriptives_MATH225N (2) - Search (Alt+Q) Hadja Kabba HK X X AutoSave @ Off Comments Share File Home Insert Page Layout Formulas Data Review View Help Insert Calibri 10 ~ A" A" ab General AY O Conditional Format as Cell Delete Sort & Find & Analyze Paste $ ~ % " .00 Formatting * Table Styles ~ Format Filter * Select v Data Clipboard Font Alignment Number Styles Cells Editing Analysis Undo B24 viXA 64 F M N O A B C D E G K L P H 1 Put values in blue cells; output or answers in YELLOW cells 1 5 Data 58 Mean 64.5789 59 Median 65.0000 60 Mode 60.0000 60 60 60 60 (Returns more than one mode) 60 Sample Variance 18.9240 60 Sample Standard Deviation 4.3502 10 65 Population Variance 7.9280 66 Population Standard Deviation 4.2341 12 67 Range 14.0000 69 Count (n) 19.0000 72 Min 58.0000 61 Quartile 1 60.0000 67 Median 65.0000 17 67 Quartile3 68.0000 69 Max 72.0000 19 63 Interquartile Range (IQR) 8.0000 20 68 21 71 22 60 23 65 24 64 25 26 Descriptives + + 100% Enter 5:09 PM Type here to search W X 2/3/2022X AutoSave @ Off week 5 excel - Search (Alt+Q) A Hadja Kabba HK X File Home Insert Page Layout Formulas Data Review View Help Comments Share Calibri 11 - A A" ab General Insert ~ =1 Ap O Paste BIULA $ ~ % " 00 Conditional Format as Cell Delete Sort & Find & Analyze Formatting Table Styles ~ Format Filter * Select v Data Undo Clipboard Font Alignment Number Styles Cells Editing Analysis N8 I X fx A B C E F G H I J K L M N O P Q R Enter input in blue cells; See answers in yellow cells W N ANSWER Empirical Rule 68-95-99.7 UI A mean 92 Lower number Upper number standard deviation 13 58% 79 105 95% 66 118 99.70% 53 131 14 15 16 34% 34% 17 18 2.35% 2.35% 19 20 0.15% 13.5% 13.5% 0.15% Normal probability Find x given probability Empirical Rule CLT Theorem + Ready + 100% Type here to search O W Rain... ~ 9 7% 5:41 PM 2/3/2022
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
