data.xlsx

    Sheet2

    College High School Part b Formula
    448 552 College High School
    480 432 Mean ERROR:#N/A ERROR:#N/A
    656 528
    624 588 Difference Between the Means ERROR:#N/A
    448 408
    592 504 Part c
    656 408 After reading these instructions delete all text in this shaded area.
    672 384
    624 456 Use the XLMiner Analysis ToolPak to conduct your t-Test analysis.
    640 408
    512 492 After deleting all text in this shaded area, set the output range in
    560 540 the ToolPak to the top left cell of this area (D8).
    656
    672 Your t-Test output should fit into this shaded area.
    576
    496
    Part d
    Significance Level (Alpha) 0.05
    Can we reject the null hypothesis? ERROR:#N/A
    (Enter "Can" or "Cannot")

                                                                                                                                      Order Now