Homework Help is Here – Start Your Trial Now!
Math
Statistics
Please see the attached tiny sample of a large data set on the passing rate of the Licensing Examination passing rate. Every row in the subset represents a school that was randomly sampled. You may accomplish it either using MS Excel or by hand (if using an MS excel, kindly show the steps or inputed codes. If computing manually shows the solution also). Given this info, kindly compute and interpret. 1. 95% confidence interval estimate of the population average number class size among schools where high school grade is required

Please see the attached tiny sample of a large data set on the passing rate of the Licensing Examination passing rate. Every row in the subset represents a school that was randomly sampled. You may accomplish it either using MS Excel or by hand (if using an MS excel, kindly show the steps or inputed codes. If computing manually shows the solution also). Given this info, kindly compute and interpret. 1. 95% confidence interval estimate of the population average number class size among schools where high school grade is required

Glencoe Algebra 1, Student Edition, 9780079039897, 0079039898, 2018
Glencoe Algebra 1, Student Edition, 9780079039897, 0079039898, 2018
18th Edition
ISBN:9780079039897
Author:Carter
Publisher:Carter
Chapter10: Statistics
Section10.5: Comparing Sets Of Data
Problem 13PPS
See similar textbooks
icon
Related questions
Question

Dataset Google sheet link for better view: http://shorturl.at/awzFP

