Finding a simple random sample

Assignment Help Mathematics
Reference no: EM1321801

Question: A real estate agent has received data on 150 houses that were recently sold in a suburban community. Included in this data set are observations for each of the following variables: the appraised value of each house [in thousands of dollars], the selling price of each house [in thousands of dollars], the size of each house [in hundreds of square feet], & the number of bedrooms in each house. Assume that this real estate agent wishes to examine a representative subject of these 150 houses. Use Excel to assist her by finding a simple random sample of size 10 from this frame.

House

Value

Price

Square_Footage

Number_Bedrooms

diff

1

119.37

121.87

20.5

4

 

2

148.93

150.25

22.0

4

 

3

130.39

122.78

15.9

3

 

4

135.70

144.35

18.6

3

 

5

126.30

116.20

12.1

2

 

6

137.08

139.49

17.1

3

 

7

123.49

115.73

16.7

3

 

8

150.83

140.59

17.8

3

 

9

123.48

120.29

15.2

4

 

10

132.05

147.25

18.3

2

 

11

148.21

152.26

17.0

3

 

12

139.53

144.80

17.2

3

 

13

114.34

107.06

16.7

3

 

14

140.04

147.47

16.5

3

 

15

136.01

135.12

16.1

2

 

16

140.93

140.24

15.7

3

 

17

132.42

129.89

16.5

4

 

18

118.30

121.14

16.4

3

 

19

122.14

111.23

14.2

2

 

20

149.82

145.14

20.7

4

 

21

128.91

139.01

16.1

2

 

22

134.61

129.34

19.1

4

 

23

121.99

113.61

14.1

2

 

24

150.50

141.05

18.6

4

 

25

142.87

152.90

19.9

4

 

26

155.55

157.79

22.7

5

 

27

128.50

135.57

19.7

4

 

28

143.36

151.99

18.2

3

 

29

119.65

120.53

16.5

3

 

30

122.57

118.64

14.7

2

 

31

145.27

149.51

18.5

4

 

32

149.73

146.86

21.7

4

 

33

147.70

143.88

19.3

3

 

34

117.53

118.52

13.8

2

 

35

140.13

146.07

18.1

3

 

36

136.57

135.35

17.6

3

 

37

130.44

121.54

15.3

2

 

38

118.13

132.98

17.0

3

 

39

130.98

147.53

19.8

4

 

40

131.33

128.49

15.9

2

 

41

141.10

141.93

17.4

3

 

42

117.87

123.55

17.3

3

 

43

160.58

162.03

21.0

5

 

44

151.10

157.39

20.4

4

 

45

120.15

114.55

17.3

2

 

46

133.17

139.54

16.8

2

 

47

140.16

149.92

20.5

4

 

48

124.56

122.08

17.5

3

 

49

127.97

136.51

18.7

4

 

50

101.93

109.41

13.3

2

 

51

131.47

127.29

17.0

3

 

52

121.27

120.45

14.6

2

 

53

143.55

151.96

19.1

3

 

54

136.89

132.54

16.1

2

 

55

106.11

114.33

14.7

2

 

56

137.54

141.32

18.1

3

 

57

134.33

83.76

16.5

2

 

58

127.59

118.20

15.2

2

 

59

137.44

140.20

19.2

4

 

60

114.09

113.55

14.1

2

 

61

145.46

156.52

20.3

3

 

62

141.90

137.35

19.5

3

 

63

116.34

110.61

13.4

2

 

64

149.20

153.69

18.5

3

 

65

141.81

153.33

17.8

3

 

66

116.44

111.95

14.4

2

 

67

137.74

143.46

20.4

4

 

68

144.70

142.13

21.6

5

 

69

149.66

155.46

21.7

4

 

70

118.17

135.44

17.1

2

 

71

137.66

127.30

16.4

3

 

72

119.70

113.77

13.8

2

 

73

143.12

141.11

21.0

5

 

74

129.91

130.08

16.1

2

 

75

141.78

139.35

19.5

4

 

76

159.19

160.03

20.8

5

 

77

156.13

152.84

19.6

3

 

78

126.72

122.27

19.2

4

 

79

133.22

145.88

19.2

4

 

80

118.09

115.47

14.9

2

 

81

141.63

135.72

16.0

2

 

82

138.56

136.16

16.5

3

 

83

134.10

144.92

18.9

4

 

84

132.24

131.29

16.2

3

 

85

145.82

138.53

18.2

3

 

86

127.15

124.05

17.5

3

 

87

105.07

107.90

14.6

2

 

88

127.20

123.45

15.3

3

 

89

111.56

111.70

15.4

2

 

90

150.41

145.14

19.5

3

 

91

129.15

120.44

14.8

3

 

92

130.31

136.87

20.5

4

 

93

129.23

140.30

16.6

3

 

94

105.06

113.78

15.4

2

 

95

134.21

141.23

17.2

3

 

96

109.25

104.83

14.0

2

 

97

127.35

118.79

15.8

3

 

98

104.01

112.04

17.0

3

 

99

133.94

137.27

18.8

4

 

100

141.13

145.71

18.5

3

 

101

136.53

138.38

14.3

2

 

102

118.04

109.46

13.9

2

 

103

153.70

144.68

21.3

4

 

104

126.31

