Lab 2-5 college scorecard transform Raghav Kapoor 300357960

docx

School

Douglas College *

*We aren’t endorsed by this school

Course

3880

Subject

Statistics

Date

Feb 20, 2024

Type

docx

Pages

Uploaded by EarlStrawCaterpillar18

Lab 2-5 Raghav Kapoor 300357960 MS 2-5 MA

2-5 MB Q1. How many schools report average SAT scores? 1304 schools Q2. What is the average completion rate (C150 4) of all the schools? 0.47795(47%) average completion rate. Q3. How many schools report data to the U.S. Department of Education? 7282 schools report data to the U.S. Department of Education. 2-5 Analysis Questions (LO 2-3) AQ1. In the checksums, you validated that the average SAT score for all of the records is 1,059.07. When we work with the data more rigorously, several tests will require us to transform NULL or blank values. If you were to transform the NULL SAT values into 0, what would happen to the average (would it stay the same, decrease, or increase? Average marks will decease as number students with 0 marks will increase.

AQ2. How would that change to the average affect the way you would interpret the data? NULL values into 0 may introduce bias or misrepresentation in the data. A score of 0 may not accurately reflect the actual performance of the students who originally had NULL SAT values. It's crucial to consider the reasons for missing data and whether assigning a 0 is a valid representation. AQ3. What would happen if we excluded all schools that don't report an average SAT score? Ans. The interpretation will be more accurate and not misleading.

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

Related Documents

WK6Assgnthompsonapart2.docx

MAT-FPX2001_BurnettJessica_Assessment 1-1.docx

aames_hypothesistesting_02042024.docx

Module 6 Fill in the Blank_ BADM 503-A02_ Quantitative Analysis In Bus.pdf

A3 In class Assignment Answer Sheet Week 3 Anusree R.docx

AP Statistics 2021 Free-Response Questions (2).pdf

c01Exploration_1_1_Interactive_Workbook.pdf

Recommended textbooks for you

Glencoe Algebra 1, Student Edition, 9780079039897...

Algebra

ISBN:9780079039897

Author:Carter

Publisher:McGraw Hill

Algebra: Structure And Method, Book 1

Algebra

ISBN:9780395977224

Author:Richard G. Brown, Mary P. Dolciani, Robert H. Sorgenfrey, William L. Cole

Publisher:McDougal Littell

Algebra & Trigonometry with Analytic Geometry

Algebra

ISBN:9781133382119

Author:Swokowski

Publisher:Cengage

Big Ideas Math A Bridge To Success Algebra 1: Stu...

Algebra

ISBN:9781680331141

Author:HOUGHTON MIFFLIN HARCOURT

Publisher:Houghton Mifflin Harcourt

Holt Mcdougal Larson Pre-algebra: Student Edition...

Algebra

ISBN:9780547587776

Author:HOLT MCDOUGAL

Publisher:HOLT MCDOUGAL

College Algebra (MindTap Course List)

Algebra

ISBN:9781305652231

Author:R. David Gustafson, Jeff Hughes

Publisher:Cengage Learning

SEE MORE TEXTBOOKS

Recommended textbooks for you

Glencoe Algebra 1, Student Edition, 9780079039897...
Algebra
ISBN:9780079039897
Author:Carter
Publisher:McGraw Hill
Algebra: Structure And Method, Book 1
Algebra
ISBN:9780395977224
Author:Richard G. Brown, Mary P. Dolciani, Robert H. Sorgenfrey, William L. Cole
Publisher:McDougal Littell
Algebra & Trigonometry with Analytic Geometry
Algebra
ISBN:9781133382119
Author:Swokowski
Publisher:Cengage
Big Ideas Math A Bridge To Success Algebra 1: Stu...
Algebra
ISBN:9781680331141
Author:HOUGHTON MIFFLIN HARCOURT
Publisher:Houghton Mifflin Harcourt
Holt Mcdougal Larson Pre-algebra: Student Edition...
Algebra
ISBN:9780547587776
Author:HOLT MCDOUGAL
Publisher:HOLT MCDOUGAL
College Algebra (MindTap Course List)
Algebra
ISBN:9781305652231
Author:R. David Gustafson, Jeff Hughes
Publisher:Cengage Learning