EA 10 ANSWER FORM

docx

School

Purdue University *

*We aren’t endorsed by this school

Course

30301

Subject

Statistics

Date

Feb 20, 2024

Type

docx

Pages

Uploaded by SargentClover22522

STAT 30301 –EXCEL ACTIVITY 10: 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) mu€-mu® = difference of population means of daily revenue from etail and retail 2. Type your answer below. (2 points) H0: mu€ - mu® = 150 Ha: mu€ - mu® < 150 3. Paste your output below. (1 point) t-Test: Two-Sample Assuming Unequal Variances Etail Revenue Retail Revenue Mean 527.964902 416.1905128 Variance 10174.02508 7866.882473 Observations 51 39 Hypothesized Mean Difference 150 df 86 t Stat - 1.908406683 P(T<=t) one-tail 0.029837351 t Critical one-tail 1.662765449 P(T<=t) two-tail 0.059674702 t Critical two-tail 1.987934206 4. Type your answer below. (2 points) P(t<-1.91) = 0.029837 5. Type your answer below: (1 point) -1.662765 6. Type your answer below: (2 points) Reject H0 at alpha = 0.05. Conclude that there is evidence that the difference of population mean daily revenue from etail and retail gift shops is less than $150. GO TO NEXT PAGE FOR #7 - #14

7. Type your answer below. (2 points) H0: the distribution of favorite ice cream flavors for Purdue students is as claimed. Ha: the distribution of favorite ice cream flavors for Purdue students is not as claimed. 8. Paste your output below: (1 point) Row Labels Count of Favorite Ice Cream Flavor Chocolate 46 Mint 5 Pecan 6 Strawberry 18 Vanilla 45 (blank) Grand Total 120 9. Paste your output below: (1 point) Chocolate Mint Pecan Strawberry Vanilla Hypothesized Proportions 0.31 0.1 0.07 0.18 0.34 Expected Counts 37.2 12 8.4 21.6 40.8 10. Type your answer below. (2 points) X^2 statistic = 7.88 11. Type your answer below. (1 point) P(chi square > 7.88) = 1-P(chi square< 7.88) = 0.095955 12. Type your answer below. (1 point) 13.27670414 13. Type your answer below: (2 points) Do not reject H0 at alpha = 0.01. Conclude there is not enough evidence that the distribution of favorite ice cream flavors for Purdue students is not as claimed. 14. 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 10 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

IMG_8075.png

IMG_8079.png

BIO120L-M7-CarryingCapacityandDemographicsLabReport-Wagner.docx

Quiz 5 Psych100.pdf

Chapter 4 Review Questions.docx

homework#5.docx

MHA 507 - Group Data.docx

12-2_Calculating_PMI_Using_Algor_Mortis (1).docx

aba 622 SAFMEDS Week 6.docx

ASSIGNMENT2.docx

Cemetery Demography Lab_F23.docx

Week7Labfinished.docx

Recommended textbooks for you

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

Algebra

ISBN:9780547587776

Author:HOLT MCDOUGAL

Publisher:HOLT MCDOUGAL

Elementary Algebra

Algebra

ISBN:9780998625713

Author:Lynn Marecek, MaryAnne Anthony-Smith

Publisher:OpenStax - Rice University

Functions and Change: A Modeling Approach to Coll...

Algebra

ISBN:9781337111348

Author:Bruce Crauder, Benny Evans, Alan Noell

Publisher:Cengage Learning

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

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

Algebra

ISBN:9781680331141

Author:HOUGHTON MIFFLIN HARCOURT

Publisher:Houghton Mifflin Harcourt

SEE MORE TEXTBOOKS

Recommended textbooks for you

Holt Mcdougal Larson Pre-algebra: Student Edition...
Algebra
ISBN:9780547587776
Author:HOLT MCDOUGAL
Publisher:HOLT MCDOUGAL
Elementary Algebra
Algebra
ISBN:9780998625713
Author:Lynn Marecek, MaryAnne Anthony-Smith
Publisher:OpenStax - Rice University
Functions and Change: A Modeling Approach to Coll...
Algebra
ISBN:9781337111348
Author:Bruce Crauder, Benny Evans, Alan Noell
Publisher:Cengage Learning
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
Big Ideas Math A Bridge To Success Algebra 1: Stu...
Algebra
ISBN:9781680331141
Author:HOUGHTON MIFFLIN HARCOURT
Publisher:Houghton Mifflin Harcourt