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

• 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
• What is the y-intercept of the regression equation?
• What does the figure that emerged as y-intercept reveal about the Y variable?
• Go to Excel click on Charts and insert a scatter gram. Click on the Charts again and insert a line in the scatter gram
• What pattern do the scatter plot and line indicate?
• From the regression analysis, indicate the p-value
• What does the p-value inform you about the sample data and population data?
• 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?
• opinion or conclusion about business-related policies or programs that the company should pursue to improve its market share of the car industry by middle of the decade