DATASET High Studentpo Average class Numaccbs Leadmea Ассept Admi College Quali Number of Percentfa Percentfa Passrate Numacc Facimean Actexpgrads school Numcerts size a Rate Quota Grade Exams Students cfull cmast Grade 3500 2 4.333333333 4.307692 4.222222222 4.846154 4 3.923077 3.777777778 3.923077 4.444444444 4.307692 3.444444444 4.384615 199 476 0.647059 0.705882 15.71% 40 45 35 50 0.8 0.7 1 1 2 0.5 0.3 0.969230769 0.944444 0.88 0.666667 50.21% 3700 1 1 1 1 2 1 36.00% 1690 1 1 2 177 0.625 0.125 0.142857 0.142857 284 0.153846 0.846154 119 0.666667 0.555556 25.95% 6283 4 1 0.8 141 34.71% 3000 2500 0.766666667 1.2 45 1 0.48 1 1 3 1 37.42% 45 1 0.75 1 1 1500 3200 37.58% 40 1 1 3.666666667 5 0.9 0.6 1 1 1 2 238 0.6 0.4 1 35 253 196 132 0.333333 443 0.363636 0.636364 795 0.215686 0.764706 333 0.833333 0.666667 4.666666667 3.888888889 2.923077 3.777777778 3.538462 4 3.461538 4.888888889 4.076923 2.666666667 3.615385 4 3.692308 4.888888889 4.846154 4.222222222 4.846154 3.777777778 3.692308 4.111111111 4.230769 3.444444444 3.923077 0.666667 1.5 1.32 20.65% 2 1 1 1 0.75 0.6875 14 14.77% 2000 20 1 0.5 0.125 1232 6623 17000 5.56% 30 40 40 40 1 1 1 0.5 62.71% 1 1 1 0.5 1 1 1 96.02% 1 2 0.754285714 0.06 0 0. 1 2 12 52.34% 10000 1 1 0.96 0.3 1 14.55% 4064 10 1 1 0.75 1 1 60 0.6 0.6 2262 0.603448 1204 0.333333 0.030303 126 0.533333 57.93% 25000 40 1 0.9 0.5 1 2 1 27 45 56.98% 36.61% 49.00% 0.785 0.933333333 0.714286 0.92 699 1 1 0.875 1 3 0.2 0.125 3000 1822 2739 2500 1568 4500 6700 1100 6000 3755 20 1 1 45 40 45 40 35 1 0.65 1 2 175 0.375 33.61% 1 0.85 1 5 357 0.3125 0.5625 4 0.92 1.142857143 0.75 38.07% 1 1 4.444444444 1 1 1 211 0.7 1 42 301 0.533333 0.466667 203 4 4.384615 2.444444444 2.615385 4.777777778 4.692308 4 4.076923 4.111111111 3.692308 3.666666667 2.923077 3 3.538462 3.777777778 3.384615 3.888888889 4.769231 4.666666667 4.769231 3.222222222 3.692308 2.777777778 3.615385 4.444444444 4.538462 3.111111111 4.307692 4 4 3.769231 4.444444444 3.615385 2.888888889 3.692308 4.538462 21.95% 1 0.6 1 1 0.4 0.8 19.02% 0.4 1 1 1 1 0.75 0.25 41.83% 40 1 1 0.457142857 0.5 1 6. 0.5 4 35 45 50 30 1.2 2.2 31.18% 0.85 1 1 201 0.75 47.27% 44.73% 25.31% 54.46% 46.22% 117 0.333333 183 0.235294 0.176471 184 0.857143 0.142857 693 172 200 517 0.277778 0.333333 286 128 0.166667 0.833333 43 0.285714 0.428571 1 1 1 1 1 2.7 1 1 1 1.111111111 0.266667 0.9 5711 2 1 2 7500 50 2 1 1 0.625 0.125 1 45 30 40 40 2500 1 0.833333333 0.275 1 1 1 5 0.5 10 0.466666667 0.666667 1.32 45.05% 1900 1 1 1 1 1 0.6 1 1 29.85% 3266 0.93 1 1 3 23.89% 3000 0.8 0.4 1 1 0.45 0.25 1 0.833333 0.96 0.5 1.057142857 0.909091 0.84 0.882353 0.95 3000 791 36.94% 40 1 1 0.6 1 1 25 25 20 35 30 45 35 50 35 45 43 10.48% 1 1 1 1 1 325 2312 37.84% 1 55 0.666667 3 30.96% 26.80% 74 0.777778 0.222222 84 193 0.428571 0.285714 276 0.777778 0.888889 166 0.214286 0.857143 742 324 0.428571 0.857143 320 0.461538 0.615385 161 0.428571 0.8 1 1 2 1230 1 1 0.4 1 1 4 0.2 1 38.89% 1800 1 1 1 1 3 7 38.24% 12000 1 1 4.222222222 1 1 3 3.444444444 4.222222222 3.923077 3.888888889 4.076923 3.888888889 4.153846 3.333333333 3.923077 41.67% 3995 1 4 0.6 1 1 24.49% 0.555556 3100 3277 1 0.4 1 1 31.35% 1 1.022222222 0.782609 1 1 63.55% 8000 1 1 0.833333333 3 44.55% 7000 2 1 0.933333333 0.857143 1 1 1
Transcribed Image Text:DATASET High Studentpo Average class Numaccbs Leadmea Ассept Admi College Quali Number of Percentfa Percentfa Passrate Numacc Facimean Actexpgrads school Numcerts size a Rate Quota Grade Exams Students cfull cmast Grade 3500 2 4.333333333 4.307692 4.222222222 4.846154 4 3.923077 3.777777778 3.923077 4.444444444 4.307692 3.444444444 4.384615 199 476 0.647059 0.705882 15.71% 40 45 35 50 0.8 0.7 1 1 2 0.5 0.3 0.969230769 0.944444 0.88 0.666667 50.21% 3700 1 1 1 1 2 1 36.00% 1690 1 1 2 177 0.625 0.125 0.142857 0.142857 284 0.153846 0.846154 119 0.666667 0.555556 25.95% 6283 4 1 0.8 141 34.71% 3000 2500 0.766666667 1.2 45 1 0.48 1 1 3 1 37.42% 45 1 0.75 1 1 1500 3200 37.58% 40 1 1 3.666666667 5 0.9 0.6 1 1 1 2 238 0.6 0.4 1 35 253 196 132 0.333333 443 0.363636 0.636364 795 0.215686 0.764706 333 0.833333 0.666667 4.666666667 3.888888889 2.923077 3.777777778 3.538462 4 3.461538 4.888888889 4.076923 2.666666667 3.615385 4 3.692308 4.888888889 4.846154 4.222222222 4.846154 3.777777778 3.692308 4.111111111 4.230769 3.444444444 3.923077 0.666667 1.5 1.32 20.65% 2 1 1 1 0.75 0.6875 14 14.77% 2000 20 1 0.5 0.125 1232 6623 17000 5.56% 30 40 40 40 1 1 1 0.5 62.71% 1 1 1 0.5 1 1 1 96.02% 1 2 0.754285714 0.06 0 0. 1 2 12 52.34% 10000 1 1 0.96 0.3 1 14.55% 4064 10 1 1 0.75 1 1 60 0.6 0.6 2262 0.603448 1204 0.333333 0.030303 126 0.533333 57.93% 25000 40 1 0.9 0.5 1 2 1 27 45 56.98% 36.61% 49.00% 0.785 0.933333333 0.714286 0.92 699 1 1 0.875 1 3 0.2 0.125 3000 1822 2739 2500 1568 4500 6700 1100 6000 3755 20 1 1 45 40 45 40 35 1 0.65 1 2 175 0.375 33.61% 1 0.85 1 5 357 0.3125 0.5625 4 0.92 1.142857143 0.75 38.07% 1 1 4.444444444 1 1 1 211 0.7 1 42 301 0.533333 0.466667 203 4 4.384615 2.444444444 2.615385 4.777777778 4.692308 4 4.076923 4.111111111 3.692308 3.666666667 2.923077 3 3.538462 3.777777778 3.384615 3.888888889 4.769231 4.666666667 4.769231 3.222222222 3.692308 2.777777778 3.615385 4.444444444 4.538462 3.111111111 4.307692 4 4 3.769231 4.444444444 3.615385 2.888888889 3.692308 4.538462 21.95% 1 0.6 1 1 0.4 0.8 19.02% 0.4 1 1 1 1 0.75 0.25 41.83% 40 1 1 0.457142857 0.5 1 6. 0.5 4 35 45 50 30 1.2 2.2 31.18% 0.85 1 1 201 0.75 47.27% 44.73% 25.31% 54.46% 46.22% 117 0.333333 183 0.235294 0.176471 184 0.857143 0.142857 693 172 200 517 0.277778 0.333333 286 128 0.166667 0.833333 43 0.285714 0.428571 1 1 1 1 1 2.7 1 1 1 1.111111111 0.266667 0.9 5711 2 1 2 7500 50 2 1 1 0.625 0.125 1 45 30 40 40 2500 1 0.833333333 0.275 1 1 1 5 0.5 10 0.466666667 0.666667 1.32 45.05% 1900 1 1 1 1 1 0.6 1 1 29.85% 3266 0.93 1 1 3 23.89% 3000 0.8 0.4 1 1 0.45 0.25 1 0.833333 0.96 0.5 1.057142857 0.909091 0.84 0.882353 0.95 3000 791 36.94% 40 1 1 0.6 1 1 25 25 20 35 30 45 35 50 35 45 43 10.48% 1 1 1 1 1 325 2312 37.84% 1 55 0.666667 3 30.96% 26.80% 74 0.777778 0.222222 84 193 0.428571 0.285714 276 0.777778 0.888889 166 0.214286 0.857143 742 324 0.428571 0.857143 320 0.461538 0.615385 161 0.428571 0.8 1 1 2 1230 1 1 0.4 1 1 4 0.2 1 38.89% 1800 1 1 1 1 3 7 38.24% 12000 1 1 4.222222222 1 1 3 3.444444444 4.222222222 3.923077 3.888888889 4.076923 3.888888889 4.153846 3.333333333 3.923077 41.67% 3995 1 4 0.6 1 1 24.49% 0.555556 3100 3277 1 0.4 1 1 31.35% 1 1.022222222 0.782609 1 1 63.55% 8000 1 1 0.833333333 3 44.55% 7000 2 1 0.933333333 0.857143 1 1 1
Please see the attached tiny sample of a large data set on the passing rate of the Licensing Examination passing rate. Every row in the subset represents a school that was randomly sampled. You may accomplish it either using MS Excel or by hand (if using an MS excel, kindly show the steps or inputed codes. If computing manually shows the solution also). Given this info, kindly compute and interpret. 1. 95% confidence interval estimate of the population average number class size among schools where high school grade is required
Transcribed Image Text:Please see the attached tiny sample of a large data set on the passing rate of the Licensing Examination passing rate. Every row in the subset represents a school that was randomly sampled. You may accomplish it either using MS Excel or by hand (if using an MS excel, kindly show the steps or inputed codes. If computing manually shows the solution also). Given this info, kindly compute and interpret. 1. 95% confidence interval estimate of the population average number class size among schools where high school grade is required
Expert Solution
steps

Step by step

Solved in 2 steps with 1 images

SEE SOLUTIONCheck out a sample Q&A here
Blurred answer
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Glencoe Algebra 1, Student Edition, 9780079039897…
Glencoe Algebra 1, Student Edition, 9780079039897…
Algebra
ISBN:
9780079039897
Author:
Carter
Publisher:
McGraw Hill
Holt Mcdougal Larson Pre-algebra: Student Edition…
Holt Mcdougal Larson Pre-algebra: Student Edition…
Algebra
ISBN:
9780547587776
Author:
HOLT MCDOUGAL
Publisher:
HOLT MCDOUGAL
College Algebra (MindTap Course List)
College Algebra (MindTap Course List)
Algebra
ISBN:
9781305652231
Author:
R. David Gustafson, Jeff Hughes
Publisher:
Cengage Learning
SEE MORE TEXTBOOKS