Hinchcliff_Megan_Project_one_MAT_240_Real_Estate_Data
xlsx
keyboard_arrow_up
School
Southern New Hampshire University *
*We aren’t endorsed by this school
Course
240
Subject
Statistics
Date
Feb 20, 2024
Type
xlsx
Pages
5
Uploaded by MegaLarkMaster816
Region
State
County
Radom
Northeast
pa
philadelphia
246,700 $166
1,489 0.9430393
East South Central
al
jackson
715,300 $111
6,420 0.1516077
Mountain
nm
valencia
298,100 $208
1,430 0.6725105
East North Central
il
st. clair
201,400 $164
1,225 0.0127312
Mid Atlantic
md
worcester
355,800 $185
1,923 0.8914282
East North Central
oh
scioto
204,200 $131
1,562 0.1655292
New England
ma
suffolk
423,600 $170
2,491 0.0543822
East South Central
al
jackson
284,900 $118
2,417 0.3207388
West North Central
mo
st. francois
355,600 $200
1,774 0.210861
New England
ct
new london
388,700 $172
2,265 0.234085
East South Central
ky
christian
325,600 $136
2,390 0.8330304
East North Central
il
tazewell
278,700 $165
1,693 0.9167785
Mountain
mt
flathead
309,300 $155
1,998 0.8575358
East North Central
in
vigo
165,800 $122
1,362 0.8112118
Mid Atlantic
md
prince george's
379,600 $276
1,377 0.5032329
West North Central
mn
clay
350,900 $163
2,158 0.9280023
Northeast
pa
chester
786,800 $149
5,290 0.0610325
Mountain
nm
bernalillo
378,000 $196
1,926 0.1105388
Mountain
az
coconino
332,300 $233
1,428 0.2423272
East South Central
al
tuscaloosa
633,100 $107
5,894 0.6787876
Mountain
co
denver
336,400 $181
1,859 0.3453023
Northeast
pa
somerset
323,900 $164
1,972 0.8232802
Mountain
az
maricopa
352,700 $158
2,237 0.3693933
Mountain
az
navajo
358,200 $222
1,611 0.2938968
Mid Atlantic
md
calvert
302,200 $198
1,529 0.4541654
Mountain
co
garfield
748,100 $129
5,817 0.3793345
Mid Atlantic
nj
monmouth
278,800 $241
1,159 0.27507
Mid Atlantic
md
baltimore
354,100 $210
1,686 0.7812898
Pacific
ca
sutter
354,600 $255
1,390 0.3403666
Mid Atlantic
va
richmond city
235,800 $160
1,472 0.7908704
Northeast
ny
livingston
353,400 $220
1,603 0.5337087
East North Central
mi
muskegon
230,400 $131
1,757 0.4017787
Listing Price (Y)
$'s per square foot
Square Feet (X) 100,0
200,0
300,0
400,0
500,0
600,0
700,0
800,0
900,0
Listing Price
East South Central
ky
daviess
239,800 $113
2,118 0.2465134
South Atlantic
ga
laurens
275,900 $163
1,694 0.1532437
Mid Atlantic
de
new castle
580,200 $130
4,479 0.2561694
East South Central
ms
lee
273,100 $132
2,066 0.9511013
New England
ma
franklin
356,800 $171
2,088 0.1972688
Mid Atlantic
va
danville city
272,400 $192
1,417 0.9005716
Mid Atlantic
va
pittsylvania
347,600 $210
1,656 0.1086702
East South Central
ky
jessamine
174,900 $98
1,777 0.7336873
East North Central
oh
seneca
211,900 $168
1,263 0.1827414
West North Central
ia
black hawk
286,700 $204
1,404 0.1639864
West North Central
mo
saint louis city
273,200 $172
1,592 0.4291534
East South Central
ky
madison
265,400 $135
1,960 0.2466383
South Atlantic
fl
lake
348,200 $180
1,931 0.8672789
Mountain
nv
carson city
396,700 $205
1,936 0.3635585
South Atlantic
sc
charleston
408,000 $197
2,067 0.065048
West South Central
tx
coryell
184,100 $126
1,460 0.6864229
Northeast
ny
erie
275,200 $189
1,453 0.1926028
New England
ma
bristol
362,400 $214
1,695 0.359788
This chart
Editing th
permanent
Mean Listing Price $ 343,510 Median listing price $ 328,950 SD listing price $ 135,213 Mean SF
2,133 Median SF
1,766 SD Square Feet 1,222 Regression Equation
y = 98.992x + 132339
Slope
Intercept 98.992
132339
r (Correlation)
Correlation
0.8947 Strong Postive R-Squared
Coefficient of determination
0.8006
- 000 000 000 000 000 000 000 000 000 f(x) = 98.9924336948794 x + 132339.340442083
R² = 0.800573858260463
50 Home Sample
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help
This chart isn't available in your version of Excel.
Editing this shape or saving this workbook into a different file format
break the chart.
- 1,000 2,000 3,000 4,000 5,000 6,000 7,000 - Square Feet
t isn't available in your version of Excel.
his shape or saving this workbook into a different file format will tly break the chart.
t will permanently
Related Documents
Related Questions
Here are the number of legal immigrants (in thousands) who settled in each state east of the Mississippi River in a given year.
Alabama
3.8
Connecticut
10.8
Delaware
2.2
Florida
102.8
Georgia
24.3
Illinois
36.0
Indiana
7.8
Kentucky
5.2
Maine
1.2
Maryland
25.5
Massachusetts
29.6
Michigan
17.0
Mississippi
1.8
New Hampshire
2.1
New Jersey
53.1
New York
133.5
North Carolina
16.8
Ohio
13.7
Pennsylvania
24.7
Rhode Island
3.3
South Carolina
4.2
Tennessee
8.5
Vermont
0.9
Virginia
27.9
West Virginia
0.8
Wisconsin
6.0
New York and Florida are high outliers in this distribution. Find the mean (in thousands) and the median (in thousands) for these data with and without New York and Florida. (Round your answers to two decimal places.)
with New York and Florida
arrow_forward
A small dealership leased 21 Suburu Outbacks on 2-year leases. When the cars were returned at the end of the lease, the mileage was recorded (see below).
40,000
24,940
14,325
17,328
44,729
44,522
20,254
33,305
24,204
41,765
58,328
35,825
25,715
28,985
25,011
43,363
23,956
43,580
53,685
31,847
36,789
Click here for the Excel Data File
(a) Is the dealer's mean significantly greater than the national average of 30,537 miles for 2-year leases? Using the 10 percent level of significance, choose the appropriate hypothesis.
H0: μ ≤ 30,537 miles vs. H1: μ > 30,537 miles, reject H0 if tcalc > 1.3250
H0: μ ≥ 30,537 miles vs. H1: μ > 30,537 miles, reject H0 if tcalc > 1.3250
H0: μ ≤ 30,537 miles vs. H1: μ < 30,537 miles, reject H0 if tcalc > 1.3250
H1: μ ≤ 30,537 miles vs. H0: μ > 30,537 miles, reject H0 if tcalc > 1.3250
c
a
d
b
(b) Calculate the test statistic. (Round your answer to 2 decimal places.)…
arrow_forward
A small dealership leased 21 Suburu Outbacks on 2-year leases. When the cars were returned at the end of the lease, the mileage was recorded (see below).
40,009
24,998
14,321
17,374
44,720
44,508
20,203
33,341
24,287
41,739
58,395
35,880
25,712
28,984
25,082
43,330
23,904
43,553
53,652
31,851
36,704
H0: μ ≤ 29,503 miles vs. H1: μ > 29,503 miles, reject H0 if tcalc > 1.3250
(b) Calculate the test statistic. (Round your answer to 2 decimal places.)
arrow_forward
Saudi Araba
597.00
572.00
599.00
467.00
Australia
987.00
2$
654.00
932.00
$ 1,017.00
$ 8,744.00
Switzerland
$ 5,007.00
$ 6,498.00
$10,042.00
United Kingdom
$ 6,514.00
$ 2,896.00
$ 2,839.00
3.
$ 6,549.00
$ 5,009.00
$ 6,217.00
$ 3,898.00
$ 2,183.00
Belgium
3
$2,665.00
$ 2,909.00
Germany
3.
$ 2,300.00
$ 1,977.00
France
3.
$ 1,728.00
$ 1,793.00
$ 1,720.00
$1,949.00
Когea, South
$ 1,967.00
S 1,427.00
$ 1,517.00
$ 1,283.00
$ 1,350.00
$ 1,108.00
Singapore
3
$ 1,206.00
$ 1,177.00
Italy
3.
24
992.00
997.00
851.00
$1,024.00
Russia
512.00
672.00
24
581.00
388.00
Spain
3
436.00
398.00
24
386.00
366.00
The table above presents data on the top 25 trading partners of the State of New York from 2011
through 2014 in $Million. The countries have been classified into three World Regions.
Cut and paste the table into a Spreadsheet and Summarize, using tables
Total Value of Trade by Region by Year and Region and Plot a chart
The Percentage of each region's trade value to total trade for each year
3. Plot a…
arrow_forward
A small dealership leased 21 Suburu Outbacks on 2-year leases. When the cars were returned at the end of the lease, the mileage was recorded (see below).
40,010
24,996
14,340
17,359
44,712
44,525
20,239
33,348
24,299
41,782
58,313
35,886
25,765
28,937
25,069
43,302
23,958
43,526
53,617
31,803
36,704
(a) Is the dealer's mean significantly greater than the national average of 29,393 miles for 2-year leases? Using the 10 percent level of significance, choose the appropriate hypothesis.
H0: μ ≤ 29,393 miles vs. H1: μ > 29,393 miles, reject H0 if tcalc > 1.3250
H0: μ ≥ 29,393 miles vs. H1: μ > 29,393 miles, reject H0 if tcalc > 1.3250
H0: μ ≤ 29,393 miles vs. H1: μ < 29,393 miles, reject H0 if tcalc > 1.3250
H1: μ ≤ 29,393 miles vs. H0: μ > 29,393 miles, reject H0 if tcalc > 1.3250
b) Calculate the test statistic. (Round your answer to 2 decimal places.) Test statistic
arrow_forward
8) see pictures to solve
arrow_forward
You have recorded your company sales
over the last 2 years and notice an
increasing trend in sales. After plotting
the sales in Excel, it shows you the
following best-fit line: y = 1036.7x +
2729.5 where y is units sold and x is
the time period. You also observe that
the sales show seasonality and
calculate the seasonal indices for each
season in the table below.
Season
Winter
Spring
Summer
Fall
Seasonal
Index
0.82
0.78
1.26
1.13
Using the trendline and seasonal index,
what is the forecast for the next
Summer (time period 11)? (Hint: this is
similar to practice problem #28)
arrow_forward
Starting Teachers' Salaries Starting teacher salaries for upper secondary education in selected states are listed below.
Average salaries
40,576
Starting salaries
Mississippi
28,200
Mississippi
Idaho
27,500
Idaho
41,150
Kansas
27,840
Kansas
41,467
Maine
26,643
Maine
40,737
Iowa
27,284
Iowa
41,083
New Mexico
33,730
New Mexico
41,637
Tennessee
32,369
Tennessee
42,537
Texas
33,775
Texas
41,744
Kentucky
30,619
Kentucky
42,592
Send data to Excel
arrow_forward
A researcher interested in determining if there is an association between head
circumference and brain volume tested for linear correlation at the a= 0.05
significance level. She took a random sample of twenty adults and measured
the head circumference and brain volume (using ultrasound) for each person in
the sample. The table above gives the paired data for the twenty adults. The
researcher determined there is positive linear correlation between head
circumference and brain volume at the 0.05 level of significance. With that
information answer the following questions.
1.) Since we've determined there is linear correlation between head
circumference and brain volume from the output on the TI83/84 what is "a" the
y-intercept of the regression line?
A. a=.508
B. a=34.740
C. a=-110.572
D. a=-823.829
2. Since we've determined there is linear correlation between head
circumference and brain volume from the output on the T183/84 what is "b" the
slope of the regression?
A. b=34.740
B. b=.508…
arrow_forward
Use the following table.
University
Headcount
FTE
University of Florida
41,295
29,475
Florida State University
30,714
21,737
Florida A&M University
11,178
8,028
University of South Florida
31,783
18,221
Florida Atlantic University
19,783
10,535
University of West Florida
7229
4516
University of Central Florida
30,005
18,344
Florida International University
30,059
17,447
University of North Florida
11,580
6231
Florida Gulf Coast University
2292
1363
Subtotal E & G
215,918
135,897
Suppose the state decides to apportion 400 new teaching positions on the basis of the number of FTEs in each university.
(a) Use the Hamilton method to find the standard divisor SD. (Round your answer to two decimal places.)SD =_______ (b) Use the Hamilton method to find the standard quotient SQ for Florida Atlantic and the University of Central Florida. Answer to 3 decimal places.
Florida Atlantic
University of Central Florida
arrow_forward
Name:
Write out the proper prime factorization and list all the natural factors.
arrow_forward
ZIP Code
Population
Season Pass Holders
45220
14171
224
45219
17576
42
45225
13437
15
45217
5731
78
45214
9952
19
45232
6913
28
45223
13349
83
45229
15713
75
45206
11353
69
45202
15105
83
45203
3411
9
45207
8233
8
41074
5566
36
41073
6193
63
45224
21043
207
41071
21596
133
45205
21683
102
45204
6642
36
41016
5603
42
45216
9028
55
45212
22356
207
41011
25849
193
41014
7913
41
45237
21137
86
45208
18236
424
45211
33968
342
45239
26485
269
41075
15868
236
45209
8941
111
45226
5029
84
45238
42737
564
45231
39939
361
45213
11683
153
45215
28915
308
45218
3917
54
41017
40218
493
41076
14779
176
45251
22887
205
45227
18431
215
45247
20372
357
41015
22298
189
45248
22880
380
45236
21823
310
45240
27033
142
45246
13522
100
45230
25763
423
45233
14175
244
45252
4799
58
41018
29001
244
45243
14755
303
45241
25623
299
45014
44178
307
45242
20015
377
45244
26316
448
41059
2266
22
41048…
arrow_forward
The February utility bills (in dollars) for ten residents of a large city are listed below Find the mode amount.
71
67 67 72 76
72 73
68 72 72
O A. $72
O B. $73
O C. $76
O D. $67
arrow_forward
The following table shows the number of active military personnel in 2009, by region (including the District of Columbia).
Pacific
229,634
Mountain
89,816
West South Central
177,336
West North Central
64,564
East North Central
26,384
East South Central
68,440
South Atlantic
376,034
Middle Atlantic
41,441
New England
8,579
Source: U.S. Census Bureau, Statistical Abstract of the United States: 2012, Table 508 (data) and U.S. Census Bureau, Census Regions and Divisions of the United States (regions).
Calculate the mean and standard deviation for the population.
Now take 10 samples of size 3 from the population. Use either simple random sampling or systematic sampling with the help of the table of random numbers in Appendix A. Calculate the mean for each sample.
Once you have calculated the mean for each sample, calculate the mean of means (i.e., add up your 10 sample means and divide by 10). How does this mean compare with the mean for all…
arrow_forward
Vermont
8.67
New Hampshire 8.84
Maine
9.20
Connecticut
9.72
Rhode Island
9.94
Massachusetts
10.01
Oregon
10.07
West Virginia
10.00
Florida
10.40
Pennsylvania
10.59
Montana
10.84
Delaware
10.98
New Mexico
10.99
Michigan
11.01
Colorado
11.04
South Carolina
11.15
Arizona
11.26
New Jersey
11.36
Wyoming
11.36
Washington
11.42
North Carolina
11.46
California
11.50
Ohio
11.56
New York
11.58
Virginia
11.72
Nevada
11.76
Maryland
11.76
Alabama
11.82
Tennessee
11.93
Hawaii
11.95
Missouri
11.96
Iowa
11.97
Georgia
11.99
Minnesota
12.00
Kentucky
12.07
Indiana
12.20
Idaho
12.20
Arkansas
12.28
Mississippi
12.39
Kansas
12.45
Oklahoma
12.63
Louisiana
12.79
District of Columbia
13.11
Texas
13.19
Nebraska
13.21
South Dakota
13.48
Alaska
13.68
North Dakota
13.99
Wisconsin
11.03
Utah
14.93
Determine the mean and standard deviation of your sample.
Find the 80%, 95%, and 99% confidence…
arrow_forward
Here are the numbers of legal immigrants (in thousands) who settled in each state east of the
Mississippi River from 2000 to 2007:
Alabama
60.4
Connecticut
158.6
Delaware
Illinois
23.4
Florida
997.9
Georgia
Kentucky
316.8
459.9
Indiana
95.3
49.6
Maine
11.7
Maryland
Mississippi
New York
227.3
Massachusetts
274.2
Michigan
New Jersey
Ohio
186.4
21.6
New Hampshire
North Carolina
19.7
444.9
992.6
253.3
134.9
Pennsylvania 204.2
Tennessee
Rhode Island
32.9
South Carolina
73.0
102.0
Vermont
4.5
Virginia
268.4
West Virginia
7.0
Wisconsin
-86.2
1. Make a histogram using Microsoft Excel or Google Sheets.
2. Answer the following questions.
• True or False: The mean and standard deviation are more suitable numerical summaries than
the five-number summary.
• What is the median value (in thousands) of this distribution?
• List the 5 number summary (in thousands) of this distribution.
Edit
View
Insert
Format Tools
Table
arrow_forward
Weight
City MPG
3968
20
3583
22
3470
22
3527
23
3990
18
4724
17
3692
21
3315
22
3616
20
5527
14
3719
16
3097
26
3800
19
3532
25
2269
31
5674
15
3402
20
4029
19
3996
19
3242
23
2434
31
2575
29
2960
27
3618
15
4054
19
3192
24
3305
23
3605
19
4240
15
3933
18
3633
19
3790
17
3477
20
3258
21
4685
17
2776
25
2615
24
3186
21
5137
13
3461
21
4233
16
4178
18
4702
17
3713
22
5794
14
2306
28
3194
26
3428
22
4894
12
4751
17
2605
29
3296
25
5267
13
2789
25
3570
19
4011
18
2363
27
4398
15
2806
25
2127
36
2665
27
3419
24
3427
24
3280
25
5765
13
3465
24
2295
30
3038
22
3070
25
4711
17
3230
24
3528
21
4667
16
SUMMARY OUTPUT
Regression Statistics
Multiple R
0.894328844
R Square
0.799824082
Adjusted R Square
0.797004703
Standard Error
2.238112689…
arrow_forward
Salaries Starting teacher salaries for upper secondary education in selected states are listed below.
Starting Teachers
Starting salaries
26,521
26,704
Average salaries
40,007
Utah
Utah
38,284
West Virginia
West Virginia
40,462
38,772
Missouri
29,281
MisSourt
29,174
Oklahoma
oklahoma
40,029
40,382
31,298
Louisiana
Louisiana
Nebraska
29,303
Nebraska
40,347
Alabama
31,368
Alabama
arrow_forward
a. the push-up range for 13-year-old boys
b. the pull-up range for 13-year-old girls
c. the mile run range for 12-year-old girls
arrow_forward
Compare California's adjusted rate with that of Florida. Use information in the table provided.
arrow_forward
Using the appropriate measure of dispersion/heterogeneity/ diversity,demonstrate which city is the most diverse?
arrow_forward
Male
Female
27,767
20,516
17,413
24,972
6,080
4,900
28,523
17,661
25,137
11,901
9,821
17,562
21,857
9,865
16,491
21,047
27,687
12,095
23,361
20,089
12,272
16,244
9,584
14,395
13,562
15,467
23,151
23,501
20,071
5,715
142
19,698
21,957
21,640
8,722
18,345
21,058
16,616
17,940
15,249
15,001
28,849
20,938
6,825
6,151
17,111
8,370
4,197
27,687
12,989
11,589
16,879
12,021
13,322
13,709
20,292
12,888
19,417
17,879
14,061
13,743
32,349
11,268
8,738
22,102
10,475
16,788
11,971
10,387
28,702
13,809
22,947
15,644
16,386
11,044
20,101
17,933
20,564
11,413
14,483
11,842
17,349
6,794…
arrow_forward
SEE MORE QUESTIONS
Recommended textbooks for you

