Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

The Affordable Housing worksheet contains information about housing in 1 6 9 towns from 2 0 1 1 to 2 0 2 2 . We

The Affordable Housing worksheet contains information about housing in 169 towns from 2011 to 2022.
We would like to calculate a desirability index score for each observation and place it in the L column of the dataset. The desirability index calculation is different for towns with a niceness index score above and below 37.
For towns with a niceness >37:
[Total Assisted Units (I column)/2010 census units (D column)]+0.97
For the remaining towns:
Total Assisted Units (I column)/2010 census units (D column)
Essentially, you are calculating a desirability index by taking the (total assisted units /2010 census) for each row, and adding a 0.97 premium if the niceness index exceeds 37.
What is the average value in the desirability column? (round to 3 digits)

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_2

Step: 3

blur-text-image_3

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

Strategic Management State Of The Field And Its Future

Authors: Irene M. Duhaime , Michael A. Hitt , Marjorie A. Lyles

1st Edition

0190090898, 978-0190090890

More Books

Students also viewed these General Management questions