Are the advertising dollars spent by a company related to


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

Solution Preview :

Prepared by a verified Expert
Basic Statistics: Are the advertising dollars spent by a company related to
Reference No:- TGS01216439

Now Priced at $30 (50% Discount)

Recommended (97%)

Rated (4.9/5)