Question: please see the attached file. please explain for me not just answer. one file is a question and one file is excel with data Cooper

please see the attached file. please explain for me not just answer. one file is a question and one file is excel with data

Cooper Realty is a small real estate company located in Albany, New York, specializing primarily in residential listings. Cooper is interested in determining the likelihood of one of its listings being sold within a certain number of days. Use Cooper's data in the HomeSales sheet in this workbook to generate excel output to answer the following questions. Put the output in given space on HomeSales sheet. 1)What is the probability a selected home takes between 30 and 90 days to sell? 2a)What is the probability a selected home's initial asking price is at least $150,000 and it takes under 30 days to sell? b) Event A = Selected home's intial asking price is at least $150,000. Event B = Selected home takes under 30 days to sell. Are events A and B independent? Proof: Prove using your answer to 5A. If independent, ....=..... 3) What is the probability a selected home's initial asking price is under $200,000? 4) Event A = Selected home takes at least 30 days to sell. Event B = Selected home's initial asking price is under $200,000. Are events A and B mutually exclusive? Prove using your answer to 8A. Proof, If mutually exclusive,...=... 5) If a selected home takes under 30 days or over 90 days to sell, what is the probability its initial asking price is under $200,000 or over $250,000? 6) What is the probability a selected home takes at most 90 days to sell or its initial asking price is between $150,000 and $250,000? 7) Given a selected home's initial asking price is no more than $250,000, what is the probability it takes 90 days or less to sell? Days Price 2 3 2 1 1 3 1 1 1 3 2 3 1 2 1 1 3 1 1 3 1 1 1 2 3 1 1 2 1 2 1 1 3 3 2 2 2 3 1 1 2 1 3 3 1 2 1 2 2 3 2 3 1 2 2 3 3 2 3 2 3 1 1 1 3 2 2 1 1 2 2 3 2 1 1 2 1 1 3 1 3 4 2 4 2 4 1 2 3 3 2 3 3 1 1 1 4 2 3 4 3 3 4 2 2 1 4 3 1 4 1 4 2 3 2 3 4 2 4 3 3 2 1 1 4 1 4 1 2 3 1 4 4 1 3 2 4 1 1 4 4 1 1 1 1 3 1 4 3 3 KEY Note: Pivot table MUST start in cell F10 of this sheet. Price1 = Unde Days1 = Unde Price2 = $150Days2 = 30 - 9 Price3 = $200Days3 = Over Price4 = Over $250,000 3 1 1 2 3 2 2 3 3 2 3 3 3 1 2 2 3 3 2 2 1 2 3 1 2 2 3 1 1 2 1 2 1 2 3 3 3 2 3 3 1 1 3 1 1 2 1 1 1 2 3 3 3 1 2 1 2 3 3 1 3 1 1 3 3 2 3 3 3 2 3 3 2 1 3 1 1 4 3 2 4 1 4 4 4 4 3 1 2 1 2 3 2 4 1 2 1 2 3 2 2 4 3 3 2 3 2 1 1 1 3 4 3 3 1 1 1 3 2 3 4 2 2 3 3 2 3 3 4 1 4 1 2 1 1 2 1 2 2 4 3 3 1 3 4 4 2 3 2 4 4 3 1 1 3 1 3 3 2 1 2 1 1 2 1 3 2 1 1 3 1 3 2 3 2 1 1 2 1 2 1 1 1 3 3 3 3 3 3 1 3 1 1 2 2 2 3 2 1 3 1 2 3 1 2 2 2 3 1 3 2 2 1 1 1 3 3 1 3 1 2 1 1 2 1 2 1 3 2 3 2 2 4 2 4 3 1 1 3 1 4 1 1 2 1 1 1 2 4 3 4 4 1 2 1 2 2 2 2 2 3 2 4 3 4 4 3 3 2 4 4 2 2 2 2 3 3 3 4 1 4 4 4 4 1 4 2 3 3 2 1 1 2 4 4 1 1 3 2 3 2 3 1 2 1 1 1 1 2 3 1 2 2 2 1 2 1 2 2 2 2 1 1 2 2 2 3 1 3 1 2 2 1 3 2 3 3 1 2 2 2 1 1 1 1 1 3 1 3 2 1 2 1 2 2 2 2 1 3 2 3 1 1 2 1 3 1 1 2 3 3 3 1 3 3 3 2 3 1 3 1 4 4 2 3 2 2 4 3 4 3 4 4 1 2 4 2 1 1 2 1 3 2 2 4 2 3 3 2 4 3 2 1 4 1 1 1 2 2 4 4 4 2 4 1 3 3 2 3 4 3 2 4 2 3 3 3 2 3 4 4 1 3 3 3 2 1 2 4 2 3 2 4 2 4 4 2 3 2 3 1 1 2 3 3 3 2 2 1 1 2 3 2 3 1 3 1 2 1 3 3 2 1 1 3 2 3 2 3 1 1 2 1 2 3 3 1 3 1 3 2 1 1 1 3 3 2 2 2 2 2 1 1 3 1 1 3 3 1 1 1 1 2 1 1 2 2 2 2 1 3 3 2 1 3 4 3 4 2 1 4 2 2 4 1 1 4 1 4 2 4 4 1 1 3 2 2 2 3 4 3 4 2 4 2 2 3 4 3 1 2 4 1 1 2 4 1 1 1 3 3 4 4 2 2 2 2 3 3 2 1 4 4 3 3 4 1 1 1 1 4 4 2 3 3 1 1 1 3 2 1 1 1 2 2 3 3 3 2 3 2 1 1 1 1 3 2 2 3 1 1 1 2 1 3 1 1 1 3 1 2 2 1 2 3 2 1 3 1 3 2 2 3 2 1 3 1 2 2 2 3 2 3 3 3 3 3 3 3 1 2 1 1 3 2 2 1 1 2 2 3 2 2 2 3 4 2 1 3 4 3 2 2 2 3 1 4 4 3 3 4 2 4 2 4 1 3 1 2 3 1 2 1 3 3 1 2 2 4 3 3 2 1 2 1 1 1 2 1 3 4 1 2 1 3 1 4 2 4 2 4 3 3 2 3 4 4 2 3 1 3 4 2 2 1 2 4 2 3 4 2 2 1 2 1 2 2 2 3 3 1 3 2 1 3 3 2 2 3 3 3 3 3 2 2 3 3 3 3 3 2 1 3 1 2 2 1 3 3 1 3 1 1 1 1 3 2 1 3 3 2 3 3 3 3 1 2 2 2 1 1 1 1 1 3 1 2 3 3 3 2 3 1 1 2 3 3 4 4 3 3 1 3 3 1 3 1 3 2 1 2 3 1 4 4 3 2 1 1 3 1 3 3 1 1 3 1 2 3 1 3 2 1 3 4 3 3 3 2 3 2 1 2 1 3 2 3 2 1 3 1 2 4 1 4 1 2 3 1 3 3 4 1 1 1 3 3 3 2 2 1 2 3 3 2 3 1 3 1 3 3 2 2 1 2 1 1 1 3 3 3 3 2 2 3 3 1 2 2 2 2 1 1 1 3 2 1 1 2 2 3 2 1 3 2 3 3 2 3 2 3 2 1 3 2 1 1 2 2 2 3 3 2 1 1 2 2 2 1 3 1 2 2 1 1 3 1 3 4 2 1 2 2 2 1 3 4 4 2 2 2 1 4 1 1 2 4 1 2 3 1 1 1 4 2 4 4 1 1 2 3 3 4 4 4 2 1 3 3 2 1 2 1 1 3 1 2 1 2 2 1 3 2 4 2 3 1 3 3 3 1 2 3 3 3 2 2 2 1 4 4 1 2 3 2 2 3 1 1 2 1 2 2 2 1 1 1 2 1 1 2 2 2 1 3 2 3 3 1 3 1 2 1 2 2 2 2 3 3 3 2 2 1 3 3 2 1 2 2 1 1 1 3 1 1 3 1 3 3 3 3 1 1 3 1 1 2 3 2 3 3 3 2 2 1 2 3 3 3 1 1 1 2 4 2 1 2 4 4 3 2 3 2 4 4 4 4 4 4 4 2 1 4 2 4 2 2 1 1 2 4 3 4 3 4 3 4 3 2 1 4 1 1 2 3 1 2 4 3 2 1 1 1 2 4 1 2 2 2 4 1 3 3 1 4 4 2 1 1 1 4 1 3 3 2 4 2 2 3 1 1 1 3 3 1 2 1 1 2 2 1 1 2 2 3 1 3 1 3 3 1 2 3 1 1 1 2 1 3 3 2 2 1 2 1 3 3 1 3 2 2 3 3 2 2 2 3 3 3 3 3 1 2 2 2 3 3 3 3 1 2 1 2 1 3 1 3 2 1 1 2 1 3 3 1 1 3 3 3 3 1 3 1 2 2 1 4 4 1 3 3 1 4 1 2 3 1 3 3 1 1 1 3 1 4 2 2 4 4 2 1 2 3 4 2 2 2 1 1 3 2 2 3 1 1 4 3 3 3 1 2 4 3 1 2 4 1 2 1 3 3 1 3 2 1 2 2 1 3 1 3 2 3 1 2 3 2 3 1 3 1 2 1 3 3 3 1 2 3 3 1 2 2 2 3 3 1 1 3 3 2 2 3 2 3 2 2 2 1 4 2 3 2 1 2 2 2 2 4 1 2 1 1 1 1 3 3 2 3 2 4 3 2 2 4 4 2 1 3 4 1 3 1 4 3 1 2 2 1 1 er 30 90 90

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Mathematics Questions!

