For Part 1, to get the full points: the frequency polygon and the histogram must be shown on the same graph; the frequency polygon must begin and end at zero; there must be no spaces between the histogram bars yet the bars must be distinct from each other (you could use a different color border for the histogram bar borders to make sure that they are distinct). For Part 2, to get the full points you should: construct a valid scatter plot where one coordinate of the point is the advertising spend and the second coordinate is the associated sales; include the line of the best fit (also known as the regression line); correctly identify the relationship and its direction, and differentiate between correlation and causation; offer a possible explanation that underlies the relationship. 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 histogram and a frequency polygon for the following data. Class Interval 30-under 32 7 34-under 36 15 36-under 38 21 38-under 40 34 40-under 42 24 42-under 44 17 44-under 46 1 5 32-under 34 MBA 501: Module 7 Frequency 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) 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 2 Sales (in $millions) 158.2 MBA 501: Module 7