notesUse Excel to answer the following questions. Copy and paste your Excel
Question
NotesUse 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) |
| 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 |
See attached file
Looking for a Similar Assignment? Order now and Get 10% Discount! Use Coupon Code "Newclient"
