# MATH questions (2)

mbdake

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

Purchase the answer to view it

Purchase the answer to view it

Purchase the answer to view it

• Not rated

# MBA 501: Module 7 Homework

Notes

Use Excel to answer the following questions. Copy and paste your Excel tables and graphs to this document and submit everything in one …

• Not rated

### Notes Use Excel to answer the following questions. Copy and paste your Excel tables and graphs to this

Notes

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 …