1 (1)

.pdf

School

Purdue University *

*We aren’t endorsed by this school

Course

30301

Subject

Statistics

Date

Apr 3, 2024

Type

pdf

Pages

Uploaded by ChefTurtleMaster4422

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 Course for credit. GO TO NEXT PAGE FOR #8 - #15 1. Complete the table below. (1.5 points) Sample size, 𝑛 61 Sample mean, 𝑥̅ 12870.37 Sample standard deviation, 𝑠 6221.155 2. Type your answer, rounded to 4 decimals, below: (1.5 points) 𝒔 𝑿 ̅ = 796.5373 3. Type your answer below: (1.5 points) If the sample size is larger than 30 or if both the population standard deviation is known, the Normal distribution can be used. Otherwise, the t-distribution is preferred, with degrees of freedom equal to n−1. 4. Type your answer, rounded to 4 decimal places, below: (1 point) 𝒎 = 2119.0146 5. Type your answer, rounded to 2 decimal places, below: (1.5 points) (10751.36,14989.39) 6. Type your answer below: (2 points) We are 99% confident that the true mean consulting fee lies between 10751.36 and 14989.39 USD. 7. Paste your Excel output below. (1.5 points) sample size 61 sample mean 12870.37 sample standard deviation 6221.155 standard error 796.5373 significance level 0.01 margin of error 2119.0146 lower bound 10751.36 upper bound 14989.39

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 Brightspace . 8. Paste your Excel output below. (1.5 points) Consulting Fee (USD) Mean 12870.372 Standard Error 796.537273 Median 13337.91 Mode #N/A Standard Deviation 6221.15498 Sample Variance 38702769.2 Kurtosis -0.2008909 Skewness 0.30986237 Range 30512.54 Minimum 188.39 Maximum 30700.93 Sum 785092.69 Count 61 Confidence Level(95.0%) 1593.31177 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, 𝑥 47 the sample proportion, 𝑝̂ 0.7705 11. Type your answer below. (1 point) FALSE 12. Type your answer, rounded to 4 decimals, below. (1.5 points) 𝒔 𝒑 ̂ = 0.0538 13. Paste your Excel output below. (2 points) number of successes 47 sample proportion 0.7705 standard error 0.0538 margin of error 0.0885 lower bound 0.682 upper bound 0.859

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

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