regression analysis 23

  • The dataset Concert Sales provides data on sales in dollars and the number of radio, TV, and newspaper ads promoting the concerts for a group of cities.
    • Develop a multiple regression model using the number of radio and TV ads and newspaper ads as the explanatory variables and sales as the response variable. Report the estimated regression equation
    • Use the model to predict the sales if the number of Radio and TV ads is 20 thousand and the number of Newspaper ads is 55 thousand. (Include your Excel work)
  • Use the dataset Cost of Living Adjustments to find a multiple regression model to predict the salary as a function of all five of the adjusted cost of living rates.
    • Interpret the slope coefficient for the Housing rate in context.
    • Interpret the adjusted R2 value and the standard error of the estimate value in context.
  • The dataset Cameras lists a sample of cameras variables and their consumer report scores. Recode Brand as a dummy variable with 1 = Nikon and 0 = Canon.
    a) Develop a multiple regression model predicting the consumer report score based off the camera’s brand, weight, price, and megapixels. Report the estimated regression equation.
    b) Interpret the coefficient for the Brand dummy variable in context.
    c) Predict the consumer report score for a Nikon camera that has a price of $350, a weight of 7 ounces, and 11 megapixels. (include your Excel work)