You are studying the market value of home in Houston. You collect data from the recent sale of 30 single family homes. The data is organized and stored in an Excel file. The dataset includes the fair market value (in $thousands), land area of the property in acres, and age, in years of the 30 homes. Develop a multilinear regression model to predict the fair market value based on land area of the property (in acres) and age, in years.

The name of the Excel data file is HoustonHomes.xlsx. Import the data into SPSS and complete the assignment using SPSS.

1. State the multiple regression equation.

2. Interpret the meaning of the slopes, b1 and b2 , in this problem?

3. Explain why the regression coefficient, b0, has no practical meaning in the context of this problem.

4. Predict the mean fair market value for a house that has a land area of 0.25 acre and is 55 years old?

5. Construct a 95% prediction interval estimate for the fair market value for an individual house that has a land area of 0.25 acre and is 55 years old.

An airline analyzed whether telephone callers to their reservations office would remain on hold longer if they heard (a) an advertisement from the airline or (b) classical music. For 10 callers randomly assigned to these two conditions, the table shows the data.

Question 5:

Choose the correct alternate hypothesis for this test.

a. Ha: The distributions for classical music and advertisements are shifted from each other.

b. Ha: The distribution for classical music is shifted to the left of the distribution for advertisements.

c. Ha: The distribution for classical music is shifted to the right of the distribution for advertisements.

d. Ha: The distributions for classical music and advertisements are the same.

Question 6:

Provide the correct test statistic. Round answer to two decimal places.

Question 7:

Choose the correct p-value.

a. <0.0001

b. 0.0475

c. 0.0029

d. 0.0225

Question 8:

What conclusions can be drawn from this hypothesis test? α = 0.05

a. Fail to reject Ho. Conclude that there is insufficient evidence to claim that the two distributions are not identical.

b. Reject Ho. Conclude that there is sufficient evidence to claim that the distributions are shifted from each other.

c. Reject Ho. Conclude that there is sufficient evidence to claim that the distributions are not identical, and that people wait longer on the phone while listening to airline advertisements rather than classical music.

d. Reject Ho. Conclude that there is sufficient evidence to claim that the distributions are not identical, and that people wait longer on the phone while listening to classical music rather than airline advertisements.

1) Melissa works as a biller for a small medical company and has just received her paycheck.

Her gross earnings were: 4300, with $900 deducted for Federal & State taxes, $175 deducted for medical insurance premiums, and $50 for disability insurance.

What is Melissa’s disposable income? ______________________

What is Melissa’s discretionary Income? ______________________

2) Using the information in questions 2, if Melissa also paid $1000 in rent, $100 for electric & gas, $50 in groceries, $150 for two pairs of shoes, and $50 on a video game as a gift for her boyfriend’s birthday, and left the rest in her savings account.

What is Melissa’s discretionary income? ________________________

How much does Melissa have left in discretionary income after paying her expenses? __________________

3) The amount of money loaned (whether it be the bank lending you money for a mortgage or you buying a bond) is called: ______________________

4) Bank of NY is short 20 million to meet its reserve requirement. To cover, Bank of NY borrows the money from Chase bank at what type of interest rate? ____________________________________

5) When a consumer gets a loan from a bank, the benchmark interest rate charged to them is called the ___________________________ rate.

6) Mohammed and Vanessa are both taking out student loans to complete their Ph. D in Business. They both go to TD Bank to apply for a loan. Mohammed has a credit rating of 800, while Vanessa has a credit rating of 650. Who would get the lower interest rate? _________________ Why? _____________________________________________________________________________________

7) Madalena borrows $300,000 from TD Bank at an annual interest rate of 8%. What is the amount of interest she will pay per year??

8) Jose has a 25,000 loan with a 5% annual interest rate, with a payment due April 1 st. What is the interest amount due on the loan?

An experiment was conducted to test the effect of a new drug on a viral infection. After the infection was induced in 100 mice, the mice were randomly split into two groups of 50. The first group, the control group, received no treatment for the infection, and the second group received the drug. After a 30-day period, the proportions of survivors, p̂₁ and p̂₂, in the two groups were found to be 0.4 and 0.60, respectively.

