DATA ANALYTICS AND BUSINESS INTELLIGENCE

Running head: DATA ANALYTICS AND BUSINESS INTELLIGENCE
Data Analytics and Business Intelligence
Name of the Student
Name of the University
Student ID

DATA ANALYTICS AND BUSINESS INTELLIGENCE1
Table of Contents
Question 1........................................................................................................................................2
Question 2........................................................................................................................................4
Question 3........................................................................................................................................4
Question 4........................................................................................................................................5
Question 5........................................................................................................................................6
References........................................................................................................................................7

DATA ANALYTICS AND BUSINESS INTELLIGENCE2
Question 1
Table 1: Multiple regression model using trend and seasonality
New car sales=41079.1314+ ( 2928.1906 ×Year ) +(218.4633 × Month)
The multiple regression model shows the impact of trend and seasonality of new car
sales. R square value of the regression model is 0.6249. The trend and seasonality account for 62
percent variation in sales of new cars. The respective coefficients for year and month are
2928.1906 and 218.4633 respectively. Both the coefficients are positive implying new car dales
tend to increase with increase in months and years. P values for year and month are respectively
0.3622 and 0.3422. Both the p value exceeds the significance level having an alpha value of
0.05. Given the p values larger than significance level, the null hypothesis stating no statistical
significance of the regression coefficient has been accepted (Schroeder, Sjoquist & Stephan,
2016). This implies in the multiple regression model both year and months are statistically
insignificant. Comparison of two p values shows that p value of year is larger than the p values