The opportunities and challenges that face the global monetary and capital markets cannot be easily separated. What are your thoughts related to the issues raised in "The Crash" scripts attached and...

help with that please, you can number then a,b,c...as they follow each other Those questions changes with pictures one pictures is one questions and others you realize they are two in one Sort the...

Could you please answer the below two questions? ( only require the answers) 1. What documentation issued by a bank increases a company's checking account balance at the bank? A) An account invoice...

Please see the attached file. There is an instruction file and SGP annual report for use as reference. Also I attached the Powerpoint which is mentioned from the instruction too. MS 6405 Advance...

Unlimited Attempts Allowed Details In this Investigation you will explore an application of exponential functions. The goal of this assignment is to apply the skills you learned in the last unit and...

31. See Table 2.5 showing financial statement data and stock price data for Mydeco Corp. ? a. How did Mydeco?s accounts receivable days change over this period? ? b. How did Mydeco?s inventory days...

The HarrisBenedict equation estimates the number of calories your body needs to maintain your weight if you do no exercise. This is called your basal metabolic rate, or BmR. The formula for the...

In this Investigation you will explore an application of exponential functions. The goal of this assignment is to apply the skills you learned in the last unit and see how exponential functions are...

2 HiMAP Pull-Out Section: Spring/Summer 2005 IN AN 8-OZ CUP OF COFFEE A round the world, people enjoy caffeine in both food and drink. Caffeine is an alkaloid compound that comes from plants,...

Please see the attached file. The question is in the attached file

Swimmingly Corp. buys raw fish, cooks and processes it, and then cans it in single-portion containers. The canned fish is sold to several wholesalers, who specialize in providing food to school lunch...

What type of ion exchange resin and what buffer pH would you use to purify pepsin from an extract of pig cells? (Assume that pepsin should bind to the column resin). Anion exchanger at pH less than 3...

What do we currently know about the gut-brain axis? Group of answer choices The gut-brain axis is supported by the bidirectional relationship between gut disease and psychological morbidity such as...

Oust the Turtle Company has the following balances on December 31, 2020: Cash on hand 4,500.00 Cash in bank A 33,000.00 Cash in bank X 50,000.00 Cash in bank C 822,999.72 Cash on hand includes $ 3....