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
Report DMCA
TutorRating
pallavi

Chat Now!

out of 1971 reviews
More..
amosmm

Chat Now!

out of 766 reviews
More..
PhyzKyd

Chat Now!

out of 1164 reviews
More..
rajdeep77

Chat Now!

out of 721 reviews
More..
sctys

Chat Now!

out of 1600 reviews
More..
sharadgreen

Chat Now!

out of 770 reviews
More..
topnotcher

Chat Now!

out of 766 reviews
More..
XXXIAO

Chat Now!

out of 680 reviews
More..
All Rights Reserved. Copyright by AceMyHW.com - Copyright Policy