For each of the question, paste visualization plots when necessary. Paste the R code at the end of the paper. Discuss the statistics in your own words when asked   1) Compute a new variable by adding magazine, newspaper, outdoor, broadcast and print advertising expenditure, and name it TotalAds. 2) Conduct a correlation plot with all the variables. Submit your visualization plots, and describe the relationships among the variables as you learn from the plot Helping R code #See column names of the file. colnames(data) #Compute new data columns data<-data %>% mutate(TotalAds = Mag + News+Outdoor+Broad+Print) #Please use the previous codes from week 1 to do data exploration and visualization. #Create and visualize Correlation plot library(corrplot) M = cor(data) corrplot(M, method = 'number') options(scipen=999) #Create regression equation model <- lm(y ~ x1 + x2 + x3 + x4 + x5, data = data) summary(model)

Np Ms Office 365/Excel 2016 I Ntermed
1st Edition
ISBN:9781337508841
Author:Carey
Publisher:Carey
Chapter6: Managing Multiple Worksheets And Workbooks
Section: Chapter Questions
Problem 15RA
icon
Related questions
Question
    • For each of the question, paste visualization plots when necessary. Paste the R code at the end of the
      paper. Discuss the statistics in your own words when asked
     
    1) Compute a new variable by adding magazine, newspaper, outdoor, broadcast and print advertising
    expenditure, and name it TotalAds.
  • 2) Conduct a correlation plot with all the variables. Submit your visualization plots, and describe the
    relationships among the variables as you learn from the plot
  • Helping R code
    #See column names of the file.
    colnames(data)
    #Compute new data columns
    data<-data %>%
    mutate(TotalAds = Mag + News+Outdoor+Broad+Print)
    #Please use the previous codes from week 1 to do data exploration and visualization.
    #Create and visualize Correlation plot
    library(corrplot)
    M = cor(data)
    corrplot(M, method = 'number')
    options(scipen=999)
    #Create regression equation
    model <- lm(y ~ x1 + x2 + x3 + x4 + x5, data = data)
    summary(model)
 
Expert Solution
steps

Step by step

Solved in 4 steps with 2 images

Blurred answer
Knowledge Booster
Image Element
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Np Ms Office 365/Excel 2016 I Ntermed
Np Ms Office 365/Excel 2016 I Ntermed
Computer Science
ISBN:
9781337508841
Author:
Carey
Publisher:
Cengage
New Perspectives on HTML5, CSS3, and JavaScript
New Perspectives on HTML5, CSS3, and JavaScript
Computer Science
ISBN:
9781305503922
Author:
Patrick M. Carey
Publisher:
Cengage Learning
COMPREHENSIVE MICROSOFT OFFICE 365 EXCE
COMPREHENSIVE MICROSOFT OFFICE 365 EXCE
Computer Science
ISBN:
9780357392676
Author:
FREUND, Steven
Publisher:
CENGAGE L
CMPTR
CMPTR
Computer Science
ISBN:
9781337681872
Author:
PINARD
Publisher:
Cengage