Posted: August 3rd, 2022

Statistic

Do Everything in excel

2

>Sheet

1

.1

0

1

1 2

2.4

4

00

0

4 0 2

2.1

3

0

3 0 2

.6

2

0

0

2 0

2 2

0 0

1 0

2

1 12 1 1 2

6

0

3 1 2

2 2100 0 9 2 1 2.5

3 2300 1

1 0 1.5

6.6

4

0

0 13 4 1 2

4 2100 0

3 1 2

2

00

0 8 4 1 1.5

6 2500 0 7 4 1 2

.1

4 2100 0 18 3 1 2

4.4

2 2300 0

3 0 2

3 2100 0 16 2 1 2

4

1 16 3 0 2

5 2300 1 21 4 0 2.5

3 2200 1 10 4 1 2

6

1 15 4 1 2

4

0 8 4 1 2

4 1900 1 14 2 1 2.5

209.3 5 2100 0 20 5 0 1.5

8 2600 0 9 4 1 2

6 2100 0 11 5 1 3

2 2200 1 21 5 1 1.5

2 1900 0 26 4 0 2

2 2100 0 9 4 1 2

3 2200 0 14 3 1 1.5

2

0 11 5 0 2

2

0 19 3 1 2

2 2000 0 11 5 1 2

5

0 16 2 1 2

3 2000 1 16 2 1 2

2 1900 0 10 5 1 2

4 2000 1 14 4 0 2.5

4 2300 0 19 2 0 2

6 2600 0 7 5 1 2.5

.8

3 2100 0 19 3 1 2

5 2200 0 16 2 1 3

3 2100 1 9 3 0 1.5

3 1900 1 16 1 1 1.5

4 2100 1 19 1 1 1.5

3 2000 1 20 4 0 2

.6

4 2300 1 24 4 1 2

3 2400 1 21 2 1 3

5 2200 0 8 5 1 3

.8

3 2200 0 17 1 1 2.5

3 2000 1 16 4 0 2

3 2200 0 15 1 1 2

6 2200 1 14 1 0 2

5 2200 0 20 3 1 2

3 2200 0 23 3 0 2

3 1900 0 12 2 1 2

246 6 2300 0 7 3 1 3

6 1700 1 12 1 0 2

4 2200 0 15 1 1 2

3 2300 0 17 5 1 1.5

3

1 19 3 0 2.5

4 2200 0 24 1 1 2

312.1 7 2400 0 13 3 1 3

6 2000 0 21 3 1 3

5 2200 1 11 4 1 2.5

2 2000 0 13 2 0 2

2 2100 0 9 5 1 2

5 2200 1 13 2 1 2

3 2200 1 18 3 1 2

4 2500 1 15 3 1 2

207.5 3 2100 1 10 2 0 2
209.7 4 2200 1 19 2 1 2

2 2100 0 13 2 1 2.5

2 2000 1 17 3 0 2

7 2400 0 8 4 1 2

224 3 1900 1 6 1 1 2

2 1900 0 18 4 0 1.5

4 2600 1 17 5 1 2

4 2300 0 19 4 0 2

3 2500 0 12 3 0 2

2 2400 0 16 2 0 2.5

2 2400 0 28 1 0 1.5

2 2300 1 12 1 1 2

6

0 15 3 1 2

2 2300 0 9 2 1 2.5

199 3 2500 1 18 1 0 1.5
240 4 2600 0 13 4 1 2

4 2300 0 14 3 1 2

2 1900 0 8 4 1 1.5

6 2700 0 7 4 1 2

4 2300 0 18 3 1 2

175 2 2500 0 11 3 0 2

3 2300 0 16 2 1 2

4 2400 1 16 3 0 2

5 2500 1 21 4 0 2.5

3 2400 1 10 4 1 2

6 2100 1 15 4 1 2

4

0 8 4 1 2

4 2100 1 14 2 1 2.5

188.3 5 2300 0 20 5 0 1.5

8 2900 0 9 4 1 2

6 2400 0 11 5 1 3

179 3 2400 0 8 4 1 2
188.3 6 2100 1 14 2 1 2.5
227.1 4 2900 0 20 5 0 1.5
173.6 4 2100 0 9 4 1 2
188.3 5 2300 0 11 5 1 3
Price Bedrooms Size Pool ER-Distance School-Distance Garage Baths
2

6 3 4 23 0 1

7 5 ReMax Real Estate collected data of select homes in Oxnard,CA.
1

8 21 1

9 Price is in hundreds of thousands
24 2300 12 ER-Distance (number of miles to the nearest ER)
2

13 2

20 16 2.5 School-Distance (number of miles to the nearest elementary school)
139.9 10 28 1.5
245.4 2100
327.2 2500 15
271.8
221.1 18
26 240
292.4 14
209 17
270.8
246
19 11
281.3
172.7 2200
207.5
198.9
209.3 1900
252.3 2600
192.9
345.3
326.3
173.1
187
257.2
233
180.4 2000
234 1700
207.1
247.7 2400
166.2
177.1
182.7
216
312.1
199
273.2
206
232.2
198.3
205.1
175
307.8
269.2
224
171.6
216.8
192.6
236.4
172.4
251.4
147.4
176
228.4
166.5 1600
189.4
289.8
269.9
154.3
222.1
209.7
190.9
254.3
294
176.3
294.3
125
236.8
164.1
217.8
192.2
125.9
220.9
294.5 2700
244.6
263.2
188.1
243.7
221.5
253.2
155.4
186.7
179
188.3
227.1 2900
173.6
310.8
293.7

· Graphical Descriptions:

· For your data, provide at least two graphs, one for each sample data (5 points) and

· The graphs could be pie chart, histogram, bar chart etc but labelled and clear.

· Numerical Descriptions:

· For the samples from each population, if applicable provide the mean, median, mode, sample standard deviation, inter-quartile range, and five-number summary.  (15 points)

· You should conduct two statistical studies, one of [estimation study (using 95% confidence interval) and another of correlation & multiple regression]. Your two studies should confirm your analysis.

· Confidence Interval (35 points):

· Find the margin of error for a 95% confidence interval.

· Give the 95% confidence interval.

· Write at least one sentence interpreting your confidence interval in context.

· Correlation and Regression – This is the second option and gradings will be done accordingly (35 points)

· Provide the correlation coefficient.

· Select the dependent and independent variable(s)

· Create a regression model.

· Provide the output.

· Test the regression for validity.

· Interpret your results.

Expert paper writers are just a few clicks away

Place an order in 3 easy steps. Takes less than 5 mins.

Calculate the price of your order

You will get a personal manager and a discount.
We'll send you the first draft for approval by at
Total price:
$0.00