To answer item 17 to 23, use MS Excel data analysis Consider the following data set, in which a maker of asphalt shingles is interested in the relationship between sales for a particular year and factors that influence sales. X1 - promotional accounts; X3 - Competing brands X2 - Active accounts; X4 - Potential and Y - sales in thousands of $ Which of the four independent variables will give a higher value to sales? Promotional accounts Competing brands Active accounts Potential

MATLAB: An Introduction with Applications
6th Edition
ISBN:9781119256830
Author:Amos Gilat
Publisher:Amos Gilat
Chapter1: Starting With Matlab
Section: Chapter Questions
Problem 1P
icon
Related questions
Question
To answer item 17 to 23, use MS Excel data analysis
Consider the following data set, in which a maker of asphalt shingles is
interested in the relationship between sales for a particular year and
factors that influence sales.
X1 - promotional accounts; X3 - Competing brands
X2 - Active accounts; X4 - Potential and Y - sales in thousands of $
Which of the four independent variables will give a higher value to
sales?
Promotional accounts
Competing brands
Active accounts
Potential
Transcribed Image Text:To answer item 17 to 23, use MS Excel data analysis Consider the following data set, in which a maker of asphalt shingles is interested in the relationship between sales for a particular year and factors that influence sales. X1 - promotional accounts; X3 - Competing brands X2 - Active accounts; X4 - Potential and Y - sales in thousands of $ Which of the four independent variables will give a higher value to sales? Promotional accounts Competing brands Active accounts Potential
X1
5.5
2.5
8
3
3
2.9
8
9
4
6.5
5.5
5
6
5
3.5
X2
31
55
67
50
38
71
30
56
42
73
60
44
50
39
55
X3
10
8
12
7
81212585nn6mm
10
10
X4
8
6
9
16
15
17
8
10
4
16
7
12
6
4
4
Y
79.3
200.1
163.2
200.1
146
177.7
30.9
291.9
160
339.4
159.6
86.3
237.5
107.2
155
Transcribed Image Text:X1 5.5 2.5 8 3 3 2.9 8 9 4 6.5 5.5 5 6 5 3.5 X2 31 55 67 50 38 71 30 56 42 73 60 44 50 39 55 X3 10 8 12 7 81212585nn6mm 10 10 X4 8 6 9 16 15 17 8 10 4 16 7 12 6 4 4 Y 79.3 200.1 163.2 200.1 146 177.7 30.9 291.9 160 339.4 159.6 86.3 237.5 107.2 155
Expert Solution
steps

Step by step

Solved in 2 steps with 2 images

Blurred answer
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
MATLAB: An Introduction with Applications
MATLAB: An Introduction with Applications
Statistics
ISBN:
9781119256830
Author:
Amos Gilat
Publisher:
John Wiley & Sons Inc
Probability and Statistics for Engineering and th…
Probability and Statistics for Engineering and th…
Statistics
ISBN:
9781305251809
Author:
Jay L. Devore
Publisher:
Cengage Learning
Statistics for The Behavioral Sciences (MindTap C…
Statistics for The Behavioral Sciences (MindTap C…
Statistics
ISBN:
9781305504912
Author:
Frederick J Gravetter, Larry B. Wallnau
Publisher:
Cengage Learning
Elementary Statistics: Picturing the World (7th E…
Elementary Statistics: Picturing the World (7th E…
Statistics
ISBN:
9780134683416
Author:
Ron Larson, Betsy Farber
Publisher:
PEARSON
The Basic Practice of Statistics
The Basic Practice of Statistics
Statistics
ISBN:
9781319042578
Author:
David S. Moore, William I. Notz, Michael A. Fligner
Publisher:
W. H. Freeman
Introduction to the Practice of Statistics
Introduction to the Practice of Statistics
Statistics
ISBN:
9781319013387
Author:
David S. Moore, George P. McCabe, Bruce A. Craig
Publisher:
W. H. Freeman