Expert answer:Data obtained from a county auditor in the Excel f
Expert answer:Data obtained from a county auditor in the Excel file Home Market Value provide information about the age, square footage, and current market value of houses along one street in a particular subdivision. Considering these data as a population of homeowners on this street, compute the mean, variance, and standard deviation for each of these variables using a spreadsheet and formulas (4.1), (4.4), and (4.6). Verify your calculations using the appropriate Excel function.In the Excel file Facebook Survey, find the average and median hours online/week and number of friends in the sample using the appropriate Excel functions. Compute the midrange and compare all measures of location.Compute descriptive statistics for liberal arts colleges and research universities in the Excel file Colleges and Universities. Compare the two types of colleges. What can you conclude?In the Excel file Economic Poll, find the proportions of each categorical variable.
week_four_suppliment.xlsx
Unformatted Attachment Preview
Home Market Value
House Age
House Age
Square Feet Market Value
33
32
32
33
32
33
32
33
32
33
32
32
32
32
32
33
32
32
32
32
28
27
28
28
28
28
28
27
28
28
28
27
27
28
27
28
28
27
27
28
27
27
1,812
1,914
1,842
1,812
1,836
2,028
1,732
1,850
1,791
1,666
1,852
1,620
1,692
2,372
2,372
1,666
2,123
1,620
1,731
1,666
1,520
1,484
1,588
1,598
1,484
1,484
1,520
1,701
1,484
1,468
1,520
1,520
1,484
1,520
1,668
1,588
1,784
1,484
1,520
1,520
1,684
1,581
$90,000.00
$104,400.00
$93,300.00
$91,000.00
$101,900.00
$108,500.00
$87,600.00
$96,000.00
$89,200.00
$88,400.00
$100,800.00
$96,700.00
$87,500.00
$114,000.00
$113,200.00
$87,500.00
$116,100.00
$94,700.00
$86,400.00
$87,100.00
$83,400.00
$79,800.00
$81,500.00
$87,100.00
$82,600.00
$78,800.00
$87,600.00
$94,200.00
$82,000.00
$88,100.00
$88,100.00
$88,600.00
$76,600.00
$84,400.00
$90,900.00
$81,000.00
$91,300.00
$81,300.00
$100,700.00
$87,200.00
$96,700.00
$120,700.00
Sq Feet
Market Value
Obs – Mean (Obs-Mean)^2
USING TEXT FORMULAS
Mean
92,069.05
Variance
108,715,946.71
Std Dev
10,426.69
USING EXCEL FORMULAS
Mean
$92,069.05
Variance
108,715,946.71
Std Dev
10,426.69
-$2,069
$12,331
$1,231
-$1,069
$9,831
$16,431
-$4,469
$3,931
-$2,869
-$3,669
$8,731
$4,631
-$4,569
$21,931
$21,131
-$4,569
$24,031
$2,631
-$5,669
-$4,969
-$8,669
-$12,269
-$10,569
-$4,969
-$9,469
-$13,269
-$4,469
$2,131
-$10,069
-$3,969
-$3,969
-$3,469
-$15,469
-$7,669
-$1,169
-$11,069
-$769
-$10,769
$8,631
-$4,869
$4,631
$28,631
4,280,958
152,052,387
1,515,244
1,142,863
96,647,625
269,976,196
19,972,387
15,452,387
8,231,434
13,461,910
76,229,529
21,445,720
20,876,196
480,966,672
446,517,149
20,876,196
577,486,672
6,921,910
32,138,101
24,691,434
75,152,387
150,529,529
111,704,768
24,691,434
89,662,863
176,067,625
19,972,387
4,540,958
101,385,720
15,753,339
15,753,339
12,034,291
239,291,434
58,814,291
1,366,672
122,523,815
591,434
115,972,387
74,493,339
23,707,625
21,445,720
819,731,434
Facebook Survey
Student
10
12
31
19
30
23
6
32
27
11
16
29
7
24
9
20
3
1
15
28
33
21
13
14
8
5
22
17
25
2
26
18
4
Gender
female
female
female
female
male
female
female
male
female
female
male
male
female
female
female
male
male
female
male
female
female
male
male
female
male
female
female
female
female
female
male
male
male
Hours online/week Friends
2
2
2
4
4
5
5
5
2
6
4
6
7
9
12
4
7
4
6
7
7
6
3
6
5
9
4
8
12
10
8
10
15
30
30
50
50
50
60
70
70
80
80
90
90
90
100
110
120
120
150
150
170
170
180
200
240
250
260
280
340
380
400
430
450
500
AVERAGE HOURS ONLINE
8.50
MEDIAN HOURS ONLINE
8.5
MIDRANGE FOR HOURS ONLINE
7.5
MODE FOR HOURS ONLINE
4, 6
AVERAGE NUMBER OF FRIENDS
265.00
MEDIAN NUMBER OF FRIENDS
265
MIDRANGE FOR NUMBER OF FRIENDS
265
MODE FOR NUMBER OF FRIENDS
50, 90
Colleges and Universities
School
Type
Amherst
Barnard
Bates
Bowdoin
Bryn Mawr
Carleton
Claremont McKenna
Colby
Colgate
Davisdson
Grinnell
Hamilton
Haverford
Middlebury
Mount Holyoke
Oberlin
Occidental
Pomona
Smith
Swarthnore
Vassar
Washinton and Lee
Wellesley
Wesleyan (CT)
Williams
Lib Arts
Lib Arts
Lib Arts
Lib Arts
Lib Arts
Lib Arts
Lib Arts
Lib Arts
Lib Arts
Lib Arts
Lib Arts
Lib Arts
Lib Arts
Lib Arts
Lib Arts
Lib Arts
Lib Arts
Lib Arts
Lib Arts
Lib Arts
Lib Arts
Lib Arts
Lib Arts
Lib Arts
Lib Arts
Median SAT Acceptance Rate Expenditures/Student
1315
1220
1240
1300
1255
1300
1260
1200
1258
1230
1244
1215
1285
1255
1200
1247
1170
1320
1195
1310
1287
1234
1250
1290
1336
22%
53%
36%
24%
56%
40%
36%
46%
38%
36%
67%
38%
35%
25%
61%
54%
49%
33%
57%
24%
43%
29%
49%
35%
28%
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
26,636
17,653
17,554
25,703
18,847
15,904
20,377
18,872
17,520
17,721
22,301
20,722
19,418
24,718
23,358
23,591
20,192
26,668
25,271
27,487
20,179
17,998
27,879
19,948
23,772
Median SAT Acceptance Rate Expenditures/Student
Top 10% HS Graduation %
85
69
58
78
70
75
68
52
61
77
65
51
71
65
47
64
54
79
65
78
53
61
76
73
86
93
80
88
90
84
80
74
84
85
89
73
85
87
92
83
77
72
80
87
88
84
78
86
91
93
Top 10% HS Graduation %
School
Type
Berkeley
University
Brown
University
Cal Tech
University
Carnegie Mellon
University
Columbia
University
Cornell
University
Duke
University
Georgetown
University
Harvard
University
Johns Hopkins
University
MIT
University
Northwestern
University
Princeton
University
Rice
University
Stanford
University
U Michigan
University
U of Chicago
University
U of Rochester
University
U Pennsylvania
University
U Va
University
UCLA
University
UNC
University
Washington U (MO)University
Yale
University
Median SAT
1176
1281
1400
1225
1268
1280
1310
1278
1370
1290
1357
1230
1340
1327
1370
1195
1300
1155
1280
1218
1142
1109
1225
1350
Median SAT
Acceptance Rate Expenditures/Student Top 10% HS Graduation %
37%
24%
31%
64%
29%
30%
25%
24%
18%
48%
30%
47%
17%
24%
18%
60%
45%
56%
41%
37%
43%
32%
54%
19%
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
23,665
24,201
102,262
33,607
45,879
37,137
39,504
23,115
46,918
45,460
56,766
28,851
48,123
26,730
61,921
21,853
38,937
38,597
30,882
19,365
26,859
19,684
39,883
52,468
95
80
98
52
78
85
91
79
90
69
95
77
89
85
92
71
74
52
87
77
96
82
71
90
68
90
75
77
90
83
91
89
90
86
86
82
93
88
88
77
73
73
86
88
61
73
76
93
Acceptance Rate Expenditures/Student Top 10% HS Graduation %
Economic Poll
Respondent
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
Age
32
35
29
31
32
66
64
22
21
33
38
31
39
30
52
35
29
29
20
32
32
31
37
29
38
21
41
26
25
30
27
32
37
33
27
30
27
28
27
64
34
30
35
25
Gender Years College Political Party Home Owner
Male
2
Democrat
Yes
Female
2
Republican
No
Female
4
Independent
No
Female
0
Republican
No
Male
5
Republican
No
Female
4
Republican
Yes
Male
4
Republican
Yes
Male
3
Democrat
No
Male
2
Republican
No
Female
1
Independent
No
Male
0
Independent
No
Female
0
Republican
No
Male
4
Democrat
No
Male
0
Independent
No
Female
5
Republican
Yes
Female
2
Republican
No
Male
4
Democrat
No
Female
0
Democrat
No
Male
1
Independent
No
Female
2
Democrat
No
Male
2
Independent
No
Female
2
Independent
Yes
Female
4
Independent
No
Male
3
Independent
No
Male
0
Independent
No
Male
2
Republican
No
Male
4
Republican
No
Female
4
Independent
Yes
Female
1
Republican
Yes
Male
4
Republican
Yes
Female
0
Democrat
No
Female
4
Independent
No
Male
2
Democrat
Yes
Male
2
Democrat
No
Male
2
Republican
No
Female
6
Independent
Yes
Female
0
Independent
Yes
Female
2
Democrat
Yes
Female
5
Independent
Yes
Male
4
Independent
Yes
Female
7
Independent
Yes
Male
5
Republican
Yes
Female
7
Democrat
Yes
Female
4
Independent
Yes
45
46
47
48
49
50
33
32
29
37
33
66
Male
Female
Female
Female
Female
Male
2
4
0
6
6
2
Independent
Independent
Independent
Independent
Democrat
Republican
Yes
Yes
No
Yes
Yes
Yes
Count
Voted in Last Election Economy Perception
Yes
Yes
Yes
No
No
No
Yes
No
Yes
No
Yes
No
Yes
No
Yes
Yes
Yes
No
Yes
No
No
No
Yes
No
Yes
Yes
No
No
Yes
No
Yes
No
Yes
Yes
Yes
No
No
No
Yes
Yes
Yes
No
No
No
Yes
No
No
No
Yes
No
Yes
No
Yes
No
No
No
Yes
No
Yes
Yes
No
No
No
No
Yes
Yes
No
No
Yes
No
Yes
No
Yes
Yes
Yes
Yes
Yes
No
Yes
No
Yes
No
Yes
No
Yes
Yes
Yes
Yes
Male
Female
23
27
Proportions
0.46
0.54
Democrat
Republican
Independent
12
16
22
0.24
0.32
0.44
Homeowner
Non-homeowner
23
27
0.46
0.54
Voter
Non-voter
38
12
0.76
0.24
Optimistic
Pessimistic
12
38
0.24
0.76
Yes
No
No
Yes
Yes
Yes
No
No
No
No
No
Yes
…
Purchase answer to see full
attachment
How it works
- Paste your instructions in the instructions box. You can also attach an instructions file
- Select the writer category, deadline, education level and review the instructions
- Make a payment for the order to be assignment to a writer
- Download the paper after the writer uploads it
Will the writer plagiarize my essay?
You will get a plagiarism-free paper and you can get an originality report upon request.
Is this service safe?
All the personal information is confidential and we have 100% safe payment methods. We also guarantee good grades