MATH questions (2)

profilembdake
Home>Homework Answsers>Mathematics homework help

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

 

    • 13 years ago
    • 15
    Report issue
    Answer(3)
    profile
    archmage
    4.8 (517)
    4.9 (86)
    Chat

    Purchase the answer to view it

    blurred-text
    NOT RATED
    • attachment
      mathematics.xlsx
    profile
    Sheryl Hogan
    5.0 (5k+)
    5.0 (834)
    Chat

    Purchase the answer to view it

    blurred-text
    NOT RATED
    • attachment
      work_in_excel.xlsx
    profile
    mat185
    3.7 (34)
    5.0 (4)
    Chat

    Purchase the answer to view it

    blurred-text
    NOT RATED
    • attachment
      sta.doc
    Bids(1)