Question: NO. ADVERTS (X variable) SALES (Y variable) 2001 3 12 2002 4 12 2003 3 13 2004 1 15 2005 2 18 2006 2 19

NO. ADVERTS (X variable) SALES (Y variable)
2001 3 12
2002 4 12
2003 3 13
2004 1 15
2005 2 18
2006 2 19
2007 3 22
2008 3 25
2009 4 27
2000 8 29
2001 8 38
2002 8 25
2003 9 25
2004 8 25
2005 11 27
2006 14 26
2007 13 26
2008 13 25
2009 16 25
2010 13 27
2011 13 26
2012 13 26
2014 14 28
2015 15 27
2016 15 28
2017 15 28
2018 15 28
2019 17 30
2020 17 29
2021 16 31
  1. What does the figure that emerged as y-intercept reveal about the Y variable?
  2. Go to Excel click on Charts and create a scatter gram. Click on the Charts again and insert a line in the scatter gram
  3. What pattern do the scatter plot and line indicate?
  4. From the regression analysis, indicate the p-value
  5. What does the p-value inform you about the sample data and population data?
  6. Using Excel, undertake a correlation analysis in order to standardize the covariance. Use the results to assess the strength and direction of the relationship between the adverts and the sales data presented. What are your interpretations/views?
  7. opinion or conclusion about business-related policies or programs that the company should pursue to improve its market share of the car industry by the middle of the decade

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Mathematics Questions!