Question

In: Statistics and Probability

Following is an extract from the database of a construction company. The table shows the height...

Following is an extract from the database of a construction company. The table shows the height of walls in feet and the cost of raising them. The estimated simple linear regression equation is given as Ŷ = b0 + b1X. (Hint: Use Excel functions).

Height (ft)

Cost ($)

4

670

3

430

7

810

9

1100

6

790

8

880

5

760

11

1200

1) What is the value of the coefficient b1?

A) 254.8371

B) 0.010697

C) -2.14625

D) 86.81704

2) What is the estimated cost of raising a 10 foot wall?

A) 1123.008

B) 1505.786

C) 1103.578

D) 968.6109

Solutions

Expert Solution


Related Solutions

The following table shows the distribution of height of a group of redwood trees found in...
The following table shows the distribution of height of a group of redwood trees found in USA height (in feet) no of redwood trees 179-182 5 183-186 7 187-190 15 191-194 10 195-198 6 199-202 7 203-206 6 a. Compute the mean height, median height and standard deviation. b. Compute first quartile, third quartile and interquartile range c. Draw box plot
The following extract appeared in the financial statements of Sihle Limited: Sihle Limited Extract from the...
The following extract appeared in the financial statements of Sihle Limited: Sihle Limited Extract from the Statement of Comprehensive Income for the year ended 31 December 2019: R Sales 4 140 000 Cost of sales (3 490 000) Opening inventory 710 000 Purchases 3 630 000 Gross profit 650 000 Operating expenses (429 000) Operating profit 221 000 Interest  expense (35 000) Profit before tax 186 000 Taxation (52 800) Profit after tax 133 200 Additional information: Dividends paid during the...
The database for a pet supply company includes the following table, named tblCollar, that contains product...
The database for a pet supply company includes the following table, named tblCollar, that contains product data for pet collars. The ItemDesc and Color fields contain text. The ItemNum, Price, and Quantity fields contain numbers. ItemNum ItemDesc Color Price Quantity 2358 leather studded collar black 30.00 35 2693 leather collar brown 25.00 25 3547 striped collar red 20.00 75 3855 striped collar blue 15.00 42 3764 striped collar green 15.00 48 5782 solid collar pink 12.00 36 5785 solid collar...
​​​​​ The following table shows the accounts from The Mockers Ltd for the year ended 31...
​​​​​ The following table shows the accounts from The Mockers Ltd for the year ended 31 March 2017. Required: Prepare a Statement of Changes in Owners’ Equity Prepare a Balance Sheet. Other information is: The repayment terms for the mortgage: payments of $1,000 are due on the 1 December each year. The profit for the year was $11,000 after tax.                                                                                                 Account $ Accounts payable 5,750 Accounts receivable 8,250 Accumulated depreciation 11,250 Cash 2,250 Selling and Administration expense 18,500 Depreciation...
You are responsible for developing a supervisory training programme for a company. The following table shows...
You are responsible for developing a supervisory training programme for a company. The following table shows the relationships between the activities that must be completed, along with estimates of the durations in days. Table 1: Activity Times and Predecessors Activity Immediate Predecessors Optimistic Time (a) Most Likely time (m) Pessimistic Time (b) A - 3 7 13 B - 5 10 17 C A,B 3 5 8 D C 5 12 14 E C 2 5 9 F E 2...
A Company manufactures and sells two products: A and B. The following table shows the information...
A Company manufactures and sells two products: A and B. The following table shows the information relating to these products: A B Total Selling price per unit $20 $40 Variable cost per unit $10 $20 Total Fixed costs $80,000 Required: If Sales mix is 2 :3 for A and B respectively, calculate the breakeven point in units and in dollars for each of the two products.
The following table is a non-normalized table for a Rental Property Management Database.  Data is included to...
The following table is a non-normalized table for a Rental Property Management Database.  Data is included to help you to perform the normalization.  One client may have multiple rental records. Identify the functional dependencies and normalize the table to 1NF, 2NF, and 3NF respectively. You also need to show the steps to reach normal form and populate each relation with sample data. As a result, you can see that duplicate data will be removed through the normalization process. CLIENT_RENTAL ClientNo ClientName PropertyNo...
Following table shows the initial investment required in and cash flow (return) from a project
Following table shows the initial investment required in and cash flow (return) from a project: The expected payback period from the project is 2 years and the discount rate is 14%. Based on the Discounted Payback Period, will you accept the project?
The following table shows the hot dogs bought from a street vendor over the course of...
The following table shows the hot dogs bought from a street vendor over the course of eight days​ ("Demand"). Also shown is the temperature for each day in degrees Celsius. Temperature °C 21 9 22 20 5 12 20 19 Demand 47 30 35 39 19 21 44 33 A linear regression on the data gives the equation below. Complete parts a through d below. Predicted Demand=12.78+1.30(Temperature) a. Calculate the SST. SST=? ​(Round to two decimal places as​ needed.) b....
The following table shows the forecasted operating results for Halong Cruises, Inc., from the purchase of...
The following table shows the forecasted operating results for Halong Cruises, Inc., from the purchase of a new luxury yacht. The company has a cost of capital of 12%. Year ($ million) 0 1 2 3 4 Investment –$ 345 Operating cash flow $ 177 $ 225 $ 240 $ 255 Working capital $ 78 $ 93 $ 98 $ 83 $ 0 Salvage cash flow $ 70 a. What are the cash flows in each year of operations? Year...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT