What is the current status of the housing stock in country

Assignment Help Operation Management
Reference no: EM13740279

1. What is the current status of the housing stock in the county?

a. To do this you will create a one-variable summaryusing StatTools and analyze the age of the recently sold homes, their average price sold, the number of bedrooms, bathrooms and number of cars that can be garaged.

b. What does the skewness and kurtosis tell you about these data?

c. Would it be better to use the Interquartile range to analyze this data (not a yes or no answer) and if so why, or why not?

2. Doing twoQ-Q plots, do you consider the data for price and square footage to be normal or not, and why?

3. Doing a correlation in StatTools and using all six of the variables, how are each of these variables correlated to each other.  Again be specific.

4. Doing a scatterplot of price versus square footage and adding a trend line to the plot, what does this tell you about the data?  

a. Now do a scatterplot of price versus age and adding a trend line, what does this tell you about the question of new homes versus price?

5. Next do a multiple regressionusing price as the dependent variable, and all other variables as independent variables:

a. Do any of the variables have a t-value that is greater than the alpha (.05) for this assignment?  If so, delete them and rerun the regression and compare and contrast the old regression versus the new regression without one or more of the variables.

b. Is the F-ratio for this/these regressions significant?  Why?

c. Is the r-squared values for this/these regressions appear to be valid?  Does it show that it explained a sufficient amount of the total variation?

6. Using the coefficients from this regression estimate the selling prices for the following typical Prescott county homes:

 

Home

number

Square footage

Age of the home

Number of bedrooms

Number of bathrooms

Size of the garage (cars)

Projected Selling Price (determined by you)

1

1,850

25

3

2

1

 

2

2,200

14

4

3

2

 

3

3,000

5

5

4

3

 

4

3,400

5

5

5

3

 

5

2,200

40

3

2

1

 

7. Based on the projected selling price of these homes, will Mayor Pete convince the county commission to rezone the land for his brother-in-law, or does the county get a new park? Defend your answer based on the statistics that you have calculated in this case study. Your argument should be no more than 300 words.

Reference no: EM13740279

Questions Cloud

Describe how you would perform a cost analysis : The Operating Budget-Describe how you would perform a Cost Analysis. (Title this section Cost Analysis)
Provide specific recommendations for resolving the problems : Show the impact of each problem on the business and on employee morale. Provide specific recommendations for resolving the problems to restore the Roanoke branch to full productivity
Government budgeting and expenditures : Government Budgeting and Expenditures, Based on the second e-Activity that focuses on the Budget of the United States Government for Fiscal Year 2014 and 2015, analyze the president's messages and the three (3) budgets you selected
Population of the american intellectual union : Explain why charts/graphs are important in conveying information in a visual format and why standard deviation and variation are important. You will need to combine all of the items above into one comprehensive report.
What is the current status of the housing stock in country : What is the current status of the housing stock in the county. To do this you will create a one-variable summary using StatTools and analyze the age of the recently sold homes, their average price sold, the number of bedrooms, bathrooms and number ..
Write an essay on the ottoman empire in world war i : ENGLISH Class research paper. 12-15 paper apa style, 3-5 sources cited. about ottoman empire in world war 1 and gallipoli war in the dardanelles campaign.
Example of a common barrier to effective communication : Share an example of a common barrier to effective communication.
Do you think that there be equal opportunity in society : Do you think that there should be equal opportunity in a just society?
Calculate the annual return : A 25-year maturity bond has a 9% coupon rate, paid annually. It sells today for $1,027.42. Calculate the annual return for the 25-year maturity bond over the next five years

Reviews

Write a Review

Operation Management Questions & Answers

  Estimate the maximum fixed cost

Zipco is in serious negotiations to purchase a chunking machine that will enable them to perform their own chunking at $1.25 per unit. They currently have their chunking outsourced at a cost of $1.75 per unit and a fixed cost of $50,000.

  Create a communication plan for the proposed change

Create a Communication Plan for the proposed change covered in the Change Management Plan. In the Communication Plan, complete the following:

  Explain how much money would be saved by switching to the

suppose annual demand for a given item is 1200 units. for this item ordering cost is 60 and the annual cost of holding

  Problem on forecasting

An Electric Company estimates its demand trend line (in millions of kilowatt hours) to be D = 79 + 0.52 Q, where Q refers to the sequential quarter number and Q=1 for winter 2000.

  Describe filene basement expansion strategy

How do you appraise Filene's Basement's expansion strategy? Comment on the concept, the choice of regions for expansion, and the number of stores.

  Provide real world example of moral philosophy

Provide a "real world" example of moral philosophy. What is the difference between idealism and realism? Support your definitions with practical examples.

  The district 4 production warehouse move project

You have kicked off the District 4 Production Warehouse Move project, your contractors are in place and working on receiving the proper building permits.

  What is most significant impact of it on organization design

What is the most significant impact of IT on organization design?

  What issues can affect the accuracy of ksa collection

How can these be overcome? Are there special issues or concerns when it comes to discovering the employee behaviors that are required in the position?

  List and explain job related competencies

Explain the concept of continuous learning to include an understanding of the work systems, relationship among jobs, their work units and the organization as it is currently designed.

  If you wish to develop a forecast of the demand for this

select a product that you can purchase at a grocery store or at a discount retailer and respond to the following

  Three strategic options for competing internationally

There are three strategic options for competing internationally: multi-country, global, and hybrid. Assume you are in charge of developing a strategy for a multi-national company selling products in some 50 countries around the world. One of the issu..

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd