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.
Construct a histogram and a frequency polygon for the following data.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)