### 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

### 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

### 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.