133.27

18.9

4

 

105

134.02

133.27

16.4

2

 

106

141.56

150.38

20.7

3

 

107

142.96

135.26

18.1

3

 

108

118.53

112.60

14.6

2

 

109

121.59

114.23

14.1

2

 

110

146.40

153.24

21.9

4

 

111

141.25

125.89

15.8

3

 

112

130.73

135.62

18.4

3

 

113

132.65

138.82

19.3

3

 

114

125.57

129.43

19.3

4

 

115

125.74

136.45

18.2

3

 

116

120.22

126.74

14.8

2

 

117

128.29

130.09

16.0

2

 

118

136.89

132.68

18.8

3

 

119

142.43

142.89

17.8

3

 

120

119.31

127.04

19.2

3

 

121

120.37

131.45

18.3

4

 

122

118.83

114.57

14.7

2

 

123

124.49

129.56

16.9

3

 

124

140.57

149.55

19.3

4

 

125

133.62

140.82

19.7

2

 

126

105.05

111.55

15.3

2

 

127

147.09

142.76

20.3

5

 

128

115.43

124.25

18.3

3

 

129

125.37

132.32

20.7

3

 

130

115.97

121.45

16.3

2

 

131

125.21

132.45

15.8

3

 

132

130.37

135.83

17.6

3

 

133

119.75

125.76

18.1

4

 

134

120.93

125.84

17.1

3

 

135

126.80

135.32

18.9

3

 

136

118.82

120.14

16.4

2

 

137

144.08

147.53

20.1

4

 

138

142.49

144.94

17.3

3

 

139

140.55

136.01

17.7

4

 

140

130.36

119.33

17.5

4

 

141

124.27

131.15

16.6

3

 

142

167.73

172.36

25.1

5

 

143

129.19

137.17

17.0

2

 

144

125.18

124.71

16.6

3

 

145

157.51

148.65

21.1

4

 

146

126.67

128.52

14.3

2

 

147

137.57

132.02

17.1

4

 

148

133.46

128.03

15.8

2

 

149

163.57

168.06

23.5

5

 

150

118.46

114.92

14.2

2

 

 

Random Numbers (House) 

39

51

35

48

57

42

134

36

124

38

 

Reference no: EM1321801

Previous Q& A

  Writing down the script

Write down a script known as whichdaemon.sh that checks if the httpd and init daemons are running over your system. If an httpd is running.

  Linear programming model to maximize budget

Tavern has budget of $2,000 for beer for Super Bowl Sunday. Betty desires to find out number of gallons of each brand of beer to order so as to maximize profit. Create a linear programming model for this problem.

  Testing equality of two means-small sample

use the following sample data to test whether the GPA are different at the 0.05 level of significance.

  Designing an e-r diagram

Assume that at PVF, every product (explained by Product No., Description, and Cost) is composed of at least three elements (explained by Component No., Description, and Unit of Measure). Design an E-R diagram for this situation.

  Presentation on collective bargaining

Imagine a simulated scenario in which you will make a presentation to your HR Department in preparation for a move by the employees to introduce collective bargaining into your company.

  Goodness of fit test for chi-square distribution

At the .01 significance level, is there a difference in the use of the four entrances?

  Estimate the missing values in given anova table

Complete the table and answer the following questions. Use the .05 significance level.

  Generation marginal lists apart from their second generation

Illustrate what sets the 1st generation marginal lists apart from their second generation marginal list

  Program to determine persons body mass index

Develop a program which determines a person's body mass index. Develop the modular program which determine and display a person's body mass index (BMI).

  Financial strategies, capital budgeting analysis

MBA 612, Financial Strategies, Capital Budgeting Analysis, Word Report and PowerPoint Presentation

Reviews

Write a Review

 

Similar Q& A

  Using one proportion z test to determine

Using one proportion Z test to determine

  Find the probability on poisson distribution

Find the probability on poisson distribution.

  Find the five month moving average

Find the five month moving average

  Fin the critical value, test statistics and the conclusion

In a survey of 700 randomly selected workers, 16 percent got their jobs through   newspaper ads. Consider hypothesis test that uses 0.05 significance level [95 percent confidence interval], test the claim that less than 20 percent of workers got thei..

  Find the number of groups

Determine the number of groups under a given condition and How many license plates can a state have if each license plate has 2 letters followed by 4 digits, if the first digit cannot be zero?

  Sketch possible graphs for all cases

Find whether x=3 is a local maximum or a local minimum and Sketch the graph - Sketch possible graphs for all four cases.

  Find the probability of hours they watch television

F ind the probability that the mean of the number of hours they watch television will be greater than 27.3 hours. Give your answer to 2 decimal places.

  The hypothesized developmental differences

The hypothesized developmental differences

  Find number of ways using permutation

Find number of ways using permutation

  Systems of ode

Find all the xed points, and study their stability and Draw the phase portrait of the system, as well as the graphs of the solutions in all relevant cases.

  Find the integral using spherical polar coordinate

Show the mass as triple integral and solve the integral using spherical polar coordinate and Use the spherical coordinate integral to evaluate

  Calculate the ninety-nine percent confidence interval

alculate the ninety-nine percent confidence interval find the mean gasoline mileage for 2006 cars when horsepower is 220.

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