Testing the Difference in Means Using MS Excel
Not what you're looking for?
Data Analysis
32. Consider a random sample of 100 households from a
middle-class neighborhood that was the recent focus
of an economic development study conducted by the
local government. Specifically, for each of the
100 households, information was gathered on each of
the following variables: family size, location of the
household within the neighborhood, an indication of
whether those surveyed owned or rented their home,
gross annual income of the first household wage
earner, gross annual income of the second household
wage earner (if applicable), monthly home mortgage
or rent payment, average monthly expenditure on utilities,
and the total indebtedness (excluding the value of
a home mortgage) of the household. The data are in
the file P09_26.xlsx.
Test for the existence of a significant difference
between the mean indebtedness levels of the households
in the first (i.e., SW) and second (i.e., NW)
sectors of this community. Perform similar hypothesis
tests for the differences between the mean indebtedness
levels of households from all other pairs of locations
(i.e., first and third, first and fourth, second and
third, second and fourth, and third and fourth).
Summarize your findings.
Purchase this Solution
Solution Summary
Three problems of testing the difference of means of two samples are solved. The general procedure for the conduct of this test using M.S Excel is also provided.
Purchase this Solution
Free BrainMass Quizzes
Terms and Definitions for Statistics
This quiz covers basic terms and definitions of statistics.
Measures of Central Tendency
This quiz evaluates the students understanding of the measures of central tendency seen in statistics. This quiz is specifically designed to incorporate the measures of central tendency as they relate to psychological research.
Measures of Central Tendency
Tests knowledge of the three main measures of central tendency, including some simple calculation questions.
Know Your Statistical Concepts
Each question is a choice-summary multiple choice question that presents you with a statistical concept and then 4 numbered statements. You must decide which (if any) of the numbered statements is/are true as they relate to the statistical concept.