# Project #53437 - Graphs

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

1. 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

 Subject Mathematics Due By (Pacific Time) 01/11/2015 03:00 pm
TutorRating
pallavi

Chat Now!

out of 1971 reviews
amosmm

Chat Now!

out of 766 reviews
PhyzKyd

Chat Now!

out of 1164 reviews
rajdeep77

Chat Now!

out of 721 reviews
sctys

Chat Now!

out of 1600 reviews

Chat Now!

out of 770 reviews
topnotcher

Chat Now!

out of 766 reviews
XXXIAO

Chat Now!

out of 680 reviews