FREE Trial
Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Linear Algebra with Applications

Linear Algebra with Applications

Authors: Steven J. Leon

7th edition

131857851, 978-0131857858

More Books

Students also viewed these Mathematics questions

Question

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

Answered: 1 week ago

Question

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

Answered: 1 week ago

Question

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

Answered: 1 week ago

Question

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

Answered: 1 week ago

Question

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

Answered: 1 week ago

Question

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

Answered: 1 week ago

Question

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

Answered: 1 week ago

Question

★★★★★
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)...

Answered: 1 week ago

Question

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

Answered: 1 week ago

Question

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

Answered: 1 week ago

Question

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

Answered: 1 week ago

Question

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

Answered: 1 week ago

Question

★★★★★
= {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

Answered: 1 week ago

Question

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

Answered: 1 week ago

Question

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

Answered: 1 week ago

Question

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

Answered: 1 week ago

Question

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

Answered: 1 week ago

Question

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

Answered: 1 week ago

Question

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

Answered: 1 week ago

Question

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

Answered: 1 week ago

Question

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

Answered: 1 week ago

Previous Question Next Question