Question
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
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started