Question
Open Excel, conduct correlation and the regression efficient analyses for Toronto car manufacturing company and Vancouver car manufacturing company (see tables of the two companies
- Open Excel, conduct correlation and the regression efficient analyses for Toronto car manufacturing company and Vancouver car manufacturing company (see tables of the two companies next page).
describe the results of the analyses (strength and direction of the relationships between adverts and sales; the extent that adverts influence/impact the sales) for
- Toronto car manufacturing company
- Vancouver car manufacturing company
- Were the sample data for the two companies statistically significant? i.e. can you indicate whether the sample data were related to the population data for
- Toronto car manufacturing company? Explain why
- Vancouver car manufacturing company? Explain why.
- Based on the result of the correlation and regression analyses conducted
- What is the co-efficient of determination for the Vancouver car manufacturing company?
- What is the co-efficient of determination for Toronto car manufacturing company?
- What is the co-efficient of non-determination of Vancouver car manufacturing company?
- What is the co-efficient of non-determination for Toronto car manufacturing company?
VANCOUVER CAR MANUFACTURING COMPANY LTD
| YEAR | ADVERTS (X VARIABLE) | SALES (Y VARIABLE) |
| 1991 | 215 | 3680 |
| 1992 | 233 | 3300 |
| 1993 | 245 | 3500 |
| 1994 | 245 | 3440 |
| 1995 | 240 | 3640 |
| 1996 | 256 | 3730 |
| 1997 | 244 | 3240 |
| 1998 | 260 | 2900 |
| 1999 | 266 | 3800 |
| 2000 | 269 | 4120 |
| 2001 | 250 | 4540 |
| 2002 | 270 | 4550 |
| 2003 | 273 | 4658 |
| 2004 | 277 | 4777 |
| 2005 | 280 | 4790 |
| 2006 | 288 | 4798 |
| 2007 | 290 | 5044 |
| 2008 | 300 | 5080 |
| 2009 | 300 | 5100 |
| 2010 | 310 | 5120 |
| 2011 | 312 | 5201 |
| 2012 | 326 | 5212 |
| 2013 | 300 | 5220 |
| 2014 | 320 | 5107 |
| 2015 | 322 | 5110 |
| 2016 | 325 | 5206 |
| 2017 | 325 | 5230 |
| 2018 | 325 | 5337 |
| 2019 | 328 | 5342 |
| 2020 | 340 | 5345 |
Source: Vancouver Car Manufacturing Company Ltd, 2022
TORONTO CAR MANUFACTURING COMPANY
| YEAR | ADVERTS (X variable) | SALES (Y variable) |
| 1991 | 3 | 12 |
| 1992 | 4 | 12 |
| 1993 | 3 | 13 |
| 1994 | 1 | 15 |
| 1995 | 2 | 18 |
| 1996 | 2 | 19 |
| 1997 | 3 | 22 |
| 1998 | 3 | 25 |
| 1999 | 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 |
| 2013 | 14 | 28 |
| 2014 | 15 | 27 |
| 2015 | 15 | 28 |
| 2016 | 15 | 28 |
| 2017 | 15 | 28 |
| 2018 | 17 | 30 |
| 2019 | 17 | 29 |
| 2020 | 16 | 31 |
Source: Fieldwork, 2022
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access with AI-Powered 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
Calculus
Authors: Dale Varberg, Edwin J. Purcell, Steven E. Rigdon
9th edition
978-0131429246