MATLAB: An Introduction with Applications
Statistics
ISBN:9781119256830
Author:Amos Gilat
Publisher:John Wiley & Sons Inc

Probability and Statistics for Engineering and th...
Statistics
ISBN:9781305251809
Author:Jay L. Devore
Publisher:Cengage Learning

Statistics for The Behavioral Sciences (MindTap C...
Statistics
ISBN:9781305504912
Author:Frederick J Gravetter, Larry B. Wallnau
Publisher:Cengage Learning

Elementary Statistics: Picturing the World (7th E...
Statistics
ISBN:9780134683416
Author:Ron Larson, Betsy Farber
Publisher:PEARSON

The Basic Practice of Statistics
Statistics
ISBN:9781319042578
Author:David S. Moore, William I. Notz, Michael A. Fligner
Publisher:W. H. Freeman

Introduction to the Practice of Statistics
Statistics
ISBN:9781319013387
Author:David S. Moore, George P. McCabe, Bruce A. Craig
Publisher:W. H. Freeman
Related Questions
- Here are the number of legal immigrants (in thousands) who settled in each state east of the Mississippi River in a given year. Alabama 3.8 Connecticut 10.8 Delaware 2.2 Florida 102.8 Georgia 24.3 Illinois 36.0 Indiana 7.8 Kentucky 5.2 Maine 1.2 Maryland 25.5 Massachusetts 29.6 Michigan 17.0 Mississippi 1.8 New Hampshire 2.1 New Jersey 53.1 New York 133.5 North Carolina 16.8 Ohio 13.7 Pennsylvania 24.7 Rhode Island 3.3 South Carolina 4.2 Tennessee 8.5 Vermont 0.9 Virginia 27.9 West Virginia 0.8 Wisconsin 6.0 New York and Florida are high outliers in this distribution. Find the mean (in thousands) and the median (in thousands) for these data with and without New York and Florida. (Round your answers to two decimal places.) with New York and Floridaarrow_forwardA small dealership leased 21 Suburu Outbacks on 2-year leases. When the cars were returned at the end of the lease, the mileage was recorded (see below). 40,000 24,940 14,325 17,328 44,729 44,522 20,254 33,305 24,204 41,765 58,328 35,825 25,715 28,985 25,011 43,363 23,956 43,580 53,685 31,847 36,789 Click here for the Excel Data File (a) Is the dealer's mean significantly greater than the national average of 30,537 miles for 2-year leases? Using the 10 percent level of significance, choose the appropriate hypothesis. H0: μ ≤ 30,537 miles vs. H1: μ > 30,537 miles, reject H0 if tcalc > 1.3250 H0: μ ≥ 30,537 miles vs. H1: μ > 30,537 miles, reject H0 if tcalc > 1.3250 H0: μ ≤ 30,537 miles vs. H1: μ < 30,537 miles, reject H0 if tcalc > 1.3250 H1: μ ≤ 30,537 miles vs. H0: μ > 30,537 miles, reject H0 if tcalc > 1.3250 c a d b (b) Calculate the test statistic. (Round your answer to 2 decimal places.)…arrow_forwardA small dealership leased 21 Suburu Outbacks on 2-year leases. When the cars were returned at the end of the lease, the mileage was recorded (see below). 40,009 24,998 14,321 17,374 44,720 44,508 20,203 33,341 24,287 41,739 58,395 35,880 25,712 28,984 25,082 43,330 23,904 43,553 53,652 31,851 36,704 H0: μ ≤ 29,503 miles vs. H1: μ > 29,503 miles, reject H0 if tcalc > 1.3250 (b) Calculate the test statistic. (Round your answer to 2 decimal places.)arrow_forward
- Saudi Araba 597.00 572.00 599.00 467.00 Australia 987.00 2$ 654.00 932.00 $ 1,017.00 $ 8,744.00 Switzerland $ 5,007.00 $ 6,498.00 $10,042.00 United Kingdom $ 6,514.00 $ 2,896.00 $ 2,839.00 3. $ 6,549.00 $ 5,009.00 $ 6,217.00 $ 3,898.00 $ 2,183.00 Belgium 3 $2,665.00 $ 2,909.00 Germany 3. $ 2,300.00 $ 1,977.00 France 3. $ 1,728.00 $ 1,793.00 $ 1,720.00 $1,949.00 Когea, South $ 1,967.00 S 1,427.00 $ 1,517.00 $ 1,283.00 $ 1,350.00 $ 1,108.00 Singapore 3 $ 1,206.00 $ 1,177.00 Italy 3. 24 992.00 997.00 851.00 $1,024.00 Russia 512.00 672.00 24 581.00 388.00 Spain 3 436.00 398.00 24 386.00 366.00 The table above presents data on the top 25 trading partners of the State of New York from 2011 through 2014 in $Million. The countries have been classified into three World Regions. Cut and paste the table into a Spreadsheet and Summarize, using tables Total Value of Trade by Region by Year and Region and Plot a chart The Percentage of each region's trade value to total trade for each year 3. Plot a…arrow_forwardA small dealership leased 21 Suburu Outbacks on 2-year leases. When the cars were returned at the end of the lease, the mileage was recorded (see below). 40,010 24,996 14,340 17,359 44,712 44,525 20,239 33,348 24,299 41,782 58,313 35,886 25,765 28,937 25,069 43,302 23,958 43,526 53,617 31,803 36,704 (a) Is the dealer's mean significantly greater than the national average of 29,393 miles for 2-year leases? Using the 10 percent level of significance, choose the appropriate hypothesis. H0: μ ≤ 29,393 miles vs. H1: μ > 29,393 miles, reject H0 if tcalc > 1.3250 H0: μ ≥ 29,393 miles vs. H1: μ > 29,393 miles, reject H0 if tcalc > 1.3250 H0: μ ≤ 29,393 miles vs. H1: μ < 29,393 miles, reject H0 if tcalc > 1.3250 H1: μ ≤ 29,393 miles vs. H0: μ > 29,393 miles, reject H0 if tcalc > 1.3250 b) Calculate the test statistic. (Round your answer to 2 decimal places.) Test statisticarrow_forward8) see pictures to solvearrow_forward
- You have recorded your company sales over the last 2 years and notice an increasing trend in sales. After plotting the sales in Excel, it shows you the following best-fit line: y = 1036.7x + 2729.5 where y is units sold and x is the time period. You also observe that the sales show seasonality and calculate the seasonal indices for each season in the table below. Season Winter Spring Summer Fall Seasonal Index 0.82 0.78 1.26 1.13 Using the trendline and seasonal index, what is the forecast for the next Summer (time period 11)? (Hint: this is similar to practice problem #28)arrow_forwardStarting Teachers' Salaries Starting teacher salaries for upper secondary education in selected states are listed below. Average salaries 40,576 Starting salaries Mississippi 28,200 Mississippi Idaho 27,500 Idaho 41,150 Kansas 27,840 Kansas 41,467 Maine 26,643 Maine 40,737 Iowa 27,284 Iowa 41,083 New Mexico 33,730 New Mexico 41,637 Tennessee 32,369 Tennessee 42,537 Texas 33,775 Texas 41,744 Kentucky 30,619 Kentucky 42,592 Send data to Excelarrow_forwardA researcher interested in determining if there is an association between head circumference and brain volume tested for linear correlation at the a= 0.05 significance level. She took a random sample of twenty adults and measured the head circumference and brain volume (using ultrasound) for each person in the sample. The table above gives the paired data for the twenty adults. The researcher determined there is positive linear correlation between head circumference and brain volume at the 0.05 level of significance. With that information answer the following questions. 1.) Since we've determined there is linear correlation between head circumference and brain volume from the output on the TI83/84 what is "a" the y-intercept of the regression line? A. a=.508 B. a=34.740 C. a=-110.572 D. a=-823.829 2. Since we've determined there is linear correlation between head circumference and brain volume from the output on the T183/84 what is "b" the slope of the regression? A. b=34.740 B. b=.508…arrow_forward
- Use the following table. University Headcount FTE University of Florida 41,295 29,475 Florida State University 30,714 21,737 Florida A&M University 11,178 8,028 University of South Florida 31,783 18,221 Florida Atlantic University 19,783 10,535 University of West Florida 7229 4516 University of Central Florida 30,005 18,344 Florida International University 30,059 17,447 University of North Florida 11,580 6231 Florida Gulf Coast University 2292 1363 Subtotal E & G 215,918 135,897 Suppose the state decides to apportion 400 new teaching positions on the basis of the number of FTEs in each university. (a) Use the Hamilton method to find the standard divisor SD. (Round your answer to two decimal places.)SD =_______ (b) Use the Hamilton method to find the standard quotient SQ for Florida Atlantic and the University of Central Florida. Answer to 3 decimal places. Florida Atlantic University of Central Floridaarrow_forwardName: Write out the proper prime factorization and list all the natural factors.arrow_forwardZIP Code Population Season Pass Holders 45220 14171 224 45219 17576 42 45225 13437 15 45217 5731 78 45214 9952 19 45232 6913 28 45223 13349 83 45229 15713 75 45206 11353 69 45202 15105 83 45203 3411 9 45207 8233 8 41074 5566 36 41073 6193 63 45224 21043 207 41071 21596 133 45205 21683 102 45204 6642 36 41016 5603 42 45216 9028 55 45212 22356 207 41011 25849 193 41014 7913 41 45237 21137 86 45208 18236 424 45211 33968 342 45239 26485 269 41075 15868 236 45209 8941 111 45226 5029 84 45238 42737 564 45231 39939 361 45213 11683 153 45215 28915 308 45218 3917 54 41017 40218 493 41076 14779 176 45251 22887 205 45227 18431 215 45247 20372 357 41015 22298 189 45248 22880 380 45236 21823 310 45240 27033 142 45246 13522 100 45230 25763 423 45233 14175 244 45252 4799 58 41018 29001 244 45243 14755 303 45241 25623 299 45014 44178 307 45242 20015 377 45244 26316 448 41059 2266 22 41048…arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- MATLAB: An Introduction with ApplicationsStatisticsISBN:9781119256830Author:Amos GilatPublisher:John Wiley & Sons IncProbability and Statistics for Engineering and th...StatisticsISBN:9781305251809Author:Jay L. DevorePublisher:Cengage LearningStatistics for The Behavioral Sciences (MindTap C...StatisticsISBN:9781305504912Author:Frederick J Gravetter, Larry B. WallnauPublisher:Cengage Learning
- Elementary Statistics: Picturing the World (7th E...StatisticsISBN:9780134683416Author:Ron Larson, Betsy FarberPublisher:PEARSONThe Basic Practice of StatisticsStatisticsISBN:9781319042578Author:David S. Moore, William I. Notz, Michael A. FlignerPublisher:W. H. FreemanIntroduction to the Practice of StatisticsStatisticsISBN:9781319013387Author:David S. Moore, George P. McCabe, Bruce A. CraigPublisher:W. H. Freeman

MATLAB: An Introduction with Applications
Statistics
ISBN:9781119256830
Author:Amos Gilat
Publisher:John Wiley & Sons Inc

Probability and Statistics for Engineering and th...
Statistics
ISBN:9781305251809
Author:Jay L. Devore
Publisher:Cengage Learning

Statistics for The Behavioral Sciences (MindTap C...
Statistics
ISBN:9781305504912
Author:Frederick J Gravetter, Larry B. Wallnau
Publisher:Cengage Learning

Elementary Statistics: Picturing the World (7th E...
Statistics
ISBN:9780134683416
Author:Ron Larson, Betsy Farber
Publisher:PEARSON

The Basic Practice of Statistics
Statistics
ISBN:9781319042578
Author:David S. Moore, William I. Notz, Michael A. Fligner
Publisher:W. H. Freeman

Introduction to the Practice of Statistics
Statistics
ISBN:9781319013387
Author:David S. Moore, George P. McCabe, Bruce A. Craig
Publisher:W. H. Freeman