Ch6_Quartiles_Histgram_BoxPlot_ProbPlot-demo

xlsx

School

University of Notre Dame *

*We aren’t endorsed by this school

Course

ECE

Subject

Statistics

Date

Feb 20, 2024

Type

xlsx

Pages

16

Uploaded by CoachField13271

Report
Orig_Data Order_Indx Ordered_Data sample mean= 105 1 76 sample variance= 221 2 87 n = 183 3 97 186 4 101 OrderIndx_q1 = 121 5 105 OrderIndx_q2 = 181 6 110 OrderIndx_q3 = 180 7 115 143 8 118 97 9 120 154 10 121 153 11 123 174 12 131 120 13 133 168 14 133 167 15 134 141 16 135 245 17 135 228 18 141 174 19 142 199 20 143 181 21 145 158 22 146 176 23 148 110 24 149 163 25 149 131 26 150 154 27 150 115 28 151 160 29 153 208 30 154 158 31 154 133 32 156 207 33 157 180 34 158 190 35 158 193 36 158 194 37 158 133 38 160 156 39 160 123 40 160 134 41 163 178 42 163 76 43 165 167 44 167 184 45 167 135 46 168
229 47 169 146 48 170 218 49 171 157 50 171 101 51 172 171 52 174 165 53 174 172 54 175 158 55 176 169 56 176 199 57 178 151 58 180 142 59 180 163 60 181 145 61 181 171 62 183 148 63 184 158 64 186 160 65 190 175 66 193 149 67 194 87 68 196 160 69 199 237 70 199 150 71 200 135 72 201 196 73 207 201 74 208 200 75 218 176 76 221 150 77 228 170 78 229 118 79 237 149 80 245
162.6625 1140.631 sample std. dev. = 33.8 80 Lecture Formula Excel Quartile Output 20.25 q1= 143.5 143.5 40.50 q2= 161.5 161.5 60.75 q3= 181.0 181
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
Ex 6-3 Dataset: 3 q1 = 6 7 q2 = 12 8 q3 = 16 5 12 14 21 13 18
Orig_Data Bins UpperLimit Frequency 105 min= 76 90 2 221 max= 245 110 4 183 130 5 186 Range= 169 150 16 121 n= 8.94 170 21 181 190 17 180 Bin-width= 18.8 210 9 143 230 4 97 250 2 154 153 174 120 168 167 141 245 228 174 199 181 158 176 110 163 131 154 115 160 208 158 133 207 180 190 193 194 133 156 123 134 178 76 167 184 135 (70,90] (90, 110] (110, 130] (130,150] (150, 170] (170, 190] (19 0 5 10 15 20 25 2 4 5 16 21 17 Histogram of Compressive Strength Compressive Strength Frequency
229 146 218 157 101 171 165 172 158 169 199 151 142 163 145 171 148 158 160 175 149 87 160 237 150 135 196 201 200 176 150 170 118 149
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
Bins Frequency (70,90] 2 Refer to this link belo (90, 110] 4 (110, 130] 5 (130,150] 16 (150, 170] 21 (170, 190] 17 (190, 210] 9 (210, 230] 4 (230, 250] 2 https://www.techon 190, 210] (210, 230] (230, 250] 9 4 2 h Data
ow to learn how to use FREQUENCEY function to find freqency distribution. nthenet.com/excel/formulas/frequency.php
Orig_Data 105 221 183 186 121 181 180 143 97 154 153 174 120 168 167 141 245 228 174 199 181 158 176 110 163 131 154 Note: click the boxplot and hover over the data points will s 115 160 208 158 133 207 180 190 193 194 133 156 123 134 178 76 167 184 This chart isn't available in your version of Excel. Editing this shape or saving this workbook into a different file format will permanently break the chart.
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
135 229 146 218 157 101 171 165 172 158 169 199 151 142 163 145 171 148 158 160 175 149 87 160 237 150 135 196 201 200 click the boxplot and hover over the data points will show the data values 176 150 170 118 149
show the data values
Orig_Data UpperLimit of Bins Freq. Actual Bins Range 105 90 2 (70,90] 221 110 4 (90, 110] 183 130 5 (110, 130] 186 150 16 (130,150] 121 170 21 (150, 170] 181 190 17 (170, 190] 180 210 9 (190, 210] 143 230 4 (210, 230] 97 250 2 (230, 250] 154 153 174 120 Refer to this link below to learn how to use FREQUENCEY function to find freq 168 167 141 245 228 174 199 181 158 176 110 163 131 154 115 160 208 158 133 207 180 190 193 194 133 156 123 134 178 76 167 184 135 https://www.techonthenet.com/excel/formulas/frequency.php (70,90] (90, 110] (110, 130] (130,150] (150, 170] (170, 19 0 5 10 15 20 25 2 4 5 16 21 17 Histogram Compressive strength (psi) Frequency
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
229 146 218 157 101 171 165 172 158 169 199 151 142 163 145 171 148 158 160 175 149 87 160 237 150 135 196 201 200 click the boxplot and hover over the data points will show the data values 176 150 170 118 149
Bins Freq. (70,90] 2 (90, 110] 4 (110, 130] 5 (130,150] 16 (150, 170] 21 (170, 190] 17 (190, 210] 9 (210, 230] 4 (230, 250] 2 qency distribution. 90] (190, 210] (210, 230] (230, 250] 9 4 2
Data x(j) j (j-0.5)/10 z_j 176 176 1 0.05 -1.64 191 183 2 0.15 -1.04 214 185 3 0.25 -0.67 220 190 4 0.35 -0.39 205 191 5 0.45 -0.13 192 192 6 0.55 0.13 201 201 7 0.65 0.39 190 205 8 0.75 0.67 183 214 9 0.85 1.04 185 220 10 0.95 1.64 -3.30 -2.30 -1.30 -0.30 0.70 1.70 2.70
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
Normal Probability Plot

Related Documents

Week 4 test (STATS).docx
Copy of BUS-352-RS-Homework_Ch3_Template.xlsx
assignment9.xlsx
Understanding patterns.docx
Screen Shot 2024-02-18 at 4.09.08 PM.png
Sec 2.1.pdf
Review - Statistics - Fall 2020(1).docx
Critically Assessed Study Article Form.docx
Normal Distribution - Introduction.docx
SPSS Homework One-Way ANOVA Assignment Instructions.docx
Assignment Data Gathering.docx
Practice Quiz 2 Problem 3 Solution.docx
Recommended textbooks for you
Text book image
Holt Mcdougal Larson Pre-algebra: Student Edition...
Algebra
ISBN:9780547587776
Author:HOLT MCDOUGAL
Publisher:HOLT MCDOUGAL
Text book image
Glencoe Algebra 1, Student Edition, 9780079039897...
Algebra
ISBN:9780079039897
Author:Carter
Publisher:McGraw Hill
SEE MORE TEXTBOOKS
Recommended textbooks for you
Text book image
Holt Mcdougal Larson Pre-algebra: Student Edition...
Algebra
ISBN:9780547587776
Author:HOLT MCDOUGAL
Publisher:HOLT MCDOUGAL
Text book image
Glencoe Algebra 1, Student Edition, 9780079039897...
Algebra
ISBN:9780079039897
Author:Carter
Publisher:McGraw Hill
SEE MORE TEXTBOOKS