Scribd Logo
Upload

Welcome to Scribd!

  • 21 views

    Statistic

    Uploaded by

    Cath
    The document describes conducting an ANOVA analysis on data from 6 cities in the USA about new car interest rates to determine if there are differences in the means between cities. It provides summary statistics of the data organized by city, results of an ANOVA analysis showing a significant difference between groups, and instructions for adjusting the analysis based on the user's own data file.

    Copyright:

    © All Rights Reserved
    Download as PPTX, PDF, TXT or read online from Scribd

    Statistic

    Uploaded by

    Cath
    21 views19 pages
    The document describes conducting an ANOVA analysis on data from 6 cities in the USA about new car interest rates to determine if there are differences in the means between cities. It provides summary statistics of the data organized by city, results of an ANOVA analysis showing a significant difference between groups, and instructions for adjusting the analysis based on the user's own data file.

    Original Title

    statistic

    Copyright

    © © All Rights Reserved

    Available Formats

    PPTX, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    The document describes conducting an ANOVA analysis on data from 6 cities in the USA about new car interest rates to determine if there are differences in the means between cities. It provides summary statistics of the data organized by city, results of an ANOVA analysis showing a significant difference between groups, and instructions for adjusting the analysis based on the user's own data file.

    Copyright:

    © All Rights Reserved
    Download as PPTX, PDF, TXT or read online from Scribd
    Download as pptx, pdf, or txt
    21 views19 pages

    Statistic

    Uploaded by

    Cath
    The document describes conducting an ANOVA analysis on data from 6 cities in the USA about new car interest rates to determine if there are differences in the means between cities. It provides summary statistics of the data organized by city, results of an ANOVA analysis showing a significant difference between groups, and instructions for adjusting the analysis based on the user's own data file.

    Copyright:

    © All Rights Reserved
    Download as PPTX, PDF, TXT or read online from Scribd
    Download as pptx, pdf, or txt
    of 19

    • Open File ANOVA1 in your PC.

    • This file contains data from 6 cities in USA


    about new car interest rate. You have to
    determine whether there is difference in
    means between cities.
    • Open Data toolbar, and click Data Analysis

    Click Anova: Single Factor


    Adjust the input according to your file
    Anova: SingleFactor

    SUMMARY
    Groups Count Sum Average Variance
    Atlanta 9 118.75 13.1944444 0.19965278
    Chicago 9 113.5 12.6111111 0.50423611
    Houston 9 119.76 13.3066667 0.309525
    Memphis 9 119.2 13.2444444 0.93510278
    New York 9 121.35 13.4833333 0.516875
    Philadelphia 9 109.8 12.2 0.254375

    ANOVA
    Source of Variation SS df MS F P-value F crit
    Between Groups 10.9456667 5 2.18913333 4.82938487 0.00117455 2.40851412
    Within Groups 21.7581333 48 0.45329444

    Total 32.7038 53       


    Adjust according to your file
    OR
    t-Test: Two-Sample Assuming Equal Variances

      Variable 1 Variable 2
    Mean 11.93333333 11.66666667
    Variance 2.495238095 1.523809524
    Observations 15 15
    Pooled Variance 2.00952381
    Hypothesized Mean Difference 0
    df 28
    t Stat 0.515172635
    P(T<=t) one-tail 0.305237973
    t Critical one-tail 1.701130934
    P(T<=t) two-tail 0.610475947
    t Critical two-tail 2.048407142 
    t-Test: Two-Sample Assuming Unequal Variances
      Variable 1 Variable 2
    Mean 11.93333333 11.66666667
    Variance 2.495238095 1.523809524
    Observations 15 15
    Hypothesized Mean Difference 0
    df 26
    t Stat 0.515172635
    P(T<=t) one-tail 0.305392496
    t Critical one-tail 1.70561792
    P(T<=t) two-tail 0.610784993
    t Critical two-tail 2.055529439 
    Excel does not provide chi-square distribution test in Data analysis add ins.
    Thus, we should conduct the test manually.
    If there is no information about
    proportion of expected number,
    then we use average (same
    amount for every category)
    Excel formula for chi-square goodness of fit test: CHISQ.DIST.RT

    x= value of chi-square
    deg_freedom= k-1

    P-Value 0.003484
    𝑇𝑜𝑡𝑎𝑙 𝑟𝑜𝑤 −𝑡𝑜𝑡𝑎𝑙 𝑐𝑜𝑙𝑢𝑚𝑛
    𝐹 𝑒=
    𝐺𝑟𝑎𝑛𝑑 𝑡𝑜𝑡𝑎𝑙
    Observed Better No impact Worse Total
    Android 13 9 11 33
    iPhone 30 9 4 43
    Total 43 18 15 76

    Expected Better No impact Worse Total


    Android 18.67105 7.8157895 6.513158 33
    iPhone 24.32895 10.184211 8.486842 43
    Total 43 18 15 76
    2 ( 𝑓 𝑜 − 𝑓 𝑒 )2
    𝜒 =
    𝑜𝑒
    𝑓𝑒
    Chi-square value is
    the sum of all chi-
    square

    = 8.82459
    In this case, we want to know
    how rain intensity would
    influence the number of
    umbrella sold in one store.

    That makes rainfall as


    independent variable and
    umbrellas sold as dependent
    variable.
    Adjust to your file

    You might also like