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
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
Study Help