Question: EXCEL PROBLEM SET 2 Z-SCORES Using the Week 2 Z Scores Excel data file and Appendix A of the book, report your results on the

EXCEL PROBLEM SET 2

Z-SCORES

Using the Week 2 Z Scores Excel data file and Appendix A of the book, report your results on the following prompts below.

Statewide Average Median Home Price in 2021 Average Monthly Payment in 2021
Average $182,158 $691
Std Dev $68,646 $260

  1. What percentage of cases falls between +.25 SD and -.25 SD in the population?

  1. Using the Excel data file, what percentage of the 82 sampled counties would we expect to have a median home price of $150,000 or greater in 2021?

  1. Calculate the Z scores for the average median home price in 2021 for all 82 sampled counties. Which county has the largest Z score?

  1. Calculate the Z scores for the average median home price in 2021 for all 82 sampled counties. Which county has the smallest Z score?

PROBLEM SET 2

County Median Home Price 2021 Monthly home payment 2021 Monthly home payment 2020
Alamance 190587 723 665
Alexander 155520 590 553
Anson 106949 406 372
Ashe 174029 660 620
Avery 163579 621 583
Beaufort 150856 572 537
Brunswick 279779 1062 976
Buncombe 315927 1199 1111
Burke 161559 613 574
Cabarrus 295283 1120 1028
Caldwell 149368 567 531
Camden 237189 900 845
Caswell 128137 486 456
Catawba 175003 664 622
Cherokee 180732 686 644
Chowan 148925 565 530
Cleveland 152787 580 544
Columbus 100987 383 360
Craven 173575 659 618
Cumberland 156003 592 566
Currituck 290720 1103 1047
Dare 328293 1246 1169
Davidson 175733 667 626
Davie 197770 750 702
Duplin 102464 389 365
Durham 283105 1074 1011
Edgecombe 97722 371 340
Forsyth 195020 740 692
Franklin 198264 752 700
Gaston 194901 740 679
Gates 167782 637 598
Graham 138928 527 495
Granville 177210 672 631
Greene 100511 381 357
Guilford 209953 797 744
Halifax 98034 372 349
Harnett 186752 709 665
Haywood 206144 782 725
Henderson 289427 1098 1018
Hertford 100646 382 358
Iredell 244271 927 851
Jackson 222762 845 793
Johnston 231901 880 818
Lee 163806 622 583
Lenoir 108484 412 386
Lincoln 237117 900 826
Macon 188115 714 670
Madison 223122 847 785
Martin 105077 399 374
Mcdowell 135407 514 482
Mecklenburg 318384 1208 1109
Mitchell 178800 678 637
Montgomery 133703 507 476
Moore 264111 1002 941
Nash 148122 562 516
New Hanover 313097 1188 1092
Onslow 187799 713 645
Orange 389113 1476 1390
Pamlico 177210 672 631
Pender 230673 875 804
Perquimans 195726 743 697
Pitt 176632 670 628
Randolph 149458 567 530
Robeson 83607 317 298
Rockingham 130403 495 462
Rowan 186105 706 648
Rutherford 145062 550 517
Sampson 101441 385 361
Scotland 97125 369 346
Stanly 157785 599 562
Surry 153469 582 547
Swain 158012 600 563
Transylvania 252070 956 898
Tyrrell 130408 495 464
Union 320847 1217 1117
Vance 115187 437 410
Wake 363694 1380 1283
Washington 97011 368 346
Watauga 270359 1026 963
Wilkes 156876 595 559
Wilson 156990 596 559
Yadkin 152510 579 541

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Mathematics Questions!

Q:

CoursHeroTranscribedText: Question 1 The daily volume of a brokerage company follows a normal distribution. The director wants to estimate the daily volume negotiated. a) What size should have a...

Q:

Use the attached "words.txt" file to store the words along with their ranks in an AVL tree. Then provide the user the option to search for any word. If the word exists the program displays the rank...

Q:

Select an employee right in the workplace. Give an example, based on your own outside reading or experience, of a situation involving this right. Was it violated? How? What was the outcome? What...

Q:

The Regina Company, Inc. BALANCE SHEET (In Thousands) ASSETS Cash Accounts Receivable Inventories Other Current Assets Total Current Assets Fixed Assets Accum Depreciation Other Assets TOTAL ASSETS...

Q:

What are our main literary sources for the Trojan War? What aspects are likely myth and what known historical events are probably related? Discuss various aspects of the Trojan War and give examples...

Q:

REVENUE RECOGNITION AND MATCHING Omega Transportation Inc., headquartered in Atlanta, Georgia, engaged in the following transactions: . billed customers $2,387,000 for transportation services ....

Q:

Explain why self-acceptance is important for high self-esteem.

Q:

The ledger of Hubbard Company includes the following accounts. Explain why each account may require adjustment. (a) Prepaid Insurance. (b) Depreciation Expense. (c) Unearned Service Revenue. (d)...

Q:

There are four different types of Mailbox enabled accounts. List the four types and describe each ones functionality and when it would be used.

Q:

During 2020. Riverbed Corporation reported net sales of $5,542.800 and net income of $1.560,000. its balance sheet reported. average total assets of $1,490,000 Calculate the asset turnover. (Round...

Q:

Cost A company buys and retails baseball caps, and the total cost function is linear. The total cost for 200 caps is $2690, and the total cost for 500 caps is $3530. What is the marginal cost, which...

Q:

Changes to Australia's superannuation legislation now enable eligible employees to choose the superannuation fund they wish their super contributions to be paid into. Employers are legally obliged to...

Q:

= {x|ln 3.2 x 20} and two events A Problem 1. (6 points) Given a sample space S x 6} and B {x|3 x 7}, describe the following events. a) AUB. b) A - B. c) AU (BNS). = {x|2

Q:

Case Study You are a business analyst who has just joined the commission system replacement project at PrivateWealth. The project has been running for six months, and half of the planned analysis...

Q:

Jumpst Corporation uses the cost formula Y = $1,600 + $0.20X for the maintenance cost in Department B, where X is machine-hours. The August budget is based on 20,000 hours of planned machine time....

Q:

Read the following information about Ellen. Provide your responses on the worksheet that accompanies this assignment. Ellen got her "first, good - real" job [not counting the "McJobs" she had while...

Q:

New York City is evaluating the construction of a new train station to serve a new high - speed rail system. The Capital Projects Team is responsible for evaluating whether the project is...

Q:

During the year land was revalued and the surplus reported as Revaluation surplus; and an asset costing 80,000, written down to 38,000, was sold for 40,000. Identify the cost of any non-current...

Q:

6.26 After all students have left the classroom, a statistics professor notices that four copies of the text were left under desks. At the beginning of the next lecture, the professor distributes the...

Q:

6.29 Suppose that a six-sided die is loaded so that any particular even-numbered face is twice as likely to land face up as any particular odd-numbered face. Consider the chance experiment that...

Q:

6.28 A student placement center has requests from five students for interviews regarding employment with a particular consulting firm. Three of these students are math majors, and the other two...