WEBDEVELOPMENT Lecture 3: 19
Get access
Related Documents
Related Questions
PROBLEM 1: Analyze the following data using LINEAR TRENDANALYSIS. How many cars will be sold in time period 13?
TIME PERIOD | NUMBER OF CARS SOLD |
1 | 70 |
2 | 80 |
3 | 66 |
4 | 74 |
5 | 64 |
6 | 76 |
7 | 72 |
8 | 83 |
9 | 82 |
10 | 76 |
11 | 84 |
12 | 80 |
PROBLEM 2: A sample of 20 cars was taken, and the miles pergallon (MPG), horsepower, and total weight were recorded.
Develop a simple regression model to predict the dependentvariable, MPG, using horsepoweras the independent variable.
Develop a simple regression model to predict the dependentvariable, MPG, using weight asthe independent variable.
Using R², which of the 2 causal forecasting models, A or B, isbetter?
Develop a multiple regression model to predict the dependentvariable, MPG, using horsepowerand weight as the 2 independent variables.
Using R², how does the multiple regression model compare witheach of the 2 simple regression models?
MPG (Y) | HORSEPOWER (X1) | WEIGHT (X2) |
44 | 67 | 1844 |
44 | 50 | 1998 |
40 | 62 | 1752 |
37 | 69 | 1980 |
37 | 66 | 1797 |
34 | 63 | 2199 |
35 | 90 | 2404 |
32 | 99 | 2611 |
30 | 63 | 3236 |
28 | 91 | 2606 |
26 | 94 | 2580 |
26 | 88 | 2507 |
25 | 124 | 2922 |
22 | 97 | 2434 |
20 | 114 | 3248 |
21 | 102 | 2812 |
18 | 114 | 3382 |
18 | 142 | 3197 |
16 | 153 | 4380 |
16 | 139 | 4036 |
give answer to the problem 1 and 2 in excel.