Use Excel to answer the following questions. Copy and paste your Excel tables and graphs to this document and submit everything in one word file.
1. Construct a histogram and a frequency polygon for the following data.
|
Class Interval
|
Frequency
|
|
30-under 32
|
5
|
|
32-under 34
|
7
|
|
34-under 36
|
15
|
|
36-under 38
|
21
|
|
38-under 40
|
34
|
|
40-under 42
|
24
|
|
42-under 44
|
17
|
|
44-under 46
|
8
|
2. Are the advertising dollars spent by a company related to total sales revenue? The following data represent the advertising dollars and the sales revenues for various companies in a given industry during a recent year. Construct a scatter plot of the data from the two variables and discuss the relationship between the two variables.
|
Advertising (in $millions)
|
Sales (in $millions)
|
|
4.2
|
155.7
|
|
1.6
|
87.3
|
|
6.3
|
135.6
|
|
2.7
|
99.0
|
|
10.4
|
168.2
|
|
7.1
|
136.9
|
|
5.5
|
101.4
|
|
8.3
|
158.2
|