Find the test statistic and rejection region. (Round your answers to two decimal places. If the test is one-tailed, enter NONE for the unused region.

z = ?? (please do not use (p1-p2) / SE as it does not work. I have tried this multiple times)

z < = -1.65

z > = NONE

(b) Use a 95% confidence interval to estimate the actual difference (p₁ − p₂) in the survival rates for the treated versus the control groups. (Round your answers to two decimal places.)

Cushing Corporation is considering the purchase of a new grading machine to replace the existing one. The existing machine was purchased 4 years ago at an installed cost of $ 20 comma 300​; it was being depreciated under MACRS using a​ 5-year recovery period.​ (See table LOADING... for the applicable depreciation​ percentages.) The existing machine is expected to have a usable life of at least 5 more years. The new machine costs $ 35 comma 400 and requires $ 4 comma 500 in installation​ costs; it will be depreciated using a​ 5-year recovery period under MACRS. The existing machine can currently be sold for $ 25 comma 100 without incurring any removal or cleanup costs. The firm is subject to a 40 % tax rate. Calculate the initial investment associated with the proposed purchase of a new grading machine.

Rounded Depreciation Percentages by Recovery Year Using MACRS for
First Four Property Classes              
   Percentage by recovery year*          
Recovery year    3 years    5 years    7 years    10 years
1    33%   20%   14%   10%
2    45%   32%   25%   18%
3    15%   19%   18%   14%
4    7%   12%   12%   12%
5        12%   9%   9%
6        5%   9%   8%
7            9%   7%
8            4%   6%
9                6%
10                6%
11                4%
Totals   100%   100%   100%   100%
              

P11–13 Initial investment at various sale prices Ed Mann, sole owner of Edward Mann Consulting (EMC) is replacing one machine with another. The old machine was purchased 3 years ago for an installed cost of $10,000. The firm is depreciating the machine under MACRS, using a 5-year recovery period (see Table 4.2). The new machine costs $24,000 and requires $2,000 in installation costs. The firm is subject to a 40% tax rate. In each of the following cases, calculate the initial investment for the replacement.

Table 4.2

Rounded Depreciation Percentages by Recovery Year Using MACRS for First Four Property Classes

1. EMC sells the old machine for $11,000.
2. EMC sells the old machine for $7,000.
3. EMC sells the old machine for $2,900.
4. EMC sells the old machine for $1,500.

I don't have a finance calculator. I have the TI84 PLus, please show work . thanks.

Question 7 (1 point)

A survey asked subjects, "Should the government increase its spending on health?" 317 of those 340 who responded said "yes."

Test, at level 0.05, that the majority of people in the population would say "yes" to the survey question.

The test is

Question 7 options:

Question 8 (1 point)

A survey asked subjects, "Should the government increase its spending on health?" 317 of those 340 who responded said "yes."

Test, at level 0.05, that the majority of people in the population would say "yes" to the survey question.

The p-value is

Question 8 options:

Question 9 (1 point)

A survey asked subjects, "Should the government increase its spending on health?" 317 of those 340 who responded said "yes."

Test, at level 0.05, that the majority of people in the population would say "yes" to the survey question.

The conclusion of the test is

Question 9 options:

Question 10 (1 point)

A survey asked people who work full time, "How do you spend your time on a typical day?" 74% of 733 women and 55% of 1219 men reported spending some time on cooking and washing up.

What is a 95% confidence interval for the difference between the proportion of women and the proportion of men who spend some time on cooking and washing up during a typical day?

Question 10 options:

Question 11 (1 point)

A survey asked people who work full time, "How do you spend your time on a typical day?" 74% of 733 women and 55% of 1219 men reported spending some time on cooking and washing up.

Test, at significance level 0.05, that the proportion of women is greater than the proportion of men who spend some time on cooking and washing up during a typical day.

The test is

Question 11 options:

Question 12 (1 point)

A survey asked people who work full time, "How do you spend your time on a typical day?" 74% of 733 women and 55% of 1219 men reported spending some time on cooking and washing up.

Test, at significance level 0.05, that the proportion of women is greater than the proportion of men who spend some time on cooking and washing up during a typical day.

The p-value is

Question 12 options:

Question 13 (1 point)

A survey asked people who work full time, "How do you spend your time on a typical day?" 74% of 733 women and 55% of 1219 men reported spending some time on cooking and washing up.

Test, at significance level 0.05, that the proportion of women is greater than the proportion of men who spend some time on cooking and washing up during a typical day.

We can conclude that

Question 13 options:

The accompanying data shows the weekly purchases of printers at a particular electronic store. Using α = ​0.05, perform a​ chi-square test to determine if the number of printers sold per week follows a normal probability distribution. Note that x = 11.3 and s = 4.6.

Use the intervals below to calculate the​ chi-square test​ statistic, χ2

Calculate the test statistic

χ2 =

​(Round to two decimal places as​ needed.)

Determine the​ p-value.

​p-value =

​(Round to three decimal places as​ needed.)

1. There is ongoing debate among U.S. policymakers whether the role the government in the healthcare system should be expanded or reduced

Which of the following are the arguments put forward by those who would like to see a reduced government role? Check all that apply

a) Private insurers and providers should compete for consumers

b) Private insurance companies put profit ahead of people

c) The government is to offer people a public option in the healthcare

d) The government is to offer people a single payer system financed out of tax revenue

2. Both sides of the policy debate over healthcare often point to Canada, where the government runs the healthcare system, financed mostly by taxes.

Which of the following are the features of the Canadian centralized system considered by those in favor of a reduced government role? Check all that apply.

a) Lower costs

b) Excessively ration care

c) Reduced administrative inefficiency

d) Limited individual freedom