Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

The excel file that corresponds to this assignment shows the results of a study that was performed to compare the costs of supporting a family

image text in transcribed
image text in transcribed
The excel file that corresponds to this assignment shows the results of a study that was performed to compare the costs of supporting a family of four Americans for a year in different foreign cities. The lifestyle of living in the Unites Stated on an annual income of $75,000 was the standard against which living in foreign cities was compared. A comparable living standard in Toronto and Mexico City was attained for about $64,000. Suppose an executive wants to determine whether there is any difference in the average annual cost of supporting her family of four in the manner to which they are accustomed between Toronto and Mexico City. She uses the following data, randomly gathered from 11 families in each city, and an alpha of .01 to test this difference. She assumes the annual cost is normally distributed and the population means are equal. What does the executive find? Develop the null and alternative hypothesis. Attach your Excel output to this forum What are your statistical and English conclusions? Show evidence that supports your conclusion (rejection rules). Toronto 69,000 64,500 67,500 64,500 66,700 68,000 65,000 69,000 71,000 68,500 67,500 Mexico City 65,000 64,000 66,000 64,900 62,000 60,500 62,500 63,000 64,500 63,500 62,400 The excel file that corresponds to this assignment shows the results of a study that was performed to compare the costs of supporting a family of four Americans for a year in different foreign cities. The lifestyle of living in the Unites Stated on an annual income of $75,000 was the standard against which living in foreign cities was compared. A comparable living standard in Toronto and Mexico City was attained for about $64,000. Suppose an executive wants to determine whether there is any difference in the average annual cost of supporting her family of four in the manner to which they are accustomed between Toronto and Mexico City. She uses the following data, randomly gathered from 11 families in each city, and an alpha of .01 to test this difference. She assumes the annual cost is normally distributed and the population means are equal. What does the executive find? Develop the null and alternative hypothesis. Attach your Excel output to this forum What are your statistical and English conclusions? Show evidence that supports your conclusion (rejection rules). Toronto 69,000 64,500 67,500 64,500 66,700 68,000 65,000 69,000 71,000 68,500 67,500 Mexico City 65,000 64,000 66,000 64,900 62,000 60,500 62,500 63,000 64,500 63,500 62,400

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Students also viewed these Finance questions