Explore BrainMass
Share

Testing the Difference in Means Using MS Excel

This content was STOLEN from BrainMass.com - View the original, and get the already-completed solution here!

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.

© BrainMass Inc. brainmass.com October 16, 2018, 11:55 pm ad1c9bdddf
https://brainmass.com/statistics/hypothesis-testing/testing-the-difference-in-means-using-ms-excel-274508

Attachments

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.

$2.19
Similar Posting

Compare the difference between the body mass index (BMI) values

Details: Statistical Report
Write an 850-1200 word statistical laboratory report using, a Statistical Report." This statistical report is not meant to be an APA report or a multiple-page scholarly treatise. The goal is that you become familiar with the formal report format that you will use whenever you are reporting statistical analysis. The report format includes the following sections: Abstract, Purpose, Methods, and Results.
Assume that you are asked to perform an exploratory data analysis in which the emphasis is to compare the difference between the body mass index (BMI) values of men and women. Use Excel and/or SAS to create reports.
Assume you are a biostatistics analyst and you received a request from the director of the nutrition program to perform the analysis. The director is developing an obesity program for the state and has obtained the data set from the National Center for Health Statistics (NCHS). Because it has been some time since the director has had a statistics course, any points that would make your analysis easier to understand would be appreciated.
Generate appropriate histograms or box plots. Find appropriate statistics that will help to understand the data set. Are there any notable features? Are there any outliers? Describe the key elements of center, variation, distribution, and outliers.
A minimum of three scholarly references are required.

View Full Posting Details