activity_12 - Georgia Southern University, College of...

Info iconThis preview shows pages 1–2. Sign up to view the full content.

View Full Document Right Arrow Icon
Georgia Southern University, College of Business BUSA 3131 Business Statistics Fall 2011 Activity 12 Name: ____________________ Many organizations are interested in comparing means or proportions among multiple samples. For example, educators find it useful to compare mean scores on exams among different classes. Businesses compare financial results among their different profit centers and assess customer opinions geographically and demographically. This activity uses Excel to compare mean test scores from two hypothetical sets of grades from two independent samples of grades from two classes, Class 1 and Class 2. The students' experience, skill and ability are presumed to be the same in both classes. While there is insufficient historical data to calculate a population mean, or a population standard deviation, we can assume that the standard deviation and variance for these two samples are the same because we have no reason to expect one class to perform differently from the other class. Since we are testing for whether there is a statistically meaningful difference between the mean grades for these two classes, the null hypothesis ( H 0 ) states: H 0 : µ 1 = µ 2 The alternative hypothesis states: H A : µ 1 µ 2 Open Georgia View and access the folder containing activities for this class section of BUSA 3131 for which you are registered. You will need to have Excel opened on your computer. Open the file called BUSA 3131 Hypoth Z test 2 samples. You will see grades for Class 1 in column
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Image of page 2
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 01/30/2012 for the course BUSA 3131 taught by Professor Watson during the Fall '11 term at Georgia Southern University .

Page1 / 3

activity_12 - Georgia Southern University, College of...

This preview shows document pages 1 - 2. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online