Question: This is a small sample of the data from the question but how would I solve these questions using formulas from excel. Primary Question: Is

This is a small sample of the data from the question but how would I solve these questions using formulas from excel.

Primary Question: Is there a relationship between Occupied By and City (are they independent of each other)? a. Create a Contingency Table b. Perform a hypothesis test regarding the relationship. Use = 0.01 (Be sure to include your hypothesis statements and results in your report) c. Summarize your finding in 1-2 sentences and answer the primary question.

\begin{tabular}{|c|c|c|c|c|c|c|c|c|c|c|c|c|c|c|} \hline & A & B & C & D & E & F & G & H & 1 & J & K & L & M & N \\ \hline 1 & Type & Price & \begin{tabular}{l} Days on \\ Market \end{tabular} & Apx SqFt & \# Acres & Year Built & Age & \# Beds & \# Baths & Asking Price & City & \begin{tabular}{c} Irrigation \\ District (Y/N) \end{tabular} & \begin{tabular}{c} Occupied \\ By \end{tabular} & Listing Date \\ \hline 2 & Single Family w/ Acreage & $1,170,000 & 40 & 3152 & 1.35 & 1992 & 31 & 4 & 3 & $1,275,000 & Eagle & Yes & Vacant & 4/21/2023 \\ \hline 3 & Condo & $1,125,000 & 6 & 2037 & 0 & 2017 & 5 & 2 & 2.5 & $1,089,000 & Boise & No & Owner & 1/4/2022 \\ \hline 4 & Townhouse & $388,900 & 7 & 1546 & 0.1 & 2001 & 21 & 3 & 2.5 & $399,900 & Boise & No & Owner & 1/7/2022 \\ \hline 5 & Mobile/Manu Owned Lot & $169,000 & 13 & 1344 & 0.106 & 1970 & 52 & 3 & 1.5 & $169,000 & Boise & No & Owner & 1/15/2022 \\ \hline 6 & Townhouse & $384,900 & 6 & 1549 & 0.1 & 1980 & 42 & 3 & 2 & $384,900 & Meridian & No & Owner & 1/15/2022 \\ \hline 7 & Condo & $770,100 & 3 & 1493 & 0 & 2017 & 5 & 1 & 2 & $725,000 & Boise & No & Owner & 1/26/2022 \\ \hline 8 & Condo & $385,000 & 4 & 1505 & 0 & 1989 & 33 & 3 & 2 & $359,900 & Boise & Yes & Owner & 1/27/2022 \\ \hline 9 & Single Family w/ Acreage & $575,000 & 2 & 2184 & 1 & 1974 & 48 & 4 & 2 & $575,000 & Boise & Yes & Tenant & 1/28/2022 \\ \hline 10 & Townhouse & $315,000 & 1 & 1160 & 0.06 & 1980 & 42 & 2 & 1.5 & $315,000 & Boise & Yes & Tenant & 1/31/2022 \\ \hline 11 & Condo & $320,000 & 5 & 823 & 0 & 1989 & 33 & 2 & 2 & $335,000 & Boise & No & Owner & 2/4/2022 \\ \hline 12 & Townhouse & $379,000 & 13 & 1397 & 0.06 & 1999 & 23 & 3 & 2.5 & $379,000 & Boise & No & Tenant & 2/8/2022 \\ \hline 13 & Townhouse & $399,000 & 4 & 1314 & 0.07 & 1997 & 25 & 2 & 2 & $399,000 & Boise & Yes & Owner & 2/14/2022 \\ \hline 14 & Single Family & $855,000 & 58 & 3255 & 0.24 & 2004 & 18 & 4 & 2.5 & $865,900 & Eagle & Yes & Tenant & 2/14/2022 \\ \hline 15 & Condo & $1,000,000 & 0 & 1189 & 0 & 2009 & 13 & 2 & 2 & $1,000,000 & Boise & No & Owner & 2/16/2022 \\ \hline 16 & Condo & $290,000 & 3 & 538 & 0 & 1947 & 75 & 1 & 1 & $244,900 & Boise & No & Owner & 2/17/2022 \\ \hline 17 & Condo & $549,000 & 0 & 1006 & 0 & 1983 & 39 & 2 & 1.5 & $550,000 & Boise & No & Owner & 2/18/2022 \\ \hline 18 & Condo & $286,000 & 6 & 954 & 0 & 1977 & 45 & 2 & 1.5 & $292,000 & Boise & No & Owner & 3/1/2022 \\ \hline 19 & Single Family & $1,099,999 & 0 & 3223 & 0.14 & 1890 & 132 & 5 & 3 & $1,099,999 & Boise & No & Tenant & 3/2/2022 \\ \hline 20 & Townhouse & $525,000 & 0 & 1350 & 0.02 & 2019 & 3 & 2 & 2 & $525,000 & \multicolumn{2}{|c|}{ Garden Cit Yes } & Tenant & 3/2/2022 \\ \hline 21 & Townhouse & $420,000 & 14 & 1601 & 0.05 & 2019 & 3 & 3 & 2.5 & $429,900 & Boise & No & Tenant & 3/4/2022 \\ \hline 22 & Townhouse & $445,000 & 3 & 1738 & 0.098 & 2016 & 6 & 3 & 2.5 & $444,990 & Boise & Yes & Tenant & 3/4/2022 \\ \hline 23 & Single Family & $265,000 & 4 & 1053 & 0.14 & 1961 & 61 & 2 & 1 & $255,000 & Boise & No & Vacant & 3/7/2022 \\ \hline 24 & Townhouse & $400,000 & 0 & 1414 & 0.06 & 1996 & 26 & 3 & 2.5 & $400,000 & Boise & Yes & Owner & 3/10/2022 \\ \hline 25 & Townhouse & $385,000 & 19 & 1108 & 0.012 & 1996 & 26 & 3 & 1.5 & $395,000 & Meridian & No & Tenant & 3/11/2022 \\ \hline 26 & Condo & $295,000 & 2 & 794 & 0 & 1982 & 40 & 1 & 1 & $295,000 & Boise & No & Owner & 3/15/2022 \\ \hline 27 & Townhouse & $309,000 & 7 & 904 & 0.06 & 1975 & 47 & 2 & 1 & $327,000 & Boise & Yes & Tenant & 3/18/2022 \\ \hline 28 & Condo & $529,900 & 7 & 1778 & 0 & 2007 & 15 & 2 & 2 & $529,900 & Boise & No & Owner & 3/21/2022 \\ \hline 29 & Townhouse & $449,500 & 12 & 1668 & 0.061 & 2019 & 3 & 3 & 2.5 & $465,000 & \multicolumn{2}{|c|}{ Garden Cit No } & Tenant & 3/21/2022 \\ \hline 30 & Single Family w/ Acreage & $1,480,000 & 41 & 4122 & 5 & 1995 & 27 & 4 & 3.5 & $1,499,000 & Eagle & Yes & Tenant & 3/22/2022 \\ \hline 31 & Townhouse & $600,000 & 5 & 1775 & 0 & 2021 & 1 & 3 & 2.5 & $594,000 & Boise & No & Tenant & 3/23/2022 \\ \hline \end{tabular}

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 Finance Questions!

