Use Excel to answer the following questions.1. Construct a histogram and a frequ

Use Excel to answer the following questions.1. Construct a histogram and a frequency polygon for the following data.Class IntervalFrequency30-under 32532-under 34734-under 361536-under 382138-under 403440-under 422442-under 441744-under 4682. 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.2155.71.687.36.3135.62.799.010.4168.27.1136.95.5101.48.3158.2