Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

You are responsible for laptop marketing in a technology company that sells multiple products including laptops, tablets, and smart phones. You suspect that tablet, and

You are responsible for laptop marketing in a technology company that sells multiple products including laptops, tablets, and smart phones. You suspect that tablet, and maybe even smart phone sales are cannibalizing laptop sales.

You were able to recover historical pricing information of tablets and smart phone and youve tabulated that data next to your promotion data as indicated below. Using a linear regression on the data, with which products does your laptop compete? (You can Copy and Paste the following table into an Excel spreadsheet.)

-----------------------------------------------------------------------

Promo Advertising Laptop price Competitors Price Tablet Price Smart Phone Cost Laptop Sales
1 $566,000 $949.90 $949.90 $669.31 $395.25 $31,573,575.00
2 $479,000 $999.50 $919.50 $675.35 $342.65 $25,706,905.60
3 $387,000 $949.90 $909.90 $658.17 $342.01 $25,925,936.74
4 $450,000 $959.50 $939.50 $607.87 $354.72 $26,764,715.85
5 $556,000 $969.50 $959.50 $662.21 $382.31 $30,582,947.78
6 $377,000 $909.90 $939.90 $644.95 $302.90 $28,482,132.59
7 $560,000 $919.90 $979.50 $610.00 $397.12 $33,035,821.67
8 $490,000 $969.90 $969.90 $670.53 $381.64 $30,288,367.15
9 $468,000 $979.90 $989.50 $697.95 $305.05 $30,028,024.77
10 $418,000 $969.90 $979.50 $626.88 $330.82 $27,970,713.01
11 $529,000 $939.90 $979.50 $614.28 $389.96 $31,573,325.26
12 $467,000 $969.50 $949.90 $651.07 $386.92 $28,529,106.21
13 $505,000 $949.90 $969.90 $696.99 $393.73 $32,279,447.08
14 $561,000 $989.90 $979.50 $696.96 $347.40 $30,930,369.85
15 $532,000 $919.90 $959.90 $677.80 $302.31 $32,003,013.64
16 $494,000 $969.50 $919.50 $613.88 $351.06 $26,056,098.32
17 $582,000 $989.90 $919.90 $672.36 $374.32 $28,070,460.18
18 $544,000 $909.50 $959.50 $660.82 $334.64 $32,753,676.90
19 $479,000 $969.90 $959.50 $624.17 $348.54 $28,059,305.80
20 $547,000 $949.90 $939.50 $695.83 $389.92 $31,349,320.67
21 $554,000 $899.50 $909.50 $638.72 $399.53 $31,179,336.99
22 $468,000 $929.50 $969.50 $638.45 $321.38 $30,414,727.61
23 $566,000 $939.50 $919.90 $692.70 $352.42 $30,574,464.89
24 $466,000 $919.50 $969.50 $675.76 $384.66 $32,583,636.82
25 $457,000 $939.50 $909.90 $687.73 $329.24 $28,057,780.90
26 $617,000 $929.50 $949.50 $667.16 $377.91 $33,069,001.13
27 $533,000 $929.90 $979.90 $622.23 $321.71 $31,447,855.27
28 $481,000 $919.50 $909.50 $644.90 $338.68 $28,458,273.52
29 $612,000 $929.50 $929.90 $698.15 $329.85 $32,110,126.68
30 $623,000 $949.90 $919.90 $619.30 $338.16 $28,955,339.62
31 $434,000 $929.90 $979.50 $687.58 $320.32 $31,560,759.95
32 $475,000 $919.50 $909.90 $694.34 $352.13 $29,805,304.68
33 $502,000 $989.50 $959.50 $622.03 $374.83 $27,706,275.90
34 $609,000 $899.50 $929.90 $632.89 $328.37 $31,982,078.58
35 $366,000 $909.90 $969.50 $653.22 $336.58 $30,392,576.34
36 $542,000 $939.90 $929.50 $608.33 $375.89 $28,919,121.82
37 $582,000 $989.90 $919.90 $672.36 $374.32 $28,059,305.80
38 $544,000 $909.50 $959.50 $660.82 $334.64 $31,349,320.67
39 $479,000 $969.90 $959.50 $624.17 $348.54 $28,070,460.20
40 $547,000 $949.90 $939.50 $695.83 $389.92 $32,753,652.49

Question 18 options:

Competitor's laptop.

Our tablets.

Our smart phones

Competitor's laptop and our tables, but not our smart phones.

Competitor's laptop, our tables, and our smart phones.

Please select the best answer from the options

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Students also viewed these Accounting questions