Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribed
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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

College Algebra Enhanced With Graphing Utilities (Subscription)

Authors: Michael Sullivan, Michael Sullivan III

6th Edition

0321849167, 9780321849168

More Books

Students also viewed these Mathematics questions

Question

=+6. For the decision tree of Exercise 4,

Answered: 1 week ago

Question

What does this look like?

Answered: 1 week ago