Analyze the sales data to determine the true track record

Assignment Help Database Management System
Reference no: EM13801975

You are an intern with the Regional Realty Association and are analyzing the claim made by Alice Barr Realty that "we get your price." You have prepared a spreadsheet that shows data relating to 3 months' sales by Alice Barr Realty. You are going to determine the percent of asking price for each home sold and analyze the sales data to determine the true track record of the company in selling homes for the asking price.

Alice Barr Realty





We get your price and we sell it quickly!



Address City Selling Agent Asking Price Selling Price % of Asking Listing Date Sale Date
8687 Kenwood Road Miami Hernandez 725000 645250
39173 39187
7 Kingston Court Sunrise Carey 500000 465000
39175 39182
1370 Pinellas Road Sunrise Lugo 219000 215000
39176 39204
10995 SW 88 Court Coral Gables Goodrich 110000 106000
39184 39266
1971 Glenview Road Coral Gables Minkus 165000 156750
39184 39214
8030 Steeplechase Drive Sunrise Merkin 450000 382500
39187 39202
2006 Cutwater Court Sunrise Minkus 345000 339999
39190 39225
4081 Lybyer Avenue Sunrise Minkus 325000 308750
39191 39233
758 University Drive Coral Gables Hernandez 325000 302250
39200 39203
224 Rockaway Street Sunrise Pijuan 98000 93100
39202 39252
11971 SW 269 Terrace Miami Carey 410000 397700
39203 39258
8307 S Indian River Drive Coral Gables Hernandez 250000 255000
39203 39220
9408 Forest Hills Circle Miami Reuter 185500 179000
39203 39206
16235 Orange Boulevard Miami Lugo 77500 75900
39207 39277
2448 Woodacres Road Coral Gables Hernandez 450000 382500
39207 39217
1414 N Sheridan Road Sunrise Pijuan 1250000 1225000
39214 39239
10700 Lake Shore Lane Miami Carey 650000 598000
39217 39242
605 Reservoir Drive Sunrise Reuter 310000 291400
39224 39231
81 Island Drive South Sunrise Bethune 147800 150000
39224 39248
1 Southampton Place Coral Gables Goodrich 285000 276450
39230 39251
1629 NW 43rd Street Miami Carey 179900 163709
39233 39313
21 Compass Road Miami Merkin 189900 182304
39233 39234
30 Kent Road Coral Gables Bethune 259900 246905
39235 39327
520 E Spring Street Sunrise Minkus 189900 186102
39239 39288
4916 Rock Spring Road Miami Lugo 275000 264000
39246 39284
8923 Harris Drive Sunrise Minkus 89000 86330
39251 39271
1132 SW 52nd Street Miami Hernandez 254500 236685
39256 39346
10 Vestal Drive Miami Carey 555000 565000
39257 39263
103 Jasper Drive Coral Gables Bethune 165900 159264
39262 39329
1600 Reeves Street Miami Reuter 245900 233605
39263 39308

Reference no: EM13801975

Questions Cloud

How many joules of energy are released by the explosion : When the plutonium bomb was tested in New Mexico in 1945, approximately 1 gram of matter was converted into energy. Suppose another bomb is tested, and 9.8 grams of matter are converted into energy. How many joules of energy are released by the explo..
How a particular group that you are a part of communicates : how a particular group that you are a part of communicates. The group could be as simple as a group of women, students, friends, family members, religious group, band members, tribe members, or co-workers.
A hydrogen atom has its electron in : (a) A hydrogen atom has its electron in the n = 4 level. The radius of the electron's orbit in the Bohr model is 0.847 nm. Find the de Broglie wavelength of the electron under these circumstances.
Which two forces are an action-reaction pair : A book is sitting on a table. According to Newton's third law, which two forces are an action-reaction pair? a) The normal force of the table on the book and the gravitational force on the book b) The normal force on the book from the table and the..
Analyze the sales data to determine the true track record : You are going to determine the percent of asking price for each home sold and analyze the sales data to determine the true track record of the company in selling homes for the asking price
Define business strategies for implementation : Business strategies for implementation
What role does congress play in formulation of health policy : Health Policy and the Federal Government Review the presentation, The U.S. Congress and Health Policy Presentation, and answer the following questions. What role does Congress play in the formulation of health policy
A car starts from rest and accelerates : A car starts from rest and accelerates at a rate of 9 m/s2 for 4 seconds and then accelerates (brakes) at a rate of -3 m/s2for 2 seconds. How far did the car travel in 6 s?
What types of crimes are codified into law : What types of crimes are codified into law

Reviews

Write a Review

Database Management System Questions & Answers

  Convert the erd

Using the descriptions of the attributes given in the, convert the ERD shown in Figure P6.2 into a dependency diagram that is in 3NF.

  Prove that the decomposition of r into r1 and r2 is lossless

Let R be a relation schema with a set F of FDs. Prove that the decomposition of R into R1 and R2 is lossless-join if and only if F+ contains R1 ∩ R2 → R1 or R1 ∩ R2 → R2.

  Write summary on relational database theory

Write a two-page executive summary for your boss explaining how a relational data solution can be applied to a current business problem or area for improvement. Assume that your boss knows nothing about relational database theory.

  Program that reads the data from the file into an array

Write a program that- Reads the data from the file into an array of structure when the form is loaded

  You have been hired as the banks director of data security

a large bank has a headquarters location plus several branches in each city in a particular region of the country. as

  Problem 1 produce a scatterplot of rent vs size square

problem 1. produce a scatterplot of rent vs. size square meters of the apartment for the rental data in

  describe capability of Good Eat Enterprise Resource Planning

This system will also provide administrators with the ability to create custom reports and filter data based upon a wide variety of information captured from each store.

  Pros and cons in agile and waterfall project management

Evaluate the pros and cons in agile and Waterfall project management in terms of planning and the execution of projects and collaboration among project team members.

  Display last name customer associated with order id

You have to write a query to display last name customer associated with order id in given database.

  Kinds of joins

It is not uncommon to have to access the data which reside in different tables, especially when formulating a report.

  Write a function checksmaller

Write a function 'Max' that takes an int array and the size of the array as input and returns the largest element of the array. The function should look like the following.

  Problem on relational algebra

The database used for this question is a very simple one with the following schema: (Primary keys are bold, foreign keys are underlined)

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