MATH questions (2)

profilembdake

Use Excel to answer the following questions.

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

 

    • Posted: 6 years ago
    • Due: 
    • Budget: $15
    Answers 3

    Purchase the answer to view it

    blurred-text

    Purchase the answer to view it

    blurred-text

    Purchase the answer to view it

    blurred-text