Conduct a hypothesis test for two independent samples

Assignment Help Business Management
Reference no: EM133052511

  • ASSIGNED PROBLEM 1: It has been noted that swimming pools do nothing to increase value of a home.  Use the Hypothesis_Tests_Two_Samples.xls file to conduct a hypothesis test for two independent samples to determine if the mean sales differ for homes with and without a pool.  Use a .05 significance level.  Describe your findings which includes stating the hypotheses, direction of the test, p-value, decision to reject the null or not, and the conclusion.  Note that this requires an assumption that homes with a pool vs. those without are not much different otherwise (if those with a pool are in better locations, made of better materials, are newer and larger, then those homes will be worth more and it won't have a thing to do with a pool.  So, for the sake of simplicity, let's assume that the homes with vs. without a pool have similar variability in them.

House_No

Bedrooms

Size

Age

Pool

Construction

Garage

Baths

SalePrice

Appraisal_1

Appraisal_2

1

4

      2,349 

8

No

Brick

Yes

2

   263,000 

      237,000 

      249,000 

2

4

      2,102 

7

Yes

Wood

No

2

   182,000 

      164,000 

      156,000 

3

3

      2,271 

6

Yes

Brick

No

2

   242,000 

      219,000 

      228,000 

4

2

      2,188 

6

Yes

Stucco

No

2.5

   214,000 

      194,000 

      186,000 

5

2

      2,148 

10

Yes

Stucco

No

1.5

   140,000 

      127,000 

      131,000 

6

2

      2,117 

2

No

Stucco

Yes

2

   245,000 

      223,000 

      216,000 

7

5

      2,484 

7

Yes

Brick

Yes

2

   300,000 

      298,000 

      304,000 

8

2

      2,130 

6

Yes

Stucco

Yes

2.5

   272,000 

      249,000 

      244,000 

9

3

      2,254 

2

No

Stucco

No

1.5

   221,000 

      202,000 

      204,000 

10

4

      2,385 

3

Yes

Wood

Yes

2

   267,000 

      245,000 

      243,000 

11

4

      2,108 

4

Yes

Brick

Yes

2

   292,000 

      269,000 

      282,000 

12

2

      1,715 

5

Yes

Wood

Yes

1.5

   209,000 

      193,000 

      183,000 

13

5

      2,495 

1

Yes

Wood

Yes

2

   271,000 

      250,000 

      260,000 

14

4

      2,073 

6

Yes

Brick

Yes

2

   246,000 

      228,000 

      219,000 

15

2

      2,283 

2

Yes

Brick

No

2

   194,000 

      180,000 

      185,000 

16

3

      2,119 

7

Yes

Stucco

Yes

2

   281,000 

      261,000 

      253,000 

17

4

      2,189 

2

No

Brick

No

2

   173,000 

      161,000 

      164,000 

18

5

      2,316 

1

No

Wood

No

2.5

   207,000 

      193,000 

      189,000 

19

3

      2,220 

5

No

Wood

Yes

2

   199,000 

      186,000 

      188,000 

20

5

      1,901 

4

No

Wood

Yes

2

   209,000 

      196,000 

      194,000 

21

4

      2,624 

8

Yes

Wood

Yes

2

   252,000 

      237,000 

      249,000 

22

4

      1,938 

4

No

Stucco

Yes

2.5

   193,000 

      182,000 

      173,000 

23

5

      2,101 

6

Yes

Brick

No

1.5

   209,000 

      197,000 

      205,000 

24

5

      2,141 

9

Yes

Brick

Yes

3

   320,000 

      309,000 

      318,000 

25

2

      2,198 

5

No

Brick

Yes

1.5

   173,000 

      164,000 

      159,000 

26

2

      1,912 

5

Yes

Wood

No

2

   187,000 

      178,000 

      182,000 

27

2

      2,117 

7

Yes

Wood

Yes

2

   257,000 

      245,000 

      240,000 

28

3

      2,162 

10

Yes

Brick

Yes

1.5

   233,000 

      223,000 

      225,000 

29

2

      2,041 

7

Yes

Brick

No

2

   180,000 

      172,000 

      170,000 

30

2

      1,712 

7

Yes

Brick

Yes

2

   234,000 

      225,000 

      236,000 

31

2

      1,974 

1

Yes

Brick

Yes

2

   207,000 

      199,000 

      189,000 

32

5

      2,438 

5

Yes

Stucco

Yes

2

   248,000 

      239,000 

      249,000 

33

3

      2,019 

7

No

Stucco

Yes

2

   166,000 

      160,000 

      154,000 

34

2

      1,919 

1

Yes

Brick

Yes

2

   177,000 

      171,000 

      176,000 

35

4

      2,023 

5

No

Wood

No

2.5

   183,000 

      178,000 

      173,000 

36

4

      2,310 

9

Yes

Stucco

No

2

   216,000 

      210,000 

      214,000 

37

5

      2,639 

4

Yes

Brick

Yes

2.5

   312,000 

      304,000 

      298,000 

38

3

      2,069 

5

Yes

Brick

Yes

2

   200,000 

      195,000 

      197,000 

39

5

      2,182 

9

Yes

Stucco

Yes

3

   273,000 

      267,000 

      264,000 

40

3

      2,090 

9

No

Brick

No

1.5

   206,000 

      202,000 

      212,000 

41

3

      1,928 

4

No

Stucco

Yes

1.5

   232,000 

      228,000 

      217,000 

42

4

      2,056 

7

No

Stucco

Yes

1.5

   198,000 

      195,000 

      203,000 

43

3

      2,012 

3

No

Wood

No

2

   205,000 

      202,000 

      194,000 

44

4

      2,262 

5

No

Wood

Yes

2

   176,000 

      174,000 

      179,000 

45

3

      2,431 

3

No

Stucco

Yes

3

   308,000 

      305,000 

      296,000 

46

5

      2,217 

2

Yes

Brick

Yes

3

   269,000 

      267,000 

      272,000 

47

3

      2,157 

4

Yes

Stucco

Yes

2.5

   225,000 

      224,000 

      220,000 

48

3

      2,014 

8

No

Wood

No

2

   172,000 

      171,000 

      173,000 

49

3

      2,221 

4

Yes

Stucco

Yes

2

   217,000 

      217,000 

      215,000 

50

5

      2,236 

8

No

Stucco

No

2

   193,000 

      193,000 

      203,000 

51

5

      2,189 

7

Yes

Brick

Yes

2

   236,000 

      236,000 

      224,000 

52

3

      2,218 

8

Yes

Brick

No

2

   172,000 

      173,000 

      180,000 

53

3

      1,937 

1

Yes

Stucco

Yes

2

   251,000 

      253,000 

      243,000 

54

5

      2,296 

6

Yes

Brick

Yes

3

   246,000 

      248,000 

      255,000 

55

5

      1,749 

9

No

Stucco

No

2

   147,000 

      148,000 

      144,000 

56

4

      2,230 

10

Yes

Stucco

Yes

2

   176,000 

      178,000 

      182,000 

57

3

      2,263 

10

Yes

Brick

Yes

1.5

   228,000 

      231,000 

      226,000 

58

3

      1,593 

9

No

Brick

No

2.5

   166,000 

      169,000 

      171,000 

59

4

      2,221 

10

Yes

Stucco

Yes

2

   189,000 

      192,000 

      190,000 

60

5

      2,036 

3

Yes

Brick

Yes

3

   290,000 

      296,000 

      281,000 

61

5

      2,170 

4

No

Wood

Yes

2.5

   270,000 

      276,000 

      287,000 

62

2

      2,007 

4

Yes

Stucco

No

2

   154,000 

      158,000 

      152,000 

63

2

      2,054 

7

Yes

Brick

Yes

2

   222,000 

      228,000 

      235,000 

64

5

      2,247 

5

No

Stucco

Yes

2

   210,000 

      216,000 

      210,000 

65

3

      2,190 

3

No

Brick

Yes

2

   191,000 

      197,000 

      201,000 

66

4

      2,495 

6

No

Brick

Yes

2

   254,000 

      263,000 

      258,000 

67

3

      2,080 

3

No

Stucco

No

2

   207,000 

      214,000 

      216,000 

68

4

      2,210 

7

No

Stucco

Yes

2

   210,000 

      218,000 

      216,000 

69

2

      2,133 

7

Yes

Stucco

Yes

2.5

   294,000 

      306,000 

      321,000 

70

2

      2,037 

7

No

Brick

No

2

   176,000 

      183,000 

      174,000 

71

3

      1,900 

3

No

Stucco

Yes

2

   224,000 

      234,000 

      225,000 

72

2

      1,871 

8

Yes

Wood

No

1.5

   125,000 

      131,000 

      135,000 

73

4

      2,584 

7

No

Brick

Yes

2

   237,000 

      249,000 

      242,000 

74

4

      2,312 

3

Yes

Wood

No

2

   164,000 

      173,000 

      176,000 

75

3

      2,498 

9

Yes

Brick

No

2

   218,000 

      230,000 

      225,000 

76

2

      2,407 

2

Yes

Stucco

No

2.5

   192,000 

      203,000 

      205,000 

77

2

      2,363 

2

Yes

Stucco

No

1.5

   126,000 

      133,000 

      132,000 

78

2

      2,329 

1

No

Stucco

Yes

2

   221,000 

      234,000 

      246,000 

79

5

      2,732 

8

Yes

Brick

Yes

2

   295,000 

      313,000 

      297,000 

80

2

      2,343 

5

Yes

Stucco

Yes

2.5

   245,000 

      261,000 

      271,000 

81

3

      2,479 

3

No

Stucco

No

1.5

   199,000 

      212,000 

      204,000 

82

4

      2,624 

2

Yes

Wood

Yes

2

   240,000 

      256,000 

      264,000 

83

4

      2,319 

1

Yes

Brick

Yes

2

   263,000 

      281,000 

      273,000 

84

2

      1,887 

4

Yes

Wood

Yes

1.5

   188,000 

      202,000 

      206,000 

85

4

      2,280 

6

Yes

Brick

Yes

2

   221,000 

      238,000 

      240,000 

86

2

      2,511 

5

Yes

Brick

No

2

   175,000 

      189,000 

      187,000 

87

3

      2,331 

9

Yes

Stucco

Yes

2

   253,000 

      273,000 

      287,000 

88

4

      2,408 

2

No

Brick

No

2

   155,000 

      168,000 

      160,000 

89

5

      2,548 

1

No

Wood

No

2.5

   187,000 

      203,000 

      211,000 

90

3

      2,442 

6

No

Wood

Yes

2

   179,000 

      194,000 

      186,000 

91

5

      2,091 

1

No

Wood

Yes

2

   188,000 

      205,000 

      211,000 

92

4

      2,886 

10

Yes

Wood

Yes

2

   227,000 

      247,000 

      240,000 

93

4

      2,132 

2

No

Stucco

Yes

2.5

   174,000 

      190,000 

      194,000 

94

5

      2,311 

7

Yes

Brick

No

1.5

   188,000 

      206,000 

      202,000 

95

5

      2,355 

4

Yes

Brick

Yes

3

   294,000 

      323,000 

      320,000 

96

3

      2,442 

2

Yes

Wood

Yes

2

   179,000 

      197,000 

      207,000 

97

5

      2,091 

10

No

Stucco

Yes

2.5

   188,000 

      207,000 

      197,000 

98

4

      2,886 

1

Yes

Brick

No

1.5

   227,000 

      251,000 

      261,000 

99

4

      2,132 

3

Yes

Wood

Yes

2

   174,000 

      192,000 

      184,000 

100

5

      2,311 

1

Yes

Brick

Yes

3

   188,000 

      208,000 

      214,000

Reference no: EM133052511

Questions Cloud

Case-hawaiian nut company : The Hawaiian Nut Company (HNC) makes four different products from macadamia nuts grown in the Hawaiian Islands: chocolate-coated whole nuts (Whole), chocolate-c
Studies of obedience and conformity : What lessons can be learned from the studies of obedience and conformity to help us avoid abuses of power in the future?
Analysis of front desk inefficiencies to improve patient : How do we Monitor the process to ensure that high performance levels are maintained in an Analysis of Front Desk Inefficiencies to Improve Patient Wait Time in
Implementing music therapy in the hospital : 1. What three key points related to leadership or management can be gained from a book entitled The Florence Prescription.
Conduct a hypothesis test for two independent samples : ASSIGNED PROBLEM 1: It has been noted that swimming pools do nothing to increase value of a home. Use the Hypothesis_Tests_Two_Samples.xls file to conduct
Prepare all general journal entries related to these bonds : nterest is payable on December 31 of each year with the first payment due December 31, Year 1. Prepare all the general journal entries related to these bonds
Systems development life cycle approach : You will be presented critical topics related to the application of appropriate frameworks, methodologies, and techniques that are used to implement
Role of state government in policymaking process : What is the role of the State Government in the policymaking process? How does it differ from that of the Federal Government?
What is the ocf for this project : The project is estimated to generate $1,684,000 in annual sales, with costs of $651,000. If the tax rate is 24 percent, what is the OCF for this project

Reviews

Write a Review

Business Management Questions & Answers

  Caselet on michael porter’s value chain management

The assignment in management is a two part assignment dealing 1.Theory of function of management. 2. Operations and Controlling.

  Mountain man brewing company

Mountain Man Brewing, a family owned business where Chris Prangel, the son of the president joins. Due to increase in the preference for light beer drinkers, Chris Prangel wants to introduce light beer version in Mountain Man. An analysis into the la..

  Mountain man brewing company

Mountain Man Brewing, a family owned business where Chris Prangel, the son of the president joins. An analysis into the launch of Mountain Man Light over the present Mountain Man Lager.

  Analysis of the case using the doing ethics technique

Analysis of the case using the Doing Ethics Technique (DET). Analysis of the ethical issue(s) from the perspective of an ICT professional, using the ACS Code of  Conduct and properly relating clauses from the ACS Code of Conduct to the ethical issue.

  Affiliations and partnerships

Affiliations and partnerships are frequently used to reach a larger local audience? Which options stand to avail for the Hotel manager and what problems do these pose.

  Innovation-friendly regulations

What influence (if any) can organizations exercise to encourage ‘innovation-friendly' regulations?

  Effect of regional and corporate cultural issues

Present your findings as a group powerpoint with an audio file. In addition individually write up your own conclusions as to the effects of regional cultural issues on the corporate organisational culture of this multinational company as it conducts ..

  Structure of business plan

This assignment shows a structure of business plan. The task is to write a business plane about a Diet Shop.

  Identify the purposes of different types of organisations

Identify the purposes of different types of organisations.

  Entrepreneur case study for analysis

Entrepreneur Case Study for Analysis. Analyze Robin Wolaner's suitability to be an entrepreneur

  Forecasting and business analysis

This problem requires you to apply your cross-sectional analysis skills to a real cross-sectional data set with the goal of answering a specific research question.

  Educational instructional leadership

Prepare a major handout on the key principles of instructional leadership

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd