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

  1modify the database by adding an additional column

1.modify the database by adding an additional column deleteddate to those tables that represent entities that could

  Explain the benefits and current trends of data warehousing

Create a diagram using Visio, Microsoft Paint, or other graphical creation utility of your choosing to illustrate the conceptual data feeds into and out of the data warehouse. Note: The graphically depicted solution is not included in the required..

  Discuss social engineering techniques

Discuss how the information gathered during your footprinting analysis could be used to initiate an attack against the organization. Discuss social engineering techniques that could be utilized to gather information regarding the organization's com..

  Create mock-up report to make the monthly claim

He wishes you to group data by insurance company number, with subtotals by company and grand totals for each numeric field.

  Draw dfd for placing order based on the e-r diagram

Draw a DFD (Context and Level 1) for placing an order based on the E-R diagram shown here.

  Create a query using the traditional join method

Using the BOOKS and PUBLISHER tables, create a query using the traditional join method that will return a list containing the book title, publisher contact person, and publisher phone number for all publishers whose publisher name starts with an ‘..

  Explain why data flow diagrams are developed in a hierarchy

Explain why data flow diagrams are developed in a hierarchy? What are the names of some levels in the hierarchy?

  Create a class diagram of the intial code

The base application consists of three classes - Doctor, Patient and Hospital. A patient can be a private or public patient and is handled differently in either case. Patients are assigned to Doctors according to availability and preference.

  Unique identifiers and normalization

Identifying Relationships.Unique Identifiers and Normalization

  Define security threats as it relate to the operating system

Discuss security threats as it relate to the Operating Systems and Memory Management. Consider a fixed partitioning scheme with equal-size partitions of 2 16 bytes and a total main memory size of 2^24 bytes. A process table is maintained that inc..

  Modifying a database design in visio

1. Use Microsoft Visio (or open source equivalent) in which you: a. Modify the database diagram from Lab 1 with the entities and attributes that the scenario identified (i.e., a college tracking students, courses, and instructors).

  Draw the er diagram above scenario by illustrating the

Consider the following requirements for an airline ticketsbooking system. The system is composed of manyairlines. Each airline is identified by a code, name and headquarter’s address. An airline has different mileprograms, identified by a type- code,..

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