Answered step by step
Verified Expert Solution
Question
1 Approved Answer
PROJECT PHASE II - CORRELATION AND REGRESSION ANALYSES TORONTO CAR MANUFACTURING COMPANY NO. | ADVERTS (X variable) SALES (Y variable) 2001 13 12 2002 4
PROJECT PHASE II - CORRELATION AND REGRESSION ANALYSES TORONTO CAR MANUFACTURING COMPANY NO. | ADVERTS (X variable) SALES (Y variable) 2001 13 12 2002 4 12 2003 3 13 2004 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 Source: Fieldwork, 2022 Open Excel Select "Data" from the toolbar/menu Choose "Data Analysis". The Analysis Tools dialog box displays. From this menu, select "Regression" and click "OK". The Regression dialog box opens Click the "Input Y Range" box and select or enter the dependent variable data (sales) Click the "Input X Range" box, select or enter the independent variable data (adverts) Click "OK" to run the regression analysis and generate results (1 mark) What is the y-intercept of the regression equation? (1 mark)
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started