For this part of the project and based on the class sample, you will create a 95% confidence interval for the mean age and the proportion of males in the population of all online college students....

Can someone review my work? I need help distinguishing the meaning of my calculations ... The purpose of this report will determine whether the region of New England's housing prices and square...

Research Topic : Danger of mobile phone on young generation I gave you sample you need to follow these format to write these research these images are sample you need to follow these format to write...

ECON 225 Final ProjectFor this final project, you will need to work through the following 5 questions using Microsoft Excel and submit a file with your responses to each individual question. Download...

Please help me solve this (use excel and show formulas), " Develop an S&OP with the level strategy using overtime, undertime, and vacations as the only supply options. Use the maximum amount of...

please solbe using EXCEL and explain step by step your formulas and data pack tooks used 3. [30 points Be prepared it is a long story. In the last class meeting of a "BORING" course, you were...

please solve both questions using formulas no excel please!!! reminder there is two parts in this picture and i am in need of both questions please! QUESTION 4 Compute the Book value of an asset att...

please solve both questions using formulas no excel please!!! reminder there is two parts in this picture and i am in need of both quesrions please! STRAIGHTLINE QUESTION 1 Calculate the depreciation...

Please write the selecting tools and approaches (according to the subject R esearch Method ) for this topic SECOND LANGUAGE ACQUISITION: LEVEL OF INTEREST IN LEARNING MANDARIN CHINESE LANGUAGE AS A...

In this assignment , you will examine what happens when different sample sizes are used to once ? What if you rolled the die 10 times or 100 times ? You will be given a data file that contains the...

Your firm will be importing a large order of its inputs from the United States in six months and is concerned that the Canadian dollar might fall against the U.S. dollar over that time. To hedge your...

In which reporter are federal district court decisions reported?

The first image are the problem and questions. The second image is the questions with the correct answers. Can I get help using an excel sheet to get to these answers? The answers below are the...

You need to choose Company ABCs company vehicle. You have two options: Audi or Acura. Once purchased, assume Company ABC keeps purchasing the same type of vehicle as soon as the useful life is over....