PH 520 West Coast University Week 4 Categorical and Continuous Variables Statistics Project

Openupthe small Excel database that is linked below.

Week 4 Database

Don't use plagiarized sources. Get Your Custom Essay on
PH 520 West Coast University Week 4 Categorical and Continuous Variables Statistics Project
Just from $13/Page
Order Essay

With this database, you will:

  • Identify and list categorical and continuous variables.
  • Calculate frequencies and percentages for all of the categorical variables, and means, and standard deviations for the continuous variables.
  • Run a one-sample z test of proportions for one categorical variable. Here is an example in terms of wording: “Is the proportion of English speaking patients greater than 50%?” Using .05 level of significant test the appropriate hypotheses.Write the null and alternate hypothesesWhat is the proportion of English speaking patientsWhat is the standard error and z statistics Find critical z and p value. Is the p value significant? Conclusion?Run an independent samples t-test to compare two groups of people (specified by a dichotomous variable) on one continuous variable. Using .05 level of significant test the appropriate hypotheses. In order to run this test statistics you have to re-arrange your data.Write the null and alternate hypotheses.What is the calculated mean for each group? What is the confidence interval for each group?What is the critical t value?Is the p value significant? Conclusion?

    Need Excel help? Click on the Excel Function Help Workbook under Course Materials.

    ID
    AA-31
    AD-29
    AF-02
    AG-25
    AG-45
    AM-01
    BS-52
    CC-63
    CK-42
    CN-18
    CR-03
    DC-09
    DH-33
    EG-24
    EG-46
    EK-34
    EM-51
    FA-50
    FP-04
    GC-05
    GK-11
    GV-23
    HC-10
    HK-12
    HL-17
    HL-55
    IH-54
    JB-47
    JC-22
    JC-39
    JJ-49
    JK-13
    JK-36
    JMC-56
    KC-59
    KK-14
    KK-35
    KL-57
    KP-64
    KS-20
    LC-06
    MG-30
    ML-41
    MP-48
    MR-32
    MW-67
    Age
    74.00
    73.00
    77.00
    72.00
    66.00
    76.00
    72.00
    77.00
    75.00
    79.00
    71.00
    71.00
    66.00
    67.00
    79.00
    66.00
    71.00
    78.00
    67.00
    67.00
    84.00
    88.00
    79.00
    86.00
    81.00
    72.00
    77.00
    82.00
    86.00
    73.00
    76.00
    81.00
    75.00
    73.00
    78.00
    81.00
    83.00
    71.00
    72.00
    66.00
    67.00
    68.00
    72.00
    70.00
    63.00
    73.00
    Language Fracture Number of Meds Ability
    1.00
    0
    1.00
    1.00
    0
    0.00
    1.00
    0
    3.00
    1.00
    0
    5.00
    1.00
    0
    0.00
    1.00
    0
    3.00
    1.00
    0
    1.00
    2.00
    0
    10.00
    2.00
    1
    7.00
    2.00
    1
    4.00
    1.00
    0
    3.00
    2.00
    0
    2.00
    1.00
    0
    0.00
    1.00
    0
    0.00
    1.00
    0
    0.00
    2.00
    0
    4.00
    1.00
    0
    0.00
    1.00
    1
    6.00
    1.00
    0
    0.00
    1.00
    1
    2.00
    2.00
    0
    8.00
    1.00
    0
    1.00
    2.00
    0
    7.00
    2.00
    0
    4.00
    2.00
    0
    1.00
    2.00
    0
    3.00
    2.00
    1
    0.00
    1.00
    0
    0.00
    1.00
    0
    0.00
    2.00
    0
    1.00
    1.00
    0
    0.00
    2.00
    0
    5.00
    2.00
    0
    1.00
    2.00
    0
    0.00
    2.00
    1
    5.00
    2.00
    0
    3.00
    2.00
    0
    4.00
    2.00
    0
    18.00
    2.00
    1
    9.00
    2.00
    0
    3.00
    1.00
    0
    4.00
    1.00
    0
    0.00
    2.00
    0
    5.00
    1.00
    0
    6.00
    1.00
    0
    0.00
    2.00
    0
    1.00
    1
    1
    2
    1
    1
    1
    1
    2
    3
    1
    2
    2
    1
    1
    1
    1
    1
    1
    1
    1
    3
    3
    1
    1
    3
    1
    1
    3
    3
    2
    1
    3
    1
    1
    2
    3
    3
    2
    3
    2
    1
    1
    1
    1
    1
    1
    Smoke status
    1
    1
    2
    1
    1
    1
    1
    2
    1
    1
    2
    2
    1
    1
    1
    1
    1
    1
    1
    1
    2
    2
    1
    1
    2
    1
    1
    2
    2
    2
    1
    2
    1
    1
    2
    1
    1
    2
    1
    2
    1
    1
    1
    1
    1
    1
    OY-65
    RG-07
    RG-26
    RO-53
    RP-28
    RR-27
    SHC-58
    SIC-62
    SJ-08
    SJ-43
    SK-15
    SKC-61
    SWK-66
    TP-19
    WC-40
    YJK-37
    YK-16
    YK-60
    YL-68
    YYK-38
    71.00
    87.00
    75.00
    71.00
    84.00
    68.00
    74.00
    70.00
    63.00
    71.00
    79.00
    71.00
    79.00
    81.00
    84.00
    75.00
    89.00
    79.00
    69.00
    71.00
    2.00
    1.00
    1.00
    1.00
    1.00
    1.00
    2.00
    2.00
    1.00
    2.00
    2.00
    2.00
    2.00
    2.00
    2.00
    2.00
    2.00
    2.00
    2.00
    2.00
    0
    0
    0
    0
    1
    0
    0
    0
    0
    0
    0
    0
    0
    1
    1
    0
    0
    1
    0
    0
    0.00
    0.00
    5.00
    1.00
    0.00
    0.00
    14.00
    4.00
    5.00
    4.00
    6.00
    6.00
    9.00
    3.00
    5.00
    7.00
    3.00
    0.00
    0.00
    4.00
    2
    3
    1
    1
    3
    1
    1
    2
    2
    2
    1
    2
    2
    1
    1
    1
    3
    2
    1
    1
    2
    2
    1
    1
    2
    1
    1
    2
    2
    2
    1
    2
    2
    1
    1
    1
    2
    2
    1
    1
    Name
    ID
    Age
    Language
    Fracture
    Number of Meds
    Ability
    Smoke status
    Description
    Participant ID number
    Age in years
    Preferred language
    Fractured hip, leg, arm, or spine
    Number of medications used regularly
    Ability to take care of own personal needs
    Past Smoke history
    Answers
    Actual age
    1= English 2= Spanish
    0= No, 1= Yes
    Total number of meds
    1= can do, 2= can do with some difficulty, 3= can not do without help
    1= nonsmoker 2=smoker

    Calculate your order
    Pages (275 words)
    Standard price: $0.00
    Client Reviews
    4.9
    Sitejabber
    4.6
    Trustpilot
    4.8
    Our Guarantees
    100% Confidentiality
    Information about customers is confidential and never disclosed to third parties.
    Original Writing
    We complete all papers from scratch. You can get a plagiarism report.
    Timely Delivery
    No missed deadlines – 97% of assignments are completed in time.
    Money Back
    If you're confident that a writer didn't follow your order details, ask for a refund.

    Calculate the price of your order

    You will get a personal manager and a discount.
    We'll send you the first draft for approval by at
    Total price:
    $0.00
    Power up Your Academic Success with the
    Team of Professionals. We’ve Got Your Back.
    Power up Your Study Success with Experts We’ve Got Your Back.
    Live Chat+1(978) 822-0999EmailWhatsApp

    Order your essay today and save 20% with the discount code ORIGINAL

    seo