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

  Find probability for student at random failed the test

Find the probability that a student selected at random failed the test?

  Evaluate the maximum height of the firework

Evaluate the maximum height of the firework from the given function - Evaluate the maximum height of the firework.

  Calculate the z transformation

Calculate the z transformation.

  Find p value and interpret its meaning

Find p-value and interpret its meaning

  Solve the average cost function

Solve the average cost function.

  Multiple choice questions based on regression

Multiple choice questions based on regression

  Advantages and disadvantages of strategy

Advantages and disadvantages of strategy I and strategy II for finding the occurrence of supernova problem - What are some possible strategies for solving this problem?

  The mean bone marrow micro vessel density

At the .01 level of significance, is there sufficient evidence to conclude that the mean bone marrow micro vessel density is higher before the stem cell transplant than after the stem cell transplant?

  Find the mean & the standard deviation of the total amount

Compute the mean & the standard deviation of the total amount that this investor in 1 year from these four investments.

  Make a ninety percent confidence interval for the proportion

Make a ninety percent confidence interval for the proportion.

  Show the applications of exponential function

Applications of exponential function: Principal, rate, time - evaluate an exact solution and the check your solution using the estimate of the "law of 72".

  Find the cost of the shortest length of carpet

Find the cost of the shortest length of carpet.

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