Using the accompanying Concert Sales data on sales dollars

Last updated: 7/20/2023

Using the accompanying Concert Sales data on sales dollars and the number of radio TV and newspaper ads promoting the concerts for a group of cities Develop simple linear regression models for predicting sales as a function of the number of each type of ad Compare these results to a multiple linear regression model using both independent variables State the model and explain R square Significance F and p values with an alpha of 0 05 Click the icon to view the Concert Sales data State the hypotheses for the simple linear regression tests Ho B 0 H B 0 State the model predicting ConcertSales as a function of Radio TV the number in thousands of radio and TV ads Concertsales Radio TV Type integers or decimals rounded to three decimal places as needed 1 Sales 1000 2 3 4 5 6 7 8 9 10 11 12 13 HELT Bg 14 15 16 17 18 19 20 21 22 23 24 1064 997 919 626 869 950 946 1199 881 1011 1614 1562 1067 934 1395 1336 1401 1496 1561 1715 1774 1786 Thousands of radio and TV ads 0 0 25 25 32 30 34 33 38 41 47 43 48 48 53 54 62 62 68 64 70 68 Thousands of newspaper ads 39 41 26 25 29 30 34 33 25 24 45 47 48 52 20 21 32 32 33 33 39 42 D