1. Please show relevant Excel output screenshots and include necessary charts/diagrams. 2. Please answer the questions...

  

Transcribed Image Text:

1. Please show relevant Excel output screenshots and include necessary charts/diagrams. 2. Please answer the questions with complete sentences. 3. Please use Excel formula | Data Analysis to verify your results. Question The Excel file Concert Sales provides data on sales dollars and the number of radio, TV, and newspaper ads promoting the concerts for a group of cities. a) Develop simple linear regression models for predicting sales as a function of the number of each type of ad. State each model and explain R-Square, Significance F, and p-values. b) Compare these results to a multiple linear regression model using both independent variables. State each model and explain R-Square, Significance F, and p-values. Sales ($1000) Sales ($1000) $1,119.00 $973.00 $875.00 $625.00 $910.00 $971.00 $931.00 $1,177.00 $882.00 $982.00 $1,628.00 $1,577.00 $1,044.00 $914.00 $1,329.00 $1,330.00 $1,405.00 $1,436.00 $1,521.00 $1,741.00 $1,866.00 $1,717.00 Thousands of Radio&TV ads 0 0 25 25 30 30 35 35 40 40 45 45 50 50 55 55 60 60 65 65 70 70 Thousands of Newspaper ads 40 40 25 25 30 30 35 35 25 25 45 45 50 50 20 20 30 30 351 35 40 40 1. Please show relevant Excel output screenshots and include necessary charts/diagrams. 2. Please answer the questions with complete sentences. 3. Please use Excel formula | Data Analysis to verify your results. Question The Excel file Concert Sales provides data on sales dollars and the number of radio, TV, and newspaper ads promoting the concerts for a group of cities. a) Develop simple linear regression models for predicting sales as a function of the number of each type of ad. State each model and explain R-Square, Significance F, and p-values. b) Compare these results to a multiple linear regression model using both independent variables. State each model and explain R-Square, Significance F, and p-values. Sales ($1000) Sales ($1000) $1,119.00 $973.00 $875.00 $625.00 $910.00 $971.00 $931.00 $1,177.00 $882.00 $982.00 $1,628.00 $1,577.00 $1,044.00 $914.00 $1,329.00 $1,330.00 $1,405.00 $1,436.00 $1,521.00 $1,741.00 $1,866.00 $1,717.00 Thousands of Radio&TV ads 0 0 25 25 30 30 35 35 40 40 45 45 50 50 55 55 60 60 65 65 70 70 Thousands of Newspaper ads 40 40 25 25 30 30 35 35 25 25 45 45 50 50 20 20 30 30 351 35 40 40

Answer rating: 100% (QA)

a Running a simple linear regression for predicting Sales using Radio TV as the predictor From From ... View the full answer