EA 7 ANSWER FORM

pdf

School

Purdue University *

*We aren’t endorsed by this school

Course

30301

Subject

Statistics

Date

Apr 3, 2024

Type

pdf

Pages

Uploaded by Flightologist

STAT 30301 – EXCEL ACTIVITY 7: 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. GO TO NEXT PAGE FOR #8 - #15 1. Complete the table below. (1.5 points) Sample size, 𝑛 109 Sample mean, 𝑥̅ 272.73 Sample standard deviation, 𝑠 86.668 2. Type your answer, rounded to 4 decimals, below: (1.5 points) 𝒔 𝑿 ̅ = 8.3013 3. Type your answer below: (1.5 points) T distribution, because we do not have the population std. dev. As a result, we cannot use the z distribution. There are 108 dF. 4. Type your answer, rounded to 4 decimal places, below: (1 point) 𝒎 = 21.7669 5. Type your answer, rounded to 2 decimal places, below: (1.5 points) (250.96,294.49) 6. Type your answer below: (2 points) We are 99% confident that the population mean weekly treatment expense for factories is between $250.96 and $294.49. 7. Paste your Excel output below. (1.5 points) sample size 109 sample mean 272.73 sample standard deviation 86.66779 standard error 8.301268 significance level 0.01 margin of error 21.76692 lower bound 250.96 upper bound 294.49

15. SAVE THIS ANSWER FORM Document 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 7 Assignment in the Brightspace Merge course . 8. Paste your Excel output below. (1.5 points) Weekly Treatment Expense Mean 272.7255963 Standard Error 8.301268396 Median 278.71 Mode #N/A Standard Deviation 86.66778647 Sample Variance 7511.305212 Kurtosis 0.698131777 Skewness - 0.700968199 Range 455.68 Minimum 9.06 Maximum 464.74 Sum 29727.09 Count 109 Confidence Level(90.0%) 13.77251107 9. Type your answer below: (1 point) FALSE 10. Complete the table below. Round to 4 decimals if needed. (1 point) number of successes in the variable of interest, 𝑥 38 the sample proportion, 𝑝̂ .3486 11. Type your answer below. (1 point) FALSE 12. Type your answer, rounded to 4 decimals, below. (1.5 points) 𝒔 𝒑̂ = 0.0456 13. Paste your Excel output below. (2 points) number of successes 38 sample proportion 0.348624 standard error 0.0456 margin of error 0.089374 lower bound 0.259249 upper bound 0.437998

14. Type your answer, rounded to 4 decimal places, below: (1.5 points) (.2592, .4380)

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

Quiz 4_ Attempt review _ Courses 2023-2024.pdf

Quiz 1_ Attempt review _ Courses 2023-2024.pdf

Quiz 2_ Attempt review _ Courses 2023-2024.pdf

EA 6 ANSWER FORM.pdf

EA 9 ANSWER FORM.pdf

Exam Cheat Sheet.docx

CJ-407 3-2.docx

MBA 662 HW 4 - Tara McAllister (1).xlsx

Week 7_Extra practice_independent samples_KEY.docx

Week 7 In-class activity_FA23_Key_v2.docx

CPSC_103_Midterm_2020W2_Solution-1.pdf

Recommended textbooks for you

Glencoe Algebra 1, Student Edition, 9780079039897...

Algebra

ISBN:9780079039897

Author:Carter

Publisher:McGraw Hill

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

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

Algebra

ISBN:9780547587776

Author:HOLT MCDOUGAL

Publisher:HOLT MCDOUGAL

SEE MORE TEXTBOOKS

Recommended textbooks for you

Glencoe Algebra 1, Student Edition, 9780079039897...
Algebra
ISBN:9780079039897
Author:Carter
Publisher:McGraw Hill
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
Holt Mcdougal Larson Pre-algebra: Student Edition...
Algebra
ISBN:9780547587776
Author:HOLT MCDOUGAL
Publisher:HOLT MCDOUGAL