Question

In: Statistics and Probability

The manager has decided to look at other factors related to each person’s sales. Below is...

The manager has decided to look at other factors related to each person’s sales. Below is the new sales data with multiple factors (i.e. hours, quarterly bonus, and a percentage discount given to customers). Answer the two bullet point below.

Sales ($ thousands)

Hours spent with customers

Quarterly Bonus ($)

Discount Given to Customer

(%)

412

3.2

100

5

500

4.6

150

3

450

3.9

95

12

610

5.3

300

5

715

6.1

575

2

500

4.2

167

5

610

5.6

290

10

600

5.3

300

7

570

5.1

195

30

800

7.1

500

17

725

6.5

500

25

850

7.8

525

10

  • Run regression analysis using excel with the data from the above table. Paste the regression output below and upload the excel file with your submission.

  • Which factors are good predictors of sales? Write a short paragraph explaining your answer.

Solutions

Expert Solution



Related Solutions

(All the questions below are related to each other) You buy an asset with a purchase...
(All the questions below are related to each other) You buy an asset with a purchase price of $7,000 and your shipping is $500. It has a 3 year class life. Show a depreciation schedule below that includes both the depreciation each year and the book value each year. If the working capital changes in number 1 are a negative $300 show the depreciation schedule. What is the net working capital change? Accounts receivable increase by $1,000; inventory increases by...
Answer all parts below, which are related to each other. A. Ammonia (NH3(aq)) is a common...
Answer all parts below, which are related to each other. A. Ammonia (NH3(aq)) is a common component in cleaning agents. The ammonium cation (NH4+(aq)) has a Ka = 1.8 x 10-10. A chemist titrates 100.0 mL of an ammonia solution of 0.20 M concentration with 0.240 M HCl(aq). For this part, what is the pH at the equivalence point (circle the correct answer): pH > 7.00 pH = 7.00 pH < 7.00 B. Calculate the pH when 40.0 mL of...
How are cognitive processes related to each other
How are cognitive processes related to each other
Discuss how to manage cultural risks and other factors related to a foreign operation of a...
Discuss how to manage cultural risks and other factors related to a foreign operation of a multinational business. Is cultural, business, or political risk more challenging to overcome than one of the others? Why or why not? How should American standards influence multinational businesses?
In 175 words or more, explain how to manage cultural risks and other factors related to...
In 175 words or more, explain how to manage cultural risks and other factors related to a foreign operation of a multinational business. Is cultural, business, or political risk more challenging to overcome than one of the others? Why or why not? How should American standards influence multinational businesses? Thanks in advance
You are an invesment manager and your client, Marge, has decided to trust you to manager...
You are an invesment manager and your client, Marge, has decided to trust you to manager her complete portfolio. You offer Marge a risky investment in your expertly crafted mutual fund as well as a risk free investment in Treasury bills. Your mutual fund's expected return is 14% and its standard deviation is 38%. The T-bill rate is 5%. Marge thinks it over and decides to invest 85% of her money in your mutual fund and 15% in T-bills. a....
Other factors being constant, NPV of an international project is__ related to consumer demand and __ related to the project's salvage value.
Other factors being constant, NPV of an international project is__ related to consumer demand and __ related to the project's salvage value.a.positively; positivelyb.positively; negativelyc.negatively; positivelyd.negatively; negatively
are the factors that impact the equilibrium of exhange rates independent of each other?
are the factors that impact the equilibrium of exhange rates independent of each other?
The following situations are independent of each other and related to the activities and events of...
The following situations are independent of each other and related to the activities and events of Global Berhad in the year 2018. The financial year end for the company is 31 December. (i) In the past, the company expensed borrowing costs on construction of its factory. The company has changed its policy this year and now capitalises as it is incurred. In 2017 accounts, borrowing costs expensed was RM2,500,000 and this year’s borrowing costs incurred was RM3,800,000. The factory is...
As manager of the St. Cloud Theatre​ Company, you have decided that concession sales will support...
As manager of the St. Cloud Theatre​ Company, you have decided that concession sales will support themselves. The following table provides the information you have been able to put together thus​ far: Item                Selling Price               Variable Cost             % of Revenue Soft Drink       $1.20                          $0.60                          26 Wine               $1.80                          $0.95                          26 Coffee             $1.00                          $0.35                          29 Candy             $1.00                          $0.35                        19 Last year�s manager, Jim Freeland, has advised you to be sure to add 10% of variable cost as a waste allowance for all...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT