Transcribed TextTranscribed Text

Topic 4: ANOVA Excel Worksheet Directions: Answer all questions 1. SYSTOLIC BLOOD PRESSURE IN DIFFERENT AGE GROUPS The following table contains a random sample of 40 women partitioned into three groups: Group 1: ages below 20 Group 2: ages 20 through 40 Group 3: ages over 40 The values in the table are the systolic blood pressure levels The Hypothesis Test: H1:at least one of the treatment means is different Use the Excel Analysis ToolPak to create an Anova Single Factor table. Is there sufficient evidence to support the claim that women in the different age categories have different mean blood pressure levels? Give reasons for your decision. Statistical Conclusion: Experimental Conclusion: Group 1 Group 2 Group 3 [Place your Anova table here] 104 97 123 106 116 107 Anova: Single Factor 104 98 127 92 95 133 SUMMARY 112 108 114 Groups Count Sum Average Voriance 107 106 93 Group 1 102 113 Group 2 108 114 Group 3 94 116 100 155 101 105 ANOVA 119 Source of Variation SS df MS F P-value F crit 89 Between Groups 113 Within Groups 99 93 Total 107 125 104 110 124 181 118

Solution PreviewSolution Preview

This material may consist of step-by-step explanations on how to solve a problem or examples of proper writing, including the use of citations, references, bibliographies, and formatting. This material is made available for the sole purpose of studying and learning - misuse is strictly forbidden.

ANOVA: Systolic Blood Pressure
    $15.00 for this solution

    PayPal, G Pay, ApplePay, Amazon Pay, and all major credit cards accepted.

    Find A Tutor

    View available General Statistics Tutors

    Get College Homework Help.

    Are you sure you don't want to upload any files?

    Fast tutor response requires as much info as possible.

    Upload a file
    Continue without uploading

    We couldn't find that subject.
    Please select the best match from the list below.

    We'll send you an email right away. If it's not in your inbox, check your spam folder.

    • 1
    • 2
    • 3
    Live Chats