EA 6 - ANSWER FORM (2) (1)

docx

School

Mission College *

*We aren’t endorsed by this school

Course

Subject

Statistics

Date

Apr 3, 2024

Type

docx

Pages

Uploaded by SargentMonkeyMaster2131

STAT 30301 – EXCEL ACTIVITY 6: ANSWER FORM 20 points Enter your answers & Excel outputs by their problem numbers. Save completed form as a pdf. Submit completed pdf of THIS FORM to your Brightspace STAT 30301 Merge Course for credit. 1. Type your answer below. (2 points) Measure Notation (Letter) Value Population mean E 50.09 Sample mean C 52.88 Population standard deviation D 9.43 Sample size B 103 2. Type your answer below: (1 point) Shape: The shape of the distribution is normal, since n>30. 3. Type your answer below: (1.5 points) μ x = ¿ 50.09 4. Type your work and answer below: (2 points) σ x = ¿ 9.2/sqrt(103) = 0.906 5. Paste your Excel output below: (2 points) Problems 1-8: Sample Mean 52.88 Population Standard Deviation 9.42794 3 Sample Size 103 Standard Error of x-bar 0.90650 3 Significance Level 0.01 Margin of Error: m = 2.39285 6. Type your answer below: (1.5 points) m = 2.39 * 0.906503 = 2.17 7. Type your answer below. (2 points) GO TO NEXT PAGE FOR #8 - #13

Xbar = 52.88 hours

8. Type your answer below. (2 points) The average duration of the project is between 50.4815 and 55.2785 hours. 9. Type your work and answer below. (2 points) σ y = ¿ 1.188 10. Type your answer below: (1 point) The standard error is lower because the sample size is smaller. 11. Type your answer below: (2 points) The mean duration of hours is between 51.69 and 54.09 hours. 12. Type your answer below: (1 point) a. TRUE b. FALSE 13. SAVE THIS ANSWER FORM D ocument AS A PDF ; any other file type will receive AT MOST 75% credit for the assignment. Upload your SINGLE pdf file to the Excel Activity 6 Assignment in the Brightspace Merge course .

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

EA 1 ANSWER FORM Eugene Chi (1).pdf

EA 3 ANSWER FORM Eugene Chi.pdf

Independent-Samples t Lab - Salary - accessible - Copy.docx

STAT 3022 HW 1.pdf

TEST 2 REVIEW (STA 2023).pdf

TEST 1 REVIEW (STA 2023).pdf

Stats 250 Practice Exam 2 W23 SOLUTIONS (1).pdf

lab5_exercises_new_2022.docx

lab4_exercises_new.docx

lab2_exercises.docx

lab3_exercises_new.docx

lab1_exercises.docx

Recommended textbooks for you

Glencoe Algebra 1, Student Edition, 9780079039897...

Algebra

ISBN:9780079039897

Author:Carter

Publisher:McGraw Hill

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

Algebra

ISBN:9780547587776

Author:HOLT MCDOUGAL

Publisher:HOLT MCDOUGAL

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

Algebra

ISBN:9781680331141

Author:HOUGHTON MIFFLIN HARCOURT

Publisher:Houghton Mifflin Harcourt

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
Holt Mcdougal Larson Pre-algebra: Student Edition...
Algebra
ISBN:9780547587776
Author:HOLT MCDOUGAL
Publisher:HOLT MCDOUGAL
Big Ideas Math A Bridge To Success Algebra 1: Stu...
Algebra
ISBN:9781680331141
Author:HOUGHTON MIFFLIN HARCOURT
Publisher:Houghton Mifflin Harcourt
College Algebra (MindTap Course List)
Algebra
ISBN:9781305652231
Author:R. David Gustafson, Jeff Hughes
Publisher:Cengage Learning